Creating and viewing your client's AE/AO ledger
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.
If you need help with this process, click Help me getting started in the Create Ledger window.
- Open a client and go to the Client Accounting > Trial Balance (Workpapers) tab.
- On the TASKS bar, click Create new AE/AO Ledger.
- In the Create Ledger window, enter the ledger name for your client in the Ledger name field.
- Select the Chart template by clicking the Browse button [...] and searching for your ledger template file. The Client Accounting Templates folder appears by default.
Confirm the Entity type and Chart type:
If you have selected a... then... MYOB Standard Chart the Entity Type and Chart Type fields will be automatically filled in Practice Chart if the CSV file name is different to the MYOB naming convention, you may need to fill out these fields manually - Enter the Financial year end date. The opening balance date and financial start month are automatically calculated from the financial year end date.
- Review the values in System 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. If any account codes in the System Account Mapping are also in the CSV file, the account codes are created as System Accounts.
- Click OK. The MYOB Ledger is configured. The ledger accounts are displayed in the Client Accounting > Trial Balance tab (called the Workpapers tab if you are licensed for Workpapers).
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 .
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.
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.