MYOB Advanced Tips and Tricks

Sharing our skills with the MYOB Advanced user community.

As your MYOB Advanced specialist, we bring together our skills and expertise with your understanding of your company to improve your business systems. MYOB Advanced is Australia’s number one cloud-based ERP system. It streamlines processes, consolidates reports, automates workflows and allows you to manage your business the way you want. MYOB Advanced is a powerful ERP with extended functionality. You could be missing out on valuable efficiencies if you are not utilising the software’s full potential. So we’ve put together these MYOB Advanced tips and tricks to boost your knowledge.

Kilimanjaro Consulting has a philosophy of making our clients as self-sufficient with their ERP systems as possible. Our MYOB Advanced Team have pooled their knowledge to share some insightful MYOB Advanced tips and tricks for you and your team.

The right help, tools and knowledge can make the difference between a good and bad day. We hope that this bank of resources provides that helping hand to guide you and your business through minimising errors, saving time, and improving business efficiency.

Make the most of MYOB Advanced with the following tips and tricks!

17. Keyboard Shortcuts to improve efficiency in MYOB Advanced

Mastering keyboard shortcuts in MYOB Advanced helps you unlock your system and team’s full potential. Discover how to swiftly perform common tasks and focus on more critical responsibilities. Every second counts in a fast-paced environment. Whether you are an experienced MYOB Advanced user or just starting to explore its features, knowing the right shortcuts can significantly enhance productivity and streamline your workflow.

Read the comprehensive list of keyboard shortcuts in MYOB Advanced.

16. Deferral Schedules in MYOB Advanced

The Deferrals module within MYOB Advanced Business is an effective tool to save time and maintain accuracy. Deferral schedules automate the recognition of your revenue and expenses in the correct accounting period(s). The Deferrals module replaces manual calculation and reconciliation that is often completed in a spreadsheet. This manual process is both inefficient and prone to errors. Integrated with the general ledger, this module ensures that journal postings occur automatically for each periodic recognition.

A deferral schedule is a handy automation to defer the recognition of revenue or expense until a later period, to ensure revenue matching, or to amortise revenue or expense over a period of time.

Read more!

15. Adding one-off public holidays in MYOB Advanced Payroll

MYOB Advanced Payroll is a powerful and flexible payroll solution. It can process multiple different pay groups across multiple pay frequencies. MYOB Advanced Payroll will also apply the annual public holidays based on information from state and federal government departments. However, MYOB Advanced Payroll can also be configured to include one-off or other public holidays that your organisation might need.

You can add these new public holidays as exceptions in your work calendar. This will record the appropriate leave payments and liabilities. You will need to account for any other payroll activities that this might affect, such as new starters, terminations, and existing leave requests.

Read more!

14. Simplify your Cross-Company Sales

Cross-Company sales record the important details from transactions between your entities. Specifically, a cross-company sale is when you fulfil a purchase order from one entity to another in the same organisation or group. It is important to make sure that the transaction details, key dates, parties involved, transaction value, and relevant documentation are accounted for.

When done manually, this is a tedious process and can lead to errors due to so many independently moving parts. With the new MYOB Advanced update, the system now allows sales and purchase orders to be processed between companies and branches under the same tenant. AP documents are automatically generated by exporting information from linked AR documents, simplifying the process and improving your efficiency.

Read more!

13. Learn to Streamline your Intercompany Sales

The complexity of your organisation may require you to pay dividends, buy and sell assets (e.g., inventory or machinery), or lend money to other entities within your organisation. It may also require central order fulfilment that sources products from different entities based on availability or other product characteristics. Regardless of the requirement, these transactions between your different entities are recorded as an Intercompany sale in MYOB Advanced Business.

Intercompany sales record important information for balancing activity between your entities, such as transaction details, key dates, parties involved, transaction value, and relevant documentation.

Read more!

12. The Global Search Function in MYOB Advanced

MYOB Advanced is an integrated business management system that gathers data across your entire operation. Whether it is reduced administration time, greater inventory control, or real-time reporting, MYOB Advanced will improve efficiency in your business. However, finding the exact screen or piece of data within this vast network can be challenging. MYOB Advanced’s Global Search allows you to quickly search for a particular piece of data in your system, regardless of where it may be located. Save time trawling through the depths of your system and instantly find what you are looking for with the Global Search function.

Read more!

11. Important Features of Reporting Dashboards

