| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | For: | To/From: | Payment Type | Due Date | Bill comes: | Amount | Budget per check | Anticipated last payment |
2 | Rental Income | Entity Name | Self | 1 | 1 | $200.00 | $100.00 | |
3 | Gym | Auto | 1 | 1 | -$30.00 | -$15.00 | ||
4 | Mortgage | Self | 1 | 25 | -$750.00 | -$375.00 | ||
5 | Credit Card | Company A | Self | 3 | 26 | $0.00 | ||
6 | Credit Card | Company B | Self | 8 | 18 | $0.00 | ||
7 | Electric | Self | 11 | 24 | $0.00 | |||
8 | HH Gregg | Auto | 13 | 13 | $0.00 | |||
9 | Car | Auto | 13 | 13 | $0.00 | |||
10 | Student Loan | Auto | 20 | 20 | $0.00 | |||
11 | Gas | Self | 17 | 6 | $0.00 | |||
12 | Credit Card | Company C | Self | 20 | 27 | $0.00 | ||
13 | Student Loan | Auto | 22 | 22 | $0.00 | |||
14 | Internet & Cable | Self | 28 | 8 | $0.00 | |||
15 | Car Insurance | Self - Annual | August 8 | August 8 | $0.00 | |||
16 | Food | Self | N/A | N/A | $0.00 | |||
17 | Gasoline | Self | N/A | N/A | $0.00 | |||
18 | Cell phone | Self | 1 | 1 | $0.00 | |||
19 | Water/Trash | Self - Quarterly | Quarterly | Quarterly | $0.00 | |||
20 | -$580.00 | -290.00 | ||||||
21 | Paychecks | $2,000.00 | 1,000.00 | |||||
22 | Remaining | $1,420.00 |