Bank Reconciliation allows you to import a bank statement file that is downloaded from your online bank account and automatically match the imported bank transactions with transactions entered in Attaché.
This helps you to complete the bank reconciliation process more efficiently. Transactions can be quickly and easily matched manually if they did not match automatically. You can also un-match any transactions which you may have matched incorrectly.
The file formats which are acceptable in Attache are:
QIF (Quicken Interchange Format).
BAI2 (for ANZ Transactive).
The screen shot below displays what the New Bank Reconciliation program looks like:
📌 Note: The previous Bank Reconciliation task is still available but has been renamed Old Reconcile. You can access this from General Ledger, Transactions, Bank Reconciliation, Old Reconcile.
New Bank Reconciliation setups
First, you'll need to complete the appropriate setups in Company Bank Account Maintenance:
Choose Setups, Company, Company Bank Accounts, Bank Accounts Maintain.
For each bank account you want to reconcile, ensure you enter the relevant GL Account Code and then select the Reconcile check box.
Using New bank reconciliation
Watch the video below which shows the steps using new bank reconciliation.
Steps to perform a bank reconciliation
To open the New Bank Reconciliation program
Go to General Ledger, Transactions, Bank Reconciliation, Reconcile.
Select the required bank account
Select the bank account you want to reconcile.
Choose the Import file
Click Choose File to select the QIF or BAI2 file you have downloaded from your online bank account. The Statement Start Date and Statement End Date are automatically updated based on the imported file. You can update these dates if necessary.
The First bank reconciliation
For your first reconciliation, enter the correct Opening Balance for the statement which you have imported. For any subsequent reconciliation, the opening balance will automatically be updated with the closing balance from the previous statement.
Important note: In the New Bank Reconciliation program, if the opening balance for the first bank statement for the financial year was entered incorrectly, it cannot be changed once bank reconciliations exist for that GL / Bank Account. See workarounds for this issue in this article: Bank Balance amount is incorrect in New Bank Reconciliation.
To Automatically match transactions
Choose Begin Reconciliation. The Auto Match screen opens, which suggests statement transactions that appear to match directly with a general ledger transaction.
You can confirm or reject the suggested matches by selecting the corresponding buttons.
Once the auto match confirmation is complete, you may continue to reconcile any remaining bank transactions manually.
To manually match transactions
Choose a bank transaction from the Unreconciled Statement Transactions area.
choose the matching general ledger transaction from the Unreconciled General Ledger Transactions area.
If the amount of both transactions match, the transactions will be automatically moved to the Matched Transactions area.
To un-reconcile mis-matched transactions
If you mismatched any transactions, expand the Matched Transactions area and then choose X. These transactions will be moved back to the Unreconciled area.
Expand the Matched Transactions area to view the matches you have made.
Match remaining Transactions
Continue to match transactions until all transactions in the bank statement have been matched. The status of the bank statement will be set to Reconciled automatically.
Deleting a Statement
📌 Tips:
You can use the search field to search transactions by any information contained in the transactions.
Click the information icon next to a general ledger transaction to view more details of that transaction.
You can filter transactions by date range and customer payment type.
If you have information in Customer Card Types and Merchant Id, you can also this information filter further on customer payments transactions for reconciliation.
Printing Reports after Completing the Bank Reconciliation
After completing the bank reconciliation, you can print the Statement Print and Reconciliation Reports:
Go to General Ledger, Reports, Bank Reconciliation, Statement Print.
Go to General Ledger, Reports, Bank Reconciliation, Reconciliation Report.
To add transactions from another statement
There may be occasions where one general ledger transaction matches to two or more bank transactions from multiple statements. To add transactions from another statement:
Click the Add More Statement Transactions button (located below the Unreconciled Bank Statement transactions area) to display bank statements that have been imported previously but have not yet been fully reconciled.
Choose the relevant bank statement. All unreconciled transactions for the chosen statement are displayed.
Choose the transactions you want to match by selecting the corresponding check boxes, then click Add Transaction(s).
Bank Reconciliation functions
Function | Description |
Choose File | choose a .qif or BAI2 file which you have downloaded from your online bank account for bank reconciliation purposes. |
Begin Reconciliation | Start a bank reconciliation session. |
Auto Match | Automatically match bank statement transactions with general ledger transactions, based on Date and Amount. |
Confirm All | Confirm that all auto match transactions are correct. |
Confirm All Strong Matches | Confirm that all strong matches are correct, meaning that both Date and Amount are matched. |
Confirm All Moderate Matches | Confirm that all moderate matches are correct, meaning that Amount is matched. |
Delete Statement | Delete the bank statement that you are currently working on. Note: You can't delete the current statement if there are transactions that have already been matched. First unmatch all transactions then delete the statement. |
Add More Statement Transactions | Add bank statement transactions from another bank statement. |