Import Supportability invoices into Reckon Accounts

If you are using Supportability and you need to import invoices into Reckon Accounts (QuickBooks) then using the Zed Axis software and the steps described in this article you can achieve that. This article has been developed in partnership with the team at Supportability.
 
First you need to export the invoices in batch from Supportability.
  1. Login into Supportabiliy.com.au
  2. Go to the Reports Menu and select Invoice Batch List and select the Invoice batch that you want to import into QuickBooks and click on the Actions button and select the option Download Invoice Batch for Zed Axis.
  3. Save the downloaded file as an Excel spreadsheet (XLS (97-2003 format), it is also possible to save as a csv
Supportability download
 
 
Next you need to import the invoice in batch into Reckon Accounts using Zed Axis:
 
  1. Open and login to your Reckon Accounts company file
  2. Open Zed Axis and in the connections tab select QuickBooks Desktop and click Connect, Axis will now connect to your Reckon Accounts Company.
  3. Click on the Import tab and browse to the file that contains the invoices that you downloaded from Supportability
  4. Next select the option to Add a New Mapping, and map the QuickBooks fields to the corresponding fields in the file you are importing, below we have provided a basic map that you can follow
  5. Save the map for subsequent imports
  6. Click the Import button and your invoices will be added to Reckon Accounts
 
Axis Import
 
QuickBooks Field
Supportability Column
CustomerRefFullName
ContactName
TxnDate
Date
InvoiceRefNumber
Invoice #
BillAddr1
Addr 1 – Line 1
BillAddr1
Line 2
BillAddr1
Line 3
BillAddr1
Line 4
ItemRefFullName
Service
Description
Description
Rate
Rate
Quantity
Quantity
ServiceDate
DateOfService
SalesTaxCodeRefFullName
GST Code

Add Feedback