Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
classsection group
classcol span_3_of_5

General questions

UI Expand
titleCan I import transactions from a third-party file?


You can import transactions into MYOB Ledger with the following file formats:

  • MYE

  • TXT

  • CSV

The import process depends on which file format you use. Check out Import client files for detailed instructions covering each file format.

UI Expand
titleCan I add or change account codes?

You sure can!

The Manage accounts function lets you add, edit or delete an account.

UI Expand
titleCan I change the order of reports?


The green up and down arrows on the right of the Reports tab let you change the order of the reports.

To change the order of reports:

  1. Click the report you want to move.

  2. Click the up arrow to move the report closer to the start of the report or the down arrow to move the report closer to the end.

To change the order of reports at a practice level:

As a Practice Administrator with security permissions, go to Maintenance > Maintenance Map > Client Accounting Practice Report Settings.

UI Expand
titleWhere do I enter data in a workpaper?

You can quickly identify data entry fields in the workpaper. These fields are indicated in grey and help perform automatic calculations which are then prefilled into the white fields. If the field is not grey, you can't enter data into it.

You can add notes to the workpaper using the Notes field. This can be useful to describe any anomalies in the data. For example, an increase in wages and salaries after hiring new staff.

To attach any supporting documentation to the workpaper, use the Document Links field at the end of the workpaper.

UI Expand
titleWhat if I find a variance?

When you create a workpaper for an account, the client balance of the account is automatically included in the workpaper, even if the account balance is zero. When you've finished entering the details in the workpaper template, you may find a variance between the workpaper template and the client balance.

If there's a variance, make sure that the data was entered correctly. If there's no error in your data, you'll need to create an adjustment journal to correct the balance and reconcile the workpaper.

UI Expand
titleWhich workpaper template do I use?

MYOB Workpapers has over 80 built-in industry standard templates, and we keep building more!

Each practice runs things a little differently, so we recommend that Partners and Practice Administrators review the available templates and set a practice rule for which templates should be used. 

You can download our handy AU workpaper template examples or NZ workpaper template examples to help you compare and review which one you want to use.

UI Expand
titleWhy is an account code highlighted in red?

A red background in an open workpaper template means an account code's been changed or deleted in the ledger.

How do I...

UI Expand
titleDistribute profits for a trust or partnership?

Distributing profits varies between trusts and a partnerships. Let's look at both procedures:


You'll need to manually prepare a journal to distribute the trust profiles to each beneficiary.

Check that the Income Allocation is set to distribute 100% of the profit to the Trustee or "Owner".

For example:

Then ensure that the Owner's Retained Earnings and Current Year Earnings account is default. For example, using a MAS-style chart of Accounts.

This lets you do a manual journal entry to the Share of Profit account for each beneficiary:


Account Code/Name




50003: Distribution to Beneficiaries




50102: Share of Profit (Beneficiary 1)




50202: Share of Profit (Beneficiary 2)




The Define Income Allocation function lets you distribute a percentage of earnings to each partner or proprietor without having to manually enter journals. When the Define Income Allocation process is complete, Client Accounting automatically creates a distribution journal. See our setup instructions.

UI Expand
titleCapture quantities in my workpapers and reports?

To capture livestock quantities:

  1. Add and complete the Livestock Calculation - Closing Stock workpaper. An adjustment journal is created for the quantities and values to correct any variances where applicable.

  2. If the journal is correct, click Add Journal.

  3. Go to Workpapers and click Post journals. MYOB Ledger is updated with the closing values. The quantities remain within the workpaper template.

When you've completed the workpapers and posted the journal, the livestock report is available in the Reports tab.

UI Expand
titlePost depreciation journals from Assets Live?

In MYOB Assets Live, when you've processed all your asset movements (asset purchases and disposals), journal entries are automatically prepared.

To ensure that the journals integrate into Workpapers:

  1. Ensure that Integrate Accounts is selected in the Maintenance Group. For details, see Maintaining controls groups.

  2. To view the journal entry, go to Reports > Journal Summary and review the Journal Summary Report.

    UI Text Box

    The journal entry that's created is an adjustment entry to bring the balances in the ledger in line with the balances in the asset register.

  3. If the journal entry is incorrect, review and correct your assets movements in Assets Live.

  4. If the journal entry is correct, on the Assets Live Tasks bar, click Submit Journal. The journal is submitted to Workpapers.

  5. Click Post Journals to ensure that your MYOB Ledger is updated. For details, see Finalise assets.

  6. If you can keep making changes in Assets Live after you've submitted your journal, make sure you click Submit Journal after the changes.

UI Expand
titleReconcile my Asset Register?

Compare the Assets GL Reconciliation report to the balances and transactions made to the Asset Register's posting accounts.

UI Expand
titleProcess general journals?

We recommend processing all journals in the Workpapers module. If you're ready to start processing journals, click Add Journal on the Tasks bar to begin. For details, see Add journals.

UI Expand
titleReverse journals?

Client Accounting lets you reverse journals in a variety of ways. The best way depends on the circumstance:

One-off transactions

Ideal for one-off accruals or prepayments. For example, if you only need to reverse once and may not need to reverse the journal in future years.

To reverse once-off:

UI Text Box

This example is an AU system but can be used for NZ. NZ systems may have some differences.

Process the journal as normal and then select the To be reversed checkbox. A tick appears in the checkbox to indicate a reversal journal for this transaction will be automatically created in the following workpaper period.

Regularly-occuring reversal transactions

For transactions that occur on a regular basis such as quarterly or yearly, you can use the Define Balance Forward Accounts function to reverse. This function clears the balance of a nominated account to zero, and instead adds the balance to a predefined account. This is commonly used for beneficiary or stock accounts to clear prior year movements into an opening balance account.

For more information on automating the balance forward process, see Defining Balance Forward accounts.

Manual journal entry

If you've already rolled over into a new financial year or you haven't set up Balance Forward Accounts, a manual journal entry at the start of the year ensures that you begin the year with the correct opening balances.

UI Expand
titleDelete a client code?

It depends on your product and location!

Deleting a client

Deleting a client in AO ClassicDeleting a client (NZ AE, AU)

Closing a client (NZ, AU)

UI Button
linkModule 1. Setup
textSetup >
title<< Other ledger FAQs


classcol span_1_of_5