Bank Import Setup - Setup Tutorials

How to Select the Copy and Paste Feature for Bank Statements

ℹ️ You can access an exported bank statement by copying and pasting it, or by finding the file on your server and importing it from there. Choose the copy-and-paste option if the person capturing the bank statement entries does not have access to find files on the server.

1. Navigate to Main Menu > Setup > Accounting > Settings & Defaults (tab).

2. Navigate to the setting: Copy and Paste Bank Import file and tick the block in the Value column.

How to Setup Bank Accounts for the Bank Import Feature

1. Navigate to Main Menu > Setup > Accounting > Accounts (tab).

2. Click Edit (button) for existing bank accounts or Add Account (button) to add a new account.

   1. Type in a description in the Name column.

   2. Enter an account number in the Code column (if applicable)

   3. For Category, select Bank from the dropdown list.

   4. For Default, select Bank from the dropdown list.

   5. For Currency, select the currency the bank account is in from the dropdown list.

   6. For Import, select an option from the dropdown list. The options are:

      • SA FNB (.ofx) (Unique FITID)

      • SA FNB - No FITID check (.ofx)

      • SA ABSA (.ofx) (Unique FITID)

      • SA Standard (.csv) (No FITID check)

      • SA Nedbank (.ofx) (No FITID check)

      • SA Standard (.ofx) (Unique FITID)

      • SA Investec (.ofx) (No FITID check)

        • Note: FITID means the system will automatically continue from the last bank statement and identify duplicate entries. Where there is no FITID check, users must do this manually.

How to Setup Users to Access the Bank Import Feature

1. Navigate to Main Menu > Setup > Settings > Users (tab).

2. Left-click on the User.

3. In the User Setting section:

   1. Navigate to  Accounting: Banking (Import and Reconciliation) and tick the block in the Value column.

   2. Navigate to  Accounting: Ledger - Access Allowed and tick the block in the Value column.

   3. Navigate to Other: Batch Updates - Access Allowed and tick the block in the Value column.

How to Set Roles to Access the Bank Import Feature

1. Navigate to Main Menu > Setup > Settings > Roles (tab).

2. Check the Role Settings for the specific Role assigned to the user doing the Bank Import. For every transaction, the user must have either Edit rights or Full Access.

3. The Transaction Types will vary per organisation, but typically the following types of transactions can be imported:

   1. • Customer Receipts

      • Customer Overpayments (may be auto-allocated when capturing Customer Receipts)

      • Customer Discounts (may be auto-allocated when capturing Customer Receipts)

      • Supplier Payments

      • Supplier Overpayments (may be auto-allocated when capturing Supplier Payments)

      • Supplier Discounts (may be auto-allocated when capturing Supplier Payments)

      • Expenses / Asset Purchases

      • Other Income

      • VAT Payment

      • VAT Refund

      • Payroll Payments

How to Allocate Users to Entities

ℹ️ Only users linked to the same Entity as the Bank Account can import the bank statements.  However, users that are not linked to an Entity have access to all Entities. 

1. Navigate to Main Menu > Setup > My Organisation > Staff (tab).

2. Double-click a staff member to edit their record.

3. Click ... next to Entities to allocate the staff member to an Entity.

4. A pop-up will appear with a list of available Entities.

   1. Click the arrow keys to add Entities the staff member may access. 

   2. Click Save (button).

   3. Click X to close the pop-up.

Related Topics

• Reference: Bank Import

• Tutorial: Bank Import & Allocations