>

Quickbooks Online Edition

David Stevenson -

Starting with Synergist version 12.5, cloud edition, there is a direct link to Quickbooks Online, removing the need to use Transaction Pro Importer as middleware to facilitate the import of batches of invoices from Synergist into Quickbooks.

The link needs to be chosen in company settings > accounts:

mceclip0.png

Options controlling what references are sent from Synergist to Quickbooks can be set on the Account details section:

mceclip1.png

Once you have set the link up go to Clients & jobs > Accounts link and click the button to authenticate with Quickbooks:

mceclip1.png

Once done this link will be persistent and only require re-authentication in the event of disconnecting Synergist & Quickbooks, from within either product.

Batches of invoices are created in the normal way via the export to accounts interface, and can be posted direct into Quickbooks by clicking the Post batch button next to each batch.

Missing client and supplier accounts will be created in Quickbooks, if this is the only validation failure in the batch - you will need to click Post batch a second time with the option to create missing accounts selected:

mceclip0.png

Other validation failures such as bad / missing nominal (item) codes or tax codes will need to be corrected in the batch prior to re-posting.

 If you have attached documents to a purchase invoice in Synergist, for example a scan of the paper invoice received from your supplier, then these documents will be transferred into Quickbooks when the batch containing the invoices is posted.  The attachments will appear on the invoice input screen in Quickbooks, from where they can be downloaded.

Another enhancement for Quickbooks Online users available in Synergist 12.5 is the ability to import purchase invoices from Quickbooks into Synergist.  So if you use receipt bank or a similar AI product to scan receipts and create invoices automatically in Quickbooks, you can then import these into Synergist.  For more information on this feature see the article here on importing purchase invoices from an accounts package.

 

Nominal Analysis

It is important to note that sales analysis and purchase analysis are each handled differently in Quickbooks.

Sales analysis entries in Synergist have to point to an item code in Quickbooks, under Products & Services.  Items in Quickbooks can optionally be linked to a Category.  If Categories are used for Items you must include both in your sales analysis in Synergist, separated by a colon.

E.G.

"Category:Item Name"

OR

"Item Name"

In the example below the sales analysis in Synergist would need to be 'General services:Catering'. 

Purchase analysis entries in Synergist have to point to a full chart of accounts entry in Quickbooks - Item codes and categories are not used for purchase analysis in Quickbooks.  The purchase analysis in Synergist must include the full chart of accounts entry in Quickbooks, separated by colons, ending with the purchase account name.

E.G.

"Cost of Something:Services:Account Name"

OR

"Cost of Something:Account Name"

Just entering the purchase account name (like you would for an item name in sales) is NOT adequate.

In the example given below, the purchase analysis in Synergist would need to be 'Cost of sales:COS Production Content and Media'. 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk