Bank Accounts
Bank Account Reconciliations (Bank Statement Imports)
Business Central provides functionality that allows you to import bank statement files. The feature uses the Data Exchange Definitions, which will enable you to handle different bank statement formats. The Theta Base Pack provides pre-configured bank statement formats for the most common banks used by New Zealand companies. The app also offers minor enhancements to the Data Exchange Definitions to enable more support for the many different bank statement formats available.
This section covers the additional features added by the Theta Base Pack. If you want help with processing a bank reconciliation, try the following links:
Here's a link to the Business Central help on Bank Reconciliation.
Processing Files with more than three record types
The bank statement import functionality requires that only the transaction lines from the statement get imported. The Data Exchange Definitions can exclude header and footer lines so that only the transaction lines get imported. It cannot handle more than three record types.
Example ANZ NZ Format CSV File
In the example below, you can see that this statement format has five different record types. You cannot import this file correctly using the standard Data Exchange variable text import unless you first edit the file.
Example Configuration to handle more than three record types
You can import the file without first editing it with the configuration below.
Please note the following fields:
| Field | Comments |
|---|---|
| File Type | This field gets set to Variable Text because the file format is comma-separated values (CSV). |
| Reading/Writing XMLport | The value 58400 refers to the Id of the Theta Base Pack enhanced reading XML Port. |
| Column Separator | This field is set to Comma, the default type for Variable Text. |
| Footer Tag | Enter a text string separated by commas or semi-colons to indicate the record types you want to ignore. In our example, we want to ignore record types 5, 6, 8 and 9. Note that the records you want to ignore do not have to be at the end of the file for the app to ignore them. |
| Header Tag | The Header Tag works like the Footer Tag. |
Handling Fixed Text Files
The Data Exchange Definitions do not support importing Fixed Text as standard (although it does support exporting Fixed Text).
Example Westpac Fixed Text File
You cannot import this fixed text file with standard functionality because it has more than three record types and it is fixed text.
Example Configuration to handle fixed text and more than three record types
You can import the file without first editing it with the configuration below.
Please note the following fields:
| Field | Comments |
|---|---|
| File Type | This field gets set to Fixed Text because the format of the file is fixed text. |
| Reading/Writing XMLport | The value 58400 refers to the Id of the Theta Base Pack enhanced reading XML Port. |
| Column Separator | This field is set to Comma, the default type for Variable Text. |
| Header Lines | We specified 1 here so that the app would skip the first line. Setting the header tag in this scenario is unnecessary because Business Central will ignore the number of rows you specify here. |
| Footer Tag | Enter a text string separated by commas or semi-colons to indicate the record types you want to ignore. In our example, we want to ignore record types 5, 6, 8 and 9. Note that the records you want to ignore do not have to be at the end of the file for the app to ignore them. |
New Zealand Bank Account Validation
Business Value
When capturing New Zealand bank account details for vendors, customers, and employees, you must ensure the details are valid. When you enter the account details, Business Central will check the branch and account number combination to ensure that the account number is a proper branch and account number.
Feature Details
The New Zealand Bank Account validation is enabled when you install the app and create a new company. If you enter invalid account details, Business Central will display a notification. You will not be able to save the changes unless you resolve the issue. You can also disable the validation on a specific bank account if you are sure your account details are valid.
You can read more about New Zealand bank account numbers here.
The validation can only check if the branch and account number are within the bank's correct range. The feature cannot check that the bank account exists and is still active.
Configuration
You can enable or disable the New Zealand Bank validation for a Business Central company on the EFT Setup.