A practical guide to turning verified bank-statement transactions into a review-ready cash-basis revenue and expense summary.
Last updated 2026-07-25
TL;DR answer
Start with complete statement rows. Separate likely operating income and expenses from transfers and other non-operating movements, leave uncertain items unclassified, and calculate net movement plus classification coverage. Treat the result as a review document rather than finished accounts. ClearlyLedger can organize an eligible converted bank statement while keeping exclusions and uncertainty visible.
A useful revenue and expense summary answers a modest but important question: what money appears to have come into and gone out of this account during the period, and how much of that activity has been classified confidently? It does not turn bank data into audited accounts. It gives an owner, bookkeeper, or accountant a transparent first pass they can examine instead of a black-box total.
This guide explains the fields, calculations, exclusions, and review decisions behind that first pass. To see the product itself, visit the ClearlyLedger revenue and expense summary report feature page.
Total statement inflows and total statement outflows cover all normalized cash movements in the eligible account. Overall net cash movement is the backend-authoritative difference across that complete activity. Candidate income is money received that appears related to normal operations, while candidate expenses are payments that appear related to running those operations.
Candidate income minus candidate expenses is a separate review calculation, not the report's overall net cash movement. A responsible report shows the overall and candidate figures together with excluded transactions, unclassified transactions, and classification coverage; otherwise a neat headline number can hide important uncertainty.
The word candidate matters. A customer receipt may be revenue, but it might instead be a loan, capital contribution, refund, or transfer from another account. A payment to a familiar supplier may be an expense, but its treatment depends on what was purchased and why. Preserve the original date, description, and amount so a reviewer can trace every summary figure back to a transaction.
Monthly totals add context. They can reveal seasonal receipts, a recurring cost that jumped, or an incomplete statement period. They are diagnostic rather than predictive: a January-through-March summary describes those months and does not forecast April.
A bank-derived summary and a profit and loss statement can have similar-looking headings, but they are not interchangeable. Formal accounts may include accruals, depreciation, inventory adjustments, prepayments, unpaid invoices, and entries that never appear as a simple bank transaction in the same period. One account may also omit card, cash, payment-processor, or other-account activity.
A cash-basis view generally records income when money is received and expenses when money is paid. Exact rules and eligibility depend on the jurisdiction and taxpayer. For UK context, consult HMRC’s official cash-basis guidance . For US context, IRS Publication 538, Accounting Periods and Methods , which explains cash and accrual methods and why consistent method selection matters.
ClearlyLedger labels the output a cash-basis draft. It is not a GAAP or IFRS statement, tax return, forecast, audit opinion, or substitute for professional accounting judgment. Use it to accelerate organization, then reconcile it with complete books and the rules applying to the entity.
Begin with the complete statement period rather than screenshots of selected transactions. Each row needs a transaction date, the bank’s unedited description, and an amount whose direction is unambiguous. Direction may appear as separate debit and credit columns or one signed amount. A running balance is valuable because it can expose missing, duplicated, or incorrectly signed rows. Account identity, currency, statement dates, and opening and closing balances provide the reconciliation frame.
Category is not a source field; it is a conclusion added after extraction. Keeping source data separate from classification makes corrections easier and preserves the review trail.
Imagine an eligible business bank statement covering January through March. After extraction and classification, the review screen shows these illustrative totals:
| Measure | Amount | Meaning |
|---|---|---|
| Total statement inflows | $50,000 | All normalized money in |
| Total statement outflows | $34,864 | All normalized money out |
| Overall net cash movement | +$15,136 | Backend total for the complete statement activity |
| Candidate income | $42,680 | Likely operating receipts |
| Candidate expenses | $27,940 | Likely operating payments |
| Candidate income minus expenses | +$14,740 | Explicit review calculation, not overall net |
| Excluded inflows / outflows | $4,500 / $2,600 | Shown separately |
| Unclassified inflows / outflows | $2,820 / $4,324 | Needs a decision |
| Classification coverage | 91.6% | Completeness signal |
The complete figures reconcile: $50,000 of total inflows minus $34,864 of total outflows equals the backend overall net cash movement of $15,136. The separate $14,740 candidate review calculation is not profit and is not substituted for that overall net. Excluded and unclassified amounts remain visible within the complete inflow and outflow totals but are not silently added to candidate income or expenses. Coverage highlights remaining work; it does not prove that every existing category is correct.
The workflow starts with a bank-statement conversion. ClearlyLedger extracts and normalizes transactions; it does not invent entries to make totals look complete. For an eligible bank-account statement that passes conversion review gates, the summary appears below the result. Credit-card statements are not eligible in the current release because purchases and card payments require a different accounting model.
The on-screen summary is included with eligible conversions. Starter and higher plans add the report worksheet to Excel and unlock a formatted PDF export. Check current pricing and plan limits rather than assuming an entitlement, and review the privacy policy before uploading financial documents.
Included views cover total statement inflows and outflows, candidate income and expenses, monthly cash movement, category totals, classification coverage, and explicit unclassified and excluded cash activity. These are review aids based on normalized transactions returned by the conversion.
Excluded from the product’s claim are tax calculations, filing advice, forecasts, and GAAP or IFRS certification. Recognized transfers, cash movements, investment activity, tax payments, and EMI categories are kept out of candidate operating totals and shown separately. Excluded means excluded from the candidate calculation, not erased or necessarily irrelevant to the books.
Transfers are a classic source of double counting. Moving $5,000 from savings to an operating account creates an inflow on one statement and an outflow on another, but no $5,000 of revenue or expense. Matching both sides across accounts is stronger evidence than a description such as “online transfer.”
Financing also needs care. Loan proceeds increase cash without being operating revenue, while a payment can contain principal, interest, and fees with different treatments. Owner contributions and distributions move cash without automatically belonging in operating income or expenses.
Reversals and refunds should be paired with the original event where possible. Equal and opposite entries may cancel in net cash, yet classifying one as income and one as expense inflates both totals. Unfamiliar acronyms, processor settlements, split deposits, and cash withdrawals should stay unclassified until evidence resolves them. Visible uncertainty is safer than false precision.
Only source statement pages consume quota. On a Starter allowance of 500 monthly pages, processing a 50-page statement means 500 minus 50 equals 450 pages remaining. The charge reflects the document length, regardless of how many transactions appear on those pages.
Viewing the summary or exporting an available report uses no additional pages. Opening classification details and adding the worksheet when the plan includes it likewise do not reduce the remaining allowance. Current limits and export availability are on the pricing page.
No. It is a bank-derived draft of candidate cash activity. Formal accounts may require accruals, depreciation, inventory, other accounts, and further adjustments.
Do not assume so. Rules and filing requirements vary. Reconcile the draft to complete records and obtain qualified advice.
Recognized transfers are shown as excluded activity rather than silently counted as operating income or expense.
It remains visible as unclassified activity, reduces coverage, and gives the reviewer a specific item to investigate.
No. Report downloads do not create a second document-processing charge, although available export formats depend on the plan.
Not in the current release. The report is for eligible bank-account statements because credit-card activity needs different logic.
Build the summary from complete, traceable rows. Show candidate totals, exclusions, uncertainty, and coverage together. Never assume net bank movement equals accounting profit, and never hide transfers or unresolved activity merely to make the report appear finished. The best summary shortens professional review while preserving its evidence.
Convert an eligible statement, inspect its rows, and review every candidate, excluded, and unclassified total.
Loading interactive converter… Try ClearlyLedger free