This feature is not enabled for all users. If this option isn’t available in the TASKS bar, please contact your client manager to enable this feature for your practice.
You can configure an AE/AO ledger as a client’s financial data source.
UI Expand
title
To create an AE/AO ledger for your client
Open the client’s Client Accounting > Trial Balance tab (called the Workpapers tab if you are licensed for Workpapers).
Click Create new AE Ledger on the TASKS bar. The Create Ledger window is displayed.
Enter the Ledger name.
Select the Chart templateby clicking the Browse button in this field, and searching for your ledger template file. The Client Accounting Templates Folder is shown by default.
MYOB Standard Charts contains the predefined charts in CSV format for AOGL, Accounts, and MAS products and entity types, separate into farming and non-farming templates. Files in this folder will always be overwritten and updated after a software update.
Practice Charts can be used to store your practice’s own custom charts in CSV format. Files here will not be modified by the update process. See To create a Practice Chart for more information on creating this chart.
Select the Entity Type and Chart Type.
If you have selected an MYOB Standard Chart, the Entity Type and Chart Type fields will be automatically filled in.
If you have selected a Practice Chart, and your CSV file name is different to the MYOB naming convention, you may need to manually enter these fields. See To create a Practice Chart for more information.
Enter the Financial year end date.
UI Text Box
type
note
The opening balance date and financial start month are automatically calculated from the financial year end date.
Review the values inSystem Account Mapping, and modify any values if required. The mapped Account code values displayed here vary depending on the Entity and Chart Type.
If you have selected an MYOB Standard Chart, the values displayed here are defined by MYOB.
Any account codes that are present in the System Account Mapping, if also present in the CSV file, will be created as System Accounts.
ClickOK. This configures the ledger. The ledger accounts are displayed in the Client Accounting > Trial Balance tab (called the Workpaperstab if you are licensed for Workpapers).
UI Expand
title
To create a Practice Chart
UI Text Box
type
note
When creating a Practice Chart CSV template, maintain the file format, structure, and column order. Headers should always be in the first row of the CSV file. When reviewing the CSV file, we recommend opening the file using Notepad or similar text editing software. Opening CSV files in Excel may result in trailing zeros being removed from Account codes with decimal places. Ensure System accounts specified in the table are in the practice chart so that the appropriate account type group is set. This can also be set manually using Manage Accounts—see Managing accounts for AE/AO ledger .
A chart template (Chart_Template.csv) can be found in Deploy/Client Accounting Templates/MYOB Standard Templates. Open this template in Excel.
In the template, fill in the following values:
Column name
Description
AccountCode
If this value is not present, the record is ignored when creating charts.
AccountName
Name of the account code. This field is optional. If this field is left blank, the value “*** unknown account ***” is used.
AccountType
Defines the type of Account. Valid values are:
Income
Other Income
Liabilities
Equity
Expense
Other Expense
Assets
Cost of Sales
Uncategorised.
If the value is not valid or no value is entered, the default value of “Uncategorised” is used.
AccountTypeGroup
If the account code is a control group, enter Yes as the value. For child accounts, enter the account code value associated with the control group to link them with the account type group/control account. This field is optional.
TaxCode
Contains the tax code. The valid code values (and their definitions) are:
NA (No tax implied)
(Australia) CAP (Capital acquisitions)
(Australia) EXP (Export sales)
(Australia) FRE (GST free)
GST (Goods & Services Tax)
(New Zealand) E (Exempt)
(Australia) GNR (Not registered)
(Australia) INP (Input taxed purchases)
(Australia) ITS (Input taxed sales)
NTR (Not reportable)
(New Zealand) Z (Zero rate)
(New Zealand) I (GST on imported supplies)
If no value is entered, the default value of NA is used.
Save the CSV file using the following naming convention:
MAS_<entity type> for MAS chart types
(Australia) ACCOUNTS_<entity type> for Accounts chart types
AOGL_<entity type>for AOGL chart types
where <entity type> is Individual, Partnership, or Company.
UI Text Box
type
note
You may choose to follow a different naming convention. However, you will be required to manually enter the entity type and chart type when creating a new AE ledger.
UI Expand
title
To view your client's ledger
Open the client’s Client Accounting > Trial Balance tab (called the Workpaperstab if you are licensed for Workpapers).
Click View AE Ledgers/View AO Ledgers on the TASKS bar. The Select Company File window opens listing all the active (in bold) and suspended (greyed out) Essentials Accounting, Cashbook and/or Ledger files. By default, if the client code of the ledger corresponds to the client code of MYOB AE/AO, then the ledger file is selected. If there is no ledger displaying with the same client code, then the most recently created ledger file is selected. You can also select any other ledger file if required.