QuickBooks Desktop with ZedAxis

This article covers the manual route: exporting data from Kompass and importing it into QuickBooks Desktop. If your company file is connected to Kompass through the direct QuickBooks Desktop integration, Kompass syncs organizations, projects, invoices, timesheets, and payments for you instead. Otherwise, export the data from Kompass and import it into QuickBooks with one of the methods below.

There are four methods for importing data. This YouTube video describes these options: https://www.youtube.com/watch?v=l8cdMJ_rXxQ.

  • Excel files are only available for a few datasets
  • Batch Entry is only available for a few datasets. The process is also quite manual (copying and pasting into QBE)
  • IIF files are available for all sorts of datasets. However, there are many factors to take into account. More on IIF: https://www.youtube.com/watch?v=igWt1Y_EZs0
  • Third-party solution: the most straightforward option. It involves exporting CSV files from Kompass and letting the third-party solution do the rest, so you do not have to run a spreadsheet, copy and paste the values into a CSV, and rename it to .iif. These solutions come with a cost. One option we have worked with is https://www.zed-systems.com/axis-buy.html. More solutions are listed here: https://desktop.apps.com/home. We will set up the mapping for you.

Working with ZedAxis

Make sure QuickBooks Desktop is open. Open ZedAxis, select "QuickBooks Desktop" (1) and click "Connect" (2).

Once connected, click the "Import" tab (1). Kompass will create a file that exports the Kompass data in a QuickBooks-friendly format for you to import. Click "Browse" and find the file (2). If the file has more than one sheet, select the one you want to import from the "Excel Options" dropdown under the "Browse" button.

The first time you use ZedAxis, you will have to create a mapping. Click "Select Mapping" (3) and "Add New Mapping". A new window appears. Make sure you select the correct "Transaction Type" (4). For example, "Invoice" if you are importing invoices, "Customers" if you are importing projects, "Estimates" if you are importing the price of each proposal item, and so on.

Depending on the transaction type you pick, you then have to map the available columns in the file and sheet you selected in step 2. The "QuickBooks" column lists all available fields you can use, while the "Import data column" lists all available columns in the selected sheet. A data preview appears in the last column. (5)

When ready, click "Save". You only have to set the mapping once; after that, select it from the dropdown in step 3. When ready, select the mapping (3) and click "Import". (6)

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us