SheetStatement

Preparing Bank Statements for an Audit: A Checklist

By SheetStatement Team · · Updated · 11 min read

TL;DR: For an audit or a tax authority review, have complete official statements for every account for the period, with reconciliations to your books at each month-end (or at least at year-end), a list of outstanding items, and explanations for large or unusual transactions. Organize everything by account and month, keep originals untouched, and give auditors data in a form they can analyze. Ask what they need before you start. This is general information, not audit or tax advice.

Audits come in different shapes: an annual financial statement audit for a company or charity, a grant or funder audit, a lender's review, or an examination by a tax authority. The scope, standards and stakes differ a lot. What they have in common is that bank statements are among the first documents requested, because cash is the easiest balance to verify independently and the hardest to fake.

We've helped plenty of small businesses and nonprofits get their statements audit-ready, usually in a rush. This checklist is what we wish they'd had a month earlier.

What auditors typically do with bank statements

Without going into auditing standards, the common procedures are easy to understand:

  1. Verify the year-end cash balance, often by comparing your reconciliation with the statement and sometimes by getting confirmation directly from the bank.
  2. Check the reconciliation: are the outstanding items real, and did they clear after year-end?
  3. Test transactions: pick payments and receipts from the statements and trace them to invoices, contracts or approvals, or pick items in your books and trace them to the statements.
  4. Look for unusual items: large transfers, payments to related parties, transactions near year-end.
  5. Check completeness: are all accounts included? Bank confirmations can reveal accounts nobody mentioned.

Knowing this tells you what to prepare.

Step 1: Ask for the request list

Auditors usually send a list of what they need (often called a PBC list, for "prepared by client"). Get it early and read it carefully. For a tax review, the authority's letter will specify the period and documents. Don't guess; preparing the wrong things wastes everyone's time.

Step 2: List every account

Include every account the entity held during the period:

  • Operating accounts.
  • Savings, money market and deposit accounts.
  • Payroll accounts.
  • Credit cards.
  • Merchant and payment processor accounts.
  • Loan accounts.
  • Accounts opened or closed during the period.

For each, note the bank, last four digits, purpose, signatories, and whether it's in your books. An account that exists at the bank but not in your books is a significant finding. Find it yourself first.

Step 3: Gather complete statements

Download official statements for every month in the period, plus the first month after the period end (auditors use it to check that outstanding items cleared). Look for "Statements" or "Documents" in online banking; request copies for closed accounts. Our guide on getting old bank statements covers the details.

Check that each statement's opening balance equals the previous closing balance. Fill any gaps.

Save them in a clear structure:

Audit 2025/
  01 Operating 4821/
    2025-01.pdf
    2025-02.pdf
    ...
    2026-01.pdf (subsequent month)
  02 Savings 1190/
  03 Credit card 7734/

Keep originals untouched. If you annotate, do it on copies in a separate folder.

Step 4: Reconcile every month

If your books aren't reconciled monthly, now is the time. At a minimum, have a reconciliation at the period end for each account; monthly reconciliations make the auditor's job (and your fee) smaller.

Each reconciliation should show:

Balance per statement
Add: deposits in transit (listed)
Less: outstanding payments (listed)
Adjusted bank balance
Balance per general ledger
Difference 0.00

List outstanding items individually with dates and references. Our guides to bank reconciliation templates and outstanding checks and deposits in transit cover the mechanics. If you can't get to zero, our discrepancy guide helps.

Step 5: Show that outstanding items cleared

For each item outstanding at year-end, note the date it cleared on the next statement. Auditors routinely check this. Items that didn't clear deserve an explanation: a stale check, a deposit that bounced, an error.

Step 6: Prepare data, not just PDFs

Auditors increasingly analyze transactions as data: sorting by amount, filtering by counterparty, sampling. Giving them a spreadsheet of all bank transactions saves time on both sides. Convert copies of the statements to Excel with SheetStatement, which checks each statement adds up, and combine them into one table with account, date, description, amount and a link to the source file.

Be clear that the spreadsheet is a convenience copy and the PDFs are the source. Auditors will verify it against the statements or obtain their own.

Step 7: Prepare explanations for large and unusual items

Filter the combined data for:

  • Transactions over a threshold that's significant for your organization.
  • Transfers between your own accounts near year-end.
  • Payments to directors, trustees, owners or related businesses.
  • Round-number payments.
  • Cash withdrawals.

