| Author |
Replies: 10 / Views: 1,293 |
|
|
Pillar of the Community
Russian Federation
1557 Posts |
Every time I make a purchase, I write down how much I bought a new coin in my collection. I also convert this amount into dollars, write the date of purchase and how much I paid for delivery (if there is one). Are you doing something similar? I am particularly interested in the opinion of dealers (of all calibers). How do you keep records of purchases and sales of materials? How do you calculate the profit, do you take into account the cost of delivery? Do you use programs or is paper your friend? I will give an example for clarity. I bought 5 coins for $5 + paid $3 for delivery. How should I break up the delivery ? What if one coin is worth $20 and the other is only $3? it would not be wise to split the delivery equally across all purchases.
|
|
|
|
Pillar of the Community
United States
883 Posts |
I don't deal at all but I would think you would split the purchase price on the items in inventory and separate the shipping cost as business expense in year incurred. In your example, you would have the option of either evenly splitting the purchase price across all 5 coins or allocating the purchase price across the coins as you deem appropriate. If you chose the second option, be prepared to defend an audit with receipts showing per item purchase price or a defendable document showing relative value.
You allocate purchase costs against income from sales on a per item basis as items sell.
As for shipping charges associated with building inventory or to sell inventory, that could be deducted as an operating expense against income in the year it is incurred.
Edited by PlumCrazy814 01/27/2022 11:07 am
|
|
Moderator
 United States
187702 Posts |
I keep a log in a spreadsheet, but it is only accurate back to 1997. For older stuff I need to look at the inventory spreadsheets and hope the "notes" column has more details.
|
|
Pillar of the Community
United States
3848 Posts |
For coins that I buy and sell, I have a composition book where I write down the item, buy price, sold price, dates, profit, and location of where I purchased the item. For multiple items in a lot purchased, I split the cost evenly among the coins, even though it may not be exact numbers. The price paid for an item should include shipping and any fees associated with purchasing that item.
I use all paper, although it can be extremely tedious keeping records that way. I recommend doing your records electronically, especially if you planning on entering in a lot of items. I only flip a handful of items per month so a composition notebook is good enough for me.
Suffering from bust half fever. Want to learn how to attribute early half dollars by die variety? Click Here: http://goccf.com/t/434955Shoot me a PM if you are looking to sell bust halves.
|
|
Pillar of the Community
 Russian Federation
1557 Posts |
I also use paper, I trade a very small number of coins, but I would like to have the exact amount that I earned when selling coins. I will be very grateful if you show me your examples.
|
|
Bedrock of the Community
United States
20753 Posts |
A long time ago I used to try keeping track of all my coins, However, as the collection grew and grew, I realized that someday I would need an entire house for all the documentation. That thought was enough for me to stop even trying to keep records of all that stuff.
|
|
Pillar of the Community
4628 Posts |
I have a basic excel file for all my good coins.
Currently that is my UK Halfcrowns, Florins, Shillings, Australian Florins and NZ Coins from Halfcrown to Threepence.
I have back ups on hard drives too, and update it regularly. This ties in with my contents insurance and the rest of my coins, I at least have a Numista record (9044 coins strong).
All of my albumed coins (About 1500 have home made cards with details of type, date purchased and from whom).
|
|
Valued Member
United States
64 Posts |
Exact Change by Wildman Software. Full records and images. Very configuarable. Works great for me.
|
|
Moderator
 United States
187702 Posts |
Quote: I realized that someday I would need an entire house for all the documentation. Digital > Paper. 
|
|
Moderator
 United States
94786 Posts |
When I buy a coin, I print out the reciept, then save it as a PDF. Then I enter the data into an excel sheet to keep a compilation of my coin series in one place. BUT before the coin is stored away in an album or 2x2 or a box, I take a photograph of it both sides to document the condition I got it as when it arrived.
Edited by Dearborn 02/01/2022 12:25 pm
|
|
Pillar of the Community
United States
1316 Posts |
If the question is business related for tracking sales and expenses, you'd best find and talk to a local accountant. These carry tax implications and our opinions, especially from other countries, don't matter. Different countries view the details of calculating COGS, cash/accrual methods, etc differently. The devils are in the details, and only your local accountant can steer you correctly. "The coin forum said this or that" doesn't carry any legal support if you landed in the wrong place.
|
| |
Replies: 10 / Views: 1,293 |
|