Skip to main content

Bank Reconciliations

Kevin Campbell avatar
Written by Kevin Campbell
Updated over a year ago

Bank reconciliations are done for a single bank account. This will include all companies within that bank account as well. Reconciliations can be created from the Accounting > Accounts page. From the three dot menu near the top left, and choose "Reconcile". Clicking this will open up the reconciliation form.

First, select the bank account you want to reconcile at the top left. This will reload the form with the information for the selected bank account. Then, select the date you want to reconcile. This will again update the information displayed.

The list on the left shows the calculations for the reconciliation. The starting amount is the current balance of the bank account in the Property Matrix system. Any outstanding transactions that have not yet been cleared will be either added to or deducted from this amount to indicate that the funds have not yet affected the real bank account. These unreconciled outstanding transactions appear in the list on the right. If a transaction is checked, it means it has shown up on the real bank account statement and can be marked as reconciled and will no longer adjust the Property Matrix balance.

Interest earned, service charges, and any other reconciliation differences can be entered in as well. These will get posted to the selected account for each one. Since these amounts will actually be posted, a company needs to be selected at the bottom for these lines - for the field 'Post new amounts to'. If these amounts are all zero, any company can be selected at the bottom because it will not have any accounting impact.

The bank statement balance from your real bank statement should be entered into the bottom and the adjusted Property Matrix balance should match this. Also update the Date on the bottom left to match the date you are doing the Reconcile for.

Any other discrepancies will need to be accounted for.

You can also save your reconciliation if you need to make any adjustments, such as editing a transaction or adding additional transactions or deleting/voiding transactions. From the three dot menu on the top right, there is an option to Save. You can have one saved reconciliation per bank account at a time. If you save again, it will override that previous saved reconciliation for that given bank account. Then when you return to this Reconciliation page, you can Load your draft from the three dot menu on the top right, after you select the Bank Account and Date on the top left of the page.

Did this answer your question?