Overview
Reconciling your bank statement with transactions in DoorLoop on a regular basis is important to ensuring the accuracy of your financial data. This process helps you find and rectify discrepancies between your bank statement and DoorLoop transactions. In fact, Reconciliation is the first place to start when you notice your reported account balance in DoorLoop doesn’t match your actual bank account balance.
While bank reconciliation is easy to do, DoorLoop offers an additional tool to help you match DoorLoop transactions to those in your bank account. Importing transactions from your bank account via Plaid helps automate matching them to transactions in DoorLoop. Note this is only available if your bank institution is compatible with Plaid.
You don’t need to use our Plaid integration to perform bank reconciliation, however. The steps below are sufficient!
The Steps
The goal in reconciliation is simple. For the time period you are reconciling (ideally every month!), you have a starting and ending balance for an account. The starting balance is from the last successful reconciliation you made with this account. (If you've never done a reconciliation, this number will be the opening balance for the account.)
The difference between these two numbers is compared to the total of the transactions you've entered in DoorLoop for that account. The difference should be $0. If it isn't, you have missing or incorrect transactions entered into DoorLoop. Since you will be matching the transactions to your bank statement, you'll easily be able to see which ones are wrong or missing!
Step 1 - Begin the Bank Reconciliation Wizard
To start the Bank Reconciliation wizard, click Accounting on the main menu and then click Reconciliation.
On the Bank Reconciliation page, click the + New Bank Reconciliation button at the top right corner.
Step 2 - Select the Bank Account to Reconcile
On the New Bank Reconciliation wizard, in the Bank Account step, select the account you want to perform reconciliation for using the Account drop-down menu.
Note: The account must have an opening balance set. Otherwise, there is no starting point to reconcile from. If you haven’t set an opening balance on this account, you will see a warning letting you know this is required. Use the Add Beginning Balance button in the warning message to correct this.
Step 3 - Enter the Statement Ending Balance
The Statement Beginning Balance shown is the balance from the date of your last successful bank reconciliation for this account. If you’ve never done bank reconciliation in DoorLoop for this account, the amount and date shown is your opening balance entry.
Using your bank statement, enter the new Statement Ending Balance and the Statement Ending Date.
Click Next to continue.
Step 4 - Transaction Matching
On the New Bank Reconciliation page, in the Match Transactions section, you will reconcile all transactions from your last reconciliation—or opening balance, if you’ve never reconciled—up to the reconciliation end date you chose in the last step.
Do this by comparing the line items from your bank statement to the line items shown in DoorLoop. Check off the transactions you’ve matched until all are accounted for. (If you've connected your bank to import transactions via Plaid and matched them to transactions in DoorLoop, these matched transactions will be checked by default.)
As you do this, the window at the bottom of the screen will keep a running total of the Cleared Balance (the total of the boxes you’ve checked) and the remaining Difference between the account’s beginning and ending balances.
Step 5 - Enter Missing Transactions
If you find that you are missing a transaction, you can use the + Create New button in the upper left corner to create the necessary expense, deposit, or payment.
Note: If the missing deposit is from a lease payment, make sure you record the payment on the tenant’s lease rather than just creating a separate deposit.
Once you’ve created the new transaction, the reconciliation page will refresh and you’ll see the new transaction added as a line item to reconcile.
Step 6 - Editing Incorrect Transactions
If you find a transaction that you created incorrectly, you will need to edit or delete that transaction.
You can do this from within the reconciliation page by clicking the 3-dots on the right side of the transaction line and choosing View. Then edit or delete the transaction.
You can also use the Save for Later button and then navigate to and delete or edit the errant transaction. (Review how to do that using this article for editing or deleting Lease Transactions and this article for editing or deleting expenses and bills.)
Step 7 - Finishing Up
Once the Difference is $0, you can click Finish Reconciliation to continue.
Note: If the difference isn't $0, you won't be able to save, but you can use the Save for Later button so you can finish the reconciliation at another time without losing your work so far.
Step 8 - Reviewing Your Reconciliation
DoorLoop then takes you to the Reconciliation Report page where you can review the reconciliation work you just did. When you are finished reviewing, navigate away to whatever part of the software you want to use next.
Tip: If you selected the Save for Later option in the last step, the account reconciliation will be saved as a Draft on the Reconciliation page.
To finish the reconciliation, click on the line and DoorLoop will take you to the reconciliation page to continue your work.
Related Articles