|
|
ExcelReportLink
|
Create any report in Excel to quickly analyse your purchases data
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 Purchases Pivot Reports is an MYOB add-on which removes this limitation. It does so by joining all purchases 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 Purchases Pivot Reports comes loaded with:
- Supplier Purchases Reports;
- Item Purchases Reports;
- Job Purchases Reports;
- Multi-company Reports;
- Purchases Journal Reports;
- Aged Payables Reports;
- Custom Reports.
ExcelReportLink Purchases Pivot Solution can produce reports with the following dimensions:
- Suppliers, with Custom Lists, Custom Fields ;
- 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 Ex 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.
Maintenance & Licensing
| Features / Edition Matrix |
Standard
$66/month
|
Pro
$99/month
|
|
|---|---|---|---|
| Supplier Purchases Reports |  |
|
|
| Item Purchases Reports | |
|
|
| Job Purchases Reports | |
|
|
| Account Purchases Reports | |
|
|
| Aged Payables | |
|
|
| Custom 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 | |
|
|
| Custom Report Templates | |
|
|
| Customisable Data Sources | |
||
| Orders Data | |
|
|
| Custom Data Warehouses | POA | ||
| Additional Features | |||
| Multiple Data File Consolidations | 5 | Unlimited | |
| Scheduled & Auto Get Data | |
|
|
| Data Archiving | |
|
|
| Upgrades | |
|
|
| License Transfer | |
|
|
| Multi Users Access | |||
| Share on File Server | |
|
|
| Share using Dropbox | |
|
|
| Share on Terminal Server | |
||
| Workspaces | 1 | Unlimited | |
| Support Options | |||
| Online Help | |
|
|
| Personal Support | $264/hour | $264/hour | |
| Email and Chat Support | |
|
|
| Custom Development | POA | POA |
Works with…
- MYOB AccountRight Live – desktop, server or cloud
- MYOB AccountRight v19.10 or prior (Enterprise, Premier, Accounting Plus or Accounting)
- 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 Purchases Pivot Reports using the following buttons.
Not ready to download ExcelReportLink Purchases 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 Purchases 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.