Import commonsku invoices into QuickBooks

If you are using commonsku and you need to import invoices into QuickBooks (for Windows) then using Zed Axis and the steps described in this article you can achieve that.  This article has been developed in partnership with the team at commonsku.

<< Insert YouTube demo here >>

  1. Firstly you need to export the invoices from commonsku that you wish to import into QuickBooks
  2. Login to your commonsku account on the web and export the invoices that you wish to import into QuickBooks.
  3. A file csv file named ?????????.csv will automatically download to your local PC, save a copy locally.
<< Insert commonsku screen shot here >>

  1. Open your QuickBooks company file and Zed Axis and click connect.
  2. Open the file ?????????.csv using Microsoft Excel and save it.
  3. Back in Axis, in the import tab browse to where you saved the commonsku invoice file, once open you will see a preview of the invoices that will be imported into QuickBooks.
  4. Select the field mapping, if this is the first time you can use one of these mapping templates, download the mapping file and import it into Axis
    1. Commonsku invoice map.xml
    2. Commonsku bill map.xml
  5. Now click the Import button and your transactions will be directly added to QuickBooks.