Bank Reconciliation is a process used to confirm that all transactions recorded in Alto match your bank statement.
When you reconcile your client bank account(s), you compare the financial records held in Alto against the records provided by your bank. This helps you identify any missing, duplicated, or incorrectly recorded transactions and ensures your accounts remain accurate.
It's important that you reconcile Alto to your client bank account(s) on a regular basis. Your client balance on the Alto bank reconciliation should match that of your actual client bank balance
Note
To help distinguish between Bank Reconciliation and Import Receipts in Alto:
- Bank Reconciliation is used to confirm that all transactions recorded in Alto match your bank statement
- Import Receipts focuses on bringing bank credit transactions into Alto and allocating them to the correct charges
Reconciling a client bank account
Warning
If the bank reconciliation contains more than 2000 unreconciled transactions, it can become difficult to manually reconcile all the transactions. To help with this, if there are more than 2000 unreconciled items, when the Bank Reconciliation screen is opened, a message will appear asking if you would like to auto reconcile transactions up to a certain date.
This will give you the option to auto reconcile all transactions up to and including the date selected, bringing the unreconciled transactions back to a manageable number.
Please note this is optional - you can attempt to open the Bank Reconciliation screen and continue with a manual reconciliation as per the below
- Click Accounts on the main navigation bar
- On the side menu, within the Bank Transactions section, click Bank Reconciliation
-
Click View on the relevant client account
Note
The colour of the account may vary depending on how many unreconciled items there are and how long it has been since the last reconciliation
- The Balance Date defaults to the current date.
In the Statement No. field, type in the bank statement number. (If you don't have a statement number, type in the date in the following format: 010623. Don't add / or . in your date format) -
In the Statement Balance field, type in the balance on your bank statement. When you enter the Statement Balance, Alto calculates the difference between the figure that was updated on a previous Alto bank reconciliation and the figure you have entered from your current bank statement
Note
You'll notice that Property details are displayed where:
- a property is directly associated with the transaction
- a tenancy is directly associated with the transaction
Where transactions are batched:
- Batched transactions without a property displays an empty string
- Batched transactions with one distinct property displays property address details both at the group level and item level
- Batched transactions with multiple distinct properties displays property address details only at the item level and "(multiple addresses)" at the group level
- Batched transactions with a mix of empty address and only one distinct property displays property address details only at the item level and an empty string at the group level
Searching for properties displays both batch and item transactions.
- Working from your bank statement, if items on the Alto reconciliation match your bank statement, click the green thumb to include these relevant items into the bank reconciliation
-
If an item is on Alto but isn't on your bank statement, click the red thumb to remove items being included in this reconciliation
Note
Alto won't allow the bank reconciliation to be updated until the Difference is £0.00. If the difference doesn't go down to £0.00, either an item hasn't gone on your bank statement yet, or, an item hasn't been put onto Alto yet, but has appeared on your bank statement
- Once the Difference is £0.00 and you're happy that all items are correct, click Update
Warning
This process cannot be reversed so only click Update if you are certain it is correct to do so
Finding historic bank account reconciliation records
- Click Accounts on the main navigation bar
- On the side menu, within the Bank Transactions section, click Bank Reconciliation
- Click View on the relevant client account
- Click the Timeline top tab
- Click View on the relevant Bank Reconciliation Completed to open the historic record
-
Related Help Centre articles that you may find useful.
Bank reconciliation does not reconcile