MYOB Advanced & Excel

Regardless of how much time, resources and money you invest in your ERP implementation, Microsoft ® Excel will always have a place in your organisation. Hence, MS Excel® is a fantastic tool for entering, calculating and analysing financial data. Rather than try to replace it, it makes sense to harness the full power of MS Excel®.

MYOB Advanced is fully integrated into MS Excel®, therefore, it has a range of inbuilt functions that can save time and money for your organisation.

Easily upload records to MYOB Advanced

Data in MS Excel® or CSV format can be uploaded as line records into transactions such as bills, journals, etc. Transactions with fixed or complex allocations can be prepared in MS Excel® using a predefined template, for example, to apportion expenses.

Benefits: Fast track data entry while minimising data entry errors.

Export records

Line records within transaction or inquiry screens can be instantly extracted for analysis using the Export to Excel button. A file with all the visible fields on the grid including the headers and parameters used is created in xlsx format to solve common queries.

Benefits: Simple to use context-sensitive reporting. This file can subsequently be used as a source for importing data.

 

MYOB Advanced and Excel 3

 

Import scenario

The Import Scenario function allows users to synchronise data between MS Excel® and MYOB Advanced. Import scenarios are commonly used to load master files and transactions. Or, to manipulate existing data in bulk like changing terms on a range of customers. Fields between the spreadsheet and the data in MYOB Advanced are mapped accordingly. As data is imported, it is validated to preserve data integrity throughout the process.

Benefits: Eliminate time-consuming data entry and minimise data entry errors.

Export Scenario

Export Scenarios allow users to extract data from MYOB Advanced to MS Excel® in a user-defined format. Where a report or inquiry screen is missing needed information, an Export Scenario may be an ideal way to extract data without the need to build complex or expensive reports.

Benefits: Fast access to large amounts of customisable data to suit requirements.

Generic Inquiry

A Generic Inquiry is a tool that allows users to build intricate queries to isolate selected data for those without programming skills. As a result, generic inquiries can be used to filter, sort, calculate, aggregate and summarise data in list form which can be exported to MS Excel®.  To help you analyse and interpret important information captured in MYOB Advanced, consider our Generic Inquiry Writers Course.

Benefits: You can build sophisticated reports to suit requirements.

OData

Simply put, Odata (Open Data Protocol) is a live link between MYOB Advanced and MS Excel®. An OData feed in MS Excel® can seamlessly source data directly from MYOB Advanced using the framework of a Generic Inquiry. The spreadsheet can be refreshed to ensure data is always up to date with current information.

Benefits: Give users access to data without having to log into MYOB Advanced thus saving user licence numbers. Reports within Excel can be highly customised to include graphs & pivot tables without needing a working knowledge of MYOB Advanced.

Report Designer

In most organisations, it is common practice to run reports in their ERP. Open them in MS Excel® and, using a text to column wizard, separate the data into columns. This is because most report designs look “pretty” on paper, screen or PDF. They are not necessarily built to be opened in MS Excel®.

Benefits: The Report Designer in MYOB Advanced eliminates the time consuming & repetitive process by allowing users to embed the column structure within the report that is only called upon when it is pushed to MS Excel®.

Need fast access to data, want to cut down on time-consuming tasks or the ability to build sophisticated reports? Microsoft ® Excel and MYOB Advanced are a perfect pair.

Velixo

Velixo was built from the ground up for MYOB Advanced, by MYOB experts. Their reports are the only reporting tool of its kind designed exclusively for MYOB Advanced. Above all, Velixo used their extensive experience with MYOB to craft a user-friendly MS Excel® plugin. Finally, it is lightning fast and leverages the unique capabilities of your cloud ERP.

Contact us today for more information about how MYOB Advanced is helping more and more growing businesses thrive.  Call us on 1300 857 464 or email on [email protected] to chat with our MYOB Specialists. 

MYOB Advanced – New User Interface

A year ago, the upgraded version of MYOB Advanced came with a new User Interface (UI) as an option. Some clients may have been reluctant at the time to use the new User Interface for a lack of familiarity. Other clients may have upgraded but are not aware of the finer details with the new User Interface.

This blog is to provide some tips and tricks with the new User Interface so that you get the best out of using MYOB Advanced. If you currently don’t have the new User Interface and would like it, please contact Kilimanjaro Consulting MYOB Advanced Support

 1. Quick Menu

