Contents

‘Menus’ – ‘Setup’ – ‘Bank Accounts’

Up to 10 bank accounts can be added to mydaEs and reconciled from the Setup > Bank Accounts menu item as shown below.

Setup / Modify Bank Accounts

A window with 10 tabs will appear. Each tab relates to a separate bank account that can be made available for payments and reconciliation, and has a variety of details you can setup.

Tip

Unused bank accounts will show ‘Inactive’ until the ‘Inactive’ field on the tab has been deselected.

You can change:

Bank Addressing details – These can be filled in for your reference.

Ledger Acct No – This should be set to a bank account in your Chart of Accounts balance sheet.

BSB No / Account No – Your bank accounts Account Number and BSB/Sort Code. Many banks require this to be present on Bank Upload files for validation.

Currency – Enables entries for the selected currency to be paid against this bank account.

Sep Direct Deposit – If this is enabled, each payment in a single payment run will be given a unique reference number on the bank reconciliation rather than being grouped together.

Bank User ID – Some banks use this as identification who is uploading or as a unique reference. e.g. For Westpac bank the bank user ID or the Direct Entry User ID must be 000000 (or your Direct Entry User ID as per letter from Westpac).

Bank Uploads (Importing Payments)

You can also choose the default export format for direct deposits and Electronic Transfers. This will affect the bank file that the system will generate and should be set to your bank if you are using bank uploads.

Which format should I select?

As bank files can vary wildly by bank and region, please see your region and bank. If you are unsure, please contact support for assistance selecting the correct format.

Australia

Bank

ET format

Bank User ID

ANZ

NAB (AUS)

Not Required

ANZ (Self Balancing Line)

ANZ Transactive

Not Required

Bendigo Bank

Westpac (AUS)

Different for each account (APCA User ID)

CBA

NAB (AUS)

Different for each account (APCA User ID)

HSBC

NAB (AUS)

Not Required

St George Bank

NAB (AUS)

Not Required

Westpac

Westpac (AUS)

000000 or the Direct Entry User ID on a letter from Westpac

New Zealand

If you experience problems when uploading to the ASB bank in NZ using the ASB format, use the BNZ format. When you import it into the ASB online banking make sure that you choose BNZ from a drop-down menu, called “Import other file” so it knows it’s not a normal ASB format.

United Kingdom

Bank

ET Format

Bank User ID

Coutts

Coutts BACs (UK)

Not required

Barclays

Barclays BACs (UK)

Not required

HSBC

HSBC Standard18 (UK)

3 letters ref (e.g. “ABC”)

RBS

RBS (UK)

Not required

AIB

AIB (IRE)

Not required

AIB SEPA – For IBAN/BIC payments

SEPA (Europe)

Your OIN number

BOI SEPA – For IBAN/BIC payments

SEPA (BOI)

Your OIN number

South Africa

Bank

ET Format

Bank User ID

Standard Bank

Standard Bank (SA)

Not required

FNB

Bankserv (SA)

4 digit ID (any letters)

Netbank

Netband (SA)

Not required

Bankserv

Bankserv (SA)

4 digit ID (any letters)

Cheque Formats

If you need to print cheques, you can select which format to print these on. Examples of available formats can be downloaded below by selecting ‘Article Attachments’.You can also select how many prints should occur.