---
title: "Electronic Bank Reconciliation - Setup and Configuration"
canonical: "https://kb.myframeworks.com.au/space/FRAM/28408698/Electronic%20Bank%20Reconciliation%20-%20Setup%20and%20Configuration"
format: markdown
---
# Overview

> ⚠️ This functionality is feature code-driven. Please contact [Support](https://kb.myframeworks.com.au/page/support) if you require this to be enabled.

Before** Electronic Banking** can be used, the following system administration activities must be completed.

# <span style="color: #172b4d">Feature Code</span>

<span style="color: #172b4d">The following feature code is required to be </span>**<span style="color: #172b4d">Active </span>**<span style="color: #172b4d">for </span>**<span style="color: #172b4d">Electronic Bank Reconciliation </span>**<span style="color: #172b4d">to be available as a module via the Frameworks menu</span>

- **<span style="color: #172b4d">BNK - </span>**<span style="color: #172b4d">E-Banking Activation Code.</span>


> ℹ️ If the **BNK **feature code is not enabled you are still able to reconcile your bank statements via the [Bank Reconciliation Dashboard](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28380822) and [Manual Bank Statement Reconciliation](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28380750).

# <span style="color: #172b4d">Security Group Maintenance </span>

<span style="color: #333333">From the Frameworks menu navigate to </span>**System Administration > Users & Security > Users > Security Group Maintenance **<span style="color: #333333">and then ensure the </span>**Activities**<span style="color: #333333"> are added to your Users required Security Groups. Tick the access as required for the security groups.</span>

| **Frameworks Module** | **Security Group Access Path** |
| --- | --- |
| **Bank Reconciliation** | ![image](media://19f0894d-7c7e-4a2b-847e-b4f07caf2826) |
| **Bank Reconciliation Reporting** | ![image](media://81900901-5fdc-42fd-99fc-202d8a8f1ee6) |


<details>
<summary>Click here for the Frameworks Activites.</summary>

<span style="color: #172b4d">The below activities are required to be added to user security in order to access this functionality within Frameworks</span>

| **Activity** | **Function** |
| --- | --- |
| **BankStatementImportPopup** | Popup screen to configure the scheduled import above |
| **BankStatementReconView** | Bank Reconciliation Dashboard view |
| **BankStatementReconManual** | Bank Reconciliation [Manual Reconciliation](https://sterlandsupport.atlassian.net/wiki/spaces/fwksproau/pages/30507268) screen |
| **BankStatementReconMain** | Bank Reconciliation [Electronic Reconciliation](https://sterlandsupport.atlassian.net/wiki/spaces/fwksproau/pages/30507268) screen (only available when FeatureBNK active) |
| **BankStatementReconSuggest** | Bank Reconciliation suggested matches function |
| **BankStatementReconJournal** | Processing Bank Reconciliation journal |
| **BankStatementReconPayment** | Processing Bank Reconciliation payment |
</details>

# Miscellaneous Tables

The configuration values loaded with the auto-installer should not need to be changed with the exception of [Electronic Bank Reconciliation - Setup and Configuration#bankdetail](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28408698/Electronic+Bank+Reconciliation+-+Setup+and+Configuration#Bank-Reconciliation-NAI-Transaction-Details). 

<details>
<summary>Click here for information about the Miscellaneous Table Installers </summary>

The following miscellaneous tables are loaded with the below default configuration settings when loaded by the auto-installers:

| **Installer Name** | **Description** | **Version** | **Tailoring Codes and Features Created** |
| --- | --- | --- | --- |
| InstallerFW15913 | Westpac MT940 Statement Format | 6.0 | BankFileFormat |
| InstallerFW10407 | Bank reconciliation setup installer for WBCCSV format | 5.10 | Apply Transaction Detail Settings for WBCCSV import types |
| InstallerFW10691 | Bank File Formats | 5.10.1 | BankFileFormat |
| InstallerFW11368 | NAB Internet Banking (CSV) | 5.12 | BankFileFormat |
| InstallerFW5531 | Bank reconciliation setup installer | 5.7 | BankReconSettings |
| InstallerFW5531-1 | Bank reconciliation setup installer 2 | 5.7 | NAI Transaction Detail Settings |
| InstallerFW5531-2 | Bank reconciliation setup installer 3 | 5.7 | Apply Transaction Detail Settings for multiple import types |
| InstallerFW5531-3 | Bank reconciliation setup installer 4 | 5.7 | Add Bank Recon cutoff date to ignore gl transactions before the date |
</details>

<span style="color: #333333">From the Frameworks menu navigate to </span>**System Administration > System Tables > Miscellaneous Table Maintenance **<span style="color: #333333">and then search for </span>**<span style="color: #333333">Bank </span>**<span style="color: #333333">and setup the information for the below tables:</span>

## Bank Reconciliation - File Format

In this table you will be able to **Enable **the banking file format you will require when you import your bank statements

![image](media://f0212afb-d2f1-477d-8721-1250d72f0011)


<span style="color: #172b4d">Bank Reconciliation NAI Account Summary Codes</span>

The NAI/BAI account summary codes contain the industry standard codes for the account summary record type. 

> ℹ️ These values should not need to be changed.

## Bank Reconciliation NAI File Record Types

Contain the list of record types that are the first field of each record in the file.  This determines headers, continuations transactions, trailers. 

> ℹ️ These values should not need to be changed.

## Bank Reconciliation NAI Transaction Details 

Contains the codes linked to the type 16 transaction record.  Each of these records is either a debit or a credit.

> ℹ️ These values should not need to be changed.

## Bank Reconciliation Transaction Detail Settings

The transaction detail settings allow for users to override to the imports.

### Is Debit on stmt Debit on System:

The bank statement file will contain debits and credits, but they often relate to debits and credits according to the bank.  Debits for the customer are credits to the bank and vice versa.  However, not all statements use this so this field allows the sign of the amounts to be reversed.

- In the case of **NAI/BAI** imports, a debit is money going into the bank and vice versa so the field is left disabled.
- For **ANZ-NZ** imports, the sign of the amounts has already been reversed to reflect the customers debits and credits and so the flag is enabled to prevent the reversal of the sign.
- If the Credits and Debits are in two columns, such as for **Westpac CSV format**, the DEBIT on Stmt is DEBIT on system flag should be left disabled.

### Prompt for DR sign on Import:

Enable this to prompt for '**Is DEBIT on Stmt DEBIT on System** when importing the statement in the **New Reconciliation** popup.

## EStatement General

<span style="color: #333333">For this </span>**<span style="color: #333333">Miscellaneous Table </span>**<span style="color: #333333">search for </span>**<span style="color: #333333">estatement </span>**<span style="color: #333333">and setup the information below:</span>

- Enter the **Initial Cutoff Date** for the bank statement.  If left empty it will default to 01/01/1900.

> ℹ️ This date will be used to ignore any GL transactions before the set date in the reconciliation 'Unreconciled' screen.

![image](media://801f5a9b-0c1b-4f41-b4b2-cbbe71e8a3b5)

# Bank Account Maintenance

Ensure the bank you are importing statements for is configured correctly via** General Ledger > Maintenance > Bank Account Maintenance**

The statement import reconciliation task uses The **Account Number** of the bank to match against the bank statement import file and the **G/L Control Account **to search for GL Transactions on the system.

![image](media://3b26b47a-f380-4af7-8bab-c4596402b587)

**IMPORTANT **- For some Banks the Bank Code (NAB above) is actually numeric and has leading zeros.  **DO NOT** include the leading zeros in the Bank Code in Frameworks.

# Additional Information

> ✅ Refer to the [Bank Reconciliation](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28380798) User Manuals for more information.
> ✅ 
> ✅ Refer to the [Reconcile Bank Statements Manually](https://sterlandsupport.atlassian.net/wiki/spaces/fwksproau/pages/30507268) and [Reconcile Electronic Bank Statements](https://sterlandsupport.atlassian.net/wiki/spaces/fwksproau/pages/30507268) Operator Guides for more information.

<details>
<summary>Related System Settings - Flags</summary>

> Macro (include)
</details>