50/20/30 Budget Worksheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions
1. Copy this to your personal Google Drive by going to File -> Make A Copy
2. Fill in B2 with your gross pay minus taxes.
3. Populate the rest of the yellow boxes.
4. Add or remove any line items to customize - be sure to update the category total formulas.
2
99.78%$4,500.00Total Monthly AllowanceGross pay minus wage-based taxes such as Social Security, federal/state income tax, Medical and disability.
3
49.89%$2,245.00Living Expenses - 50%Anything you must pay, either due to a contract, as a cost of living, or to survive. These are your basic cost-of-living expenses
4
$550.00Rent/MortgageYour total rent and/or mortgage payment due each month.
5
$75.00UtilitiesElectricity, water/sewage, gas
6
$350.00Transportation & FuelMinimum payment on any car loans, fuel, bus fare, and maintenance fund
7
$550.00FoodYour food budget (dining out can be listed under discretionary spending)
8
$50.00Household costsNon-food costs for the household - toiletries, cleaning supplies,
9
$125.00HealthcareYour health insurance premiums (whether paid for out of pocket or via paycheck deduction), prescription cost, any out-of-pocket expenses
10
$160.00House/Car InsuranceHouse or apartment insurance, and car insurance premium payments. If you pay in full every 6/12 months, break it down into a monthly cost
11
$0.00Child CareChild care costs, or any school/tuition costs
12
$25.00Minimum Credit Card PaymentThe minimum payment that must be made on your credit card bill, if you have credit card debt.
13
$300.00
Minimum Student Loan Payment
The minimum student loan payment that you must make, if you have student loan debt.
14
$60.00PhoneCell and/or landline phone costs, if you are bound by a contract.
15
20.00%$900.00Savings/Debt - 20%Paying down any existing debt faster, and saving for your future.
16
$550.00401k/retirement contributionsPut your employer-deducted 401k/retirement contributions here.
17
$0.00Investment/savings plansAny additional investing or savings plans on the side.
18
$0.00Extra debt paymnetsExtra debt payments are ON TOP OF your minimum amount due, to help pay off debt faster.
19
$350.00Rainy-day fundAim for a three month pillow of living expenses.
20
29.89%$1,345.00Discretionary - 30%Discretionary or luxury spending - nothing you couldn't live without if you had to cut back.
21
$185.00Dining OutRestaurants and bars, evenings out, etc.
22
$30.00SubscriptionsNetflix, Spotify, magazines, and any other subscription that isn't a necessity, and you can cancel at any time.
23
$400.00Personal spendingJust like it sounds.
24
$300.00Clothing/hygieneJust like it sounds.
25
$60.00Gym memberships/clubsPersonal fitness memberships or club payments.
26
$150.00Vacation fundPutting a little aside for a lot of fun later.
27
$80.00PetsYour furbabies have expenses, too!
28
$50.00GiftsHolidays, birthdays, anniversaries - start saving year-round.
29
$90.00Internet/TVConsider moving this to essential living expenses if your career depends on it
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1
 
 
Main menu