02-13-2023 09:55 PM
Any tips or suggestions or even cheap app suggestions that help track purchase prices on items I sell? I have a feeling tax time is going to be painful. I keep every purchase receipt. For shipping costs, pirate ship and ebay make it pretty easy. But what about refunds, returns and most importantly source costs.
Any experienced sellers have some advice? Beyond my stack of receipts strategy?
Thanks in advance.
Solved! Go to Best Answer
02-14-2023 08:47 AM
Your original post was a bit unclear as you asked for help in tracking your purchase prices on items you sell.
So what you are actually looking for is a way to track your sales verse cost of sales.
For me, my husband built me a database in Microsoft Access. I have data entry screens to enter my sales and a place to run reports as needed. And I have data entry screens to enter my COGS [cost of sales] as they arise with a place for reports too.
So many sellers this isn't something they need.
If you know how to utilize a worksheet program like MS Excel, you could build a worksheet to track your sales and COGS. Or you could look into something like Quickbooks.
02-13-2023 09:58 PM
All you have to do is download the report available to you in the Seller Hub, then the Payments tab, select Reports.
02-14-2023 08:28 AM
I'm referring to costs that eBay knows nothing about. i.e. the cost to purchase items I sell. Any suggestions?
02-14-2023 08:47 AM
Your original post was a bit unclear as you asked for help in tracking your purchase prices on items you sell.
So what you are actually looking for is a way to track your sales verse cost of sales.
For me, my husband built me a database in Microsoft Access. I have data entry screens to enter my sales and a place to run reports as needed. And I have data entry screens to enter my COGS [cost of sales] as they arise with a place for reports too.
So many sellers this isn't something they need.
If you know how to utilize a worksheet program like MS Excel, you could build a worksheet to track your sales and COGS. Or you could look into something like Quickbooks.
02-14-2023 09:09 AM
There are various ways to enter source cost on a listing........you could use SKU box; at one time some sellers used a "code" to enter it into a title or description........... But that still entails picking the amount up and putting into some spread sheet to come up with totals.
02-14-2023 09:13 AM
At this point; a pen will work
Using the 'reports' and just adding a line manually to that report showing 'cost of item'. The report will show the date, the description, the fee paid, the shipping paid (if you used Pending Payments- or go to Paypal for 'payments sent report' if you paid for shipping that way).
Then all you have to do is add the 'cost' to any of the blank lines that will come up on the report.
02-14-2023 09:16 AM
@dhbookds wrote:There are various ways to enter source cost on a listing........you could use SKU box; at one time some sellers used a "code" to enter it into a title or description........... But that still entails picking the amount up and putting into some spread sheet to come up with totals.
I don't believe that is what the OP is asking for. They just are looking for a way to track their sales and COGS. There are more costs to selling than just the price of the product. There are shipping supplies, labels, office supplies, inventory sourcing, etc.
02-14-2023 09:20 AM
This was what I was going by:
I'm referring to costs that eBay knows nothing about. i.e. the cost to purchase items I sell. Any suggestions?
message 3
02-14-2023 09:26 AM
@dhbookds wrote:
This was what I was going by:
I'm referring to costs that eBay knows nothing about. i.e. the cost to purchase items I sell. Any suggestions?
message 3
I understand, but as you and I know there is more COGS than just the price paid for the item any given seller is selling. And they did say "I'm referring to costs that eBay knows nothing about" the rest was just an example hence the "I.E. " to denote it is an example.
02-14-2023 09:32 AM
02-14-2023 09:34 AM
02-14-2023 10:32 AM - edited 02-14-2023 10:33 AM
I attach the cost documentation to the item when I list it, so that when the item is in inventory it has the cost documentation right with it.
When I ship an item, I remove the cost documentation and put it in a COGS folder.
Refunds already appear in the transaction detail report.
02-14-2023 11:03 AM
That is a great way to track your cost of the product you are selling. How do you track your other costs?