You can import transactions into MYOB Ledger with the following file formats:
The import process depends on which file format you use. Check out Import client files for detailed instructions covering each file format.
You sure can!
The Manage accounts function lets you add, edit or delete an account.
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:
Click the report you want to move.
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.
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.
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.
A red background in an open workpaper template means an account code's been changed or deleted in the ledger.
How do I...
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".
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:
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.
To capture livestock quantities:
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.
If the journal is correct, click Add Journal.
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.
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:
Ensure that Integrate Accounts is selected in the Maintenance Group. For details, see Maintaining controls groups.
To view the journal entry, go to Reports > Journal Summary and review the Journal Summary Report.
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.
If the journal entry is incorrect, review and correct your assets movements in Assets Live.
If the journal entry is correct, on the Assets Live Tasks bar, click Submit Journal. The journal is submitted to Workpapers.
Click Post Journals to ensure that your MYOB Ledger is updated. For details, see Finalise assets.
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 Add journals.
Client Accounting lets you reverse journals in a variety of ways. The best way depends on the circumstance:
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:
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.