Data Presentation Products
 
Microsoft Excel Tools  
 
Microsoft Excel Add-ins  

   

 
  HOME > PRODUCTS > EZ-Quick
 

 
EZ-Quick for QuickBooks Reports
Reformats Reports exported to Microsoft® Excel®

Quickly reformat QuickBooks Reports exported to Excel for
Better Printing and Better Viewing in Microsoft Excel.


Reformatted QuickBooks Reports print in up to 80% Fewer Pages.

Includes features to make working with Excel Worksheets easier.




EZ-Quick Ribbon in Excel 2007 / Excel 2010
The identical functions are on the EZ-Quick Toolbar in earlier Excel versions.

EZ-Quick Ribbon in Excel 2007 / Excel 2010

New!  Includes 32 bit and 64 bit versions for Excel 2010.




EZ-Quick 'QuickBooks Reports' Overview Video  07/17/2008 02:05 Flash Video on EZ-Quick's Fast and
Easy Reformatting of QuickBooks Reports Exported to Excel

EZ-Quick for Excel works with QuickBooks Reports exported to Excel.
Requires "No" design changes to QuickBooks Reports.

Merge all Description columns to one column in QuickBooks Reports.
Hide / Unhide Empty Columns in QuickBooks Reports and in all Excel Worksheets.


One Description column and no Spacing columns prints more Amount columns per page.

Reformat QuickBooks Reports to Print One-Page Wide in Excel.
Reduce printed pages for QuickBooks Reports by up to 80%.

Print five or more Amount columns at 100% in Portrait Orientation.

Automatically update the Page Setup for better printing of QuickBooks Reports.
Increase the Top Margin to prevent Headings from overlapping into the Body.
Switch Print Orientation from Portrait to Landscape for wide Reports.
Print Description Columns on the left of each page.
Print left-to-right then top-to-bottom to keep related data on contiguous pages.
Horizontally "Center" reports on the page.


Features for working with any Excel Worksheet

Unhide Total Rows in "Outline Groups and Subtotals" when Excel Data Filters are set.
Works with filtered "Subtotaled" data and filtered "Group Outlined" data.
Converts "SUM" formulas to "Subtotal" formulas so totals automatically adjust.


Unhiding Total Rows in "filtered" data is impossible using standard Excel features.

Export only the visible rows in any Excel Worksheet.
Exported formulas producing Excel #REF errors are automatically converted to value.
Optionally convert all formulas to values when exporting visible worksheet data.
Optionally delete all hidden columns when exporting data to a new worksheet.


Exporting only visible worksheet data & correcting #REF errors is impossible using standard Excel features.

Reset Excel's Vertical and Horizontal Scrollbars in any Excel Worksheet.
Easily correct Excel's Scrollbars to reflect the actual Worksheet Data.

Manually resetting Excel scrollbars is a poorly documented precise process; not just a single mouse click.


Download 15-Day Trial    Purchase for $39.95

Latest update 01/15/2012

Installs and Completely Uninstalls in Seconds.  Securely Purchase from inside Excel.
Use with Excel 2000, XP, 2003, 2007 & 2010 on Windows® 2000, XP, Vista® & Windows 7®.
We recommend running Windows Update for Windows and Office® before installing EZ-Quick.



Income Section from a QuickBooks Report
This is a typical Intuit QuickBooks Excel Financial Statement

The blank column Q on the right is incorrectly included in the QuickBooks defined print area.

Income Section of Typical Intuit QuickBooks Financial Statement
Top


QuickBooks Report Reformatted by EZ-Quick
Financial Statement Account Descriptions are Merged into Column A
Empty Account Description Columns are Automatically Deleted

Income Section of Typical Intuit QuickBooks Financial Statement after EZ-Quick Reformatting of Account Descriptions
Top


QuickBooks Reports are not Excel Printer-Ready!
Excel Print Preview of a QuickBooks Report.
This QuickBooks Financial Statement is 6 pages long.

The seven columns of descriptions keep the five amount columns from printing together.
By default QuickBooks Reports are set to print top to bottom and then left to right.


Print Preview of Page 1 of 6 pages of a typical Intuit QuickBooks Financial Statement
Top


EZ-Quick QuickBooks Excel Reports are Better Formatted
Print Preview of Better Formatted Financial Statement
EZ-Quick Reformatted QuickBooks Financial Statement is 3 pages long.

The five amount columns print together when descriptions are merged into 1 column.
EZ-Quick reformats reports to print left to right and then top to bottom.


Print Preview of a typical Intuit QuickBooks Financial Statement after EZ-Quick Merging of Account Descriptions into a single column
Top


65 Page QuickBooks "Profit & Loss Detail" Report

Print Preview of a typical Intuit QuickBooks Financial Statement after EZ-Quick Merging of Account Descriptions into a single column
Top


15 Page Reformatted "Profit & Loss Detail" Report

Print Preview of a typical Intuit QuickBooks Financial Statement after EZ-Quick Merging of Account Descriptions into a single column
Top