Why sign in to the Community?

  • Submit a question
  • Check your notifications
Sign in to the Community or Sign in to TurboTax and start working on your taxes
Level 15
posted Feb 10, 2020 7:22:17 AM

Inventory Question

@Jester32t I do not answer questions posted privately.

Bottom line: Your 2019 beginning of year inventory balance *must* match *exactly* your 2018 end of year inventory balance. If it does not you'll have some 'splainin' to do to the IRS, and they flat out will not accept "any" reason or excuse you may provide them.

 

0 15 3475
1 Best answer
Level 15
Feb 10, 2020 8:09:10 AM


@Jester32t wrote:

Or am I simplifying or thinking about it wrong?


You only have to do an internet search for "cost of goods sold formula" to discover the one that is virtually universally accepted and relatively simple:

 

  • Beginning Inventory (at the beginning of the year)
  • Plus Purchases
  • Minus Ending Inventory (at the end of the year)
  • Equals Cost of Goods Sold

 

EX:

$14,000 inventory at the beginning of the year


+ $8,000 purchases during the year
- $10,000 ending inventory


= $12,000 cost of goods sold.

 

 

15 Replies
Level 1
Feb 10, 2020 7:24:53 AM

Okay thanks. How do I post publicly?

Level 15
Feb 10, 2020 7:28:40 AM

BOY Inventory balance - What *you* paid for the inventory in your physical possession on Jan 1 of the tax year. It does not matter what year you paid for it either. If this is your first year of dealing with inventory, then this balance "must" be $0. If this is not your first year then the balance must match exactly your prior year's EOY inventory balance.

EOY Inventory balance - What *you* paid for the inventory in your physical possession on Dec 31 of the tax year. It does not matter in what year you paid for it either.

Cost of Goods Sold (COGS) - What "you" paid for the inventory you actually sold during the tax year. In what year you paid for it does not matter.

Example:

 

BOY Inventory balance $5000

EOY Inventory balance $9000

COGS - $10,000

The above indicates that you started the tax year with $5000 of inventory in your physical possession on Jan 1. During the year you purchased an additional $14,000 of inventory bringing the total to $19,000 for the tax year. During that same year you sold $10,000 worth of inventory leaving you with an EOY balance of $9000.

 

Level 15
Feb 10, 2020 7:32:29 AM

Oh, and you just did post publicly BTW. Instead of clicking an screen name, select the "Ask a Question" button to start a new thread. At this point, you don't need to start a new thread and so long as we continue on the same subject, you can just click the REPLY button at the bottom of "this" post.

ASK A QUESTION will start an entirely new thread.

REPLY will add your post to the existing thread you are replying to.

I myself think this "new" interface sucks. But then we all know what opinions are like. 🙂

 

Level 1
Feb 10, 2020 7:42:51 AM

Hahah well regardless of interface I need the expert advice!

 

So if I could clarify or confirm what you are saying. If my BOY inventory was 46k for 2019, my end of year inventory for 2019 would be 46k + any new cogs - 2019 sales? Does this maintain the same thought process? Or am I simplifying or thinking about it wrong?

Level 15
Feb 10, 2020 8:09:10 AM


@Jester32t wrote:

Or am I simplifying or thinking about it wrong?


You only have to do an internet search for "cost of goods sold formula" to discover the one that is virtually universally accepted and relatively simple:

 

  • Beginning Inventory (at the beginning of the year)
  • Plus Purchases
  • Minus Ending Inventory (at the end of the year)
  • Equals Cost of Goods Sold

 

EX:

$14,000 inventory at the beginning of the year


+ $8,000 purchases during the year
- $10,000 ending inventory


= $12,000 cost of goods sold.

 

 

Level 1
Feb 23, 2020 6:18:23 PM

You sound like you know more than the person at TT I'm on the phone with.

 

I just put in my inventory valuation. At what point will it ask for my COGS? I wanted to go accrual method rather than cash.

Level 15
Feb 23, 2020 6:25:43 PM


@rachaelmw72 wrote:

I just put in my inventory valuation. At what point will it ask for my COGS? I wanted to go accrual method rather than cash.


The program does not ask for your COGS because COGS is part of a formula, which is derived as stated in my earlier post (COGS is actually a result, not an input). You can input your beginning inventory, your purchases (also materials/supplies and labor costs if applicable), and your ending inventory; the program will calculate your COGS.

 

Note that you have to change your accounting method from the default "Cash" to "Accrual" in the Business Profile section of the program.

Level 1
Feb 23, 2020 6:34:14 PM

@Anonymous_ 

So here's my numbers:

 

Cost of inventory overall in 2019: $10,150.29

BOY inventory: $0 (started business in October)

EOY inventory: $8887

 

So where would I put in my 10k figure? And where do I put in my 8.8k figure? I feel foolish at this point - I'm usually very together and self-sufficient. Almost embarrassed to ask for help, but very grateful!

Level 1
Feb 23, 2020 6:39:59 PM

@Anonymous_ Also... Since that's the case, should I just go with the cash method instead of accrual? If I'm ultimately putting in the same values anyway?

Level 15
Feb 23, 2020 6:45:21 PM

I have to presume you are using either TurboTax Self-Employed or Home & Business. I have a copy of the latter and you start with the Inventory and Cost of Goods Sold section in which you will be asked if you have inventory to report.

 

One of the first few screens will be boxes to enter beginning of 2019 and end of 2019 inventory. The immediately following screen will have, among others, a box for Cost of Purchases which is where you will input the cost of the inventory you bought.

 

 

Level 15
Feb 23, 2020 6:45:52 PM


@rachaelmw72 wrote:

@Anonymous_ Also... Since that's the case, should I just go with the cash method instead of accrual? If I'm ultimately putting in the same values anyway?


Cash is the most common method of accounting for small businesses.

Level 1
Feb 23, 2020 6:53:37 PM


@Anonymous_ wrote:The immediately following screen will have, among others, a box for Cost of Purchases which is where you will input the cost of the inventory you bought.

 

 


I just learned how to quote in a reply. Win. Ok, so I know exactly what box you're referring to here - so would I put my $10k value there?

Level 15
Feb 23, 2020 7:26:00 PM


@rachaelmw72 wrote:

@Anonymous_ wrote:The immediately following screen will have, among others, a box for Cost of Purchases which is where you will input the cost of the inventory you bought.

 

 


I just learned how to quote in a reply. Win. Ok, so I know exactly what box you're referring to here - so would I put my $10k value there?


Yes, you would put the $10k cost in that box.

Level 1
Feb 23, 2020 7:40:32 PM

@Anonymous_  I cannot believe I was on the phone with TT for almost an hour about this and they chalked the 0 showing up to a glitch in the system, THEN told me it's because I'm taking the standard deduction. 🙄 Thank YOU so much for your help! 😊

New Member
May 16, 2020 8:50:10 AM

I have an essential oils business where I buy and sell oils.  I get oils 3 ways.  1) I pay wholesale cost, which I get points depending on how much I buy, 2) I use my points to buy the products at no cost to me, 3) I get what they call loyalty products that the company gives me at no cost for buying a certain amount of products a month.  Since all of these products are for sale to my customers, I have put them on my inventory.  However, I am not sure how to value the free products.  Do I put "$0" value since I didn't pay for them or do I use the wholesale value?