Skip to main content

Account Reconciliation

How to complete a bank reconciliation in Propra

Written by Karyn Millar

Bank Reconciliation in Propra — A Complete Guide

Bank reconciliation is one of the most important accounting tasks in property management. It ensures that the transactions recorded in Propra match exactly what has cleared your bank account, keeping your books accurate, your owners informed, and your business compliant with provincial regulations that require reconciliations to be completed within five weeks of month end.


Before You Begin — Opening Balances

Before starting any accounting in Propra, it is critical that your opening balances are set up correctly. Your opening numbers should come directly from your trial balance from your previous accounting system. Having the correct opening balance in Propra for your first bank reconciliation is essential — without it, your numbers will always be off and every reconciliation going forward will be affected.

If you are unable to provide a trial balance, you can create a journal entry for your opening balance amount. This entry will appear in your bank reconciliation as the previous statement amount, allowing you to move forward with your accounting. Each property must have its own individual journal entry — a single bulk entry will not distribute balances at the property level and will cause ongoing reconciliation issues.


Starting Your Reconciliation

To begin your account reconciliation go to Accounting Tasks and select the Account Reconciliation task

Setting Up Your Reconciliation

When starting a new bank reconciliation, your statement date and opening balance amount must come directly from your bank statement. These figures need to match your statement exactly — do not estimate or adjust these numbers.

If you are on the Professional plan, you can upload your bank statement directly into Propra and the system will automatically attempt to match your uploaded transactions to the ones you have already posted in Propra, saving significant time.


Understanding the Transaction Tabs

Once inside your reconciliation, you will see the following tabs:

Recommended — These are Propra's suggested matches based on amounts, dates, and transaction types. Always start here as these are the most likely correct matches.

Unmatched — Transactions that Propra was not able to find a match for. If you do not want to use a recommended match, you can find and manually select a match from this tab.

Outstanding Bills — Use this button to select unpaid bills that need to be posted as paid. Once you select and post the outstanding bill the status will change to Paid and the transaction will be matched in your bank rec.

Add Entry — Use this button to add entries while in the bank reconciliation task.

Refresh — Use this button to make sure your reconciliation is fully up to date before reviewing or finalizing.

Deposit Transactions — A full list of all deposits recorded in Propra for the period.

Withdrawals — A full list of all withdrawals recorded in Propra for the period.


Matching Your Transactions

Recommended Matches Start with the Recommended tab and work through each suggested match. If the match looks correct, confirm it. If it does not look right, move on and address it manually.

Unbalanced Items An unbalanced item means Propra believes it has found a match but something is slightly off — most commonly the amount. Select the recommended match and review the amounts carefully before confirming.

Needs Review These are items where Propra has found two or more transactions with the same date or amount and is not sure which one to match. Click into the item, use the search bar to select the correct match from the recommended options, or navigate to the Unmatched tab to find the right transaction manually.

Unmatching a Transaction If you have matched something incorrectly, use the orange Undo button to unmatch it. The transaction will return to the deposit or withdrawal page so you can rematch it correctly.


Finalizing Your Reconciliation

Once all transactions have been matched, your reconciliation balance should be at zero. Before closing off, verify that:

  • Your total deposits balance

  • Your total payments balance

  • Any uncleared cheques are reviewed — cheques that have not yet cleared the bank can be left as outstanding and will carry forward to the next reconciliation period


Printing and Signing Off

Provincial regulations require that your bank reconciliation be reviewed and signed off each month. To complete this process in Propra click on the Printer Icon in the top right corner:

  1. Download the Reconciliation Report — this shows the statement date, all matched transactions, and any uncleared items. This report is to be signed by the property manager.

  2. Download the General Ledger for the period covering your last reconciliation date through to your current reconciliation date — this provides the full transaction detail supporting your reconciliation.

If you need to make any corrections before finalizing, use the Edit function to update the statement date or statement amount.


Quick Checklist Before Closing Your Rec

  • Opening balance matches your bank statement

  • Statement date and amount entered correctly

  • All recommended matches reviewed and confirmed

  • Unbalanced and Needs Review items resolved

  • Balance is at zero

  • Total deposits and total payments verified

  • Uncleared cheques noted

  • Reconciliation report downloaded and signed

  • GL downloaded for the period

Missing Entries in Your Bank Reconciliation

If you notice entries are missing from your bank reconciliation, it may be due to adding a property or owner to the bank group after the reconciliation was started.

When this happens, the reconciliation will not automatically update to include those newly added properties or owners.

To resolve this:

  1. Click on the bank group name at the top of the bank reconciliation

  2. Manually select the owner and property you recently added

  3. Click the refresh button if needed to update the view

Once refreshed, the missing entries should appear in your reconciliation.

Double Check Transaction Details

If transactions are not appearing as expected in your bank reconciliation, it’s important to review the details of the entry itself.

Make sure the transaction includes:

  • The correct date (falls within the reconciliation period)

  • The correct owner

  • The correct property

If any of these details are incorrect or missing, the transaction may not show up in the reconciliation. Updating the entry with the correct information should resolve the issue.


Undoing a Bank Reconciliation

If you need to undo a completed bank reconciliation, there are a few important rules to follow.

Key Requirements

  • Paused reconciliations must be deleted first
    Any in-progress (paused) bank reconciliations need to be cleared before undoing a completed one.

  • You can only undo one month at a time

  • You must start with the most recent completed month


How to Undo a Bank Reconciliation

  1. Go to Accounting → Account Reconciliation Task

  2. Find the relevant account

  3. Click the three-dot menu on the task

  4. Select View Past Reconciliations

  5. Locate the reconciliation you want to undo

  6. Click the red backward arrow next to the most recent reconciliation

  7. Confirm the action

Repeat this process month-by-month if you need to go further back.


Example

If January, February, and March are all reconciled:

  • You cannot undo January directly

  • You must:

    1. Undo March first

    2. Then undo February

    3. Then undo January


Why This Matters

Bank reconciliations are sequential and dependent on each other.

Each month’s reconciliation:

  • Uses the ending balance from the previous month

  • Confirms that all prior transactions are accurate and finalized

Because of this, undoing an earlier month without reversing later ones would create inconsistencies in balances and transaction history.

Requiring users to undo reconciliations in reverse order ensures:

  • Financial data remains accurate

  • Balances stay aligned across periods

  • Reporting integrity is maintained

Did this answer your question?