Start with the first paycheck
Begin with $100 and add $2,000 income. Reserve $600 and cover $1,000 in bills.
The first projected closing balance is $500.
Change a yellow input and see how the numbers respond. Switch tabs to explore the rest of the workbook.
Sample figures in USD · No account needed · Your changes stay in this preview
Review any negative period before assigning more money.
Sample workbook figures. This dashboard uses an eight-paycheck example; the Example tab shows a separate two-paycheck plan.
Projected closing balances: $500 after paycheck 1 and $1,700 after paycheck 2.
| Paycheck | Income | Reserve | Bills | Closing |
|---|---|---|---|---|
| 1 | $2,000 | $600 | $1,000 | $500 |
| 2 | $2,000 | $600 | $200 | $1,700 |
Sample figures in USD. Starting available balance: $100. These are projected balances, not bank balances.
Enter up to 10 monthly bills, generate occurrences, then copy and paste Values only into Bills. This does not automatically write to Bills or pay a bill.
| Bill | Amount | Due day |
|---|---|---|
| Rent | $1,000 | 3 |
| Utilities | $200 | 17 |
Use a Google account to copy the workbook into your own Drive after receiving your template.
Change a yellow input in Example. Practice figures stay separate from your own plan.
Add your inputs, then review Dashboard. Leave formula cells intact.
No bank connection, add-on, or Apps Script authorization required. Desktop setup is recommended.
Your next step
See the included tabs, setup steps and supported capacity before choosing.
Projected planning balances, not bank balances. Enter your own numbers; no bank connection or automatic bill payment. Desktop Google Sheets is the supported format.
Begin with $100 and add $2,000 income. Reserve $600 and cover $1,000 in bills.
The first projected closing balance is $500.
Add the next $2,000 paycheck, reserve $600, and cover $200 in bills.
The next projected closing balance is $1,700.
Change the first income to $1,000, leaving the other example inputs unchanged.
The projected balances become −$500 and $700.