Create any report in Excel to analyse your sales data quickly and get Standard Reports for Free

MYOB includes many useful reports, however some find it limited when customising them and can’t include the required fields or achive the desired layout

ExcelReportLink Sales Pivot Reports is an MYOB add-on which removes this limitation. It does so by joining all sales data fields into a single data source and then uses Excels Pivot Table functionality to shape the data into desired layouts by dragging fields into rows and columns

Out of the box, ExcelReportLink Sales Pivot Reports comes loaded with:

• Customer Sales Reports;
• Employee (Sales Reps) Sales Reports;
• Item Sales Reports;
• Multi-company Reports;
• Aged Receivables. Reports

ExcelReportLink Sales Pivot Reports can produce reports with the following dimensions:

• Customers, with Custom Lists, Custom Fields ;
• Default Supplier and Salesperson (Employee) cards;
• Companies (Data File Consolidations across different accounting software);
• Jobs and Categories;
• Account Classifications (Income, Cost of Sales, Gross Profit, Expenses, Operating Profit, Other Income, Other Expenses & Net Profit);
• Accounts;
• Items with Custom Fields and Custom Lists;
• Dates, Months and Financial years;
• Tax Inc, Tax Exc and Tax Codes;
• Drilldown to Transaction number, type, Memo and Line Memo and other detail fields;
• Other detail dimensions like Status, Promised Date and Last Payment Date.

Features / Edition Matrix	Free	Standard $44/month	Pro $77/month
Customer Sales Reports
Salesperson Sales Reports
Item Sales Reports
Job Sales Reports
Account Sales Reports
Aged Receivable Reports
Custom Reports
Transaction Sales Reports
Compatible Accounting Software
MYOB AccountRight Live (Online)
MYOB AccountRight Live (Local)
MYOB AccountRight Live (Server)
Xero
MYOB AccountRight (Classic) v19 or below
Consolidate Accounting Software
Years
Report before Last Year and after Next Year
Advanced Report Functionality
Advanced Fields
Save Custom Report Templates
Customisable Data Sources
Custom Data Warehouses
Additional Features
Multiple Data File Consolidations	1	5	Unlimited
Consolidate Accounting Systems
Multiple Users
Scheduled & Auto Get Data
Sales Budgets by Items and by Customers			$POA
Data Archiving
Sales Orders Data
Licensing
Upgrades
License Transfer
Share on File Server
Share using Dropbox
Share on Terminal Server
Workspaces	1	1	Unlimited
Support Options
Online Help
Email and Chat Support
Personal Support		$220/hour	$220/hour
Custom Development		POA	POA

Works with…

• MYOB AccountRight (Live)
• MYOB AccountRight (Classic)
• Xero

System Requirements

Microsoft Excel 2010 to 2016 (32-bit or 64-bit) *

Microsoft Access 2003 to 2016 (optional) (32-bit or 64-bit) *

How to get started

Download your copy of ExcelReportLink Sales Pivot Reports using the following buttons.

Not ready to download ExcelReportLink Sales Pivot Reports just yet, contact us and ask us any questions you may have.

Need Help with ExcelReportLink?

See ExcelReportLink’s wiki online.

For more on consulting, support and customisation, see Consulting and Support.Note that training, support and consulting is billable.

Want to stay up to date with ExcelReportLink Sales Pivot Reports?

Check out our blog for the latest news and updates.

Read more about upgrading to the latest version.

Contact us for assistance, more information or a conversation about your individual requirements.