Automatically sync Avaza Invoices with QuickBooks via our integration! The integration supports the following scenarios.
Supported Scenarios
When an invoice is created in Avaza, create the invoice in QuickBooks
When an invoice is updated in Avaza, update the invoice in QuickBooks
When a payment is applied to an invoice in Avaza, apply the payment to the linked invoice in QuickBooks
When a payment is applied to an invoice in QuickBooks, apply the payment to the linked invoice in Avaza
The integration also creates new Contacts and Items in QuickBooks if they don't already exist. We plan to add support for additional scenarios in the future.
Data Flow
During the sync, we pass specific information to and from QuickBooks. The illustration below describes the flow of data between the two systems.
Connect Avaza with QuickBooks
Please follow the steps below to connect your Avaza and QuickBooks accounts.
Navigate to Settings > Marketplace.
You will find the QuickBooks app in both the Feature and Accounting categories.
Click the QuickBooks app to open the details in a modal.
Click the "Connect" button. You will be navigated to the Settings tab.
Grant the integration access to your Avaza account by clicking the "Grant Access to Avaza" button.
Once permission to the Avaza account is granted, you will see the details of the Settings screen. Before you can proceed, you must connect the integration to one of your QuickBooks accounts.
Click the "Connect to QuickBooks" button. If you are not already logged in to QuickBooks, you will be asked to log in and authorise access to your QuickBooks account. Once authorisation is granted, you will return to the Settings page.
Integration Settings
Under the connection panels, you will see the Integration Settings panel. Please select the Integration Start Date. All invoices that have been created or updated after the Integration Start Date will be copied across to QuickBooks when the integration runs for the first time.
Under the Integration Settings panel, you will see a checkbox "When an Invoice is created or updated in Avaza, create or update an Invoice in QuickBooks". This is the primary scenario supported by our integration. Please check this checkbox to view its settings.
Select the Default Revenue Account that will be specified as the revenue account when creating a new Product or Service in QuickBooks Online, ensuring accurate financial categorisation and seamless bookkeeping.
Specify one of the revenue accounts that should be used for discount amounts.
Certain invoices may generate a minor rounding amount to ensure the invoice total is the same. Please specify the Product that the rounding amount should be allocated to.
Choose which Avaza Invoices you wish to pass to QuickBooks by selecting the relevant Invoice statuses.
Check the Automatic Invoice Number option if you would like QuickBooks to generate its own invoice number.
You will need to map tax codes in Avaza to tax codes in QuickBooks using the drop-downs. All available taxes in your QuickBooks account will be displayed, so you can easily choose the correct ones.
If you wish to send payments that are applied to invoices in Avaza to QuickBooks, check the "Send Payments from Avaza to QuickBooks" option. Whenever you apply a payment to an invoice in Avaza, that payment will be applied to the linked invoice in QuickBooks. Please select from the list of payment accounts that will be set when creating a payment in QuickBooks.
If you prefer creating and applying payments in QuickBooks instead, check the "Send Payments from QuickBooks to Avaza" option. Whenever you apply payments to invoices in QuickBooks, those payments will be created in Avaza automatically.
Once you have configured all the settings, click the Save Settings button. You can now click the Start Sync button. The integration is now active, and whenever a new invoice is created or updated in Avaza, it will copy that information to QuickBooks instantly. You can also click the Sync Now button if you wish to run the sync immediately without creating or updating invoices in Avaza.
Exception Management
If the integration is unable to update QuickBooks or Avaza for some reason, the exception will be logged in the Activity Log section. In addition to this, an exception email will be sent.
To access the Activity Log, click the "View Details" button from the Activity Log panel at the top of the Settings page.
The Activity Log list displays all transactions that the sync function has attempted to process. All transactions that have synced without any issues will display the status "Ok". The transactions that the sync function was unable to process due to an issue will have the status "Error".
You will notice an "Ignore" button next to the error transactions. If you don't want the integration to try syncing a transaction again, click the "Ignore" button. You will notice an "Undo" button next to transactions that are already ignored. Clicking "Undo" will retry syncing that transaction. Please note that the integration automatically ignores any transaction that has failed 5 times. Use the filter dropdown to view only transactions that are in Error status.
To view the details of a particular activity log record, simply click the record. It will display important details such as the error message and more.
The exception email includes the following details:
Where possible, the Avaza Invoice Number with a link to open the invoice in Avaza.
The detailed error message received from the QuickBooks or Avaza API.
The QuickBooks account name that the integration is connected to.
This email will be sent to the user who last updated the integration settings page and to the account email. You can update the account email by navigating to Settings > General Settings.
Frequently Asked Questions
Who in our Avaza account can access the integration?
The QuickBooks integration can only be accessed by Avaza users with the Administrator role assigned.
How do I pause the integration?
You can pause the integration at any point. Navigate to Settings > Marketplace Apps > QuickBooks and, on the Settings page under the Integration Settings panel, click "Pause Sync". Data is not automatically copied between Avaza and QuickBooks while the sync is paused.
How do I disconnect from QuickBooks?
On the Integration Settings page, you will notice the "Disconnect from QuickBooks" button inside the QuickBooks connection panel. A confirmation popup will inform you that disconnecting QuickBooks will remove all the integration settings and data related to this account. If you click "Yes", your QuickBooks account will be disconnected and all related data will be deleted.
When does the sync occur?
For an active integration, data is copied between QuickBooks and Avaza instantly.
Can I run the sync manually?
Yes. On the integration settings page, you can click the Sync Now button to run the sync manually. Sync Now works even if the sync status is paused.
Who should I contact if I need assistance?
You can contact our friendly 24/7 Avaza support team via chat or email if you have any questions or require assistance with your integration. Visit us here for details.