Export transactions or lists from QuickBooks

You can export transactions or list from QuickBooks desktop using Zed Axis - Exporter module, this data can then be saved to Excel or text files.
Follow these steps
Transaction list
Export filters
  1. Open Zed Axis and connect to your QuickBooks desktop company file, then click on the export tab
  2. Select the transaction type or list type that you would like to export. You can export a wide range of transactions, list and reports the full list of supported items are listed in this article.
  3. If you only want to export a certain range of transaction or list items you have the option to filter by date ranges, reference numbers, accounts or names and paid or unpaid, depending on the data type you are exporting the filters will apply.
  4. Once you have set the data type and the filters click the Get button and Axis will retrieve the data from QuickBooks
  5. The results are then display in the preview grid.
  6. Finally you can save the exported data, to the following file formats Excel 2007, Excel or Text, you also have the option to delete the exported transactions or lists.
Export preview



Thanks for the great tool. One thing I noticed that's the QB allowed length for RefNum contains 11 characters, however, Zed export module filter box for Ref Number is only allowing to input 10 characters. It can completely stop me from doing what I have to do when I do have 11-character long reference numbers. Is there a new version that can fix that?


BPFinance (3/2/2017 at 4:20 PM)
I keep getting "Unable to get data" I'm connected to QB but I cannot export any data. It worked a couple of times and now has quit.
Bob Marshaus (6/3/2018 at 12:11 PM)