Options
--> Sort by Category yes/no
  • Number of transactions
  • Alphabetically
Recurring Payments go here
  • Existing recurring payments with delete option
  • Add new recurring payment - category, item name, amount, day (1-28; last day of the month; 1st, 2nd, 3rd, 4th, day of the week - of the month
Category/item editing goes here
  • Existing category/item combinations with delete option?

Planning info for Tables (may do uni styled tables):

  • allocate_users
    • user_id (incrementing number)
    • user_added_on
    • user_removed_on
  • allocate_user_preferences
    • preference_id (user_id)
    • preference_name (name, password, email, show transactions, sort order, group by category)
    • preference_choice
    • preference_added_on
    • preference_removed_on
  • allocate_user_groups
    • group_id (incrementing number)
    • group_name
    • group_coordinator (user_name)
    • group_member_name (user_name)
    • group_invited_on
    • group_uninvited_on
    • group_invitation_response
    • Am I in a group? - if yes create option to leave the group; set allocate_id to group_id
    • Am I in a group? - if no always show an option to invite a user to the group; set allocate_id to user_id
    • Confirm valid user_name and not it a group before allowing membership
    • Email invitations and rescinded invitations
    • Primary user can invite other users to join their group if they are not already in a group
    • Accept or deny invitations before continuing on
    • Login order
      • login verifies user first
      • then checks for invitations
      • then looks for group account
      • if no budgets found - make one, otherwise show the current budget or make a new month budget if applicable
  • allocate_categories (i.e. Income, Giving, Savings, Debt, Food, Clothing, Shelter, Transportation, Personal, Insurance, Communications, Medical)
  • allocate_items (i.e. Netflix, Amazon Prime, etc)
    • item_id (incrementing number)
    • item_group_id
    • item_name
    • group_coordinator (user_name)
    • group_member_name (user_name)
    • group_invited_on
    • group_uninvited_on
    • group_invitation_response
  • allocate_recurring
  • allocate_beginning_balance
    • allocate_id (group_id)
    • category
    • item
    • (beginning_)amount
    • //comment
    • //location
    • (year_month)//date
    • entered_by
    • entered_on
  • allocate_transactions
    • category
    • item
    • amount
    • comment
    • location
    • date
    • entered_by
    • entered_on

Category Name
Item #1 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$350
$135
$215
$440
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #2 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$224
$247
$-23
$340
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #3 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$86
$172
$-86
$170
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #4 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$248
$182
$66
$430
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #5 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$327
$147
$180
$50
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #6 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$419
$134
$285
$320
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #7 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$62
$162
$-100
$160
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #8 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$7
$237
$-230
$200
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #9 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$275
$197
$78
$360
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #10 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$370
$300
$70
$160
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #11 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$1
$155
$-154
$150
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Category Name
Item #12 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$46
$92
$-46
$180
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #13 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$284
$63
$221
$400
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #14 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$306
$185
$121
$500
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #15 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$366
$146
$220
$490
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #16 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$372
$237
$135
$250
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #17 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$135
$247
$-112
$120
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #18 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$276
$178
$98
$60
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #19 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$437
$112
$325
$190
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #20 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$494
$1
$493
$160
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #21 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$1
$257
$-256
$470
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #22 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$106
$163
$-57
$340
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #23 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$300
$75
$225
$430
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #24 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$261
$124
$137
$150
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #25 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$309
$297
$12
$90
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #26 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$460
$105
$355
$320
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #27 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$230
$287
$-57
$430
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #28 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$102
$2
$100
$460
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #29 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$241
$123
$118
$500
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #30 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$364
$196
$168
$370
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #31 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$342
$271
$71
$140
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #32 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$168
$123
$45
$430
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #33 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$450
$152
$298
$190
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #34 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$347
$274
$73
$110
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #35 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$201
$132
$69
$410
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #36 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$429
$195
$234
$370
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #37 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$91
$154
$-63
$350
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #38 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$69
$291
$-222
$100
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #39 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$148
$20
$128
$430
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #40 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$185
$291
$-106
$460
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #41 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$391
$192
$199
$410
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #42 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$81
$55
$26
$440
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #43 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$164
$221
$-57
$280
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #44 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$244
$202
$42
$230
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #45 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$254
$29
$225
$80
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #46 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$256
$300
$-44
$210
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #47 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$318
$29
$289
$160
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #48 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$80
$185
$-105
$190
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #49 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$409
$210
$199
$410
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Category Name
Item #50 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$274
$163
$111
$150
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #51 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$245
$69
$176
$490
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #52 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$248
$91
$157
$240
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #53 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$90
$67
$23
$410
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #54 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$458
$251
$207
$60
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #55 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$442
$266
$176
$160
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #56 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$152
$107
$45
$260
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #57 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$355
$210
$145
$150
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #58 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$305
$224
$81
$310
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #59 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$16
$43
$-27
$300
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #60 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$301
$193
$108
$50
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #61 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$397
$200
$197
$410
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #62 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$284
$42
$242
$90
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #63 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$78
$102
$-24
$50
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #64 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$47
$49
$-2
$290
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #65 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$84
$69
$15
$370
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #66 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$127
$111
$16
$210
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #67 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$327
$215
$112
$300
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #68 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$381
$39
$342
$460
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #69 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$355
$297
$58
$80
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #70 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$129
$288
$-159
$300
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #71 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$481
$222
$259
$450
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #72 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$455
$177
$278
$180
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #73 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$441
$217
$224
$300
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #74 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$356
$51
$305
$380
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #75 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$326
$106
$220
$500
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #76 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$109
$146
$-37
$120
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #77 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$216
$21
$195
$390
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #78 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$462
$100
$362
$470
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #79 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$46
$36
$10
$330
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #80 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$391
$49
$342
$460
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #81 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$33
$184
$-151
$400
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #82 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$359
$51
$308
$470
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #83 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$194
$265
$-71
$490
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #84 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$122
$248
$-126
$360
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #85 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$135
$217
$-82
$390
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #86 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$437
$294
$143
$290
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #87 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$345
$292
$53
$230
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #88 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$463
$54
$409
$140
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #89 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$15
$164
$-149
$410
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #90 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$25
$263
$-238
$110
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #91 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$456
$164
$292
$340
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #92 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$489
$187
$302
$130
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #93 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$228
$87
$141
$500
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #94 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$110
$140
$-30
$420
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #95 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$417
$120
$297
$130
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #96 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$19
$63
$-44
$440
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #97 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$356
$173
$183
$320
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #98 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$240
$257
$-17
$460
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #99 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$334
$213
$121
$160
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?
Item #100 Name
PlannedNew Amount

Spent
Left
TargetNew Amount

$99
$148
$-49
$220
Spending


or add a new one

Transactions columns - date (mm-YYYY), store, amount, edit?