Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
HTML Wrap
classcol span_3_of_5
UI Text Box
typenote

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
titleTo create an AE/AO ledger for your client
  1. Open the client’s Client Accounting > Trial Balance tab (called the Workpapers tab if you are licensed for Workpapers).
  2. Click Create new AE Ledger on the TASKS bar. The Create Ledger window is displayed.
  3. Enter the Ledger name.
  4. Select the Chart template by 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.
  5. 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.
  6. Enter the Financial year end date.

    UI Text Box
    typenote

    The opening balance date and financial start month are automatically calculated from the financial year end date.

  7. 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.
    Any account codes that are present in the System Account Mapping, if also present in the CSV file, will be created as System Accounts.
  8. Click OK. This configures the ledger. The ledger accounts are displayed in the Client Accounting > Trial Balance tab (called the Workpapers tab if you are licensed for Workpapers).

 

UI Expand
titleTo create a Practice Chart
UI Text Box
typenote

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   .

  1. A chart template (Chart_Template.csv) can be found in Deploy/Client Accounting Templates/MYOB Standard Templates. Open this template in Excel.

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

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

    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
titleTo view your client's ledger
  1. Open the client’s Client Accounting > Trial Balance tab (called the Workpapers tab if you are licensed for Workpapers).
  2. 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.
  3. Click Select file to view the ledger.
HTML
</span>
HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Trial Balance (Workpapers) tab

Assets tab

Reports tab

Launching a ledger 

Configuring Client Accounting 

Configuring an Essentials general ledger as the data source

Modify prior year balances

Workpapers

Statutory Reporter

Assets