Blog · Board and management reporting · Finance and FP&A teams
A business bank statement analysis report explains receipts, payments and the change in cash. Build it from transaction exports, remove internal transfers from consolidated activity and reconcile the result to the cash ledger.
A bank statement analysis report explains where a business's cash came from, where it went and why the closing balance changed. Start with the bank's transaction export, classify each movement and prove opening cash plus receipts minus payments equals closing cash. Reconcile that bank balance to the cash ledger before using the report for a finance review.
Use one completed statement period for each account. Keep the account identifier, bank transaction reference, posting date, description, money in, money out and currency. Save the statement's opening and closing balances separately from its transaction rows; importing those balances as transactions would count them twice.
Use posted transactions for the statement proof. Pending transactions belong on a separate review list because their amounts or settlement dates can change. For a company with several accounts, reconcile each account before combining them. Do not combine foreign-currency balances with USD without an explicit translation method and a separate exchange difference.
The IRS's recordkeeping guidance recommends monthly checking-account reconciliation and describes differences caused by bank charges, deposits and uncleared checks. The same discipline applies when a finance team builds a summary from a bank export rather than a checkbook.
Here is an illustrative October 2026 export for Cedar Industrial Supply, a US distributor. Its operating account starts with $100,000. Amounts below are whole USD, with inflows positive and outflows negative; no rounding is needed.
| Posted date | Reference | Classification | Signed amount (USD) |
|---|---|---|---|
| October 2, 2026 | C101 | Customer receipts | 80,000 |
| October 4, 2026 | P201 | Supplier payments | -50,000 |
| October 9, 2026 | C102 | Customer receipts | 45,000 |
| October 12, 2026 | P202 | Payroll | -30,000 |
| October 15, 2026 | T001 | Internal transfer | -20,000 |
| October 19, 2026 | L001 | Loan proceeds | 25,000 |
| October 23, 2026 | P203 | Rent | -12,000 |
| October 31, 2026 | F001 | Bank fees | -150 |
Put these columns in A:D, with headings on row 1. If the export supplies separate money-in and money-out columns, subtract money out from money in to create D; retain the original columns for inspection. Never assume a bank's debit label uses the same sign as your ledger.
Enter the opening balance in H2 and the statement closing balance in H3. Use:
Total receipts: =SUMIF(D2:D9,">0",D2:D9)
Total payments: =-SUMIF(D2:D9,"<0",D2:D9)
Computed closing balance: =$H$2+SUM(D2:D9)
Statement difference: =$H$2+SUM(D2:D9)-$H$3
Customer receipts: =SUMIFS(D2:D9,C2:C9,"Customer receipts")
The labels identify output cells; enter the formula after each colon. Microsoft documents SUMIFS as summing amounts that meet specified criteria. Covirage is not affiliated with Microsoft.
| Operating-account proof | Calculation | Amount (USD) |
|---|---|---|
| Opening balance | Statement opening | 100,000 |
| Total receipts | 80,000 + 45,000 + 25,000 | 150,000 |
| Total payments | 50,000 + 30,000 + 20,000 + 12,000 + 150 | 112,150 |
| Net increase | 150,000 - 112,150 | 37,850 |
| Computed closing balance | 100,000 + 37,850 | 137,850 |
| Statement closing balance | Statement closing | 137,850 |
| Difference | 137,850 - 137,850 | 0 |
The proof establishes completeness against the statement, not correct classification. A loan mistakenly labeled as a customer collection would still pass this balance test. Review the classification support as a separate control.
Cedar's savings account starts with $40,000 and receives the matching $20,000 transfer, with no other activity. Its closing balance is $60,000. The consolidated opening balance is $100,000 + $40,000 = $140,000; the consolidated closing balance is $137,850 + $60,000 = $197,850.
| External cash bridge | Calculation | Amount (USD) |
|---|---|---|
| Customer receipts | 80,000 + 45,000 | 125,000 |
| Loan proceeds | L001 | 25,000 |
| External payments | 50,000 + 30,000 + 12,000 + 150 | -92,150 |
| Net external increase | 125,000 + 25,000 - 92,150 | 57,850 |
| Balance movement | 197,850 - 140,000 | 57,850 |
The transfer is a payment in the operating account and a receipt in savings. Across both accounts, -$20,000 + $20,000 = $0. Excluding both sides from external activity leaves the company's cash movement unchanged.
This report follows the company's cash, while bank profitability analysis answers a different question about banking economics. For forward payment decisions, carry the reconciled balances into a cash management report.
Suppose Cedar's unadjusted operating-account ledger balance is $139,500. The reconciliation identifies a deposit recorded in the books but not yet posted by the bank, outstanding checks and the bank fee not yet recorded in the ledger.
| Reconciliation item | Bank side (USD) | Book side (USD) |
|---|---|---|
| Unadjusted closing balance | 137,850 | 139,500 |
| Deposit in transit | 8,000 | 0 |
| Outstanding checks | -6,500 | 0 |
| Unrecorded bank fee | 0 | -150 |
| Adjusted balance | 139,350 | 139,350 |
Enter these columns in J:L, with the unadjusted balance on row 2 and adjustments on rows 3:5. The check is:
=SUM(K2:K5)-SUM(L2:L5)
It returns zero. Keep the $137,850 statement balance distinct from the $139,350 adjusted cash balance. The fee needs an approved ledger entry; the timing items need follow-up evidence that they cleared. The report itself does not post either correction.
Keep a named reviewer and unresolved-item list beside the report. A flash report can summarize the result once the bank and ledger checks are complete.
Bring your business bank transaction export and cash-ledger workbook: Covirage maps the columns, and its tools compute the movement summaries and check the supplied balances. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for finance teams for the broader reporting context.
No. Customer collections can relate to earlier sales, loan proceeds increase cash without creating revenue, and equipment purchases affect cash differently from expense. Use the statement to explain cash movements, then use the income statement for profit under the company's accounting policies.
Keep both sides in their individual account reports and match them using the transfer reference, amount and dates. Exclude matched internal transfers from consolidated external receipts and payments. Investigate an unmatched side before assuming the transfer has cleared.
Descriptions help identify transactions, but they do not establish the accounting treatment. Match payments to approved invoices, payroll records or other support. Keep uncertain classifications visible for review rather than assigning an expense category simply because a vendor name looks familiar.