Prepare the Inventory Adjustment data with the following templateRefNumberAccountTransaction DateMemoItemNew QtyNew ValueAdj QtyAdj ValueCustomerClass1231-1Cost of Goods Sold31/12/2020Year End Inventory AdjustmentHardware10 1231-1Cost of Goods Sold31/12/2020Year End Inventory AdjustmentDoor Frame10 1231-1Cost of Goods Sold31/12/2020Year End Inventory AdjustmentCabinets -1 1231-2Cost of Goods Sold31/12/2020Year End Inventory AdjustmentWood Door 1000 1231-2Cost of Goods Sold31/12/2020Year End Inventory AdjustmentInterior Door Kit 500 then utilize one of these importer tools.https://transactionpro.grsm.io/qbdhttps://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

Hours

Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST

Product support & help

Need help signing in?

Recipes

Question

How do I upload an inventory count sheet from excel into Quickbooks Premiere 2019 Desktop version

Forum|Forum|4 years ago
October 6, 2021
1 reply
1 view

No text available

QuickBooks Desktop

Fiat Lux - ASIA

Level 14

Prepare the Inventory Adjustment data with the following template

RefNumber	Account	Transaction Date	Memo	Item	New Qty	New Value	Adj Qty	Adj Value	Customer	Class
1231-1	Cost of Goods Sold	31/12/2020	Year End Inventory Adjustment	Hardware	10
1231-1	Cost of Goods Sold	31/12/2020	Year End Inventory Adjustment	Door Frame	10
1231-1	Cost of Goods Sold	31/12/2020	Year End Inventory Adjustment	Cabinets			-1
1231-2	Cost of Goods Sold	31/12/2020	Year End Inventory Adjustment	Wood Door		1000
1231-2	Cost of Goods Sold	31/12/2020	Year End Inventory Adjustment	Interior Door Kit				500

then utilize one of these importer tools.

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

Sign up

Login with SSO

Let's get you signed in

Login with SSO