Bank statement automation for bookkeeping and reconciliation
For bookkeepers and accounting teams whose clients send statements as PDFs and scans. It covers when a bank feed isn't enough, how automation works, the checks to run before import, and how to reconcile.
Key takeaways
- Bank statement automation reads statements that arrive as PDFs, scans or photos. It turns every transaction into data your accounting software can import, with the balances checked on the way.
- It fills the gaps bank feeds leave, from accounts with no feed to history older than the feed reaches.
- Before import, check that opening and closing balances tie out. Also check that running balances hold, no month is missing or loaded twice, and the account matches the ledger.
- A bank reconciliation statement is a report that compares your bank balance with your books. You adjust the bank balance for deposits the bank hasn't received yet and checks that haven't cleared. You adjust the book balance for fees, interest or errors, until the two match. The IRS recommends reconciling every month.
On this page
Bank statement automation turns the statements your clients send into checked transactions. Your accounting software can import them. The statements may be PDFs, scans or phone photos. Nobody retypes them when a bank feed can't supply the data. Software reads every transaction, checks it against the statement's running balance and flags anything it isn't sure of. You import the clean data and reconcile as usual.
| Field | Extracted value | Confidence |
|---|---|---|
| Account holder | Harbor Street Bakery LLC | |
| Address | 118 Harbor St, Portland, ME | |
| Bank name | First Midwest Bank | |
| Account number | •••• 4821 | |
| Account type | Business checking | |
| Statement period | 2026-07-01 → 2026-07-31 |
| Field | Extracted value | Confidence |
|---|---|---|
| Opening balance | 42,180.55 | |
| Total deposits | 88,412.10 | |
| Total withdrawals | 91,686.44 | |
| Closing balance | 38,906.21 | |
| Transaction count | 142 |
| Field | Extracted value | Confidence |
|---|---|---|
| Date | 2026-07-14 | |
| Description | ACH DEPOSIT STRIPE PAYOUT | |
| Amount | +3,284.10 | |
| Debit / credit | Credit | |
| Running balance | 51,902.44 | |
| Category | Card processor payout |
When bank statements arrive as PDFs instead of a feed#
When a bank feed is connected, transactions arrive on their own. Statements fill the gaps. These are the usual ones.
No bank feed
Some banks, credit unions and card issuers don't connect to your accounting software, or the connection breaks.Catch-up and cleanup
A bank feed only downloads transactions back to a certain date. So if a client's books are months behind, you rebuild the older months from their statements.New clients
Opening balances and last year's activity come from the statements the client already has.Closed accounts
An account closed mid-year has no feed left, but its transactions still belong in the books.Year-end and tax prep
Closing statements back up year-end balances, and the IRS lists account statements among the records that support business expenses.Fiduciary accounts
Court accountings rest on statements. California, for one, requires conservators and guardians to file, with each accounting, the statement for every account showing its balance on the closing date.
How bank statement automation works#
Every statement goes through the same four stages, whatever the bank or layout.
- Client PDFs
- Scans and phone photos
- Statements sent by email
- 01Extract every transaction
- 02Check running balances
- 03Categorize with your rules
- 04Review flagged lines
Extraction reads the header, the balances and every transaction row. It joins tables that run across pages. Each row is checked against the statement's running balance, so a misread amount shows up as a break instead of landing in the books. Values the software isn't sure of go to a person with the source line highlighted.
We'd want automation that behaves the same way every time. Your reviewer should see only the lines the software isn't sure of, with the reason and the matching line on the statement. All other lines should import without anyone opening them.
Categories can be added in two ways. You can set up a step in the Docsumo workflow. It can be an AI step or your own Python code that matches each payee to an account. Or your accounting software can add them after import.
The result downloads to Excel. Keep the date, description and amount columns and save the sheet as CSV. QuickBooks Online, for example, imports 3 columns (Date, Description, Amount) or 4 (Date, Description, Credit, Debit), up to 1,000 lines per upload. Firms loading many clients can pull the data through Docsumo's API instead. For other ways to get a statement into Excel, see how to convert a bank statement PDF to Excel.
Checks to run before you import#
A statement that reads cleanly can still be wrong for your books. Run these on every file.
- Balances tie outThe opening balance plus deposits minus withdrawals equals the closing balance printed on the statement.
- Running balances holdEach transaction moves the running balance by its own amount. A break points to a misread or missing row.
- No missing monthsEach statement opens at the previous month's closing balance, and no period is skipped.
- No duplicatesNo statement is loaded twice, and no month the bank feed already brought in is imported again.
- Dates in rangeEvery transaction falls inside the statement period you're importing.
- Right accountThe account number and account holder match the ledger account you're importing into.
Docsumo checks each transaction against the statement's running balance. The tie-out, date and account checks can run as steps you set up in the workflow. Checks that compare several statements, such as spotting a missing month or a statement loaded twice, are called cross-document validation. Cross-document validation is on the Enterprise plan.
What is a bank reconciliation statement?#
A bank reconciliation statement is the report that bank statement reconciliation produces. It compares the balance on your bank statement with the balance in your books for the same date. It lists every item that explains the difference between them. Once every item is listed, both adjusted balances are the same. It confirms how much cash is really in the account, brings bank charges into your books and catches errors on either side. IRS Publication 583 recommends doing it every month.
Here is the publication's worked example. It is a small business's January reconciliation.
| Item | Amount |
|---|---|
| Closing balance on the bank statement | $1,458.12 |
| Add: two deposits not yet on the statement | +$1,217.41 |
| Subtract: four checks that haven't cleared | −$526.50 |
| Adjusted bank balance | $2,149.03 |
| Balance in the checkbook | $2,153.03 |
| Add: a $600.40 deposit entered in the checkbook as $594.40 | +$6.00 |
| Subtract: bank service charge | −$10.00 |
| Adjusted book balance | $2,149.03 |
How to reconcile a bank statement#
Take the same January example and work through it in order. Step 1 is to make sure the periods match. The bank statement and your cash account must end on the same date. Also check your own figures before you start.
Next, adjust the bank side. The statement closes at $1,458.12. Two deposits made late in the month aren't on it yet, so you add $1,217.41. Four checks haven't cleared, so you subtract $526.50. The adjusted bank balance is $2,149.03. A bank error would be corrected on this side too.
Then adjust the book side. The checkbook says $2,153.03. A $600.40 deposit was entered as $594.40, so you add the $6 difference. The bank also charged a $10 service charge that isn't in the books, so you subtract it. Returned (NSF) checks come off on this side as well, and interest the bank paid goes on.
Both adjusted balances land on $2,149.03, so the account is reconciled. The $6 difference was only a mistake in the checkbook, because the cash receipts record had the right amount. The only entry still missing from the books is the $10 service charge. Record the book-side adjustments and keep the reconciliation with the month's records.
If the balances still differ, the IRS advice is to go back and check each step to find the error. Automation helps most with step 1, because it gets every transaction and balance off the statement correctly. The matching itself happens in your accounting software.
Where Docsumo fits#
Docsumo is an intelligent document processing (IDP) platform. It reads bank statements whether they arrive as PDFs, scans or photos. It joins transaction tables that run across pages and checks running balances. It sends values it's unsure of to your reviewers. Statements come in by upload, by email to a Docsumo inbox or through the API. Results go out as an Excel download or through API and webhooks. It isn't accounting software. It doesn't keep a ledger, reconcile accounts or connect to bank accounts the way a bank feed does.
In the video, Tien Tran of Heard describes how Heard scaled its bookkeeping with Docsumo. More stories are on our customers page. For other tools bookkeepers use, see the best accounting data entry software.
- 99%field-level accuracy on 250+ document types
- 95%+of documents processed straight through, without manual review
- <5 minper document, down from 2+ hours
What's left for the bookkeeper once the import is clean#
Bank feeds bring in the transactions they can, and statements supply the rest. With automation, the software reads every transaction from the PDF, checks the balances and catches problems before you import. A person looks only at the lines the software isn't sure of. Then reconcile as always. Adjust both sides until they match, and record what the books were missing.
Book a demo with a few of your clients' statements, or start a free trial.
Frequently asked questions#
What is bank statement automation?
Bank statement automation is software that reads bank statements, whether they arrive as PDFs, scans or photos. It reads every transaction and balance, checks them, and sends the data to your accounting software. It replaces retyping statements when a bank feed can't supply the transactions.
What is a bank reconciliation statement?
A short report that starts from the closing balance on the bank statement and the balance in your books for the same date. It adjusts each side for items the other doesn't show yet, such as deposits in transit, outstanding checks, bank fees or interest, and for errors. It ends with two matching adjusted balances.
What are the advantages of a bank reconciliation statement?
It confirms how much cash is really in the account. It brings bank charges and interest into your books and catches errors made by you or the bank. It also leaves a monthly record your accountant or auditor can check.
How often should you reconcile a bank statement?
Every month, when the statement arrives. IRS Publication 583 recommends reconciling your checking account each month, after checking your own figures first.
Can QuickBooks Online read PDF bank statements?
Yes. Intuit's help center says QuickBooks Online accepts a PDF or image of an account statement from any bank, as long as it's in English. It uses AI to extract the transactions, with some items flagged for review. It also takes transaction files in CSV, QBO or QFX format. Separate extraction software helps when you handle many clients' statements and want the same checks run on every file before anything is imported.
Does Docsumo reconcile accounts or connect to bank accounts?
No. Docsumo reads the statements you or your clients provide, checks running balances and sends uncertain values to a reviewer. It doesn't connect to bank accounts the way a bank feed does. It doesn't keep a ledger or reconcile accounts either. Its output goes to your accounting software, where reconciliation happens.