When creating a new MYOB Ledger, you're asked to choose a chart of accounts template.
We've provided templates for each entity type using MYOB standard chart of accounts. However, you can choose to create your own set of templates for use by your practice.
You can find the chart of accounts templates in your \Central\Deploy\Client Accounting Templates folder. Within this folder is your Practice Chart templates and MYOB Standard Chart templates.
By default, the Practice Charts folder is empty. This is where you'll save your practice's custom chart templates.
Open Windows File Explorer and navigate to:
If you're using... Go to...
Accountants Enterprise (AE)
X:\MYOBAE\AESQL\Central\Deploy\Client Accounting Templates\MYOB Standard Charts
Accountants Office (AO) X:\MYOBAO\AOSQL\Central\Deploy\Client Accounting Templates\MYOB Standard Charts.
Where X:\ is drive AE or AO has been installed to.
RIght-click on the Chart_Template.csv file and from the drop-down menu, choose Copy.
Click the up arrow () next to the address bar to return to the Client Accounting Templates folder.
From the Client Accounting Templates folder, open the Practice Charts folder.
Right-click on any blank space in the Practice Charts folder and from the drop-down menu, choose Paste.
Right-click on the Chart_Template.csv file and from the drop-down menu click Open With...
Opening CSV files in Excel may result in trailing zeros being removed from Account codes with decimal places.
Start at row 2 and enter the account code, name, type, account type group and tax code in the relevant fields as per the table below:
Row 1 must contain ALL column headers.
You must have the column headings present in row 1, in the same order as the Chart_template.csv file. These column headings are the name of the fields that the data is imported to.
If you don't have data to import for a particular field, the column heading must still be present in Row 1, but you can leave the data blank (i.e. row 2 onwards)
Column Column header Rules for the data A AccountCode
If this field is left blank, the record is ignored and the account is not imported.
Enter a description for the account. If this field is left blank the account will be imported with the account name "*** Unknown Account ***".
Enter the type of account in this column. Accepted account types are as follows:
- Other Income
- Cost of Sales
- Other Expense
If this field is left blank or an account type not in the above list is used, the account will be given the type “Uncategorised”
If the account is a control account, enter Yes in the AccountTypeGroup column. For each sub-account, enter the account code of the control account in the AccountTypeGroup column. This will link the sub-account to the control account.
This field is optional. For normal accounts, leave this field blank.
E TaxCodeAccepted Tax codes Tax Code Description AU NZ CAP Capital acquisitions EXP Export sales FRE GST free GNR GST not registered INP Input taxed purchases ITS Input taxed Sales GST Goods & Services Tax NTR Not reportable NA No tax implied E Exempt Z Zero-rated I GST on imported supplies
If this field is left blank, the account will be given the default tax code 'NA' (no tax implied).
Make sure you include all system accounts in the chart template. You'll need to specify these account codes when creating a ledger. These are:
Allocate Me (Withdrawal)
- Allocate Me (Deposit)
- Historical Balancing
Once all accounts that you wish to import are listed in the file, click the File tab and choose Save As.
Change the name of the file to reflect the chart style and entity type, then click Save.
Save the file using the following naming convention <ChartType>_<EntityType> (where <entity type> is Individual, Partnership, or Company).
When creating a new MYOB Ledger, Client Accounting will automatically fill in the entity type and chart type based on this naming convention.
For example, MAS_Partnership, ACCOUNTS_Company or AOGL_Indiviudal.
Practice Chart FAQs
When creating a new MYOB Ledger, the Select chart template is a mandatory field, meaning you must choose a template to create the ledger.
This file is a blank chart template containing only the column headers required by Client Accounting.
Yes, you can. Check out Importing a Chart of Accounts for details.