How to Map Your Monthly Cash Flow
Reconcile the change in cash first. Then classify outflows so transfers and card payments do not inflate spending.
Read guideTurn transactions into a defensible map of where money went - Without confusing transfers, refunds, or cash withdrawals for spending.

A useful spending analysis is an accounting exercise before it is a budgeting exercise. Start with complete transaction data, normalize merchants, separate transfers, and only then compare categories.
Once transfers, refunds, and unresolved cash are separated, test the reconciled totals rather than a distorted debit total. Use the Spending Analyzer.
Reconcile the change in cash first. Then classify outflows so transfers and card payments do not inflate spending.
Read guideAmount and timing are separate dimensions. A bill can be fixed but annual, or variable but essential.
Read guideClean data preserves the original description while adding a normalized merchant, transaction class, category, and confidence note.
Read guideUse the fewest categories that change a decision, document their boundaries, and keep uncertainty visible.
Read guidePreserve the bank description, normalize in a separate field, and use cautious rules for payment processors and branches.
Read guideCount the economic purchase once; treat later movement between accounts you control as a transfer.
Read guideTreat an ATM withdrawal as cash funding, then classify purchases only to the level your records support.
Read guideDefine the household boundary, contribution rules, and private-spending treatment before combining transactions.
Read guideExplain the drivers of change instead of treating every difference as a trend.
Read guideA small recurring review improves data quality and makes the monthly budget easier to manage.
Read guideA category chart is only the final layer. The underlying work is to define the accounts and dates included, reconcile opening and closing cash, distinguish external activity from transfers, and preserve uncertain transactions for review. If those controls are missing, a polished chart can still be wrong.
| Question | Evidence to use | Output |
|---|---|---|
| How much actually left the household? | Opening balance, closing balance, external inflows | Reconciled external outflow |
| What was purchased? | Posted transactions and receipts | Decision-ready categories |
| What only moved? | Matched amounts across owned accounts | Excluded internal transfers |
| What is still uncertain? | Cash withdrawals and ambiguous merchants | Visible unresolved total |
First reconcile the period. Next normalize merchants without deleting raw descriptions. Then assign transaction classes, followed by spending categories. Compare months only after each month passes the same checks. This order prevents a transfer or credit-card repayment from becoming an apparent spending spike.
The tools do not require bank credentials, and the guides do not assume every transaction can be classified with certainty. We prefer an honest unresolved bucket to a confident but invented answer. The objective is a report you can explain and use, not a decorative score.
Start with a defined question: how much cash is available after obligations, which category changed, or which costs are candidates for reduction. A report that tries to answer every question at once usually becomes an unreadable ledger.
For a monthly review, show total external inflow, total external outflow, the cash-flow difference, major categories, periodic costs, and unresolved transactions. Keep the transaction-level evidence available beneath that summary.
A larger total does not always mean habits changed. One month may contain five weekly shopping trips, an annual bill, a delayed refund, or two pay dates.
Explain changes with a bridge from the prior period: identify the few categories responsible, mark one-time events, and calculate a normalized view only when it clarifies the decision. Preserve the actual cash view as well, because the bank balance still absorbs the real timing.
If one of these checks fails, use the result as a draft rather than a conclusion. The guides below cover the individual controls, while the spending analyzer provides a private browser-based workspace for testing the final category view.