File Setup

The default File Setup is Fixed which will export the file name as FTZZZZZZZZZZZZ999999.IMP where ZZZZZZZZZZ is the Bank Code and 999999 is the Batch ID.

To customize the export file name click on the Name list and select Custom. You can choose up to 5 segments specifying the length and format for each one.

File Sequence Number

The File Sequence Number is a unique serial number for your transaction files and is updated each time an EFT batch is successfully posted or the Regenerate function is run.

It starts from 0 and increments with each new transaction file. However, when you restore a backup, this number may reset to 0. For specific formats it is reset when the session date changes.

Note: If your File Sequence Number resets after a backup restore, you'll need to contact your bank to obtain the last used File Sequence Number. If you ever need to manually change the File Sequence Number, Cashbook will provide a warning to alert you.

File Name

Field

Value

Name

Select Fixed or Custom to setup the export file name.

Example

This is an example of the format of the file name.

Own Description

The descriptions in your transaction files can vary based on your preferences and the format you're using.

When you see "COMPANYNAME" and "USERID" in the file, replace it with your actual company name and user ID.

The word "INPUT" should remain as it is.

The last three characters should be:

  • TST when you're testing the system with trial transactions.
  • PRD when you're conducting live, real transactions.

Segment 1-5

Select from the following options:

  • None

  • Bank Code

  • Batch ID

  • Posting Sequence

  • Time

  • EFT Process Date

  • Session Date

  • Bank Optional Field 1

  • Bank Optional Field 2

  • Bank Optional Field 3

  • Bank Optional Field 4

  • Bank Optional Field 5

Length

Enter the length for the corresponding Segment.

Format

Select from the following options:

  • None

  • Right Justify,Zero Fill

Current File Sequence Number

A unique serial number for your transaction files and is updated each time an EFT batch is successfully posted or the Regenerate function is run.

Sequence Start

If there are more than two banks using the NEDCONNECT format and the output destination is not set to 'Local,' each bank must have a unique Sequence Start. The same Sequence Start cannot be used across multiple banks.

When uploading files, the sequence in the file name will be calculated as follows:

  • Current File Sequence Number + 1 + Sequence Start.

  • The first file of each day resets the sequence to 1 + Sequence Start.

    Example: QNGG00.CDPACK.AT5A051.D0.SQ320.

Note: The Sequence Start field is only visible when using the NEDCONNECT format.

Encryption

Field

Value

Encryption

  • None
  • PGP: Select this option if you want to encrypt the EFT Export file.

Public Key File

The path of the public key file used to encrypt the files.

Encrypted File Extension

Type the file name extension that you want to appended to the file name when it is encrypted. The default extension is GPG.

Generate Keys Checkbox

Select this checkbox to enable the input fields for configuring the key generation process.

Password

Type the password that will be used for generating the key. This field is required to configure the key generation process.

Email

Enter the email address associated with the key generation. This field is necessary for notifications or validation during the process.

Key Path

Specify the path where the generated key will be saved. This location is essential to store the key securely.

Generate Button

Select this button to initiate the key generation process. All required fields (Password, Email, Key Path)must be completed before this button can be used.


Note: All required fields (Password, Email, Key Path)must be completed before this button can be used.