ExcelReportLink Logo

ExcelReportLink
GL Pivot Reports

Analyse your general ledger data quickly in Excel Pivot tables and get standard reports for free

Accounting Packages come pre-loaded with many useful reports. However, there are always some fields or layouts that users would like included on their reports that are not available.

ExcelReportLink GL Pivot Reports is a free add-on to MYOB, QuickBooks and Xero which solves this problem. It does so by transforming your accounting data into data sources which can then be manipulated using Excel’s Pivot Table functionality.

Out of the box, ExcelReportLink GL Pivot Reports comes loaded with the following general ledger based reports:

  • Profit and Loss Reports;
  • Balance Sheet Reports;
  • Transaction Reports;
  • Job and Category Reports;
  • Multi-company Reports;
  • Custom Reports.

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

  • Companies, Accounts and Versions (actual and budget);
  • Job and Categories;
  • Dates, Months and Financial years;
  • Drilldown to detail;
  • Other dimensions (customers, suppliers, items) with some level of customisation.
Features / Edition Matrix
Free
Standard
$44/month
Pro
$77/month
Profit and Loss Reports
Balance Sheet Reports
Transaction Reports
Job Reports
Category Reports
Multi-Company Reports
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
Accounts
Account Headers
Jobs
Job Headers
Data Versions
Accrual Basis Reporting
Advanced Accrual Reporting (e.g line memos)
Cash Basis Reporting
Cash Cr Dr Reporting
Budgeting
Report on MYOB Budget
Report on MYOB Job Budget
Report on BudgetLink Budget
Advanced Report Functionality
Advanced Fields (Custom Fields, Line Memo’s etc)
Customisable Data Sources
Multiple Data Warehouses
Save Report Templates
Additional Features
Multiple Users
Multiple Data File Consolidations 1 5 Unlimited
Scheduled & Auto Get Data
Data Archiving
Advance Data File Management
Transfer Installation to Another Machine
Upgrades
Share on File Server
Share using Dropbox
Share on Terminal Server
Workspaces 1 1 Unlimited
Support Options
Email and Chat Support
Personal Support $220/hour $220/hour
Custom Development POA POA
Online Help
Limit of one free edition key issued per organsation.

Works with…

System Requirements

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

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

* Note, the 32-bit version of Microsoft Excel and Access is required when connecting to the older version of MYOB (19.10 or older).

How to get started

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

Not ready to download ExcelReportLink GL 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 GL 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.