Can’t find a menu item which you think should be there?

Check the quick menu!

MYOB Advanced Tips n Tricks #2

To add/remove from the quick menu, go to settings in top right corner:

MYOB Advanced Tips n Tricks #2

Then tick boxes of the items you want in your quick menu, and Exit to view Quick Menu:

2. Favourites

As with prior versions, you can click on the stars to add menu items to your “Favourites” menu at the top.

So, if you have trouble finding a menu option, once you’ve found it click on the star and you’ll never have trouble finding it again.

MYOB Advanced Tips n Tricks #2

3. Pin to the Menu

If you use options under the “More Items” frequently, you may wish to pin these to the main menu. From then on it will stay in the first level of the menu on the left-hand side. Eg below pin the integration menu:

MYOB Advanced Tips n Tricks #2

4. Search

If you still can’t find something, search for it.

MYOB Advanced Tips n Tricks #2

5. Add new item to the menu

Click on Edit Menu

Select a menu item eg Finance and then select + Add Menu Item

MYOB Advanced Tips n Tricks #2

Find relevant menu items, tick, then select Add and Close.

MYOB Advanced Tips n Tricks #2

6. Minimise the menu

Click on < to minimise the menu and release even more real estate to work with.

MYOB Advanced Tips n Tricks #2MYOB Advanced Tips n Tricks #2

MYOB Advanced Tips and Tricks

For further guidance regarding your MYOB Advanced, check out our other useful Tips and Tricks!

MYOB Advanced Tips and Tricks #1 – Generating Statements on Demand

We hope these tips and tricks were helpful to you! Remember, if you have any questions about the new User Interface or in general our friendly MYOB Advanced team is always here to help. Call us on 1300 857 464 or send us an email.

 

Chugg Entertainment

One of the greatest benefits of our role as MYOB implementers and specialists is seeing how businesses grow, improve and succeed with the right ERP system in place. It was a pleasure implementing MYOB Advanced for Chugg Entertainment and gives us a sense of satisfaction knowing that their systems, accessibility and overall performance have improved.

MYOB Advanced for Chugg Entertainment

Who is Chugg Entertainment?

Chugg Entertainment is an Australian-based global company with a legacy of over 50 years in the music industry. Operating in the entertainment industry, they take pride in developing an artist’s career internationally through innovative promotions, tours and special events. Ever heard of Robbie Williams, Coldplay, Bob Dylan, Radiohead or Dolly Parton? Chugg Entertainment has worked with all of these internationally recognised artists and more around Australia, NZ and Asia.

What problems was Chugg experiencing?

Chugg Entertainment needed a system that was going to give them full control and oversight over their high-calibre events.  Kilimanjaro quickly recognised that the Chugg Entertainment team worked in a fast paced environment with some of the world’s biggest musical acts. This meant they needed to have complete control and absolute confidence in their systems. Dealing with so many individual events each year, Chugg found that they had outgrown their accounting system,  MYOB AccountRight. Their business needs were changing which required a more complex system. They needed a solution that would offer project accounting for their tours and simultaneously reduce manual data entry. After assessing the needs,  Kilimanjaro felt confident that MYOB Advanced would be a great solution to overcome the challenges.

Tailoring MYOB Advanced to  Chugg Entertainment’s needs

It was clear that Chugg needed a system that would be able to handle their current and future needs, giving them full visibility and instant access, even remotely. MYOB Advanced is designed for dynamic businesses, allowing users to update reports and monitor accounts 24/7.  Therefore, Chugg is now able to access data quickly and easily, saving time previously wasted on entering data multiple times. This means more time to concentrate on running their business. Chugg’s business requirements, like all others, is specific to its unique way of doing business. Hence, the biggest challenge was to provide real-time reporting to external parties. Because of this, Kilimanjaro created a customised solution allowing data to be fed to Excel. Kilimanjaro created automated Inter Company Journals, which reduced manual data entry.

The Kilimanjaro Team are proud to have worked with such a successful business and to have crafted a solution to meet the demands of their growth. We were able to work with Chugg to identify specific and complex requirements,  and to then design a practical solution. The implementation of MYOB Advanced for Chugg Entertainment has ultimately saved Chugg a huge amount of time and effort. They have confidence in both the financial and operational aspects of MYOB Advanced. Above all, the team at Chugg can now operate on a world-class level and deliver the best services to their world-class stars.

