Populating Autotask lists with QuickBooks items

If you are setting up Autotask and QB at the same time, set up your items in Autotask only. When the item is transferred to QB for the first time, a QB item is created automatically.

If you want to ensure that Autotask plays nicely with your existing QB Item list, you must recreate the QB items in Autotask. The following table indicates where items of different types will need to be entered.

NOTE  It is possible to create Autotask billing items that resolve as QB Item:Subitem. Refer to Using the tilde for mapping sub-items.

QB All item types appear on one list	Example	Autotask Billing Item Types appear on separate lists
Hourly Service Services where the unit of measure is 1 hour, or where the price is listed per hour.	Consulting	Work Type > Admin > Features & Settings > Finance, Accounting & Invoicing > Billing Codes > Work Types tab Refer to Introduction to billing for labor
Managed Service Services where the unit of measure is 1 month [quarter, year], or where the price is listed per month [quarter, year].	Web Hosting	Service or Service Bundle > Admin > Features & Settings > Products, Services, & Inventory > Services and/or Service Bundles Refer to ADMIN: Setting up your products and services portfolio
Lump Sum Service Progress payment on a fixed price contract.	Milestone Payment	Milestone Code > Admin > Features & Settings > Finance, Accounting & Invoicing > Billing Codes > Milestone tab Refer to Milestone codes
Inventory and Non-inventory Part Hardware or software billed to the customer	HP Deskjet, Adobe Premiere	Product > Admin > Features & Settings > Products, Services, & Inventory > Products Refer to Searching and managing products.
Other Charge T & E billed back to the customer	Airfare, Parking	Expense Category > Admin > Features & Settings > Finance, Accounting & Invoicing > Billing Codes > Expense Categories Refer to Adding expense categories

Export your QB item list

1. In QB, open the Item List and sort it by Item Type. Then go to Reports > Lists > Item Listing. Export the list to a new Excel spreadsheet.
2. On the Excel spreadsheet, do a Find and Replace and replace the colons “:” with tildes “~”.

Add QB Services to the right list

1. Identify the services that are priced by the hour. Copy the service names and enter them into Autotask on the > Admin > Features & Settings > Finance, Accounting & Invoicing > Billing Codes > Work Types tab. Refer to Introduction to billing for labor.
2. Identify the services that are priced by the month, quarter, or year. Copy the service names and enter them into Autotask on the > Admin > Features & Settings > Products, Services, & Inventory > Services list. Refer to Setting up your services.
3. If you will be using fixed price contracts, find the item name you are using for a lump sum payment in QB and copy it into > Admin > Features & Settings > Finance, Accounting & Invoicing > Billing Codes > Milestone tab. Refer to Milestone codes.

Add inventory parts and non-inventory parts to the Products list

1. In Autotask, open the > Admin > Features & Settings > Products, Services, & Inventory > Product Categories list. Categories will not be transferred to QB; they are intended to make selecting products on quotes and tickets easier. They are not required. Add or delete categories as needed.
2. In Autotask, open the > Admin > Features & Settings > Finance, Accounting & Invoicing > Billing Codes > Material Codes tab. This is a required field that will determine the tax category of the product. If all products you sell have the same tax rate, you may only need one material code called Taxable. Refer to Material codes and Configuring your tax table.
3. In Autotask, open the > Admin > Features & Settings > Products, Services, & Inventory > Products list and clickImport.

4. Click Import on the Product Import History page.
5. Download the recommended template and copy the columns you exported from QB into the template. Populate all required fields and save the file.
6. Browse to the file location of the .csv file.
7. Select a duplicate handling option:
   1. Do not update or import existing product: When this option is selected, the duplicate record will be returned in the Exceptions report.
   2. Update existing product: The information in the import file will overwrite information for the existing product. However, if a field is blank in the import file, but it has a value in the existing inventory item, we will not overwrite the value with a blank.
   3. If there are multiple matches based on Name + Category + Period, we will NOT perform the update.
8. Click Import. Autotask will validate that the file is a .csv file smaller than 5 MB, that all required columns are populated, and that no extra or duplicate columns are in the file.
9. A dialog box will inform you that the import is processing and that you will be informed via email when it is complete.

Add QB expense items to the Expense Categories list

If you will be billing your customers for expenses your resources have incurred, add expense and travel-related items to > Admin > Features & Settings > Finance, Accounting & Invoicing > Billing Codes > Expense Categories. Refer to Adding expense categories.