For each, prepare a short note with the supporting document. You won't be asked about all of them, but you'll be ready for the ones you are.

Step 8: Keep supporting documents linked

When auditors test transactions, they'll ask for invoices, receipts, contracts, payroll records or board approvals. If your accounting software has attachments, make sure they're there. If not, organize documents so you can find any one in a minute: by month and payee, or by transaction ID.

Bank confirmations

For financial statement audits, auditors often send a confirmation request directly to your bank, asking it to confirm balances, accounts, loans and sometimes other arrangements as at the year-end. You may be asked to sign an authority letter allowing the bank to respond, or to authorize the request through an electronic confirmation platform that the bank and auditor both use.

A few practical points:

  • Respond quickly to the auditor's request for authorization. Bank confirmations can take time, and a late one delays the audit.
  • Expect the bank to list everything in the entity's name, including accounts you'd forgotten. That's partly the point. Better to have mentioned them first.
  • Make sure signatories are current. If the bank's records show people who've left, update them; it can slow the confirmation and it's a control weakness anyway.
  • Compare the confirmation with your reconciliation. The confirmed balance should equal the statement balance on your year-end reconciliation.

Cut-off: transactions around year-end

Auditors pay particular attention to the days either side of year-end. A payment recorded in December that didn't leave the bank until January, or a receipt recorded in January that was banked in December, affects the year-end figures. Before the audit:

  1. List bank transactions from the last week of the year and the first week of the next.
  2. Check each is recorded in the right period in your books.
  3. Pay special attention to transfers between your own accounts: both sides should be recorded in the same period, or the in-transit amount explained.

A transfer that leaves one account on December 31 and arrives in another on January 2 is a classic cut-off item. If one side is recorded in each year, your cash balance is overstated or understated at year-end.

Grant and funder audits

Grant audits focus on whether money was spent as the funder intended. Bank statements are used to show that grant income was received and that eligible expenditure was paid. Useful extras:

  • Tag transactions by grant or project in your combined spreadsheet, so you can produce a list of expenditure per grant directly from the bank data.
  • Separate accounts for restricted funds, if the funder requires it or if you have many grants, make this far easier.
  • Match payments to invoices in advance for each grant's claimed expenditure.

Check the grant agreement for specific record-keeping requirements; some funders specify what evidence they'll accept.

Working with your auditor

A short planning conversation pays for itself. Ask:

  • What period and accounts are in scope?
  • Do they want monthly reconciliations or only year-end?
  • What format do they prefer for transaction listings?
  • Will they request bank confirmations, and how?
  • What sample sizes or thresholds should you prepare explanations for?

Auditors can't do your bookkeeping for you if they're also auditing it, but they can tell you what they need. Most are glad to be asked.

A worked example

A charity with income of a few hundred thousand a year has its first independent audit. The auditor's request list asks for year-end bank reconciliations, statements for all accounts, and a transaction listing.

  1. The treasurer lists five accounts: two current accounts, a deposit account, a card and a payment processor account for online donations. The processor account had been overlooked in the books; its balance is small but real.
  2. She downloads 13 months of statements for each, including January after year-end.
  3. The year-end reconciliations for the two current accounts balance; the deposit account needs an interest posting added.
  4. She records the processor balance in the books with the accountant's guidance.
  5. She converts all statements to Excel and combines them: about 3,400 transactions.
  6. She filters for payments over 2,000 and prepares notes and invoices for 23 of them.
  7. She lists outstanding items at year-end and the dates they cleared in January.

The audit fieldwork took less time than the auditor had planned, and the processor account was disclosed by the charity rather than discovered by the auditor.

Credit cards and payment processors

Card statements get the same treatment as bank statements: a complete set, a year-end reconciliation to the card balance in the books, and support for sampled transactions. Make sure each card payment from the bank account is matched to the payment received on the card, so the auditor can follow it. Our credit card statement converter puts card statements into the same format as your bank data.

Payment processors and online payment accounts are where auditors most often find unrecorded balances. If you take card payments or online donations, your processor holds money between the sale and the payout, and may deduct fees or hold reserves. Download the processor's statement or balance report for the year-end, and record the balance in the books if it's material. Then your bank deposits from the processor can be traced back to individual sales.

