@jkellydjgreen
You can prepare your 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 use a 3rd party tool to import it. It's a $199 one time license and you can get $100 cashback to purchase via a partner.
https://get.transactionpro.com/qbd
