features Tutorial

Quick Books Online Sync

ServiceWorks syncs all the data from ServiceWorks to QuickBooks online in appropriate accounting bucket. Search for the transactions that you want to be synced by the date range.

Then click on the QB Connect button. Enter your credentials to connect to QB. You will see the sync data button when you are connected.

Check the elements you want to see and it will turn green and say active. ServiceWorks automatically marks the dependents elements as Active. For example if you check Ticket Invoice then automatically Customer, Vendor, Employee,Inventory will be selected for synchronization.

Next you just have to click the Sync Data button and data will flow from ServiceWOrks to QuickBooks and you will see the result of syn under the Sync Result panel on the right.

Steps to follow

For online QuickBook sync these steps has to be followed

  1. Sync Chart of Account independently: This will bring all the Chart of Accounts from QB to ServiceWorks and SW to QB.
  1. Sync Customers independently: This will do two way sync and all customers from QB will come to SW and from SW it will go to QB.
  1. When those are done let your product specialist know so we can set relevant chart of account head as your inventory or service items may not be associated with any specific chart of account
  2. Next you can go and sync whatever you need.

All the Service Items are mapped to a Chart of Account Sales under Acct Type INC if it is not associated otherwise
All Items are mapped to Chart of Account Cost of Good sold under ACCT type COGS if it is not associated otherwise
ALL Inventory items are mapped to Chart of Account Inventory Asset under Acct Type OCASSET if it is not associated otherwise

You can see all the chart of account imported from QB in this page.

Associate your Items to Specific Chart of Account

Service Items

Go to Configuration->PriceList. Edit a Service Item and select appropriate Chart of Account. You can pick any from this list but make sure they are of Account Type INC, otherwise in QuickBooks it will not be considered as Income.

Items

Go to Inventory -> Item -> Edit an item. appropriate Chart of Account. You can pick any from this list but make sure they are of Account Type COGS, otherwise in QuickBooks it will not be considered as Cost of Good Sold.

One comment

  1. Pingback: Homepage

Comments are closed.

%d bloggers like this: