A bank reconciliation should be completed each month (or more frequently). This process confirms that all entries on the bank statement have been entered in ACAS, and helps identify any errors on the bank statement or in ACAS. This screen is where existing reconciliations can be searched, and new bank reconciliations created.
Create and verify a new Bank Reconciliation entry
- Go to the Period Close menu, then click on Bank Reco Search.
Select the Bank Account that you wish to reconcile, and click Search. Then click the New button.
Complete the following fields:
- Statement Date - enter the Statement Date show showing on the bank statement
- Statement Amount - enter the closing balance showing on the bank statement
Transactions up to and including the Statement Date that have not been reconciled will be displayed. There will likely be an amount showing in the Variance field, which should come to 0.00 when the correct transactions have been selected (the Statement Amount will equal the Ledger Balance).
- Working from the bank statement, click on the checkbox beside each transaction that shows on the bank statement. Also tick the transaction on the bank statement (it is easiest to work from a printed copy so you can do this).
If there are entries on the bank statement that are not ticked in ACAS, they must be entered into the system either by a Receipt Entry, Expense Entry, Express Payment Entry or Journal Entry (the Fee Entry, Interest Entry, Deposit Entry and Payment Entry shortcut buttons can be used to complete these entries).
It is possible to finish your bank reconciliation and still have items not ticked in ACAS because they have not shown on your bank statement yet, but you cannot have items on your bank statement that are not ticked in ACAS.
When all transactions on the bank statement have been ticked on the statement and in ACAS, the Variance should be 0.00. Click Save and a message will appear confirming the reconciliation has been saved.
Note: If the Variance is not 0.00 you need to find out why. Contact the ACAS support personnel at your local conference office if you need further assistance.
- Click Print to display and print/save the Bank Reconciliation report. Click the X to close the report.
If the reconciliation is ready to be verified (no further changes allowed), click on Bank Reco Search. Search using the correct filters to display the reconciliation.
Highlight the reconciliation to be verified and click Verify. The Verified Date will appear next time a search is done for this reconciliation, and it cannot be edited unless it is unverified.
Search for a bank reconciliation
- Go to the Period Close menu, then click on Bank Reco Search.
Select your search filters. These can either be one or a combination of the following:
- Bank Account
- Date
- Only Unverified Statements
Click Search.
Un-verify a bank reconciliation
If you need to edit a verified (saved) reconciliation, it must be unverified first. Contact the ACAS support personnel at your local conference office to request assistance if you are unsure about whether you should do this.
Select your search filters. These can either be one or a combination of the following:
- Bank Account
- Date
- Only Unverified Statements
Click Search
- Highlight the reconciliation to be unverified and click Unverify. A warning pop-up message will appear, indicating if any previous reconciliations will also be unverified. Click Ok to continue.
- The Verified Date will be removed from the relevant reconciliation/s. When an unverified reconciliation is double-clicked on, the reconciliation can now be edited.
- Once the edits have been completed and the Variance is 0.00, remember to verify the reconciliation again.