Once bank statement transactions have been imported or manually created, they can be reconciled. After importing a bank transaction file the statement will show on the screen.
To reconcile a Client or Trust Account:
- Select Trust Accounts or Client Accounts on the green menu
- Select the account you want to import the statement for
- Click Bank Statements at the bottom of the page or the blue bank statements tile
- Click the blue link under Status for the statement you want to reconcile or Import a Statement (or use a manual statement)
Transactions from the file appear on the left side of the screen, invoices and disbursements from Re-Leased will show on the right side.
- Any transactions where the reference and amounts are a perfect match will show in green. Click OK All at the top to process receipts for all of these transactions.
- Some transactions may appear in orange where the system has made a best guess to match the transaction. You can preview the details for each transaction on the right and choose whether to approve the match if it is correct. If the match is not correct, use the find and match icon
- Use Find and Match on any transaction to select the invoice or payment it relates to.
- There is further information available explaining the colour coding available.
At the top of the screen the blue button will show previously reconciled transactions on this statement.Using Find and Match
After processing all the green, and correctly matched, orange lines, use Find and Match to complete the reconciliation of all other transactions. For deposited amounts, the transactions available in the Find and Match screen will be invoices. For Withdrawals the available transactions will be payments processed using Disbursements or Tenancy Ledger Refunds.
What if there is no match?
When there is no invoice available to match with received funds, there is an option to hold the funds against a tenancy ledger or in the Suspense Ledger. See Holding Funds for Tenants articles and the Suspense video articles for more information on using these options.