Reconciliation

How reconciliation works

DocuClipper reconciles the statements ensuring that no transactions are missing and that they have the right amounts. This is how reconciliation works:

  1. DocuClipper reads the start and end balance from the statement. Balances

The balances appear on top of the transactions: Fields

  1. Next, DocuClipper adds up all the credits and debits in the statement.
  2. If "end balance" - "start balance" is equal to "credits" - "debits" then the statement is reconciled and DocuClipper displays a blue badge:

Job

What does it mean when the job is "not reconciled"?

Sometimes DocuClipper isn't able to reconcile the statement. When this happens you'll see a red badge: Not reconciled

Here are a couple of reasons that can prevent DocuClipper from reconciling the statement:

  1. The start or end balances have been detected incorrectly.
  2. DocuClipper wasn't able to read the start or end balances.
  3. Balances are correct but there are missing or wrong transactions.
  4. DocuClipper can't reconcile this statement type yet. E.g. some multi-account statements can't be reconciled at the moment. We're working on adding support for those.

Fixing errors to reconcile the statement

Watch the video at the top of the page to see the reconciliation process in action.

  1. If the start or end balances are wrong, you can update them by clicking on the balance and entering the correct value: Fields
  2. If a transaction is wrong, you can fix it by clicking on the wrong value and entering a new value. Check the box on the first column to include/exclude transactions from the output file. Bad Transactions

What to do if there are lots of red lines?

Red lines aren't bad necessarily. DocuClipper excludes lines that don't contain transaction data (e.g. table headings). We recommend you review the Excel file to make sure no transactions are missing and have the right values. If a transaction is wrong, you can fix it by clicking on the wrong value and entering a new value. Check the box on the first column to include/exclude transactions from the output file.