MYOB Advanced is built to consolidate your data and reports, simplifying your decision-making process by giving you the best view of your data. Dashboards allow users to monitor financial, operational, and organisational information while analysing real-time trends related to their company role. You can now create and use personalised business dashboards to display different information types related to job functions, roles, or responsibilities to give you an overview of your current financial, organisational, and operational information.

Read more!

10. Company Groups – Restricted Visibility of Customer and Supplier Records

Managing multiple companies in a single tenant has several advantages, including sharing master records such as customers, suppliers, and inventory items.  However, there may be a requirement to separate customers and suppliers from different companies and users. This feature is now available as of MYOB Advanced version 2021.1.1, where the visibility of customers and supplier data can be restricted without Restriction Groups.

Read more!

9. Matrix Items in MYOB Advanced

In many ERP systems, managing inventory with multiple attributes can become challenging. In MYOB Advanced, Stock and Non-Stock items can be flagged as Matrix items. This enables users to easily create a new set of stock items by taking advantage of higher-level template settings. This article teaches how to simplify simple work processes using matrix items.

Read more!

8. Corporate Cards in MYOB Advanced

As of MYOB Advanced version 2020.3, the use of corporate credit cards is now supported through the Expense Claim and Expense Receipt forms. This helps employees and your accounts department to categorise and track expenses. For example, an employee can buy something to charge to a project and pay for it with a corporate card. This article details the advantages of leveraging this function in MYOB Advanced and how it creates employee efficiencies.

Read more!

7. Restricted use of Control Accounts in MYOB Advanced

Posting directly to the General Ledger Control Accounts can cause imbalances between sub-ledgers and their respective balance sheet accounts. Introduced in Release 2020.3, MYOB Advanced now provides the ability to restrict direct postings of transactions, such as journal entries, to control accounts. Read more about how restricting control accounts can improve the use of your system.

Read more!

6. Business Events in MYOB Advanced

Use the Business Events feature in MYOB Advanced to automate your workflows. A Business Event monitors specified Generic Inquiries and then processes certain actions based on changes or schedules. Use these powerful features to streamline repetitive processes and improve efficiency.

Read more!

5. Fixed Assets in MYOB Advanced

Fixed Assets Management in MYOB Advanced makes it easier to manage company assets and provides complete visibility and depreciation calculations. The newest version of MYOB Advanced completed the long-awaited additions to the Fixed Assets module. This release adds functionality by completing work on the diminishing value and prime cost/straight-line depreciation methods for the Aust and NZ jurisdictions.

Read more!

4. Generic Inquiries in MYOB Advanced

With version 2019, new functionality has been added to Generic Inquiries in MYOB Advanced. Customise your Generic Inquiries with these new functions to save time and improve the results from your reporting.

Read more!

3. Row Level Security in MYOB Advanced

MYOB Advanced is a cloud-based system that you can access remotely, anytime, anywhere. With this comes the need for complex security and permissions. Your data is accessible, but more importantly, is it safe? Security features such as 2FA (2-factor authentication) were rolled out recently and are now automatically part of the login system. Another important feature that is often overlooked or simply not recognised is Row-Level Security.

Read more!

2. MYOB Advanced – New User Interface

In 2018, the upgraded version of MYOB Advanced came with a new User Interface (UI) as an option. Some users may have been reluctant at the time to use the new User Interface for lack of familiarity. Other users may have upgraded but are not aware of the finer details of the new User Interface. Read more on how to use the new user interface here.

Read more!

1. How to Generate Statements on Demand

Since the upgrade of MYOB Advanced to version 2018.1, it is now possible to generate customer statements quickly and easily upon ad-hoc requests from customers. Here are step-by-step instructions on how to use this feature.

Read more!

Stay up to date with the latest MYOB Advanced features

Many of these tips and tricks come about from new additions to MYOB Advanced. With each new version, new functionality is added that can make you more efficient and improve productivity. Visit the MYOB Advanced Version History page to discover the newest and upcoming features.

Want clarification on any of these MYOB Advanced tips and tricks?

Remember, if you have any questions about how to generate statements, the new User Interface, Row-Level Security, Generic Inquiries, or just a general query about anything from the above MYOB tips and tricks, our friendly MYOB Advanced team is always here to help. Call us on 1300 857 464 (AU) or 0800 436 774 (NZ) or email at or

MYOB Diamond Partner
Velixo Award 2023
Consultant of the Year Award
Velixo Award 2019
Business awards logo
Excellence in Business Development 2015 AU
MYOB EXO Award 2015
Telstra Awards 2012