Auto-Reconciliation

Auto-reconciliation that catches extraction errors before they reach QuickBooks

Documentric verifies that every extracted transaction adds up to the opening and closing balance on the statement. If anything is off, you see it before you export — not after you've already imported bad data.

50 free pages · No account required

Why reconciliation matters

A single missed or duplicated transaction changes the closing balance. If a $500 debit is extracted as $50, or a transaction row is skipped entirely because it spanned a page break, the exported QBO file will be internally inconsistent from the moment it is created. That error propagates into your QuickBooks ledger, affects every report that touches that account, and may not surface until month-end close or an audit — sometimes months later. Documentric reconciles each statement against its printed balances before you can generate an export file, closing that gap entirely.

How reconciliation works

Four automated steps run every time you process a statement.

1

Extract transactions

All transaction rows are read from the PDF — dates, descriptions, amounts, and running balance.

2

Sum debits and credits

Documentric totals all debits and credits from the extracted transaction list.

3

Compare to statement balances

The computed closing balance (opening balance + net transactions) is compared to the closing balance printed on the statement.

4

Flag any mismatch

If the values do not match within a $0.01 tolerance, a reconciliation warning is displayed before export is allowed.

Extraction errors reconciliation catches

These are the three most common ways extracted data diverges from the original statement.

Missing transaction

A transaction row was not extracted — common when a page break splits a row, or when OCR misreads a dense multi-column layout. The closing balance will not match, and Documentric flags the discrepancy.

Duplicate row

A transaction appears twice — often caused by overlapping page ranges or repeated headers in multi-page statements. The running total becomes inflated and the closing balance check catches it immediately.

Wrong amount

OCR misread a digit — a '3' read as an '8', or a comma misinterpreted as a decimal point. A single wrong amount shifts every running balance below it. Reconciliation surfaces the exact amount of the discrepancy so you can find and fix it.

Reconciliation features

Auto-balance check

After extraction, Documentric sums all debits and credits and verifies the result matches the opening and closing balances printed on the statement.

Flags mismatches before export

If balances do not reconcile, you see a clear warning in the review interface — before any QBO or CSV file is generated. No bad data reaches QuickBooks.

Works across all banks

Documentric reads the opening and closing balance from the statement header or footer regardless of bank layout. No bank-specific templates needed.

Inline fix editor

When a mismatch is flagged, click any transaction to edit the amount, date, or description directly in the table. Reconciliation recalculates live as you type.

Who relies on reconciliation?

Bookkeepers verifying client data

Before entering a client's transactions into QuickBooks, a bookkeeper can confirm in seconds that the extracted data matches the statement exactly — protecting their work and their client relationship.

Mortgage brokers checking income

Income verification requires that every deposit is accounted for. Auto-reconciliation confirms completeness so no deposit is missing from the income calculation.

Accountants closing monthly books

Month-end close requires that bank balances agree to the general ledger. Reconciliation in Documentric means the import file is already verified before it lands in the accounting system.

Forensic accountants

Forensic work depends on complete, unaltered transaction data. Auto-reconciliation provides documented evidence that the extracted dataset matches the original statement balance.

Frequently asked questions

What happens when the balance doesn't match?

Documentric displays a reconciliation warning in the review interface showing the expected closing balance, the computed closing balance from extracted transactions, and the difference. You can edit transactions inline to resolve the discrepancy before generating an export file.

Can I override the reconciliation warning and export anyway?

Yes. If you have reviewed the mismatch and determined it is acceptable — for example, the statement itself contains a printing error — you can acknowledge the warning and proceed to export. The exported file will include a reconciliation note.

How does reconciliation work for multi-statement uploads?

Each statement is reconciled independently against its own opening and closing balances. If you upload three months of statements as separate PDFs, each is checked individually. Documentric does not attempt to chain end-of-month balances across statements automatically.

How is the reconciliation mismatch shown to the user?

A banner appears at the top of the transaction review table with the exact dollar difference. Rows with values that appear suspicious based on amount patterns are highlighted in amber. You can sort, filter, and edit directly in the table to locate and correct the issue.

Which statement types support auto-reconciliation?

Auto-reconciliation works on any bank statement where an opening balance and closing balance are printed on the document. This covers the vast majority of personal and business checking and savings statements from all major banks. Credit card statements and investment account statements are supported where the balance fields are machine-readable.

Stop importing bank statements you haven't verified

Documentric checks balances automatically. Upload a statement and see reconciliation in action — free, no account required.

Starter from $29/mo · No card required to try