Personal Cash Flow Analysis

Here's the bit that catches people out. If you pull your transactions into a spreadsheet and a 180 direct debit goes missing in the copy-paste, your "surplus" month was never a surplus. You'll budget around a number that isn't real. So before you total anything, you prove nothing dropped out — and your bank already gives you the tool for that.

Income minus outgoings: the number that matters

Strip away the apps and the jargon and personal cash flow is one subtraction: money in, minus money out, over a fixed window — usually a calendar month, because that's how rent, salary and most bills are timed.

A positive result is a surplus — the month grew your balance, and that's what you can save, overpay debt with, or invest. A negative result is a deficit — you spent more than you earned and made it up from savings, an overdraft, or a card. One deficit month isn't a crisis; three in a row is a pattern that needs a decision.

Two things trip households up. First, your closing balance lies — you can finish 200 up and still have dipped into your overdraft on the 28th, every month, the week before payday. The headline figure hides the trough. Second, lumpy spending distorts a single month — an annual insurance payment, a holiday, a tax bill — so you read the *shape* across several months, not one snapshot.

Start by proving the statement is complete

Before you judge a single month, prove no transaction is missing. Every bank prints a running balance after each line — the true position of the account at that moment. That makes it a built-in checksum. Take the opening balance, apply every credit and debit in order, and you should land exactly on the printed closing balance. If you do, the statement reconciles and you can trust what follows. If you're out by, say, 180, a transaction is missing or misread — and the size of the gap often points straight at the culprit.

This matters most when the data has been pulled out of a PDF. Extraction slips in predictable places: a row vanishes in the join between two pages, a 1,290.00 debit gets read as 1,920.00 when the digits swap, a credit lands in the wrong column. None of these wave a flag at you. The running balance catches all of them at once.

Export Bank Statement runs this check for you. It reads every line, walks the running balance from opening to closing, and confirms the totals reconcile before you download — or flags the statement instead of handing you tidy-looking numbers that are quietly wrong. Most converters just extract and hope. For your own money, that isn't good enough, because every budget decision inherits whatever slipped through.

What a personal cash flow analysis should tell you

Once the figures are verified, four reads do most of the work. They map onto what the built-in analyser surfaces after you convert.

• Monthly surplus or deficit. Income minus outgoings for the month. Track it across the year and you stop guessing whether you're actually saving or just feeling like you are.
• The lowest point, not the closing balance. The day in the month your account hits bottom. If that trough is regularly near zero or in your overdraft, you're living closer to the edge than the end-of-month figure admits.
• Where the money goes. Outgoings grouped into categories — groceries, transport, eating out, housing, debt. This is the honest answer to "where does it all go", and it's almost never where people guess.
• Recurring payments. The subscriptions, memberships and direct debits that repeat. These are the easiest spend to lose track of and the easiest to cut. A forgotten 12.99 streaming service is 155 a year for something you stopped watching.

The analyser pulls these out after conversion — cash flow over the period, income, expenses grouped by category, and recurring or merchant detection. Because it runs on reconciled data, every figure inherits the completeness you proved first. The expense analysis guide goes deeper on the category breakdown, and monthly spending trends covers reading the shape across months.

The subscription leak

If one finding pays for the whole exercise, it's the subscription audit. Seen scattered through a month, each direct debit feels small. Listed together, the total tends to land with a thud — doubled-up streaming services, a gym used twice since January, an app trial that became a 9.99 habit, cloud storage you forgot you pay for. Individually trivial; together, often 100 a month that buys nothing you'd miss. Recurring detection groups these so you decide from a list, not from memory. The detect recurring transactions guide covers how that spotting works.

How to analyse your personal cash flow, step by step

You can do this by hand — total each month, tick the running balance, sort money in from money out, then group the outgoings. It works, but it eats an evening and the re-keying breeds fresh errors. The faster route, on data you can trust:

1. Gather the statements. Download the PDFs from online banking — ideally three to twelve consecutive months, so recurring costs and seasonal spending have room to show. A scan or phone photo of a paper statement works too; it's read by OCR. Pull every account you actually spend from — current account, plus any credit card.
2. Convert them. Upload the PDFs at /convert. The tool reads each line — date, description, money in, money out, balance — across every page.
3. Confirm the reconciliation result. The foundation. Check the totals reconcile before you trust anything downstream. A flagged statement means you've caught a gap a quick skim would have sailed past.
4. Read the cash flow. Open the analyser: monthly surplus or deficit, the lowest point each month, your regular income, and where the money goes once it's grouped.
5. Act on the leaks. Cancel what you don't use, renegotiate what you do, and watch the categories that crept up.
6. Export. Take the clean .xlsx for your own budget spreadsheet, or a CSV if you keep your finances in accounting software.

A single month is usually done in well under a minute, which changes how often you bother to look. Checking monthly beats checking once a year: a habit you catch in week two is fixable, while the same one found at year-end is just a story about where the money went.

A worked example

Take a typical household — two incomes, one joint current account, a credit card, six months of multi-page PDFs. When I footed the third month, a page didn't tie out: a transfer had collapsed onto the row above during the copy-paste, so the month looked 300 better than it was. Nothing on screen looked wrong; the number was just quietly flattering, which is the worst kind of error, because you plan around it.

Run the same PDFs through the converter and the reconciliation check flagged that month in seconds. Fixed, the real picture showed. The surplus was thinner than it felt, and the account dipped into the overdraft in the last week of four months out of six, always just before payday. Recurring subscriptions came to 140 a month — overlapping streaming bundles, a dormant gym, an app nobody remembered. Groceries had drifted up nearly 90 a month without anyone deciding to spend more. None of that shows in the closing balance; all of it is obvious once the data is verified and grouped — and most of it was fixable in an afternoon.

A note on what this is and isn't

Worth being precise, because it's easy to assume more than the tool does. Export Bank Statement converts your PDF statements, verifies they reconcile against the running balance, and exports clean Excel and CSV — including the native bank-import format Xero, QuickBooks and Zoho Books expect, if you keep your finances there. The honest caveat: this is a file import, not a live bank feed. It doesn't connect to your account or pull transactions through an API. The path is convert → import the CSV. It's a tool you run yourself, not a financial-advice service — the decisions stay yours, and it just hands you figures you can trust. Files are processed, then deleted, never used to train AI.