What is QXL Desktop?
QXL Desktop is an easy to use system that creates Excel spreadsheets from QuickBooks current data tables. Needs no training – one button exports all data. It uses the customer’s familiarity with Excel spreadsheets to allow them to build custom reports and organize data to their preference with no experience in anything but Excel – once they build a calculation macro based on one of these sheets, they never have to build it again, just refresh the data.
What can I do with QXL Desktop – QuickBooks Export Made Easy?
- Export QuickBooks Data to Excel format via QODBC.
- Export QuickBooks Data to CSV format via QODBC.
- Choose export file(s) location
- Export to Separate files or single file.
- Export all tables, selected tabled or excluded tables.
- Custom Query Export.
Initial SetupDownload and click on the Install program (QXLSetup.exe) to install the QXL Desktop Application. Select Next on all of the options unless you want to change the default settings.
QXL Desktop has been successfully installed onto your computer. You can begin using it immediately; it will run as a free 30-day evaluation edition, during which you can export a maximum of 100 records per table, per session.
To run just click the icon placed on your desktop:
In addition, new Icons have been added to your Start>All Programs Menu under QXL – QuickBooks Export Made Easy
First use of QXL DesktopFirst, make sure the QuickBooks program is running on this machine with the company file open and logged in as Administrator, otherwise the status will not show as green. QXL Desktop only gets QuickBooks data from the QuickBooks program, so it must be running to function.
Switch back to QXL Desktop and click the Export start button:
QXL Desktop will then export the data in your current company file to an Excel file in the output folder.
Once the export completes, the folder of Excel documents with data from QuickBooks will be shown – that’s it! You are ready to embed your QuickBooks data in any spreadsheet you need.
It’s a good idea to use these spreadsheets as source data from this destination folder directly so that next time you need an update it will copy over the source data files in the same place. The best way to make use of this data is in an embedded query – use the Excel documents as source material for your own personal spreadsheets – do not modify these documents directly – otherwise, your changes will be lost on the next update/sync.
Creating a Spreadsheet from QXL Data Source Sample:
You can find QXL Desktop sample reports installed in “QXL Sample Reports” folder under “This PC” –> “Documents” –> ”QXL” folder.
1. QXL-Sample-Report-Customer which contains customers outstanding balance details.
2. QXL-Sample-Report-Invoice-Aging which contains Unpaid Invoice aging details.
When you run them they will query data from the QuickBooks data you have just exported automatically by using a small “macro” program in the spreadsheet. If the message comes up to “activate macros”, please activate the macros in this spreadsheet so it can then find and create a report based on your company data instantly!
Let’s see the details on these samples.
QXL-Sample-Report-Customer report will show Customer contact details & balance details for the Customer whose balance is more than $1.
QXL-Sample-Report-Invoice-Aging report will show Customer details, Invoice details & Invoice aging period details which are pending for more than 30 days.
How to use the report:
After running QXL Desktop, you can open these reports to show data from the recently exported data in your QuickBooks system to show how easy it is to report on Excel data exported by QXL Desktop.
You can make use of the two sample reports, change the data source or report to suit your requirement.
To change report data source, Click on “Change Data Source” button.
Choose QXL Export folder which you want to use & click on Apply & Close button.
Data in the sample spreadsheet will be refreshed using provided QXL Export folder data. Refer: How To Change QXL Sample Report Data Source for more details.
When you open this file you may receive the security warning about active content is disabled. You need to click on “Enable Content” button to start the QXL Spreadsheet wizard.
How to create Excel report using QXL’s Excel sheet
How to change QXL sample report data source
How to change the filters and formatting
OptionsClick here for detail information about QXL Desktop options and settings.
QXL Frequently Asked QuestionsThe Frequently asked questions about this product are constantly changing, so we have a web page setup with these questions and answers. A more detailed FAQ can be found at: http://support.qxl1.com.
Tutorials and DocumentationAn additional host of information can be found on our web site, https://www.qxl1.com.
Product SupportWhen you first install QXL, it operates 30-days for free as a fully functional trial copy limited to exporting 100 records per table per session.
A FAQ section and a Help Desk support system is available for registered users and those evaluating QXL Desktop.
Those purchasing the product will receive free installation support for 30 days from the date of purchase. Program anomalies will be addressed at no charge and updaters posted on our web site. Other issues requiring hands-on support may be subject to a fee.
Support can be obtained by the following methods:
Online Support: http://support.qxl1.com
Mail: FLEXquarters USA Sales P.O. Box 1466 Clarkston, MI 48347 USA
The most effective of these methods is the online support system via our website, since you can attach an ODBC or SDK trace log to the message and we can attach an updated product to you if we have a patch.
Product UpdatesThe latest updated versions will always be available on-line at our web page: https://qxl1.com/qxl-for-quickbooks-desktop-downloads/
QXL CreditsQXL Desktop version 19.x
For Microsoft Windows, Windows XP, Vista, Windows 7, Windows 8 and Windows 10.
© Copyright 2018, FLEXquarters.com Limited, All Rights Reserved Worldwide
Portions of this product © Copyright Intuit Incorporated.
QODBC and QXL are trademarks of FLEXquarters.com Limited.
QuickBooks Pro, QuickBooks Premier, QuickBooks Enterprise Solutions and QuickBooks Online Edition are registered trademarks of Intuit Incorporated.
Windows, Vista, Windows 7 and Windows 8 are registered trademarks of Microsoft Corporation.
All other trademarks are copyrights of their respective holders.
Version v16.0 First released June 2016
Version v17.0 First released August 2017
Version v18.0 First released December 2017
Version v19.0 First released August 2018
Program published and supported by:FLEXquarters.com Limited
41-43 Carnarvon Road Suite 809
Tsim Sha Tsui Kowloon Hong Kong
USA Mailing Address:
2620 S Maryland Pkwy Ste 14 # 557
Las Vegas, NV 89109-1692
USA Sales Office:
FLEXquarters USA Sales
P.O. Box 1466
Clarkston, MI 48347 USA
Licensing Support: 248-620-2406 (Registered user activation/deactivation issues only)
Other Regional Sales Numbers:
United Kingdom: +44 (0)845 638 3730 email@example.com
Australia/New Zealand/Southeast Asia: +61 3 9761 3644 firstname.lastname@example.org
International: +1 246-620-2400 email@example.com
Program developed by Brad Waddell and Rajendra Dewani.
Documentation produced by Mark Kuznar, Brad Waddell, Rajendra Dewani and Juan Jiménez.