How to Fix "Not Reconciled" Statements in DocuClipper

Understanding Reconciliation

When bank or credit card statements are uploaded to DocuClipper, the system automatically extracts transaction data and calculates totals to verify alignment with the original statement. This verification process is called reconciliation.

A Reconciled status indicates that DocuClipper's extracted data matches the statement's totals. Conversely, a Not Reconciled status signals a mismatch, typically caused by missing data, misclassified transactions, or unavailable totals in the uploaded document.

Reconciliation is tracked per account and period, not per file. A PDF that holds several accounts or months can show some periods Reconciled and others Not Reconciled at the same time — fix each period on its own.

DocuClipper captures these key values:

Start Balance (if available)
End Balance
Total Credits (Deposits/Incomes)
Total Debits (Withdrawals/Expenses)
Number of Credits
Number of Debits

Common Causes of "Not Reconciled" Status

Missing Transactions: One or more transactions weren't extracted due to formatting issues or scanning problems
Incorrect Transaction Type: A transaction classified as debit instead of credit (or vice versa)
Incomplete Statement Data: The PDF lacks totals for debits, credits, or balances
Corrupted or Partial Upload: Missing or cropped pages during upload

How to Fix Reconciliation Issues

1. Review the Summary panel

Open the period and check the Summary panel. It shows the extracted Start Balance, End Balance, and the credit and debit counts and totals, next to a Reconciled / Not Reconciled badge. Compare these against the statement's printed totals to see where the mismatch is.

Transactions Summary panel with the Account selector and Reconciled badge alongside the balances strip showing Start Balance, End Balance, and credit and debit totals

2. Identify Mismatched Credits or Debits

Scan the transactions table for the period to locate discrepancies between DocuClipper's counts and the amounts printed on your statement.

3. Correct Misclassified Transactions

Select the transaction (or transactions) incorrectly labeled as a debit when it should be a credit, then click Switch credits/debits in the toolbar. The Summary panel updates automatically.

Transactions toolbar highlighting the Switch credits/debits bulk-action button and the Add Transaction button

4. Add Missing Transactions

Click Add Transaction and enter the date, description, and amount exactly as shown on your bank statement. Assign the correct type and save.

5. Recheck the Totals

Verify that:

All statement pages were uploaded
Beginning and ending balances are present
Transaction amounts use consistent decimal formatting

Additional Considerations

OCR quality: if the statement is a low-quality scan, small numbers (cents, balances) can be misread. Upload a higher-quality source if you have one.
Multi-page PDFs: confirm every page made it in. If the last page is missing, the end balance won't match.
Statements without printed totals: some bank formats don't print credit/debit totals. DocuClipper can't reconcile against something that isn't there; these will stay Not Reconciled even when the data is correct. Use Cashflow Analysis instead to verify the totals yourself.

If your statement remains unreconciled after these steps, email support@docuclipper.com with the source PDF, a screenshot of the reconciliation pane, and notes on the mismatch. We'll dig into the OCR output directly.