A budget shows how much you plan to spend. A cash-flow spreadsheet also shows when money arrives and leaves. That timing matters when a month has enough income overall but bills are due before payday.
Download the personal cash-flow CSV template to begin with expected amounts, actual amounts, a running balance, and payment status.
Create the Transaction Sheet
Use columns for date, description, amount, account, category, and status. Keep income positive and expenses negative, or use separate income and expense columns. Whichever convention you choose, use it consistently.
Import bank data instead of typing every row. Statementsify can convert bank statement PDFs to CSV for Excel or Google Sheets.
Create a Monthly Summary
Add a second sheet with these rows:
- Opening balance
- Expected income
- Fixed bills
- Variable essentials
- Optional spending
- Savings and debt payments
- Closing balance
Use SUMIFS formulas or a pivot table to summarize transactions by date and
category. Keep the raw data separate from the summary so imports do not break
the reporting layout.
Calculate the Running Balance
Enter the opening balance in the first row. Each following row adds income or subtracts an expense from the prior balance. If amounts share one signed column, the spreadsheet logic is simply:
current running balance = previous balance + current amount
Use expected amounts for the forecast and actual amounts after transactions clear. Never assume that the bank's available balance includes every upcoming or pending payment.
Add a Cash-Flow Calendar
List paydays and due dates in chronological order. Calculate a running balance after every expected item. A negative point during the month signals a timing problem even if the projected closing balance is positive.
Possible responses include changing a bill’s due date, maintaining a larger checking buffer, or adjusting discretionary spending. Confirm terms and fees with the provider before changing payment arrangements.
Worked Timing Example
Consider a month that opens with $700. A $1,900 housing payment is due on the third, but a $2,400 paycheck arrives on the fifth. The month may be positive in total while the projected balance temporarily reaches negative $1,200.
The calendar exposes the timing gap before a payment fails. Depending on the person's options, they might use an established buffer, contact the provider about a different due date, or change when money is transferred between their own accounts. The spreadsheet reveals the problem; it does not prescribe the right financial decision.
Add Three Useful Checks
Use conditional formatting to highlight a running balance below a chosen safety threshold. Add a status field such as Expected, Scheduled, Cleared, or Needs Review. Finally, compare the forecast closing balance with the actual statement balance and investigate any difference.
Keep credit card purchases and payments consistent to prevent double counting. Treat transfers between your own accounts as transfers rather than new income.
Compare Forecast With Reality
At month end, replace estimates with actual transactions and note the difference. Large differences can reveal variable bills, forgotten annual charges, or an unrealistic category target.
Use the 30-minute monthly review to keep the spreadsheet current without turning it into a daily burden.
Keep the Workbook Safe
Do not store passwords, full account numbers, or security answers in the workbook. Use a secure device, restricted sharing permissions, and an account protected with multi-factor authentication.
A simple cash-flow spreadsheet should answer three questions quickly: what is available now, what is due next, and whether the month remains positive. Start with clean transaction data from the Statementsify converter.