Integrating Ascora with QuickBooks

Ascora can integrate directly with most major accounting packages – Xero, QuickBooks, MYOB Live and MYOB Essentials.  Ascora runs two-way, full integration which means data will flow from Ascora into your accounting package as well as from your accounting package back into Ascora to ensure your Customers, Invoices and Payments are always synchronised.  To connect Ascora to your QuickBooks Accounting Package:



1.  From the Administration Icon in the Top Menu, choose the Accounts Integration option.

2.  Select QuickBooks from the dropdown list.  A summary will display on the screen to explain the integration further.

3.  Click the Connect to QuickBooks button to commence the integration.  You will be re-directed to QuickBooks to authorise Ascora to access you accounting data.

4.  Enter your QuickBooks log-in details and click the Sign In button.  QuickBooks will ask you to allow Ascora access to your QuickBooks Account.

5.  Click the Connect button to allow Ascora to integrate with QuickBooks.  You will be re-directed back to Ascora to finish the integration.

6.  Once you have successfully connected Ascora with QuickBooks, a list of account code options will display.  These tell Ascora which account codes in QuickBooks to send different information to.  Work through the list and select the applicable account codes from the dropdown lists.  When you are ready, click the Save Accounting Settings button.

A – Select the applicable Sales Tax Code

B – Select the applicable Sales Tax Free Code

C – Select the applicable Purchases Tax Code

D - Select the applicable Purchases Tax Free Code

E - Select a custom field in QuickBooks to save Lead Source records

F - Tick the checkbox if you wish to accept credit card payments in Ascora and push these records across to QuickBooks

G - Select the account to record customer payments that you capture in Ascora.  Ascora will also poll this account to pull-down payment information recorded directly in QuickBooks and mark the applicable invoices as paid in Ascora (for example, when a customer pays by direct debit and you reconcile that payment in QuickBooks via your bank feed)

H – Select the default payment method used by your customers.  You can override this default when recording payments in Ascora

I – Select the account for Ascora to push Supplier Invoice income *******

J – Select the default account to record Expenses.  You can override this default when recording Expenses against a Job

K – Select the account to record income from Labour

L – Select the default account to record income from the sale of Supplies.  You can set different Materials Income Accounts for specific Supply Items if required - see Configure Specific Account Codes for Individual Supplies

M – Select the default account for recording credit notes issued to Customers

N – Tick the checkbox to push line items on an invoice across to QuickBooks, in addition to the Invoice summary information

7.  Ascora is now integrated with QuickBooks and will ask if you wish to import customer information.  Click Yes, import all my customers to import customer information from QuickBooks immediately.  Alternatively, click Not right now to import data at a later time using the Import Icon in the Top Menu.

Configure Specific Account Codes for Different Job Types

When you create a Job Type in Ascora, you can choose to assign unique Labour and Materials Income Account Codes to it.  For example, you can set a Domestic Job Type to push income to Domestic Labour and Domestic Materials income accounts in QuickBooks.  

Note that you do not need to configure specific Account Codes for different Job Types - any Job Type that does not have a specific Labour and/or Materials Income Account Code assigned to it will use the default Labour and Materials Income Account Codes configured in the main Accounts Integration settings.



1.  From the Administration Icon in the Top Menu, choose the Jobs option.

2.  Under the Job Type section, click the +Add New button to create a new Job Type, or click the Edit button to edit an existing Job Type.

3.  The Job Type details pop-up window will display.  Select the required Labour and Materials Income Account Codes from the dropdown lists then click the Save button.

Configure Specific Account Codes for Individual Supplies

You can configure Ascora to push income generated from a specific Supply Item into a specific Income Account Code in QuickBooks.  This would typically be used when, for example, you charge out a rate for the use of a particular piece of equipment and have the equipment listed as a Supply in Ascora.  By specifying a unique Income Account Code, you can track income specifically generated by that piece of equipment.

1.  From the Inventory Icon in the Top Menu, choose the Supplies option.

2.  Locate the Supply in the Supplies List for which you wish to apply a specific Income Account Code and click the Edit button

3.  The Edit Supply pop-up window will display.  Select the applicable Income Account Code from the dropdown list then click the Save button.

Configure Account Codes for Credit Card Surcharges

1.  From the Administration Icon in the Top Menu, choose the Payments & Tax option.

2.  Under the Payment Methods section, click the +Add button to add a new Payment Method or click the Edit button to edit an existing Payment Method. 

3.  The Payment Method pop-up window will display.  Select the applicable Surcharge Income Account Code from the dropdown list then click the Save button.