Absolutely!

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 Importing client files for detailed instructions covering each file format.

You sure can!

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

Yes!

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

Image Removed

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.
   Image Removed

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.

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.

Image Removed

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.

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.

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.

Image Removed

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

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
   type note
   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 Finalising 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.

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

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 Adding journals.

Client Accounting lets you can 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:

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.

Image Removed

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.