Using Excel to create reports from EXO Payroll
Any Software system is only as good as the reporting that you can get out of it and your Payroll system is no exception. Your software should provide you the reports to check:
- That your pay is accurate each pay period
- That your pay variances are minimal so that you can budget ahead
- How your wages are made up and what cost centres are resulting in increased costs
- That your system is setup correctly and using accurate pay rates
Your system should also provide you with the flexibility to manipulate your data and get additional information as needed.
Exo Payroll holds 73 standard reports in the system for Employee data, Pay and Financial Information, Maintenance detail and IRD reporting. These standard reports offer the functionality to export to your printer, CSV & PDF, and also directly to Excel.
Excel reporting is a largely underutilized feature in the system. It allows users to export the report data to an Excel spreadsheet to manipulate and display the information exactly how you need.
Once you have the report in Excel you can add filters, create pivot tables, create charts & graphs and much more.
Excel training webinars
We are offering Excel training webinars (Beginner or Intermediate webinars) where you can learn how to make the most of Exo Payroll reporting.
The 1 hour Exo Excel beginner session will cover:
- Saving data to an Excel format
- Filter and sort options
- Separating text into separate columns
- Creating graphs
- Adding a formula
The 1 hour Exo Excel intermediate session will cover:
- V Lookup
- Subtotalling of data
- Using conditional formatting to see trends and patterns within the reported data
- Creating Pivot tables, charts and graphs
Alternatively, you can attend a 3 hour workshop session that will take you through all of the information covered in the webinars from the basics through to the more complex reporting options.
Or to express your interest or find out more email us at exoservices@myob.com.
Need more help? You can open the online help by pressing F1 on your keyboard while in your software.
You can also find more help resources on the MYOB Exo Employer Services Education Centre for Australia or New Zealand.