The content in this guide is currently being revised to align with the new user interface. Some text and images may be outdated.

Item Sync with QuickBooks Online

Pull in all the Products/Services you use in QuickBooks for a seamless invoicing experience.

Using this guide, you can:


 

Where are my QuickBooks Products/Services?

In QuickBooks, your Services are also part of what is called Products. Accelo can import in all your Services from your Products and Services list.

Screen Shot 2016 08 19 at 1.29.32 PM

You can access your lists by clicking on the Gear Icon at the top right of the page, which will expose your options shown in the screenshot above.

Once your list is accessed, you’ll see there are a number of fields in common with Accelo, though the terminology is slightly different.

Screen Shot 2016 08 19 at 1.22.26 PM

 

It should be noted that we don’t pull all QuickBooks Products & Services fields into Accelo. Here are the fields we pull in, and which ones we match it to.

2018 08 21 16 14 42

We use:

  • Taxable - To figure out if the item should use the a tax code with a 0% tax rate
  • SalesTaxCodeRef - US only, the actual tax rate to use
  • IncomeAccountRef - The Ledger id to use for Invoices
  • ExpenseAccountRef - The Ledger id to use for Purchases

We pull in:

  • Id - To maintain a link between the systems for sync.
  • Type - To set the Accelo type to Material (Item) or Service
  • Sku - Which matches the Accelo code
  • Name - Accelo title
  • Description - Accelo description
  • Active - Will be either active or inactive in Accelo
  • UnitPrice - For Accelo Sale Price
  • PurchaseCost - For Accelo Purchase Price

 

Importing Services

We try to make Importing your Services quick and efficient in Accelo. In order to perform any imports, be sure you have already previously made the necessary QuickBooks connection.

 2018 08 21 16 21 04

To import your Products/Services:

  1. Hover over your User Icon, at the top right.

  2. Click the Integrations link.

  3. Click the QuickBooks Online button.

  4. Click the Import button for Products and Services listed above.

It may take a couple of minutes for your Services & Products to roll in, but after that you’re all good to go! Remember, your Products (Materials/Items) and Services can be renamed in Accelo to however you wish.

Try Accelo for 7 Days
Fast and easy setup No credit card required
Get Started Now
Schedule a Live Demo
Tailored to your business All questions answered
Request a Time
Accelo uses cookies to give you the best possible experience - by clicking 'Continue' you agree to our use of cookies. Refer to our Privacy Policy for details. Continue