Business Cash Flow Analysis

That first step is the one most people skip, and it quietly wrecks the rest. If a 4,000 supplier payment never made it onto your spreadsheet during a copy-paste, your "healthy" month was never healthy. Treat verification as part of the analysis, not a separate chore.

One thing to settle up front, because it trips up new owners: cash flow is not profit. Profit is revenue earned minus costs incurred, whenever they fall. Cash flow is the real movement of money in and out of the bank. A business can be profitable on paper and still run out of cash, because customers pay late while wages, rent and VAT don't wait. Statements are the honest record because they ignore accruals — they show the day money arrived and the day it left.

Start by proving the statement is complete

Before you total a single inflow, prove nothing is missing. Banks print a running balance after every transaction — it's the account's true position at that moment, so you can use it as a checksum. Take the opening balance, apply every credit and debit in order, and you should land exactly on the closing balance on the last line. If you do, the statement reconciles and you can trust what follows. If you're out by, say, 4,000, a transaction is missing or misread — and the size of the gap usually points straight at it.

This matters most when the data has been pulled out of a PDF. Extraction slips in predictable spots: a row goes missing in the join between two pages, a 1,290.00 debit gets read as 1,920.00 when the digits flip, a credit lands in the wrong column. None of these announce themselves; the running balance catches all of them at once.

Export Bank Statement runs this check for you. It extracts 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 cash flow work, hoping isn't good enough, because the whole analysis inherits whatever errors slipped through.

The four things a business cash flow analysis should tell you

Once the figures are verified, the analysis is straightforward. These are the four reads that inform a decision, and they map onto what the built-in analyser surfaces after conversion.

• Net cash position. Money in minus money out across the period. Positive means the account grew; negative means it shrank. Read it alongside the closing balance, because a business can post a positive month and still have sat dangerously low halfway through.
• The lowest point, not the last line. A statement can end higher than it started and still have spent ten days underwater. The trough tells you whether you needed an overdraft, and it's invisible from the headline figures.
• Seasonality. Pull several months together and the shape appears: the quarter receipts spike, the month costs balloon, the lag between a busy sales period and the cash arriving. One statement is a snapshot; several are a pattern.
• Recurring costs. The payments that repeat — subscriptions, standing orders, finance repayments, the direct debit nobody remembers signing up for. Easiest to lose track of, easiest to act on. A forgotten 60 monthly charge is 720 a year doing nothing.

The analyser pulls these out after conversion: cash flow over the period, income verification, expenses grouped by category, and recurring or merchant detection. Because it runs on reconciled data, every figure inherits the completeness you proved first.

How to analyse business cash flow from bank statements, step by step

You can do all of this by hand — foot each page, tick the running balance, sort credits from debits, then group the outgoings. It works, but it eats an afternoon for a busy account, and the manual re-keying is where fresh errors creep in. The faster route, on data you can trust:

1. Gather the statements. Download the PDFs from online banking — ideally several consecutive months, so seasonality and recurring costs have room to show. A scan or phone photo of a paper statement works too; it'll be read by OCR.
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 manual skim would likely have missed.
4. Read the cash flow. Open the analyser: net cash position, the lowest point in the period, income regularity, and where the money goes once it's grouped. The expense analysis guide breaks the outgoings down further.
5. Project forward if you need to. A clean run of verified months is the only honest basis for a cash flow forecast.
6. Export. Take the clean .xlsx for your own working, or the CSV in the native bank-import format if it's headed for your accounting software.

A single month is usually done in well under a minute, which changes how often you bother to look. Monthly beats annually: a cash squeeze you spot in week two is fixable; the same one found at year-end is just a story about what went wrong.

A worked example

A small trading business, one quarter, roughly 300 transactions a month across a nine-page PDF. By hand that's the best part of a day — and when I footed the first month, page six didn't tie out. Two transactions had collapsed onto a single row during a copy-paste, so the total understated outgoings. Nothing on screen looked wrong; the numbers were just quietly short, which is the worst kind of error because you trust it.

Run the same PDFs through the converter and the reconciliation check flagged that month in seconds and pointed at roughly where the gap sat. Once it was fixed, the real story showed. Net cash position looked fine — slightly positive across the quarter. But the lowest point told a different tale: the account dropped under 900 in the second week of every month, when wages and rent left, a fortnight before the largest customer settled. And four recurring subscriptions had crept up to 340 a month between them, none of it questioned. None of that shows in the closing balance; all of it is obvious once the data is verified and grouped.

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 a CSV in the native bank-import format Xero, QuickBooks and Zoho Books expect. The honest caveat: this is a file import, not a live bank feed. It doesn't push transactions into your ledger through a certified bank-feed API — you convert, then you import the CSV, and it lands as reconcilable statement lines. It's also a tool you run yourself, not a bookkeeping service: the judgement stays yours, and the tool gives you the figures that judgement depends on. The same logic covers a household budget; for that, see the personal cash flow analysis guide.