Exporting to QuickBooks

Summary

In order to export to QuickBooks, you will first need to make sure you have purchased the OrderMate accounting integration, your accounts have been configured and you have installed and configured Zed Axis. 

OrderMate supports exporting of: 

• Sales & Takings
• Stock Control Invoices (Expense / Bill Invoices)

These export files can then be imported to QuickBooks. 

Exporting from OfficeMate 

Log in to OfficeMate as a user that has sufficient permission to perform an export.

 

On the left, navigate to Daily Tasks -> Accounting Export. 

 

Choose the desired export type Sales & Takings or Invoices. 

 

Select the desired date range to export. 

 

Note:

• The export range is NOT inclusive of the "to" date. (Eg: in order to export data from the 01/08/2014, you should set the date range to be from 01/08/2014 to 02/08/2014).
• When exporting invoices the export range picks up invoices based on the invoice date, NOT the date the invoice was entered. 

Select the file name and location where you would like to save the export file. 

 

On the toolbar at the top, click "Export". 

 

Importing to QuickBooks 

Open QuickBooks and log in to your company file.

 

Open Zed Axis, select how you would like to connect to QuickBooks (Desktop or Online) and click "Connect" to connect to QuickBooks. (The first time you do this, you may need to  accept a security warning in QuickBooks and say that you trust Zed Axis.) 

 

Click the "Import" tab. 

Browse for the desired file that you want to import. 

 

Select the appropriate mapping from the drop-down (e.g.: OrderMate Sales & Takings or OrderMate Invoices). 

 

Click "Import". This will import the selected file into QuickBooks. 

 

A summary screen will appear showing the status of each shift imported. 

 f you encounter any errors, you can consult the Zed Axis knowledge base. The most common error encountered (shown above in the screenshot) can be handled quite easily using this OrderMate knowledge base solution.