Bank Statement Reconciliation Issues In DocuClipper

A bank statement shows "Not Reconciled" in DocuClipper when the sum of credits and debits does not equal the difference between the printed end balance and start balance — most often caused by a missing transaction, a wrong amount, swapped debits and credits, or a low-quality scan that lost a column header.

To fix it, review the transactions table against the source PDF, click any incorrect value to edit it inline, click Add Transaction to insert missing rows, or use Bulk Edit Transactions in the top-right of the summary table.

Why is my bank statement showing "Not Reconciled"?

When DocuClipper finishes processing the statements, it adds up all the transactions and compares the totals with the beginning and end balances on the statement. If everything matches, DocuClipper displays a blue “Reconciled” box. Otherwise, it shows a red “Not Reconciled” box, indicating there may be missing or incorrect transactions. Click here for detailed information.

Reasons why your Job is not Reconciled

The statement isn’t supported by DocuClipper. Click here to check the list of supported banks.
The statement is of low quality. When the statement is too blurry, warped, and has writings sometimes DocuClipper can’t extract the data properly.
The statement is missing the headers (date, description, amount, etc.). DocuClipper needs the headers (at least on the first page) for data extraction to work.
Missing Transactions and Incorrect Transactions

How to Resolve Reconciliation Issues

To resolve reconciliation issues, follow these steps:

Review the Transactions: On the summary table, go through the transactions until you locate the problem. The system displays the transactions per page.
Correct Errors: If you find a transaction with incorrect data, click on the field to edit it inline. To fix multiple transactions at once, click Bulk Edit Transactions in the top-right of the summary table.
Add Missing Transactions: If a transaction is missing, click Add Transaction in the top-right corner of the summary table. Enter the date, description, and amount, then click Add.
Select Transactions for Output: Check or uncheck the box in the first column of each transaction to include or exclude it from the download. Excluded transactions are saved but omitted from exports.

FAQs

Why does my statement show "Not Reconciled"?

The sum of credits and debits does not equal the difference between the end balance and the start balance. Common causes are missing transactions, incorrect amounts, low-quality scans, or missing column headers on the first page.

How do I fix a Not Reconciled statement?

Review the transactions, click any incorrect value to edit it inline, and use Add Transaction to insert missing rows. For multiple fixes, use Bulk Edit Transactions in the top-right of the summary table.

What if the statement is too blurry or warped to extract correctly?

DocuClipper may not be able to read all transactions from low-quality scans. Try uploading a higher-quality copy of the statement, or edit the missing or wrong rows manually.

Can I exclude transactions from the export without deleting them?

Yes. Uncheck the box in the first column of any transaction. Excluded rows stay saved in the project but are omitted from downloads.

Does the statement need headers on every page?

At minimum DocuClipper needs the headers (date, description, amount) on the first page. Without them, extraction cannot map columns correctly and the statement will not reconcile.