Track COGS (Cost of Goods Sold)
Table of Contents
Note: This document has been imported from the former KB and has not yet been verified.
Note: You’ll need a QBO Plus or Advanced Plan, which includes inventory tracking.
Sync Products in QBO and Syncro
Follow these steps to sync Products in QBO and Syncro:
- Create a new Inventory product in QBO or edit an existing one:
- Make sure the Income Account is “Sales of Product Income,” and the Expense Account is “Cost of Goods Sold”:
- In Syncro, if you add the Product, make sure you enter a Price Retail and Price Cost:
-
Navigate to the QB Settings page and scroll to the bottom:
- If the product already exists in Syncro, click Check for Item Changes. If the product does not exist in Syncro, click Import Products from QuickBooks to Inventory.
Note: The Product/Item imports include "Service, Non-Inventory Part, and Inventory Part” and exclude “Other Charge, Group, Subtotal, Discount, Payment, Sales Tax and Sales Tax Group.”
Add Items to the Invoice and Sync to QBO
- Add the item to an invoice in your account. The invoice syncs to QBO.
- Accept payment on the invoice in your account.
View the Cost of Goods Sold Report
To view the Cost of Goods Sold report, follow these steps:
- In QBO, navigate to Accounting > Chart of Accounts.
- Then search for Cost of Goods Sold:
- Click “Run Report” to see the Cost of Goods Sold report:
View the Profit & Loss Report
In QBO, navigate to Reports, then under the Standard tab, select “Profit and Loss”:
Note: If COGS isn't showing up by default on your Profit and Loss Report, select the “Accrual” Accounting Method in the upper right, then click Run Report: