Reconciling bank accounts using imported bank files
Some organisations reconcile their bank accounts using account files imported from their bank.
Synergetic supports several bank file formats, including:
- NAI format, supported by the National Australia Bank (NAB)
- OCBC format, supported by the OCBC Bank
- QIF format (that is, Quicken file format), supported by most banks.
This setting is configured on the Bank Files tab of Banking Configuration Maintenance. See Banking Configuration Maintenance - Bank Files tab in the Finance manual.
To reconcile bank accounts using imported bank files:
- Select Module > General Ledger > Bank Reconciliation from the main menu.
The Select Current Bank Statement Control window is displayed.
Tip: You can also access General Ledger functions by clicking . - Click .
The Create New Bank Statement Control window is displayed.
Note: Most of the details are usually populated from the previous bank reconciliation. - Select the bank account to reconcile using the Bank Code drop-down list, if you have more than one bank account.
- Download the bank account transaction file from the bank.
- Return to the Create New Bank Statement Control window.
- Click.
The Load Bank Transactions window is displayed. - Click .
A window similar to the following one is displayed. - Browse for the bank account transaction file.
- Select the required file.
- Click .
The Load Bank Transactions window is redisplayed. - Click .
The following dialog window is displayed. - Click .
The Change Bank Statement Control window is displayed.
Note: The Closing Balance is updated automatically from the bank transaction file. - Click .
The Bank Reconciliation window is displayed.
Note: In the example above a single transaction (Ord 2) in the right pane has not been matched. An EFT deposit has been added to the NYBA total.
If the bank statement is reconciled, the difference (Diff field) is zero and the following message is highlighted in green: B/S Reconciled.
If the general ledger bank transactions are reconciled, the Variance is zero and the following message is highlighted in green: G/L Reconciled. - Click .
The following dialog window is displayed. - Click .
The following dialog window is displayed. - Click .
The Bank Reconciliation report is spooled to your default Synergetic printer and the Select Current Bank Statement Control window is redisplayed. - Repeat from step 2 for each bank account to reconcile.