Skip to main content

Banking Setup

Theta Base Pack Wizard

The Theta Base Pack Wizard guides you through configuring your EFT Transfer file formats, assigning the file formats to your bank accounts and downloading pre-configured bank statement formats.

note

Our standard bank statement formats also include the required mapping for our Advanced Payment Reconciliation extension. We recommend that you first install this extension if you intend to use the extension so that you do not have to come back and update your extensions.

EFT Setup

On the EFT Setup page, you specify settings that control the EFT functionality in Business Central. The EFT Setup is created automatically when the app is installed and when new companies get created.

EFT Payment Status

EFT Bank Setup (EFT Transfers)

Bank Statement Import Setup

You can use the Theta Base Pack Wizard to download the pre-configured bank statement formats.

The app relies on the standard Data Exchange Definitions functionality provided by Business Central. We have enhanced this to cover scenarios the standard functionality could not handle.

You can do the following additional set up with the Theta Base Pack:

Transformation Rule for the Westpac Deskbank Fixed Text Bank Statement

All transactions on a Westpac Deskbank Fixed Text Bank Statement are positive. The sign gets derived from the transaction code. To achieve this, we provide a custom transformation rule.

West Pack Transformation Rule

In the data exchange columns, we define the transaction code and the amount as a single column:

West Pack Transformation Rule

In the field mapping, we map this field to the amount and use the transformation rule to apply the custom logic.

EFT Payment Status

EFT Bank Setup (EFT Transfers)

New Zealand Bank Account Validation Setup

The New Zealand Bank Account Validation feature includes two additional tables that get set up automatically on the installation of the app. You can access these pages from the EFT Setup Card.

NZ Bank Account Validation Setup

This page records every bank and contains the valid ranges for branch and account. NZ Bank Account Validation Setup

NZ Bank Account Algorithms

This page contains the algorithms that get used to validate the account details. NZ Bank Account Algorithms