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

$242
$153
$89
$200
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$167
$258
$-91
$420
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$421
$256
$165
$400
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$409
$234
$175
$180
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$128
$175
$-47
$220
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$147
$45
$102
$500
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$37
$66
$-29
$300
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$308
$271
$37
$160
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$241
$236
$5
$240
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$238
$190
$48
$320
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$436
$139
$297
$250
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

$265
$193
$72
$490
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$158
$64
$94
$250
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$382
$256
$126
$50
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$378
$4
$374
$320
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$488
$135
$353
$500
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$89
$62
$27
$430
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$224
$174
$50
$140
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$368
$229
$139
$170
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$420
$276
$144
$380
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$421
$190
$231
$390
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$285
$54
$231
$140
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$378
$126
$252
$200
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$121
$70
$51
$360
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$321
$65
$256
$450
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$194
$163
$31
$360
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$466
$120
$346
$210
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$73
$141
$-68
$160
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$182
$265
$-83
$250
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$110
$38
$72
$500
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$322
$91
$231
$310
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$255
$105
$150
$340
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$424
$23
$401
$230
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$184
$79
$105
$50
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$243
$10
$233
$110
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$423
$171
$252
$60
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$263
$117
$146
$200
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$483
$222
$261
$350
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$25
$227
$-202
$260
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$481
$175
$306
$360
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$77
$53
$24
$80
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$43
$157
$-114
$290
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$331
$237
$94
$430
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$105
$129
$-24
$220
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$392
$280
$112
$320
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$287
$49
$238
$370
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$192
$273
$-81
$420
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$153
$228
$-75
$470
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$7
$125
$-118
$440
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

$432
$177
$255
$50
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$70
$160
$-90
$270
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$242
$119
$123
$410
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$438
$49
$389
$330
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$186
$272
$-86
$120
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$252
$248
$4
$350
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$32
$245
$-213
$170
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$215
$262
$-47
$190
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$29
$114
$-85
$370
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$209
$205
$4
$200
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$231
$86
$145
$130
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$358
$98
$260
$160
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$400
$154
$246
$120
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$341
$277
$64
$380
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$142
$64
$78
$160
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$468
$65
$403
$120
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$31
$149
$-118
$140
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$348
$23
$325
$130
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$45
$288
$-243
$320
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$212
$0
$212
$320
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$253
$39
$214
$160
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$342
$294
$48
$420
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$279
$293
$-14
$280
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$382
$50
$332
$270
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$290
$154
$136
$70
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$152
$221
$-69
$150
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$319
$144
$175
$130
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$105
$141
$-36
$190
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$456
$107
$349
$110
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$315
$31
$284
$100
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$118
$272
$-154
$180
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$237
$265
$-28
$320
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$16
$35
$-19
$320
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$236
$245
$-9
$450
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$381
$121
$260
$160
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$69
$251
$-182
$350
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$22
$171
$-149
$420
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$428
$270
$158
$180
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$350
$130
$220
$270
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$259
$300
$-41
$400
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$29
$197
$-168
$180
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$98
$92
$6
$500
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$18
$152
$-134
$280
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$499
$281
$218
$350
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$485
$8
$477
$130
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$487
$106
$381
$130
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$208
$280
$-72
$480
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$190
$297
$-107
$270
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$9
$46
$-37
$480
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$30
$147
$-117
$390
Spending


or add a new one

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

Spent
Left
TargetNew Amount

$395
$207
$188
$150
Spending


or add a new one

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