Sharpe CPA / For CPAs / Bank statement workbook

A year of bank statements, in one workbook.

Give it the monthly statements. You get back an Excel workbook with every transaction, each month proved to the bank’s own ending balance, the checks in number order with the gaps, totals by category, and a reconciliation ready to fill in. Free, no account needed.

Use at your own risk. This free tool is provided as is, without warranty, and is not accounting, legal or tax advice. All of the work a CPA performs is subject to that person’s or firm’s judgment. Do your own research and verify that the checklist or protocol you are using is valid and up to date. Built from public sources — see the sources and the terms of use.

Step 1

The statements

Choose all of them at once — the PDFs downloaded from the bank’s website, or the bank’s CSV export. More than one account is fine; they are kept apart.

Choose the statements or drop them here — PDF or CSV, as many as you have

The statements stay on your computer. They are read by this page in your browser and the workbook is written there too. Nothing is uploaded, stored or seen by anyone.

What you get

Read, proved, and ready to work.

A reading you cannot check is not worth much, so every statement is proved: its beginning balance, plus what was read in, less what was read out, has to come to the ending balance the bank printed.

Summary

Sign-offs; each month’s beginning balance, deposits, electronic credits, checks, other debits and ending balance, proved and checked against the month before; the year in total; and the points to look at — a statement that does not prove, a missing month, a check that cleared twice.

Transactions

Every line of every statement with date, month, type, check number and the bank’s description, and columns for payee, memo and category. Filter it by month, type or category and the totals follow.

Categories and checks

Receipts and payments by category, filling in as the transactions are coded. The checks in number order, with every number that did not clear — outstanding, void, or cleared outside the year.

Reconciliation

The balance per the last statement, with room for deposits in transit and outstanding checks, the balance per books, and the difference.

It reads statements that were produced by the bank as PDFs. A scanned statement is a picture of the page and has no text in it to read; download the statement from the bank’s website, or export the transactions as CSV.