Overview

When performing account reconciliation, if you select all available DoorLoop transactions and your difference still doesn't equal $0, there are several possible reasons for this.

Common Reconciliation Mistakes

Usually the problem is related to entering incorrect data during a manual process. We'll go through several of those possibilities below.

  1. Incorrect Opening Balance

  2. Incorrect Statement Ending Balance Amount or Date

  3. Missing Transaction

  4. Incorrect Manual Transaction

1. Incorrect Opening Balance

  • If you've entered an incorrect Opening Balance for this account, the reconciliation will never square with your actual bank account balance.

  • To change the account's opening balance, follow the instructions in this linked article.


2. Incorrect Statement Ending Balance Amount or Date

  • Double check to make sure you entered the correct Statement Ending Balance amount for the Statement Ending Date you chose.

  • You might have picked a balance for another date!


3. Missing Transaction

  • Look for a transaction in your bank statement that matches the amount of the Difference on the reconciliation page. If you find one or more that exactly matches the amount, this transaction might just be missing in DoorLoop.

  • Then all you have to do is create this transaction and continue on with reconciliation.


4. Incorrect Manual Transaction

  • If your Opening Balance is correct, you've entered the right Statement Ending Balance, and you don't see any missing transactions from your bank statement, you likely need to correct a transaction already entered into DoorLoop.

  • Go through your listed DoorLoop transactions on the New Bank Reconciliation page and compare them to the transactions listed on your bank statements, checking them off as you find them.

  • When you find a transaction that doesn't match, you can edit or delete the transaction in DoorLoop to fix it.

  • Repeat until your Difference is $0 and you can finish the reconciliation!

Did this answer your question?