From the Outlook Bar, select Financial, then Bank reconciliation. The following form will load.
Follow the steps below:
- In the Bank Reconciliation Details section:
- Select the bank account to be reconciled, from the drop down list of bank accounts.
- Enter the reconciliation date, which will be the last date on the bank statement.
- Enter the balance on the bank statement
- The right hand side of the section will display
- GL balance for the bank account
- The difference between the GL balance and the bank balance
- The value of uncleared items
- The unreconciled balance
- From the Action Bar, select the Populate GL Transaction List button. All uncleared items will appear in the GL Account Transactions list. The Uncleared Items and Unreconciled Balance values will change.
- For all cleared items on the bank statement which appear in the GL Transaction List, right-mouse-click on the item and select Set as Provisional or select the item in the list and click on the Provisional button in the GL Account Status section of the Action Bar. The Uncleared Items and Unreconciled Balance will change after each item is set to provisional.
- For any cleared items on the bank statement which do not appear in the GL Transaction List, General Journal entries can be added on the fly (see instructions below).
- If at any time during the reconciliation process, the operator is interrupted or has to perform another task, the reconciliation can be saved as a work-in-progress by clicking on the Save button on the Action Bar. When the reconciliation is reloaded, all of the Provisional items will be reloaded as Provisional. The reconciliation process can continue from where it was last left off.
- Once all of the steps above have been correctly completed, the Unreconciled Balance should be zero. At this point the reconciliation is complete. Click the Clear All Provisional Items button. All Provisional items will be set to cleared and the process will be complete.
Making Corrections
- If a line item in the GL Transaction list is incorrectly set to Provisional, click on the line item, then right-mouse-click and set as Open or click on the Open button in the GL Account Status section of the Action Bar.
- If an item was incorrectly cleared during a previous reconciliation follow the instructions below to unclear a cleared transaction.
To add a General Journal entry on the fly, click on the Add Ad Hoc Transaction button on the Action Bar. The Ad Hoc Transaction Editor will load.
Add the General Journal entry. At least one line item in the journal entry must be to the bank account being reconciled. When the entry is in balance, click Save. The Ad Hoc Transaction Editor will close and the bank portion of the entry will be added to the GL Transaction List and marked as provisional.
To unclear a cleared transaction, select the Closed Bank Transaction menu on the Outlook Bar.
Select the bank account and a range of dates for the cleared transaction. Next click on the Populate GL Closed Transaction List button. All closed transactions for the bank account will load. Click on the transaction to be uncleared. Right-mouse-click and select Set as Open or select the Set as Open button on the Action Bar. The item will be set as opened and will disappear from the list. Once all re-opened items have been completed, return to the Bank Reconciliation module.