A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Date | 1st Half | totals | Date | 2nd Half | totals | Snow Ball | ||||||||||
2 | Income | $536.00 | Beginning month (1-12) ----------> | 11 | |||||||||||||
3 | Person A Paycheck | 1st | $1,000.00 | $1,000.00 | 15th | $1,000.00 | $1,000.00 | Beginning year (ex: 2013)-------> | 2013 | ||||||||
4 | Person B Paycheck | 1st | $753.00 | $1,753.00 | 15th | $753.00 | $1,753.00 | Person A Paycheck | |||||||||
5 | House Bills | $1,000.00 | |||||||||||||||
6 | Rent | 1st | $600.00 | $1,153.00 | 15th | $2,056.00 | |||||||||||
7 | Grocery | 2nd | $150.00 | $1,003.00 | 15th | $150.00 | $1,906.00 | Person B Paycheck | |||||||||
8 | House Items | 3rd | $100.00 | $903.00 | 15th | $100.00 | $1,806.00 | $753.00 | |||||||||
9 | Cable | $903.00 | 15th | $52.00 | $1,754.00 | ||||||||||||
10 | Netflix / Spotify | $903.00 | 15th | $18.00 | $1,736.00 | ||||||||||||
11 | Day Care | $903.00 | 15th | $350.00 | $1,386.00 | NEW SPREADSHEET : https://goo.gl/t38a49 | |||||||||||
12 | Cell Phones | $903.00 | 17th | $80.00 | $1,306.00 | ||||||||||||
13 | House Heating | $903.00 | 18th | $100.00 | $1,206.00 | ||||||||||||
14 | House Electric | $903.00 | 18th | $120.00 | $1,086.00 | ||||||||||||
15 | Car Insurance | $903.00 | 25th | $150.00 | $936.00 | Step 1. Enter in the Month and Year at the top. | |||||||||||
16 | $903.00 | $936.00 | Step 2. Enter in your paycheck information in cell K5 and K8 (if available). | ||||||||||||||
17 | $903.00 | $936.00 | |||||||||||||||
18 | $903.00 | $936.00 | Step 3. Enter in your bills and the date that their due. If you do NOT put in a date or amount, you'll get errors. | ||||||||||||||
19 | $903.00 | $936.00 | |||||||||||||||
20 | $903.00 | $936.00 | Step 4. Enter in your debt below with the required information (min. payment, interest rate and total amount due). | ||||||||||||||
21 | $903.00 | $936.00 | |||||||||||||||
22 | $903.00 | $936.00 | |||||||||||||||
23 | $903.00 | $936.00 | Step 5. Navigate to the 'Month to Month' tab and see where your money is going. You can hide the empty cells by filtering these out using an auto filter on column A and removing the 'blanks'. | ||||||||||||||
24 | $903.00 | $936.00 | |||||||||||||||
25 | $903.00 | $936.00 | |||||||||||||||
26 | Extra Money | Note: You can change the name of the categories. You can also hide any cells that are blank. You might want to hide them on the 'Month to Month' page as you'll have a lot of empty space. | |||||||||||||||
27 | Person A Fun Money | 1st | $25.00 | $878.00 | 15th | $25.00 | $911.00 | ||||||||||
28 | Person B Fun Money | 1st | $25.00 | $853.00 | 15th | $25.00 | $886.00 | ||||||||||
29 | House Fun Money | 1st | $100.00 | $753.00 | $886.00 | ||||||||||||
30 | $753.00 | $886.00 | |||||||||||||||
31 | $753.00 | $886.00 | Also - the Snowball amount at the top is ONLY relevant if you are trying to pay off debt. Once you have NO debt left on the bottom, make sure to allocate this amount to something else, such as 401k, Roth IRA, etc. | ||||||||||||||
32 | $753.00 | $886.00 | |||||||||||||||
33 | $753.00 | $886.00 | |||||||||||||||
34 | $753.00 | $886.00 | |||||||||||||||
35 | $753.00 | $886.00 | |||||||||||||||
36 | $753.00 | $886.00 | Any questions, email me at bgiglio@gmail.com Donations gladly appreciated: Paypal - bgiglio@gmail.com | ||||||||||||||
37 | Savings | ||||||||||||||||
38 | Car Care | 1st | $50.00 | $703.00 | $886.00 | ||||||||||||
39 | Emergency Fund | $703.00 | 15th | $50.00 | $836.00 | ||||||||||||
40 | Vacation Fund | $703.00 | 15th | $50.00 | $786.00 | ||||||||||||
41 | Christmas | $703.00 | 15th | $50.00 | $736.00 | ||||||||||||
42 | $703.00 | $736.00 | |||||||||||||||
43 | $703.00 | $736.00 | |||||||||||||||
44 | $703.00 | $736.00 | |||||||||||||||
45 | $703.00 | $736.00 | |||||||||||||||
46 | $703.00 | $736.00 | |||||||||||||||
47 | $703.00 | $736.00 | |||||||||||||||
48 | |||||||||||||||||
49 | Debt | ||||||||||||||||
50 | Bill Name | Date | Minimum Payment | Date | Minimum Payment | Interest Rate | Total Owed | ||||||||||
51 | Car Payment 1 | 1st | $100.00 | $603.00 | $736.00 | 4.00% | $5,000.00 | ||||||||||
52 | Car Payment 2 | 5th | $300.00 | $303.00 | $736.00 | 3.00% | $4,000.00 | ||||||||||
53 | Student Loan | $303.00 | 17th | $200.00 | $536.00 | 2.00% | $4,000.00 | ||||||||||
54 | $303.00 | $536.00 | |||||||||||||||
55 | $303.00 | $536.00 | |||||||||||||||
56 | $303.00 | $536.00 | |||||||||||||||
57 | $303.00 | $536.00 | |||||||||||||||
58 | $303.00 | $536.00 | |||||||||||||||
59 | $303.00 | $536.00 | |||||||||||||||
60 | $303.00 | $536.00 | |||||||||||||||
61 | $303.00 | $536.00 | |||||||||||||||
62 | $303.00 | $536.00 | |||||||||||||||
63 | $303.00 | $536.00 | |||||||||||||||
64 | $303.00 | $536.00 | |||||||||||||||
65 | $303.00 | $536.00 | |||||||||||||||
66 |