Bank Statement Reconciliation Issues In DocuClipper
Troubleshoot bank statement reconciliation issues in DocuClipper: review and correct transactions, add missing entries, and resolve Not Reconciled status.
Reconciling bank statements and converting data to Excel or other accounting systems is a key feature of DocuClipper. However, you may encounter issues where the statement isn’t reconciling due to conversion errors. This article will guide you on how to troubleshoot and resolve these issues.
Understanding Reconciliation Issues
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.