Small businesses without an audit requirement

Plenty of small businesses never face a statutory audit, but get a lighter review from a lender, an investor or a buyer doing due diligence. The same preparation works, scaled down: complete statements, year-end reconciliations, and explanations for big items. A buyer's accountant looking at a small business will typically compare bank deposits with reported sales over a couple of years, so having that comparison ready, with differences explained, makes a sale go faster.

Tax authority reviews

If a tax authority is examining your returns, bank statements are used to test whether income is complete and expenses are genuine. They may compare total deposits with declared income, so prepare a reconciliation from deposits to income: total deposits, less transfers between your own accounts, loans, owner contributions, refunds and other non-income items, should come close to reported income, with the remaining differences explained. Our article on bank statements for tax preparation covers organizing statements by tax year.

For any tax examination, get professional advice. How you respond matters, and an accountant or tax adviser who deals with reviews regularly is worth their fee.

Common gaps auditors find

  • Missing statements for months or for closed accounts.
  • Unrecorded accounts, often payment processors, PayPal-type accounts or old savings accounts.
  • Unreconciled differences carried from year to year.
  • Stale outstanding items that should have been written back.
  • Undocumented transfers between accounts.
  • Year-end transactions recorded in the wrong period.

Each of these is cheaper to fix before the audit than during it.

Retention

Keep statements and reconciliations for at least as long as your jurisdiction requires for accounting and tax records, which is often several years and can be longer for certain records. Ask your accountant for the period that applies to you. Store them where you can retrieve them quickly; an audit or review can come years after the period it covers.

Troubleshooting common audit queries

"This outstanding cheque is six months old." Explain why it's still outstanding and what you're doing about it: contacting the payee, voiding and reissuing, or treating it under the unclaimed property rules that apply. Stale items without a plan look like weak controls.

"Why does this transfer appear in one account but not the other?" Usually a timing difference across year-end, or a transfer to an account that isn't in the books. Show the matching line on the other account's next statement, or record the missing account.

"Who approved this payment?" Auditors testing controls may ask for evidence of approval. If your organization requires two signatories or board approval for large payments, keep that evidence with the invoice.

"These totals don't match the general ledger." Usually the reconciliation was done to a different date, or an adjustment was posted after it. Re-run the reconciliation at the exact year-end date.

"Can we have this in Excel?" Have the combined transaction listing ready, with a source column linking each row to a statement.

A mini checklist for the week before fieldwork

  1. Every account listed, with statements for every month plus the next month.
  2. Year-end reconciliations at zero difference, with outstanding items listed.
  3. Outstanding items checked against the next statement.
  4. Combined transaction listing prepared.
  5. Large and unusual items explained, with support.
  6. Supporting documents findable within a minute.
  7. Bank confirmation authorization signed.

A second worked example: a small company's first audit

A growing company passes the threshold for a statutory audit in its jurisdiction. Its bookkeeper had reconciled monthly, but never saved the reports. Rebuilding twelve reconciliations from scratch took two days. They now save each month's reconciliation as a PDF in a dated folder the day it's completed. The following year's audit request for "monthly bank reconciliations" took ten minutes to fulfil.

FAQ

What bank documents do auditors need?

Typically statements for all accounts for the period (often plus the following month), year-end bank reconciliations with outstanding items, and supporting documents for sampled transactions. Ask for the auditor's request list.

Do I need monthly bank reconciliations for an audit?

At least year-end reconciliations are usually needed. Monthly reconciliations make the audit smoother and help you find problems earlier.

Why do auditors want the statement after year-end?

To check that items outstanding at year-end, such as uncashed checks and deposits in transit, cleared as expected.

Can I give auditors a spreadsheet instead of statements?

A spreadsheet of transactions is a helpful addition, but auditors need the official statements as source documents and may get confirmations directly from the bank.

What if I find an account that isn't in the books?

Tell your accountant and auditor, record it properly, and explain it. Disclosing it yourself is far better than having it discovered.

How long should I keep bank statements?

It depends on your jurisdiction and the type of organization. Several years is common for tax and accounting records. Ask your accountant for the rule that applies.

Skip the retyping

Upload a PDF or scanned statement and download a balance-checked Excel, CSV, QuickBooks or Xero file. Try the converter free.

Related articles

Convert your first statement free

3 pages a month on the free plan. No credit card.