Chart of Accounts Best Practice Structure

Note: If you are upgrading to Accounting Fall 2021 and you do not want to adopt the new Chart of Accounts Best Practice Structure, you must go to the Accounting Payments Plus feature in Feature Console and perform step 4 to transfer your current chart of accounts structure. If you do not, Payments Plus and Payment Selection will not filter the correct GLAs.

You can choose how to structure your chart of accounts. However, we recommend using the following Chart of Accounts Best Practice Structure. This is especially important if you are using Certinia Reporting, because our best practice structure ensures that the reports produced are accurate.

When setting up your general ledger accounts, we recommend you implement the reporting hierarchy shown in the table below. If you have upgraded to Accounting Spring 2023, your administrator will need to manually add these picklist values to the Trial Balance fields 1 - 3 on the General Ledger Account object and create the required dependencies. Refer to the “Upgrading Accounting” document for more information.

Trial Balance 1	Trial Balance 2	Trial Balance 3
Assets	Current Assets	Bank and Cash
		Accounts Receivable
		Prepayments and Accrued Income
		Debtors
		Inventory
	Fixed Assets	Land and Buildings
		Fixtures Fittings and Equipment
	Intangible Assets	Intangible Assets
	Other Assets	Other Assets
Liabilities	Current Liabilities	Accounts Payable
		Accruals and Deferred Income
		Employment Payables
		Tax Liability
		Creditors
		Employment Creditors
		Provisions
	Long Term Liabilities	Payable After 1 Year
		Creditors Due After 1 Year
Equity	Shareholders Funds	Stock
		Capital and Reserves
	Retained Earnings	Retained Earnings
Gross Profit	Sales Revenue	Sales Revenue
	Cost of Sales	Cost of Sales
Expenses	Operating Expenses	Administration Costs
		Equipment Hire and Repairs
		Marketing Expenses
		Motor Expenses
		Occupation Costs
		Payroll Costs
		Professional Fees
		Staff Costs
		Travel Expenses
	Depreciation and Amortization	Amortization
		Depreciation
	Interest and Tax	Finance Costs
		Taxation
	Other Income/Expense	Other Income and Expenses

Custom Setting - GLA Filtering

You can control GLA filtering in Payment Selection and Payments Plus by allowing custom Trial Balance combinations.

Use the following format (if set as NO FILTERING all GLAs are retrieved):

• TB1=Liabilities,TB2=Current Liabilities,TB3=Creditors,TB3=Provisions

Note: In accordance with the previous example, when using multiple selections, separate with a comma and do not add spaces.

To use custom filtering for trial balances you must enable the GLA Filtering custom setting. For more information, see Payments Plus Options.