Finances, Assets & Liabilities: Catch-e Set-up Steps

Driver financial information and bank accounts

Catch-e Set-up 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

Click on **.

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

Click ** to save.

Delete a Bank Account

Click on ** next to the record.

Cannot delete default account
Click ** to confirm deletion

Add Bank Account to Item

Qualifiers

Editing an Employee / Item
Payee = Employee

Process

Go to Employee / Item
Click **
Click **
Select bank account
Apply selection

Create Bank Account (from Item)

Click ** and enter:

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

Click ** to save.

Change Bank Account Details (Support Request)

Send to support@catch-e.com.au:

Field	Value
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)

Invoice Footer Update Request

Field	Value
footer11_text
footer12_text
footer21_text
footer22_text
footer31_text
footer32_text
footer4text
footer5text
footer6text
footer7text

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
Click **
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