Is this enough documentation or do I need to be keeping more?
At the beginning of the year I started up a small home business purchasing and re-selling consumer electronics products. Business license and registered with the state (Georgia) as DBA. I am a sole proprietor and the only one involved in the business.
January and February have been kind of rocky. I was learning the best and cheapest ways to ship, the quickest ways to test my products (stuff like memory cards coming from wholesale suppliers that could unknowingly be selling fake/misrepresented cards to companies, etc.) I sell on Ebay only, and I only accept Paypal as a payment method. So every sale, sale date, product description, Ebay fees, Paypal fee, date sold, etc. are all there. When I was a little more naive, I unknowingly flipped some products before I knew of a solid way to test them, so I got some returns and had to refund. Long story short, January and the beginning of February turned into an accounting nightmare in regards to logging everything. I utilize the "Outright" program on Ebay, which pulls all of my Paypal data. So it basically organizes everything, tells me the final profit, the total fees/business expenses for each month and year, the product description, date sold, sale price, Paypal fees, Ebay fees…all of that. The only thing it doesn’t log is the original purchase price and purchase date. I’m pretty much screwed for January and February in regards to proper documentation in regards to bookkeeping, but I do have the final profit amount for both months, all of the expenses and fees, payments received, etc. and I will just have to eat the taxes on the purchase amount vs. re-sold price. So taxing the whole instead of only the profit.
Is there a better way to keep track of this? I did make a spreadsheet in January. It has the item description, purchase date, purchase price, purchase tax paid, purchase shipping fee (I buy all of my inventory online and get it shipped to me from wholesale companies using my tax id), resale date, resale price, shipping fee, Georgia sales tax charged (if they were in my state – I only had one sale to Georgia during January and February and I have logged and paid taxes to the state on that), Ebay Listing/Insertion Fee, Ebay Final Value Fee, Ebay Final Value Fee on Shipping, Paypal Fee and then Finally Profit/Loss at the end.
Yeah, that’s a lot of fields to log for each transaction. Outright seems to do a really good job with keeping up with everything and letting me just print out all fees and sales with proper dates and descriptions. The only thing it doesn’t keep up with is the purchase price. I try to print out the invoice each time I buy something to re-sell and staple that to the printed paypal transaction paper for each transaction, when I have sold it. Is there a good way to keep this from being too tedious? We’re talking probably…$4,000 a month in sales in February. January was rather slow.
At tax time, Outright supposedly makes it easy to just see the total profit, total fees/deductions and such. But it doesn’t have an option to compare my purchase price per item to the re-sale price. So I could print that stuff out…but I’d end up paying taxes on everything for the whole year as a $0 purchase price value.
Any advice from sellers? Apart from "Get a CPA to do it all for you"…I wouldn’t make anything if I did that.
I keep all my items, prices, descriptions, final payouts, etc listed in an excel workbook. It does my calculations for me once I put the formulas in and I have a nice setup now after using it for a while. I don’t have to pay any fees to use it and I’m just very organized and attentive to it. If your business is so large that you can not handle the books on your own, I suggest hiring an employee. It shouldn’t take much training to keep good records. Just discipline.
Recent Comments