5 time saving reporting features for MYOB Advanced

5 time saving reporting features for MYOB Advanced

Your MYOB Advanced system collects data from across your organisation. This is what makes it so valuable for growing, complex organisations – it gives you the real-time data you need to make better decisions and drive your growth. However, making sense of all the data in your system can be difficult for your team members who are unfamiliar with MYOB Advanced. There is a way for MYOB Advanced users, allowing them to access their live ERP data within the familiarity of MS Excel® - Velixo.

Velixo image 1 - Smartphone screen

Simple formulas and functions to manipulate data

The beauty of working in Excel is that you are using the software you know and love. You can easily create totals and averages or use MS Excel® formulas to manipulate the values in any way you need. With MS Excel®, you can create dashboards, graphs, slices, and filters to enhance your reporting.

MS Excel® is great at reporting, analysis, planning, and modelling, and its simplicity of use means that most other financial report writers that come with ERP solutions don’t come close to it. MS Excel® is used by 750 million+ users worldwide, and its flexibility and ease of use are unparalleled.

Smart Refresh and Smart Drilldown

If you use MS Excel® for reporting purposes, then you need to manually export your data from MYOB Advanced and import it to MS Excel®. This needs to be done every time you build a new report which is a time-consuming and avoidable process.

With Velixo (An Excel-based reporting application) all you need to do is to create a financial or project report once. The Smart Refresh feature will load the data in your MS Excel® spreadsheet in seconds. Not only is this convenient and easy, but you and your team can work with confidence knowing that this information is accurate and up to date.

Another great feature is Smart Drilldown. This allows you to drill through the data that makes up your reports. You can see both the information that makes up each specific calculation, as well as the ability to view the original document in MYOB Advanced.

Velixo image 2 - MS Excel spreadsheet

Automated Report Distribution

Automation is what separates the wheat of efficient organisations from the chaff of smaller businesses. Taking advantage of automation in your financial software helps your team to take care of tedious tasks quickly and efficiently and lets them focus more on tasks that can grow the business. With Velixo you can automatically email, export, or share multiple versions of the same report with a single click. Report distribution is customisable so you can include different tabs or set specific parameters based on who is going to receive it.  Easily output your reports as MS Excel®, PDF, or simple values. Additionally, exported documents can be password protected, and configured by each recipient – so that they are only viewing information that is relevant to their position.

60+ Extra MS Excel® Functions

Velixo Reports adds over 60 new functions to your MS Excel® package. These functions are designed to work with your MYOB Advanced General Ledger (GL), Projects, and Generic Inquiries (GI). Microsoft 365 users have access to even more functions that take advantage of the new Dynamic Array capabilities built into MS Excel® 365. These additional functions can take the place of long formulas and complex arrays, allowing you to quickly create the reports you need without consulting a complex MS Excel® manual.

With these additional functions, you can create a GL Writeback report that takes the downloaded information and automatically creates detailed transactions for you, including all the account, subaccount, and branch details you need.

Make your life easier with sample reports

If you work in Project Management, Velixo has tools that will help with Project Reporting. A major benefit to Velixo is that you get access to sample reports, which you can easily manipulate if needed. This way you can build reports that look the way you like without requiring customisation to your ERP reporting suite.

Click here to download a Project Reports Sample Pack.

Velixo image 3 - MS Excel spreadsheet

Watch the full demo here:

More information

To start a conversation about how Velixo could improve efficiency in your business, contact us by email or call 0800 436 774. To learn more about Velixo and how it works with MYOB Advanced and MS Excel® to strengthen your reporting functionality, watch the webinar recording below.


Source note: This article was originally published on Enprise's sister company Kilimanjaro Consulting's website. It is republished here with permission. You can read the original article here. 

5 good reasons to choose Enprise

Reason 1: Gold standard service and support. 

Reason 2: Cloud options for every piece of software we sell.

Reason 3: The largest MYOB Advanced and MYOB Exo partner in Australasia, with dedicated sales, implementation & support teams.

Reason 4: A wide range of proven companion products from trusted partners. 

Reason 5: With Enprise, you get MYOB Exo from the people that invented it. 

More Information

For more information, contact us.
One of our consultants can call or visit you to discuss your needs.

MYOB Advanced Platinum Partner & MYOB Exo Platinum Partner logos - Enprise

Enprise MYOB Awards strip 2016-2021, 1200

Contact or Subscribe

Complete the form below and one of our consultants will contact you to discuss your needs.
You can also subscribe to our email newsletter to stay up-to-date on industry news.

The 'First name' field is required
The 'Last name' field is required
Please enter a valid Email address
by: