What is QXL Online?QXL Online is an easy-to-use application which creates Excel spreadsheets from the data in your QuickBooks Online company file. It requires no training – one button exports all of your data. It enables 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 one click to refresh the data from QuickBooks Online and your reports have the latest numbers instantly.
What can I do with QXL Online?
- Export QuickBooks Online Data to Excel format via QODBC.
- Export QuickBooks Online 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 (QXLOnlineSetup.exe) to install the QXL Application. Select Next on all of the options unless you want to change the default settings.
For detail setup instructions click here
QXL Online 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 Online Export Made Easy
First use of QXL OnlineFirst, make sure you have access to QuickBooks Online company file with Administrator privileges, to authorize QXL Online to connect to your QuickBooks Online Company file. In case you are using QuickBooks Online Accountant (a ProAdvisor) that you need to be logged in to “Your Books” (the option in the left menu bar for accountants) or the client’s books. To authorize QXL Online to connect to your QuickBooks Online Company file just click the Red/Green toggle button.
QXL Online connection wizard should appear. Enter a Connection name to identify which account this represents and then click Connect to QuickBooks
Switch back to QXL Online and click the Export start button:
QXL 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 sample reports installed in “QXL Sample Reports” folder under “This PC” –> “Documents” –> ”QXL” folder.
There are two sample reports installed with QXL:
1. QXL-Online-Sample-Report-Customer which contains customers outstanding balance details.
2. QXL-Online-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-Online-Sample-Report-Customer report will show Customer contact details & balance details for the Customer whose balance is more than $1.
QXL-Online-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 Online, 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 Online.
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.
TutorialsHow 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 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, http://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.
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: http://www.qxl1.com/downloads.htm
QXL CreditsQODBC version 18.x
For Microsoft Win7/Win8/Win10.
© 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 October 2016
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 0036
Union Lake, MI 48387-0036
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.