Banking Configuration Maintenance - Bank Files tab

Owned by Former user (Deleted)
Last updated: Sept 10, 2021 by Richard Kennedy (Unlicensed)
3 min read

Use the Bank Files tab to maintain:

  • bank account details
  • BPAY and credit card processing details
  • ABA (Australian Banking Association) details.


 Opening the Bank Files tab

To open the Bank Files tab:

  1. Select Module > System > Banking Configuration Maintenance.
    Note: Alternatively you can launch into Banking Configuration Maintenance from the Finance Configuration Maintenance - General tab, by clicking  next to the Default Bank Account field.
    The General tab of the Banking Configuration Maintenance window is displayed.
  2. Click the Bank Files tab.
    The Bank Files tab of the Banking Configuration Maintenance window is displayed.


Banking Configuration Maintenance - Bank Files tab key fields and buttons
Fields

Field

Description

Bank

Select the bank holding the account. Banks are defined in the luBank lookup table.

User Code

This number is supplied by your bank if you are using electronic transmission using the bank's EFT software.

EFT File Type

The EFT file type used at your organisation.

B. S. B. / Account

The BSB and account number for the selected bank.

BPAY File Type

If you have a BPAY service, specify which bank it is from.

Credit Card File Type

If you want to direct debit credit cards, specify which bank you use.

Credit Card User Code and User Code 2

User codes for use with credit cards.

This is required for some banking file exports.

Note: If your organisation uses the CBA Evolve banking file export then this field is used instead of the User Code field for the export. If this field is blank, the User Code field is used.

Other Receipts File Type

If you want to import other receipts, specify what file format they are. You can select:

Cred Card Password

Password of the credit card.

User Short Name

Some banks have a restriction on the size of the user name. This field is 26 characters and is also provided by your bank when you set up the EFT software.

Alpha Code

No longer used.

Debtor Match Method

Select your preferred method of matching debtors in the banking file:

  • Default (determined by banking type).
  • BPAY Reference, then by debtor ID.
  • Debtor ID then by BPAY Reference.
  • BPAY Reference only.
  • Debtor ID only.

Bank Statement File Type

Select the format that the bank statement is to be produced in, for example NAB format or Quicken format.

Preview Report when closing a Bank Reconciliation

Select to preview reconciliation reports instead of printing them when closing bank reconciliations.

Note: Reports can still be printed from the preview page.

Create Auto Pay File

Use this to set the default option in Process EFT Payments to automatically select to create an ABA file.

Create Balancing Entry in Auto Pay File

If your bank's online/EFT system requires that you not only supply details of who you are going to pay but also an entry in the ABA file for the amount to be taken out of your account.

Some banking systems calculate this figure automatically whereas others do not.

Include Posting Number in Auto Pay Reference

Select to include the EFT posting number as a reference in the creditor EFT file.

When Importing Files Keep Posting Open

Select to keep the posting open while you import files.

When Exporting Files Keep Posting OpenSelect to keep the posting open while you export files.


Buttons

Button

Description

Insert a new bank account entry then edit the details.

Delete the selected bank account entry.

The Confirm Delete window is displayed.

To confirm the deletion:

  1. Type delete.
  2. Click .

Save the changes made to the new or existing bank account record.