Overall, it is vitally important to have a trusted partner who can guide you on your implementation journey. Download the detailed case study to learn more or contact us to learn how your business can benefit from implementing a new ERP system. For more examples about how ERP can transform your business, visit our case study page here.

Making the Transition from MYOB AccountRight to MYOB Exo or MYOB Advanced

Editors Note: This article was originally published in May 2013. It has been reviewed and updated to provide the most relevant and accurate information. Please enjoy this article and feel free to share your feedback with us.

If we think back to the late 1990s, many businesses were moving receipts from shoeboxes and carbon invoice books to a foreign interface where they had to learn about debtors, creditors and general ledger. The natural progression for the larger, more complex businesses was their journey to use complete and fully integrated financial and business management software such as MYOB Exo.

The transition from small financial software to a more complex but better equipped ERP software is often a consideration for managers or business owners. This is usually when they feel the company has come to a stage where the processes become more complex and challenging to manage. The old software no longer supports the company to a satisfactory level, and there is more hassle than the actual benefit of using the current software.

Upgrading from MYOB Premier or AccountRight

One of the decisions to move from MYOB Premier or MYOB AccountRight to another MYOB suite of products like MYOB Exo or MYOB Advanced is the lack of specific functionality and controls in these less complex product suites.

Not only is lack of functionality a reason to upgrade to MYOB Exo or MYOB Advanced but MYOB is also introducing a change to the pricing model of MYOB AccountRight Live.

MYOB AccountRight Live has moved to a SaaS model and invoiced monthly. Account RightLive Premier version allows two entities per licence. To save on your license fees, consider using a site that is built to handle many entities in one, such as MYOB Advanced.

MYOB AccountRight Classic v19 (MYOB Premier) does not support Single Touch Payroll (STP), whereas MYOB Exo Payroll and MYOB Advanced People do.

If you are already using MYOB AccountRight Enterprise, there is even more imperative to switch.

Once businesses are ready to accept the changes, they learn to love some of the differences between the AccountRight suite and MYOB Exo or MYOB Advanced

Why you should consider MYOB Exo or MYOB Advanced

MYOB Exo is mature ERP software in the MYOB products family. It is a complete, integrated financial and business management system. MYOB Exo consists of various modules which support finance, job costing, fixed assets, point of sales, customers relationship management, consolidation and intercompany reporting. MYOB Exo is an Australian software made and designed for Australian businesses to help them succeed.  It can be both on-premise or hosted. Find out the difference between Hosted vs SaaS here.

MYOB Advanced is relatively new and is SaaS (Software as a Service). As such, it is cloud-based but still gives a business the ability to configure and customize. With broad functionality for larger Tier 3 and Tier 2 businesses, the real strength of this software lies in its General Ledger functionality.

Making the transition from MYOB AccountRight to MYOB Exo or MYOB Advanced allows you to stay with the same software provider but gives you the ability to access more functionality and features to support your growing business.

Let’s have a look at some of the differences you may consider useful for your company.

Auditability – Full audit trail

The inability to edit recorded financial transactions was a feature not favoured by many new users. Yes, it’s a feature, not a design flaw. MYOB Exo and MYOB Advanced provide a true audit trail for transactions impacting your profit and loss and balance sheets. Your auditors and accountants love this. Users may find this frustrating at first, but it is something you get used to, and the bonus is that you can be sure that the printed/emailed invoice that your customer holds is the same that your accounting system holds. There is some flexibility around this issue and should be discussed in detail with your MYOB consultant.

Period Based Accounting

You’ve probably never really noticed it, but running reports in MYOB AccountRight relies on date selection. With MYOB Exo or Advanced, you can run most reports by Periods. Some reports also allow for date selection in addition to periods. Periods are defined by date range, and you have the flexibility to create as many financial periods in a year as you require. You can post back to prior periods, regardless of the transaction date, thus ensuring that your revenue occurs in the same period as your expense if revenue matching is required.

Reporting in MYOB Exo and MYOB Advanced

The reporting suite in MYOB Exo and MYOB Advanced is far more extensive and customisable than in MYOB AccountRight.

MYOB Exo comes with around 400 standard reports. Most of which are customisable using the inbuilt report writer and many will need tweaking to your specific business requirements. The G/L reports come with a report writer, which is easy to use and doesn’t require in-depth knowledge of the underlying database. Dashboards and widgets are available and can be configured to show critical reports all in one place.  Sales Analysis Designer and SSRS  (SQL Server Reporting Services) Reports providing even more functionality.

