You can import clients, suppliers, and products into Zigaflow and push your sales invoices and supplier invoices into QuickBooks.
Updating & Adding Customers, Items, and Suppliers in QuickBooks
Importing Tax and Nominal Codes
Exporting Sales Invoices to QuickBooks
Jumping to an Invoice in QuickBooks Directly from Zigaflow
Updating & Adding Customers, Items, and Suppliers in QuickBooks
When an invoice or purchase order is pushed from Zigaflow the following happens:
If the customer does not exist in QuickBooks it is added. The system will check using QuickBooks unique internal id for the company, not the company name.
- Zigaflow will search for the item/product by:
- ZF Item code -> QuickBooks Name. If there is no match it will search by:
- ZF Item Description -> QuickBooks Name
- If there is no match it will add the item into QuickBooks
- If the supplier does not exist in QuickBooks it is added. The system will check using the supplier's name.
Connecting to QuickBooks
- Go to the Cog at the top right
- Select 'Integration Settings'
- Click on 'Connect' on the QuickBooks line:
On the next page, enter your QuickBooks login details:
Click on Connect on the next page:
You are now connected. You can disconnect by clicking on the Revoke button:
Once you have connected you won't need to connect again.
Importing Tax and Nominal Codes
In order for Zigaflow to match up with QuickBooks, you need to import these. Once you have connected to QuickBooks:
- Click on Configure
- Select Accounting
- Select 'Tax Codes' on the left
- 'Import from QuickBooks'
- Select the codes you need
- Follow the same process for the account codes
Exporting Supplier Invoices
Assuming that you are connected to QuickBooks you can export supplier invoices in the system to QuickBooks.
To do this:
- Select Go To > Purchase Orders
- At the top, click on the 'Supplier Invoices' button
- Click on 'Export'
- Click on 'QuickBooks Export'. If you do not see this, you are not connected to QuickBooks through Zigaflow
- On this screen, you can review the invoices before exporting
- When they have been exported, the date they have been exported is marked so they will not be exported again
- Select the date range for the supplier invoices on the left
- Click on 'QuickBooks Export' to push them to QuickBooks
Notes:
Supplier invoices will only be exported if their statuses are:
- Approved
- Paid
- Received
Exporting Sales Invoices to QuickBooks
If an item does not have a nominal code Zigaflow will use 'Sales'.
There are two ways to export sales invoices to QuickBooks:
From an Invoice
The invoice cannot be in draft or canceled status. You may have to click on the '+Show More Settings' link which will show this button:
If you can't see it, make sure you are connected in the Integration Settings page.
Clicking on this will export the invoice to QuickBooks and put in the Exported date as today. The system will not re-export an invoice with the exported date set. You can reset the date to allow this to be exported again.
From the Invoice List Screen
This will open a screen to export all the invoices that have not been exported, do not have the status of draft or canceled, and are within your specified date range.
Exporting Supplier Invoices
- Go to Purchase Orders
- Select 'Supplier Invoices'
- Click on the button at the top right 'Export' -> 'QuickBooks Export'
- Filter the invoices by data and whether you want to re-export
- Click on 'QuickBooks Export'
- This will mark all the exported invoices with today's date to prevent them from being exported again.
Jumping to an Invoice in QuickBooks Directly from Zigaflow
Once you have a sales invoice exported into QuickBooks you can now open that directly from Zigaflow.
On the invoices’ list screen you click on the QuickBooks icon. This opens the invoice in the accounts software in another browser tab.
You can also open it from the invoice edit screen using the QuickBooks icon.
If you can't see the icon, make sure you click on 'Show More Settings'. The icon will not appear if the invoice has not been exported.
Note
The transaction ID that is created when you post an invoice to QuickBooks is based on the user credentials used to connect to QuickBooks. This means that if you post an invoice then reconnect to QuickBooks from Zigaflow with a different login these links will be incorrect. As long as you use one set of user credentials to connect from Zigaflow (which is the normal way to work) this will not be a problem.