cancel
Showing results for 
Search instead for 
Did you mean: 
HitchCovers23
Level 1

COGS split for Inventory

Hi!

 

I'm an owner of a  business where we manufacture and sell hitch covers. 

 

I use both excel and Quickbooks for tracking. Excel tracks our inventory/sales while Quickbooks tracks our expenses and accounting. 

 

As a result, any item we purchase for parts is categorized as COGS. At year end we had $14500 worth of COGS. However, at year end we did an inventory count and saw that we had $9500 worth of inventory. Is there a way in quickbooks to "split" the COGS so that $9500 of the $14500 is Inventory and the remaining $5000 is COGS...without going into each individual COGS transaction and splitting them?

 

Thanks!

1 Comment 1
Angelyn_T
QuickBooks Team

COGS split for Inventory

Hello, @HitchCovers23

 

Normally, the Cost of Good Sold (COGS) is only affected when you sell inventory items on invoices or sales receipts. That being said, you don't need to split the COGS manually so that the $9500 of the $14500 will go to your inventory and the remaining $5000 is for COGS.

 

All you need to do is switch the report (Profit and Loss) to either the cash or accrual method of accounting. If you're on a cash accounting report, it'll calculate COGS base on the amount of purchase. By the time you record an invoice for the sold item from the invoice, it'll now reflect COGS in the accrual accounting report.

 

I've added these screenshots for your visual reference.

 

To learn more about the accounting reports in QuickBooks Online, read these articles:

 

Let me know if you have any other questions. I'm always here to help. Have a good day!

Need to get in touch?

Contact us