The Sales Analysis Designer is a popular reporting tool, as it allows for slicing and dicing your data without requiring report writing skills.

MYOB Advanced has several reporting options from inbuilt report writers, GL report writers, screen enquiries, dashboards, and Pivot Tables!

OData feeds and PowerBI integration provide further reporting options.  MYOB Advanced also gives you full functionality from any device, anytime anywhere.

On-Screen, enquiries are becoming a standard way to report within ERP’s rather than having to run reports to screen. Kilimanjaro Consulting offers courses on report writing for both MYOB Exo and MYOB Advanced.

As an MYOB Exo user here are some features you won’t be able to live without:

MYOB Exo Grids – Copy to clipboard or ODBC Links

Most of the data on Exo screens can be copied and pasted into Excel. The possibilities from there are endless! If you are using MYOB AccountRight, then you are missing out on this feature. Also, you can link Microsoft Excel directly to the database. Click on “Refresh Data”, and your favourite report has the latest info.

Ability to have multiple Transactions Screens open at one time

MYOB Exo Users can have multiple invoices/sales orders/purchase orders open or in progress at the same time, allowing you to multitask more effectively. Users may have found it limiting in MYOB AccountRight to only have up to 8 windows at one time, and only be able to process one invoice at a time.

Sales Analysis Designer

A great sales reports in MYOB AccountRight was the Sales Analysis, which listed the 12-month sales for stock items. MYOB Exo’s Sales Analysis Designer has this with the ability to add groupings to this report, filter stock codes, branches, locations. As a result, for MYOB Exo users, the report possibilities are endless.

Multiple Stock Locations

The core software intuitively deals with multiple stock locations. Using the Blue Echidna add-on, Exo will even allow multiple bin locations and scan picking. Read more about Multi-Stock locations here.

Multi-Currency

One of MYOB Exo’s greatest strengths compared to AccountRight is the ease with which multicurrency is handled, in Accounts Payable, Accounts Receivable and General Ledger. Learn more here.

On Costs Calculation

MYOB Exo handles the calculation for the landed cost of your stock within the software. Therefore, you no longer need MS Excel spreadsheets to help you work out how much to add to your suppliers’ invoice.  Exo takes care of the calculation and all of the required G/L entries too! This includes the multi-currency calculations.

As an MYOB Advanced user here are some features you won’t be able to live without:

Intercompany Consolidation

MYOB Advanced uses the concept of an “entity”. You can have multiple branches, divisions, or even companies within a single database. No need for consolidating financials outside of the system.

Multi-Currency

Designed to support companies operating across multiple countries, MYOB Advanced easily manages bank accounts in multiple currencies and all other intricacies associated with different taxation regimes.

Mobility and remote access

Being a true cloud solution, MYOB Advanced can be accessed from anywhere, on any device. Learn more about being mobile with MYOB Advanced.

Workflows

The configurable workflow engine means you can automate repetitive procedures according to your business processes. This also allows for separation of duties along with the master and transactional approval workflows.

Security and Permissions

Access permissions can be narrowly defined per user or user group, right down to the field level in any screen. Row-level security allows one to control the visibility of certain data to certain users. Also, MYOB Advanced now has Two Factor Authentication as an added layer to ensure your data is secure in the cloud.

Taking the next step

When transitioning from MYOB AccountRight or MYOB Premier, it is important to expect a different system. MYOB Exo and MYOB Advanced are designed for more complex businesses. They require a skilled implementation partner to support you with all phases of the implementation: design, build, User Acceptance Testing and Go-live. The goal is to get it right the first time. Therefore, if there are features/processes that you will miss in MYOB Premier or AccountRight, speak to us about these. Don’t let it hinder your decision to progress to the next level of software. The transition from MYOB Premier or AccountRight to MYOB Exo or MYOB Advanced is a big step. Many businesses are now outgrowing the MYOB Small Business Suite of products, with the natural progression being MYOB Enterprise Solutions (Exo and Advanced).

Call us for a demo today on 1300 857 464 and let us advise you regarding a move to more functional financial software.

Free download

Download our free Capability Matrix to see the full functionality of MYOB Exo and MYOB Advanced. Discover what functions you could benefit from when you upgrade from MYOB Premier or MYOB AccountRight.

