Options
How best to track inventory.
Jinx86
Posts: 3,677 ✭✭✭✭✭
Ive come to the point with my ebay store and collecting that I have many coins coming and going. Mostly I want to be able to track my costs vs my sales for tax purposes. Problem for me is entering every coin into a spread sheet and adding correct info once sold/traded. For this years taxes I have a pretty accurate numbers for what I sold but when It comes to purchases all I have is the receipts that were written/printed out for me. Also for when I buy coins by the pound or BV and pull better dates how do I show profits?
So how do others out there do it. I have 100+ coins I buy a week and typically sell 100 lots of ebay a week if not more.
So how do others out there do it. I have 100+ coins I buy a week and typically sell 100 lots of ebay a week if not more.
0
Comments
<< <i>So how do others out there do it. I have 100+ coins I buy a week and typically sell 100 lots of ebay a week if not more. >>
get receipts for everything and write out the things you don't get receipts for although they may not qualify at the time of an audit
and/or this
tally everything into 3 categories. 1. purchases 2. sales. 3. expenses and take it all to a CPA and they should help you break out those 3 categories even further. if you have no experience i don't recommend you tallying it all yourself. you may miss vital tax benefits etc by doing it yourself.
all refunds, consignments, your returns etc will ultimately fall into those categories. go through your checks, credit cards etc. leave no stone unturned.
.
<--- look what's behind the mask! - cool link 1/NO ~ 2/NNP ~ 3/NNC ~ 4/CF ~ 5/PG ~ 6/Cert ~ 7/NGC 7a/NGC pop~ 8/NGCF ~ 9/HA archives ~ 10/PM ~ 11/NM ~ 12/ANACS cert ~ 13/ANACS pop - report fakes 1/ACEF ~ report fakes/thefts 1/NCIS - Numi-Classes SS ~ Bass ~ Transcribed Docs NNP - clashed coins - error training - V V mm styles -
I have a spread sheet for my personal collection that is quite detailed.
as far as the IRS goes you just need track/report your purchases/sales/expenses, actually they probably only care about your sales but that is getting off the point.
you only need track the coins you have for your personal edification and/or insurance. if you got receipts at the time of purchase and get receipts at the time of sales then the rest kind of takes care of itself. you will probably need an estimation of your inventory at the end of the year too but i'm not getting into that one, especially in a public forum where their prying eyes can see what i say.
.
<--- look what's behind the mask! - cool link 1/NO ~ 2/NNP ~ 3/NNC ~ 4/CF ~ 5/PG ~ 6/Cert ~ 7/NGC 7a/NGC pop~ 8/NGCF ~ 9/HA archives ~ 10/PM ~ 11/NM ~ 12/ANACS cert ~ 13/ANACS pop - report fakes 1/ACEF ~ report fakes/thefts 1/NCIS - Numi-Classes SS ~ Bass ~ Transcribed Docs NNP - clashed coins - error training - V V mm styles -
Once you learn how to use it, it is a huge timesaver. Moderate upfront investment for long-term savings.
Another easier way to do it is to have periodic inventory system. You take a physical inventory at the begging of the year. You would need to list every significant item in detail. Cheep stuf could recored in bulk, like the Indian cents. During the year you record each purchase. This can be done on an Excell Spread sheet. At the end of the year you take another physical inventory. The year end calculation is this:
Beginning Inventory + Purchases - Purchase retruns and discounts (if any) = Cost of goods available for sale
Cost of good available for sale - Ending inventory = Cost of goods sold.
Sales - Cost of goods sold = Gross margin.
From the gross margin you deduct your operating expenses to get to net income.
One key is you have record your purchases and file the recepts properly. If you have all of this stuff you should have no trouble with the IRS if you get called in for an audit. Sometimes you can use cash, but it's best to conduct business with checks as much as possible because this provides you with traceable records. It's also easy to lose track of cash and have it stolen.
<< <i>Only buy/sell expensive coins... that should limit your inventory substantially! >>
Limits my cliental substantially also...
<< <i>Only buy/sell expensive coins... that should limit your inventory substantially! >>
So ahhhh.... Buy one coin at a time, sell it before I buy another one...lol. That should slow the process...
j/k
<< <i>
<< <i>So how do others out there do it. I have 100+ coins I buy a week and typically sell 100 lots of ebay a week if not more. >>
get receipts for everything and write out the things you don't get receipts for although they may not qualify at the time of an audit
and/or this
tally everything into 3 categories. 1. purchases 2. sales. 3. expenses and take it all to a CPA and they should help you break out those 3 categories even further. if you have no experience i don't recommend you tallying it all yourself. you may miss vital tax benefits etc by doing it yourself.
all refunds, consignments, your returns etc will ultimately fall into those categories. go through your checks, credit cards etc. leave no stone unturned.
. >>
^^^This^^^ 3 categories. The CPA does his magic after that.
Coin Elite