Create a profit and loss statement from bank statements
A profit and loss statement is computed from categorized journal entries, so the work is the categorizing — the report itself is one request. Reconcile first, so the books agree with the bank, then ask for the P&L for a date range. Bank statements alone will miss anything that never touched the account.
People usually arrive at this wanting the report and discover the report is the easy part. A profit and loss statement is arithmetic over entries that already exist; if the entries are wrong, the report is wrong in a way that looks perfectly reasonable.
So this covers the two steps that make the number trustworthy, and then the four situations where a P&L built from bank statements tells you something misleading.
Before you start
- Transactions categorized for the period you want. If they are not, start with turning a statement into categorized books.
- The closing balance from your bank for the end of that period.
1. Reconcile before you report
Reconciling compares what your books think the account holds against what the bank says it holds. If those disagree, something is missing, duplicated, or recorded twice — and this is the step that catches the transfer problem, which nothing else does.
A P&L run on unreconciled books is a confident number derived from an unchecked premise.
What you should get back: The two balances side by side and the difference between them. Zero is what you want. Anything else is worth resolving before continuing.
2. Check that the books internally agree
A quick structural check: total debits equal total credits. This will essentially always pass, because the database refuses unbalanced entries — which makes it a fast way to confirm you are looking at the book you think you are looking at, and a useful place to spot an account with a balance that surprises you.
What you should get back: Every account with a balance, and debits equal to credits.
Tools: See every account balance in one place, and confirm the books actually balance
3. Run the profit and loss statement
Income, then cost of sales, then operating expenses, then what is left. Computed from the entries rather than summarised from anything.
Read the expense lines against what you expected. The number that surprises you is usually either a genuinely surprising month or a categorization that went somewhere odd, and the general ledger will tell you which within a minute.
What you should get back: A statement for the range you asked for, with amounts as both figures and formatted currency.
4. Ask what the report does not say on its face
This is the part that is genuinely better with an assistant than with a spreadsheet. The report gives you totals; asking about them gets you the specific transactions behind a line, without you clicking into anything.
What you should get back: A comparison with the underlying transactions for whatever moved.
Tools: See where your money actually went, grouped your way, Trace exactly how one account got to its current number
When it does not go to plan
| What you see | Why | What to do |
|---|---|---|
| Profit looks far better than it feels. | Expenses paid from an account you have not imported — a personal card used for business, or cash. | Import those statements too, or record the expenses directly. A P&L only knows what it has been told. |
| A loan repayment is eating your profit. | The whole repayment was categorized as an expense. Only the interest is an expense; the principal reduces the loan balance and belongs on the balance sheet. | Split the payment: interest to interest expense, principal against the loan account. |
| Profit is high but there is no money in the bank. | Profit and cash are different questions. Money can leave for things that are not expenses — loan principal, owner draws, buying equipment. | Run the cash position beside the P&L. The guide on cash flow explains why the two disagree. |
| Income looks inflated. | A transfer in from your own savings, or a refund, was categorized as revenue. | Reverse it and recategorize. Refunds reduce the expense they reversed; transfers are not income at all. |
Common questions
- Can I really produce a P&L from just bank statements?
- For a business whose money all moves through one or two accounts, yes, and it will be broadly right. It will miss anything that never touched those accounts, and it will be on a cash basis rather than an accrual one, which matters if you invoice and get paid late.
- Is this good enough for taxes?
- It gives your accountant a categorized ledger and real statements, which is what they usually ask for first. Whether the treatment of any particular item is right for your tax position is a question for them — this is not a tax product.
- Why does my P&L not match my bank balance?
- It should not. A P&L covers a period and only includes income and expenses. Your bank balance is a point in time and is affected by things that are neither.
- Can I get a balance sheet the same way?
- Yes, from the same entries. It answers a different question — what you own and owe at a moment — and it is worth running beside the P&L.
Checked against the tools on 2026-08-09.