MYOB Advanced – the perfect fit for Museum of Australian Democracy

Kilimanjaro Consulting’s approach is to help our clients scale new heights in safe and trusted hands. We understand the importance of a successful software implementation in order to improve efficiency and achieve growth. Recently, Kilimanjaro concluded an effective implementation for the Museum of Australian Democracy (MoAD) – Old Parliament House,  who were facing challenges due to growth and limited reporting capabilities.

Museum of Australian Democracy – Old Parliament House

Museum of Australian Democracy

Old Parliament House is home to the Museum of Australian Democracy (MoAD). The nationally listed heritage building consists of social and political history displays and artefacts. The museum prides itself on workplace diversity for all its employees and visitors. The vision and role of Old Parliament House is to emphasise the importance of Parliament to Australians and to conserve the building for both entertainment and educational programs.

As the Museum is a constantly evolving organisation, effective financial control is very important. MYOB Advanced is the perfect fit, providing separation of responsibilities and duties, as well as a scalable platform for growth.

 

New Cloud-Based ERP Solution from MYOB

MYOB Advanced is a relatively new product in the Australian market.  It is a cloud-based ERP solution which is aimed at larger businesses that require a business management system which covers the entire business operation, from finance to administration and everything in between. MYOB Advanced is an easy to use, web-based product, making it accessible to users anywhere and anytime. It is the perfect software for businesses that want to reap the benefits working in the cloud.

Effective MYOB Advanced Implementation

Kilimanjaro Consulting understands that providing a structured, methodological approach is essential in deriving real benefit from a new system. This is what made the MoAD implementation so successful. When we first met with MoAD representatives, we identified a variety of management challenges due to a growing number of visitors, school tours and exhibitions. They were looking for something more intuitive and user-friendly which would allow them to manage business processes more easily. Implementing MYOB Advanced led to the removal of a significant number of manual processes. Manual data entry was eliminated in purchase orders, AP payments and AR requests. Paperwork coming into the Finance department decreased by up to 75%. In essence, MYOB Advanced has given the Museum of Australian Democracy a platform for future growth.

Measuring The Risk

Our experience with software implementation has confirmed our view that the three major risks in implementation are:

  • software risk
  • implementer risk
  • self-inflicted risk

In the case of Old Parliament House, the software risk was minimal because Kilimanjaro had determined at the outset that MYOB Advanced was an extremely good fit for their specific requirements. In the case of implementer risk, Kilimanjaro’s low risk methodology and structured approach to implementing large more complex sites once again proved its worth. In the case of self-inflicted risk, the team at Old Parliament House were a pleasure to deal with and had all the necessary skills to eliminate this area of risk.

Structured Kilimanjaro Methodology equals a smooth implementation

The team at Old Parliament House embraced our methodologies which made the implementation both smooth and successful. Whilst one may think that software is software, a far larger element of success is the implementer, the project champion, the client’s team and the change management. Kilimanjaro Consulting has incorporated all of these into its methodologies. This has driven them to become the number one MYOB Advanced implementer in Australia. When dealing with prominent or high-profile organizations, there is always a risk that a failed implementation can lead to negative publicity for the product. This case study illustrates the nexus between software, implementer and the clients team, all essential to ensure a successful outcome. It is a testament to the perfect mix of all three of these elements.

Your Trusted Advisor

The experience Kilimanjaro has gained in this successful implementation for Old Parliament House shows that we are well equipped to replicate this success in other government, semi-government and non-government organizations that require this a strong General Ledger, and integrated ERP system.

Remember that when choosing your software, you do have a choice of implementers and you would be wise to cast your democratic vote for someone that has done this before.To read the whole case study please visit our MoAD Case Study page. At Kilimanjaro Consulting, we can help you

  • select the right solution
  • guide you through the implementation process
  • provide on-going support

If you would like to learn more about MYOB Exo and Advanced or how to implement ERP software in your company contact us on 1300 857 464 or email us on [email protected]

JCurve Solutions has been appointed by MYOB to offer its Advanced solution

Sydney’s JCurve Solutions has partnered with MYOB to sell, implement and support the Australian accounting software vendor’s Advanced cloud ERP software for large businesses.

MYOB’s Advanced offers clients control over inventory, sales, distribution, CRM, finance and payroll.

JCurve chief executive Stephen Canning said Advanced would offer new opportunities for tailored customer solutions.

 

Read more