The Quick Easy Banking module enables users to import bank statements from any local bank using the Open Financial Exchange (.ofx) format. After importing a file, the imported file will be renamed with the Batch ID and a Date and moved to an 'Imported' subfolder. Duplicate transactions can therefore not be imported.
Setup > Menu Manager - The Banking module needs to be linked to a Menu
Setup > Settings & Defaults > General Settings > Accounting > Bank Account Category
Setup > Settings & Defaults > User Settings > Accounting > Banking - Access Allowed.
Setup > Accounting > Accounts: The Bank Account descriptions must include the bank Account Number - eg. Bank - FNB62075828502
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.
Data Filter - This allows you to filter on Date, Type, and Status.
Menu - This allows you to Import Bank Statements: Menu > Import.
Bank Import - Changes were made to the import procedure to be able to import .ofx files from Mercantile Bank.NB. Fees will have to be captured manually for Mercantile Bank as they are not consolidated into one transaction on the bank statement.
3. Data Grid - This shows the Bank transactions by ID, Batch, Date, Account, Description, and Amount.
Based on newer versions of BOSEnterprise these enhancements have been applied to Banking:
Multiple Transactions from one Bank Transaction - Users are now able to add multiple Ledger Transactions from one Bank Transaction. After the first Transaction has been created an Update button is enabled so users can update the open transaction or create a new transaction. See image below:
Bank Balance - When importing a .ofx file, the Bank balance (as at the last date on the batch) is now also imported with the batch and compared to the balance on the ledger for the same date in the footer of the Bank Transaction window. NB. The balance only shows when you filter on a Batch ID - this is the default filter after importing a batch. See image below:
In the Ledger, when you view the Detailed Ledger for a Bank account, the Balance Bar is also displayed for the End date of the Date Filter or when 'No date' is used, the balance will be as at the date of the last transaction that has been recorded. Users can override the date, however.
Balance bar in the Ledger Footer
If a balance has not been captured/imported for the selected day, users can add the balance by clicking the + button - see below:
The Ledger amount and variance are now displayed alongside the transaction amount - useful when splitting a Bank Transaction into multiple Ledger Transactions. The matching record Description has also been updated to show more information. The Note field has been moved down, just above the Bank Balance. See image below: