Bank

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.

Discover Bank

Bank Setup

The following is important to set-up before attempting to use the Banking Module:

  • A Banking Account Category must be created. Navigate to Main Menu > Setup > Settings & Defaults > Accounting > Categories > Add - Bank. See image below:
  • A Bank Account must be created. Navigate to Main Menu > Setup > Settings & Defaults > Accounting > Accounts > Add: The Bank Account descriptions must include the bank Account Number - eg. Bank - FNB62075828502. See example below:
  • Select the correct Account Category for Banking. Navigate to Main Menu > Setup > Settings & Defaults > Settings > Accounting > Account Category - Banking - Bank. See image below:
  • User Access must be set, navigate to Main Menu > Setup > Staff > Edit > Settings > Accounting > Bank - Access Allowed - Yes. See image below:

Click here for more about Settings & Defaults and Staff Setups.

Bank Interface

Navigation

Main Menu > Accounting > Bank > View

  1. Filter - This allows you to filter the data displayed in the data grid. You can specify a date, Type and Status.
  2. Type - This allows you to filter the data by Type, simply select between Debit, Credit or All from the drop-down list.
  3. Status - This allows you to filter the data by Status.
  4. Search - This allows you to search for records by simply entering a description or ID code.
  5. Menu - The Menu button provides the following additional functionality:
    • Reset Data Filters - This will reset the data filters back to default.
    • Import - This allows you to import bank statements from any bank by selecting the exported file. When running on a cloud server, the file must first be copied to the server before it can be imported.

Note

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.

Note

It is recommended not to make 'Pending' and 'Cancelled' Statuses available on Payment/Receipt transactions.

Bank Transaction

Navigation

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:

  1. Edit Ledger - This is the Ledger interface. The Ledger will display the Ledger transaction linked to the Bank transaction, if one was created.
  2. Edit Bank Transaction - This is the Bank transaction opened in the Bank side-panel. See more below:
  1. Bank Transaction - Here you will find the Date the Transaction was made, the current Status and the Description of the Bank Transaction.
  2. Amount - This indicates the Bank Transaction's Amount.
  3. Ledger - This indicates the Amount that has been Allocated in the Ledger.
  4. Variance - This indicates the Outstanding Amount for the Transaction.
  5. Matching Records - The Matching Records field will display any Transactions in the Ledger that matches this Transaction.
  6. Create or Update from Matching - This button will create or update a Ledger Transaction from a previously created Matching Transaction.
    • If there is no Matching Transaction, this field will be greyed out as shown above.
  7. Transaction Types - This field shows all the Transaction Types this Bank Transaction may link to.
  8. Create or Update from Trans Type - Select a Transaction Type (7) that you want this Bank Transaction to link to, and click on the Create or Update from Trans Type button to create a Ledger Transaction.

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: