How to Fix "Not Reconciled" Statements in DocuClipper, Docs

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.

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 Reconcile Pane

Check the reconciliation pane at the top of your statement view to compare extracted totals against the statement's printed totals.

2. Identify Mismatched Credits or Debits

Scroll through the Transactions panel on the right side to locate discrepancies between DocuClipper's count and your statement's listed amounts.

3. Correct Misclassified Transactions

Select a transaction incorrectly labeled as debit when it should be credit, then click "Switch Credit/Debit." The reconciliation pane updates automatically.

4. Add Missing Transactions

Click "Add Transaction" in the Transactions panel 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.