Overview:

General Ledger Accounts and its details can be imported into this screen to be used later on on reports or anywhere in the system where instead of displaying a GL Code, an Account description can be used.

Image Removed

Image Added

Screen Guide:

New lines can be added manually. User can modify all columns except for the GL Code. For this delete the line and create anew one.

There is a data import with atemplate a template format that can be used to populate with an export of the Chart of Accounts from the financial system.

Note that all existing lines are deleted before importing the file.
Columns:

• Sequence No

• GL Code - this cannot be edited.

• Description

• Section (Type): Is the category in the Chart of Accounts. Example: Assets, Liabilities, Income, Cost of Sales, Expenses, Other Income, Other Expenses. This is free text.

• Subsection (SubType) optional

• Category - 1 = Revenue, 2 = Job Cost, 3 = Other Cost. These are used mainly to categorise all existing transactions in the Job Margin report (which is essentialy a Profit & Loss report within Workbench).

GL Account Validation:

To use the function ‘GL Account Validation’ for Activities and Sales Codes, the GL Account should be correctly configured in advance. If you're using Xero or MYOB AccountRight, you can automate GL Account imports from their configuration screens. For other systems, export GL accounts from your financial system and manually import them into the GL Accounts screen. Click here to learn about Xero Integration or MYOB AccountRight

Image Added

Next Steps: