The QuickEasy Banking module allows you to import bank statements from any bank using the Open Financial Exchange (.ofx) format. After importing a file, the imported file will be renamed with the BatchID and a Date and moved to an 'Imported' subfolder. Duplicate transactions can therefore not be imported.
The following is important to set-up before attempting to use the Banking Module:
Click here for more about Settings & Defaults and Staff Setups.
Main Menu > Accounting > Bank > View
Where regular Standard Bank Online Banking exports with ease, Standard Bank Business Online cannot export to .OFX
It is therefore suggested that those with Standard Bank register for each (regular Online Banking and Business Online Banking) separately in order to export to OFX (by default they only get access to Business Online). Companies are able to be both Business Online users, as well as regular internet banking users.
6. Amount - This column indicates the Amount that was allocated.
7. Ledger - This column indicates the Amount that is outstanding from the Transaction.
8. Open Transaction - By right-clicking on a Transaction, you are able to open the Bank Transaction (more below).
9. Set Status to - By right-clicking on a Transaction, you are able to change the Status.
It is recommended not to make 'Pending' and 'Cancelled' Statuses available on Payment/Receipt transactions.
Main Menu > Accounting > Bank > View > Right-click on transaction > Open Transaction
When you open a Transaction from the Bank side-panel the Ledger will simultaneously open, displaying the selected Transaction. See image below:
Once the Amount has been Allocated in the Ledger, the Status will automatically be set to Posted, and the Ledger Amount will be populated, setting the Variance field to zero. See image below:
For an overview of the Banking module, watch this short video: