Skip to main content
January 2, 2024
Question

Subtracting Cost of item from Sales total after Invoice was paid

  • January 2, 2024
  • 1 reply
  • 0 views

Hi there, I'm a brand new quickbooks user converting my first business year of manual bookkeeping to quickbooks and made a mistake on the first sale. I'm using the EasyStart version which does not include inventory tracking. About 10% of my business is refurbishing items we purchase for re sale, 90% is items customers send to us for refurbishing. Our first sale was for 2 items we purchased, refurbished and sold. At the time of invoicing the customer I forgot to figure out where to put the cost of each item so it gets subtracted from our sales profit and the original purchase prices added to expenses. I can't figure out how to make this adjustment now after the customer has paid the invoice. I've tried creating a COGS account setup as an inventory type account inputting the items and costs manually but nothing I seem to do makes any adjustments to our overall sales amount or even appear in the COGS account we created, the account balance stays at 0.00. Any help to get this mistake corrected and a solution for future COGS sales so the cost is always going to expenses and the remaining to sales profit is appreciated!

1 reply

January 2, 2024

It's great to hear you are transitioning to QuickBooks for your bookkeeping needs. Even though the EasyStart version doesn't include inventory tracking, you can still manage your costs and sales effectively.

 

To help you with this, you can continue to record sales by sales receipt or invoice. Then, ensure that when you purchase inventory using the Asset account. Here's how to track the value of your inventory assets manually in QuickBooks Online Essentials and Simple Start:

 

First, create an account to track your inventory value.

 

  1. Go to Settings ⚙ then Chart of accounts.
  2. Pick New.
  3. From the Account Type dropdown, select Current Assets.
  4. From the Detail Type dropdown, choose Other current assets.
  5. (Optional) Enter a unique Name (system default will be Other current assets), Description, Default Tax Code, and Balance for the account.
  6. Click Save and Close.

 

Next, create an account to track your cost of goods sold.

 

  1. Go to Settings ⚙ then Chart of accounts.
  2. Pick New.
  3. From the Account Type dropdown, select Cost of Goods Sold.
  4. From the Detail Type dropdown, choose the closest type of Cost of Goods Sold that matches your situation. If you're not sure, use Other Costs of Service - COS.
  5. (Optional) Enter a unique Name, Description, and Default Tax Code for the Cost of Goods Sold item.
  6. Click Save and Close.

 

You can check out this article for the detailed steps when you record a Journal Entry for your COGS: Track inventory manually in QuickBooks Online.

 

I'm adding these articles you can use in the future:

 

 

I hope this helps you correct the mistake and set up a solution for future COGS sales. If you need further assistance, feel free to ask! I'll always be around to answer them. Have a great day!