Recording Stock for Tax Reporting

Any advice...I keep my Excel income and expenses spreadsheet but not sure if I should record all stock as I buy it as a monthly expense or just the cost of the actual items I sell and then keep the cost of remaining stock at hand as a separate thing?

Message 1 of 11
Latest reply
10 REPLIES 10

Recording Stock for Tax Reporting

Definitely record the dollar amount you are purchasing as this figure is given as expenses to your accountant.

I also keep an Excel spreadsheet which is super handy come tax time.

 

In a nutshell, I -

Record each months gross sales

Record each months' purchases of fabric/stock etc

Run a transaction report each month to get the fixed and variable fees.

 

Of course, items that I purchase this month may not sell until later in the year, but I just tally it all up and give to my agent.

 

Message 2 of 11
Latest reply

Recording Stock for Tax Reporting

First thing's first - Don't ask strangers on the internet for tax advice - ask your accountant.  

 

In saying that I have two pieces of advice.  Depending on scale - spend the money and use Xero or MYOB etc to do your reconciliation.  Put everything through a single bank account linked to your software, so you just login, you'll see your transactions and you can allocate them to various cost centres, attach receipts and so on.

 

Two - purchases of inventory are NOT AN EXPENSE.  You do not get to claim purchases of inventory as a tax deduction or an expense.  The only time you can claim the inventory cost as an expense is when you sell the item - Cost of Goods Sold.   Unsold inventory is an asset, it sits on your balance sheet.  It is not an expense.  You may end the year thinking you've made a modest profit because you've been investing in inventory, but that asset value will be deemed as profit and you'll be taxed on it.

 

 

Message 3 of 11
Latest reply

Recording Stock for Tax Reporting

Stock is capital, jelly, and only deductible upon sale. It IS possibly able to be depreciated.

 

That's why businesses have stocktake sales. It means they can claim the costs in the current tax year. And also save wages for staff not having to count things.

 

As p9 said, I don't claim to be an accountant, so this advice is general. But correct.

Message 4 of 11
Latest reply

Recording Stock for Tax Reporting

sorry but I could not stop ๐Ÿ˜‚ at this

"That's why businesses have stocktake sales. It means they can claim the costs in the current tax year"

yes, you sure can, but you also have the income from those sales so basically the profit goes up and so is the tax

that's not why business have these

only way these would help with tax is if you sell the stock in June and get paid in July, but then all you do is moving the tax into next year

 

Message 5 of 11
Latest reply

Recording Stock for Tax Reporting

You're less of an accountant than I am, it would appear. The carry-over costs of stock (capital) are less, and the tax on the 'extra' profit would be minimal compared to demurrage.

Message 6 of 11
Latest reply

Recording Stock for Tax Reporting

LOL - you are now into shipping.??

Message 7 of 11
Latest reply

Recording Stock for Tax Reporting

"You're less of an accountant than I am, it would appear. The carry-over costs of stock (capital) are less, and the tax on the 'extra' profit would be minimal compared to demurrage."

 

This gets better and funnier - The carry-over costs of stock (capital) are less - this is an everyday expense, has nothing to do with tax time, you can do sales anytime of the year if you want to clear stock to pay less storage fees. That's not the reason for a stocksale in June

the tax on the 'extra' profit would be minimal compared to demurrage - so, the extra tax will be lower than charge payable to the owner of a chartered ship on failure to load or discharge the ship within the time agreed - at least that's what demurrage means

you said "That's why businesses have stocktake sales. It means they can claim the costs in the current tax year" - which makes no sense. The more you sell, the more tax you pay. Period.

 

Don't try to spin it now, trying to look smart, just go back to school

 

Less of an accountant

Message 8 of 11
Latest reply

Recording Stock for Tax Reporting

>>> The more you sell, the more tax you pay. Period. <<<

 

This is categorically not true.  Sales (stocktake or otherwise) often result in products being sold below cost.  Selling a product below cost will REDUCE your tax liability.

 

There are many reasons why one might want to do that. 

  • Improving cash position. 
  • Clearing obsolete products. 
  • Making space for new inventory in stores or warehouse. 
  • Hitting supplier rebate targets

Your reply is exactly why sellers should not be seeking financial or accounting advice from anybody other than trusted professionals. 

Message 9 of 11
Latest reply

Recording Stock for Tax Reporting

I'm been involved in retail for last 15 years, from online to big chain sores and i can assure you, stocksales, where products are sold under cost, are not even 1%

Even clearance and close down sales with 80% discount , most of them, are still selling with profit

and this debate was not regarding accounting issues or advice but for the reason why stocksales are done

And your point and mine is the same.

My point was that stocksales are NOT done to reduce your tax, that would be stupid. 

Message 10 of 11
Latest reply