Accounts Integration (Sync)

The accounting 'Sync' API allows Sales Invoices, Sales Credit Notes and Supplier Invoices created through AutoVu to be synced with your accounting software.

 

Introduction

 

For this example, 'QuickBooks' has been used, the process is the same for other accounting software titles. 

 

On opening the sync page, there will be a simple menu to the left and a centre dialogue. The menu will allow you to choose between Sales Invoices, Sales Credit Notes and Supplier Invoices. 

 

 

 

 

 

Connect to your accounting package by clicking 'Connect to Quickbooks'. Depending on the accounting package you use, the process will involve a series of prompts from your accounting software provider requesting that you log into your accounting software. Follow these in the usual way that is expected when you log into your accounting software user portal.

 

Once connected, the connection status will change from red to green, stating 'Connected', and the name of your accounting software will be shown.

 

 

Once you are connected to your accounting software, you have 5 options available to you.

 

  1. Disconnect from your accounting software by clicking 'Disconnect'.
  2. Update: this prompts AutoVu to attempt 'Sync' for any listed documents.
  3. Open the 'Accounts Sync (Actions) popup by clicking anywhere within the grid lines for any document (Except the 'Nav' panel)
  4. Within the 'Nav' panel, click the green 'S' number to navigate directly to the document in question.
  5. Within the 'Nav' panel, click the orange 'A' number to navigate directly to the client account for the given document.

 

 

In this instance, we will click the 'Update' button to attempt 'Sync'

 

There are a number of check stages to overcome before a financial document is allowed to sync. These are listed below and must be satisfied between each title before the sync will occur.

 

  1. Invoices only: Check that the invoice has been marked as 'Sent' I.E. email, post etc.
  2. Check for matching Accounts ID.
  3. If used, check for matching ‘Care of ID, this option is not available with some accounting software titles.
  4. Confirm the document number being used does not already exist. (I.E. duplicate invoice numbers)
  5. Check each line of the invoice has a matching nominal code within your accounting software.
  6. Where applicable, make sure the nominal has an associated tax value. (This depends on the accounting software used)
  7. Confirm that each financial document detail line has text. (I.E. no blank lines allowed)

 

Once these points are all satisfied, the document will sync from AutoVu to your accounting software.

 

Using the above example screen, we can see that the Customer Account' does not exist in our accounting software. We can open the 'Accounts Sync (Actions) popup by clicking anywhere within the grid to perform actions.

 

 

This example shows us that the account we are trying to sync has a similar named account within our accounting software as shown in the 'Suggestions' panel. If no match had been found, this panel would be empty. We can link this matching account by clicking 'Link This'

 

Should we wish to simply create a new account within our accounting software, we can click 'Create New'

 

If we have an account within our accounting software that we want to link that has not been listed as a suggestion, we can enter the 'AccountID' from our accounting software directly into the 'AccsID' field on the Account Sync (Actions) dialogue.

 

Each account within your accounting software has its own ‘Unique’ customer code. This can be seen in the url bar when entering a customer account for edit.

For our QuickBooks example, the url for our demo company would be; https://c51.sandbox.qbo.intuit.com/app/customerdetail?nameId=129

 

We would enter 129 in the AccsID field if we were to use that option.

 

For clarity, we would use only 'Create New' or 'Link This' under normal circumstances. The direct entry of 'AccsID' is considered a relatively rare option to use.

 

 

General Information

 

To get to the Sync Page, from the main diary click ‘My Company’ then click ‘Accounts Sync’ from the menu on the left. (For users with permission, there is a ‘Go to Sync’ button in the integration panel once a document has been marked for sync.

 

Initially, the connection between AutoVu and your accounting software will not exist. This will be identified in the Connection Status panel with the label stating Not Connected. To connect, click the ‘Connect to QuickBooks’ button. This will re-route you to QuickBooks for authentication.

 

Depending on whether you are already logged into QuickBooks via your browser, you will either be asked to confirm the current connection, or you will be asked to provide your login credentials and then connect. Once connected, the Name of the currently connected account will be shown in the connection status box of AutoVu. To disconnect, simply press the ‘Disconnect’ button. To swap between two different accounts on QuickBooks, it may be necessary to log out of the online session to QuickBooks if you already have it open in another tab on your browser.

 

The connection between QuickBooks and AutoVu will persist even if you navigate away from this page. This means that it is not required to keep login into QuickBooks each time you visit the page. The connection will maintain for approx 20 mins then will auto disconnect unless you click the disconnect button which breaks the connection immediately.

 

Once connected, a list of all Invoices / Credit Notes or Supplier Invoices that have been marked for sync will be listed. To sync these to QuickBooks, simply press the ‘Update’ button.

 

If sync is successful, the invoice will be removed from the list and will appear on QuickBooks (you may need to refresh the QuickBooks browser to see this)

 

If sync was not successful, the reason will be shown in the StatusCode column of the invoice list.

 

If the customer does not exist, clicking the entry within the list will allow you to either Create a brand new customer account on QuickBooks, OR link an existing account if one was found in QuickBooks showing the same account name.

 

If you are given the option to ‘Create New’ and you already have a number of accounts within QuickBooks and are not sure if the account exists or not, it is advisable to confirm this by viewing your customer accounts on QuickBooks to confirm. If an account does exist, you will be required to manually enter the AccsID into AutoVu.

 

If you are given the option to Link an existing account, this means that AutoVu found a customer account within Quickbooks that has the same account name as that shown in AutoVu. Clicking the ‘Link This’ button will automatically link the account to AutoVu.

 

Once the accounts are linked, further attempts to sync on this account will be successful. I.E. it is only necessary to link an account once.

 

After re-submitting the invoice for sync, there may be further problems to rectify. This would often be regarding Nominal Codes if they are not correctly duplicated between each software title.

 

Once all accounts are linked, and all nominals exist between QuickBooks and AutoVu, subsequent sync attempts will become seamless.

 

 

 

 

See Also:

If you would like to know more about AutoVu and what we can do to help your business, why not check out our Frequently Asked Questions page, or Contact Us any time to discuss your specific requirements.

Professional cloud based software