Syncing Work Orders and Disassembly's to QuickBooks Online
When syncing inventory with QuickBooks Online and using Work Orders and Disassembly's we are often left with random COGs amounts. The issue is QuickBooks Online does not allow for the negative qty line items. So using our normal method of negative quantity components and positive quantity finished good had to be altered to account for this. To get around this we are using the following Workflow:
Part 1: QuickBooks One-time setup
Users will need to create two Accounts. Order Time will create a Vendor (The Vendor part has not changed)
Clearing Account
Name: OT Production Clearing
Account type: Other Current Assets
Detail type: Other Current Assets
Variance Account:
Name: OT Production Variance
Account type: Cost of Goods Sold
Detail type: Other Costs of Services – COS
Subaccount: Cost of Goods Sold
Order Time will create a Vendor
“NC WorkOrder Internal” (Required for the $0 bill described further below)
Part 2: Finished Product from Component
In the following example, if you have an Assembly Item with a $4.50 inventory part and $3.00 of labor that you are posting to QuickBooks Online, but QuickBooks Online is valuing the inventory part at $4.00, we are left with a variance. Below describes what Order Time will sync over to account for that::
- New Bill
Vendor: NC WorkOrder Internal
Add Category Line: OT Production Clearing, Amount −4.50
Add Category Line: Expense Account on the “Labor” Item, Amount -3
Add Line Item for: Finished Product, Qty 1, Rate 7.00, Amount 7.50
Bill No./Memo: WO-1222 (reference the Work Order here for easier reconciliation)
Save, this creates a $0 Bill


- New Inventory Adjustment
Inventory adjustment account: OT Production Clearing
Reference no/Memo: WO-1222 (reference the Work Order here for easier reconciliation)
Add Line Item: Component, Change in Qty -1


- Chart of accounts: OT Production Clearing
The register will show a balance of -0.50
Future Bills/Inventory Adjustments will continue to record all variance in this Clearing Account.

Part 3: Month end (frequency determined by user)
- In QuickBooks, record a journal entry to Clear out the Clearing account using the Variance account as the offset.
- Debit the OT Production Clearing account for the balance (e.g. 10.20)
- Credit the OT Production Variance account for the balance (e.g. 10.20)
(Reverse if the balance is positive)
This will move the total variance to the OT Production Variance account, which is a sub account of COGS, Users can use this to account for the variance between Order Time/QuickBooks. The OT Production Clearing account is then cleared out/ready for the next month.
Note: Be aware if an earlier component purchase is edited or backdated, QBO recalculates and the change flows into Clearing automatically. It gets picked up at the next month end for reconciliation.