Turn a bank CSV into a cash-flow picture you can trust

List the accounts included in the review and use one opening and closing date. If checking and savings are both included, transfers between them are internal movement. If a savings account is outside the review, a transfer to it is an outflow from the included accounts, but still deserves a transfer label rather than Groceries or Rent.

Use the transaction's posting date consistently. A pending card transaction and its settled replacement are not two purchases. Keep the original description, signed amount, account label, and an optional category in separate columns. Do not overwrite the source description when assigning a clearer merchant name.

For a fictional month, opening cash is $2,000, money received is $3,000, and money paid out is $2,600. Closing cash should be $2,400. Check that opening cash plus net movement equals the statement's closing balance before interpreting categories. A missing $80 line changes the reconciliation even if every category label looks reasonable.

If you combine accounts, reconcile each account separately first. Then remove paired internal transfers from the combined inflow and outflow totals. Their net effect is already zero, but leaving them in both sides exaggerates the scale of income and spending. Do not automatically pair every equal amount: timing, account direction, and reference information must also support the match.

Suppose the month contains a $500 move from checking to savings, a $700 card payment, and $700 of card purchase lines. If both the bank account and card activity are included, count purchases in their categories and treat the card payment as settlement of those purchases. Otherwise the apparent expense becomes $1,400.

Record refunds as reductions of the relevant spending category when the link is clear. Keep loan principal, interest, reimbursements, and transfers distinguishable. They can all reduce cash, but they answer different questions. An unexplained transaction is an exception to review, not a reason to silently delete a row.

Group the signed amounts by category and month. Excel SUMIFS can total amounts meeting both category and period criteria. Keep an Unreviewed category visible until its rows are resolved. The spreadsheet totals guide explains why a filter, subtotal, or text-typed amount can make a second total disagree.

Treat annual bills and one-off purchases separately when describing recurring cash needs. A single month's export does not establish an annual pattern, and dividing an unusually large month by four weeks does not make it representative. State the observed window beside every chart and compare like-for-like periods when more history is available.

Keep three outputs: the unchanged export, a reviewed transaction table, and a short summary of inflows, outflows, closing balance, and unresolved items. Record why transfers were paired and why ambiguous rows received their categories. Next month, reuse the rules and review new exceptions rather than trusting last month's merchant mapping blindly.

The personal finance use case shows the broader workflow. To inspect a file, start a free analysis, then compare its findings with the statement reconciliation. A clear chart is helpful; a chart that accounts for every source row is the one you can check.