Catch-e Setup Steps

Where only one bank account is used for payments, it only needs to be populated with a single set of bank account details.

The table glbankaccounts contains these fields:

Field	Type	Description
bankaccountid	int(10)	unique_id
glcodeid	int(10)	Enter as 0 or link to `gl_codes` (optional)
bank	varchar(3)	Bank code (e.g. ANZ, CBA)
account_name	varchar(26)	Account name shown in Payments screen
accountnameshort	varchar(16)	Short name used in ABA files
bsb	tinyblob
account_number	tinyblob

glbankaccountabamappings table

Field	Type	Description
bankaccountmap_id	int(10)	Unique ID
bankaccountid	int(10)	Links to bank account
process_type	enum('payables','receipts','becs','bpay')	Payment process type
company_id	int(10)	Company link
apca_number	varchar(6)	APCA identifier
aba_description	varchar(12)	ABA file description
abaselfbalancing_flag	enum('yes','no')	Self balancing flag

Table Mapping

The glbankaccounts table links to glbankaccountabamappings to define how bank accounts are used across payment processes such as payables, receipts, BECS, and BPAY.

Sample Queries

Query

select * from gl_bank_accounts;

select * from gl_bank_account_aba_mappings where process_type = 'payables';

select ba.bank_account_id, ba.bank, ba.account_name, ba.account_name_short, baam.process_type, baam.apca_number, baam.aba_description, baam.aba_self_balancing_flag from gl_bank_accounts ba inner join gl_bank_account_aba_mappings baam on baam.bank_account_id = ba.bank_account_id where baam.process_type = 'payables';

Bank Account Setup

Create a Bank Account

Set the following:

Account Name (optional)
BSB
Account Number
Claim (optional)
Default (optional)

Click Save.

Delete a Bank Account

Click on the record.

Cannot delete default accounts
Click to confirm deletion

Add Bank Account to Item

Qualifiers

Editing an Employee / Item
Payee = Employee

Process

Go to Employee / Item
Select bank account
Apply selection

Create Bank Account (from Item)

Enter:

Account Name (optional)
BSB
Account Number
Claim (optional)
Default (optional)

Click Save.

Change Bank Account Details (Support Request)

Raise a request via Lily to do so:

Field

Date to update

Bank Account

Company Name

Bank

Account Name

Account Name SHORT

BSB

Account Number

APCA Number (BECS)

ABA Description (BECS)

ABA Self Balancing (BECS)

APCA Number (Payables)

ABA Description (Payables)

ABA Self Balancing (Payables)

Useful Queries

Query

select * from gb_companies;

select * from gl_bank_accounts;

select * from gl_bank_account_aba_mappings;

select coy.name as company, ba.bank_account_id, ba.bank, ba.account_name, ba.account_name_short, baam.process_type, baam.apca_number, baam.aba_description, baam.aba_self_balancing_flag from gl_bank_accounts ba inner join gl_bank_account_aba_mappings baam on baam.bank_account_id = ba.bank_account_id left join gb_companies coy on coy.company_id = ba.company_id;

Change Bank Account on Item

Qualifiers

Updating Employee bank account
Payee = Employee

Process

Go to Employee / Item
Select or create account
Tick account
Click Apply

View Bank Accounts

Field	Description
Account Name	Editable
BSB	Read-only after creation
Account Number	Read-only after creation
Claim	Enables use in Claims
Default	Only one allowed

Actions

Action	Description
View	Apply changes
Edit	Modify record
Delete	Inactivate (if not default)
New	Create record
Close	Exit