Overview:

General Ledger Accounts and its details can be imported into this screen to be used later 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 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

• 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:

Account Type

Section (Type)

Category

MYOB

CostOfSales

Cost of Sales

Job Cost

Expense

Expenses

Other Cost

OtherExpense

Other Expenses

Other Cost

Income

Income

Revenue

OtherIncome

Other Income

Revenue

Xero

DIRECTCOSTS

Direct Costs

Job Cost

EXPENSE

Expenses

Other Cost

OVERHEADS

Overheads

Other Cost

REVENUE

Revenue

Revenue

SALES

Sales

Revenue

. 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.

Image Removed

Click here to learn about Xero Integration or MYOB AccountRight

Image Added

Next Steps: