posted on April 9, 2004 10:38:19 PM new
If you could design a accounting, tracking, reporting spreadsheet for ebay auctions/store items. What all would you want on it and what reports would you want to be able to get out of it?
The “givens” are it must
calculate ebay listing fees and FVF’s per item
calculate PayPal fee’s
The must have reports:
Profit by item
Profit by month
Sales by month
Store Sales
Auction Sales
Late Payments need to file NBP
No Payments need to file FVF
Paid items to ship
Invoice
Packing Slip
Items sold off ebay
The must have graphs:
Profit by month
Sales by month
My question to everyone here that sells on and off ebay is if you can have everything and everything ….
What is important to you to have in an accounting, tracking spreadsheet? And why?
I am interested in hearing from everyone … big sellers and little sellers.
posted on April 9, 2004 10:47:12 PM new
Sorry, I'm not at all representative of an average eBay seller, most likely, but I don't have any use for a tracking system.
Back when I was selling antiques and a good day at the flea market was 30 or 40 sales, it was not a whole lot of work to maintain an inventory database and update it with sold prices.
I'm not going to do that now. Time spent inputting data is time that detracts from making money. Reports in various formats are available from eBay itself, PayPal, and vrane, if you're willing to spend a few shekels. No keyboarding required.
I don't print packing slips. I don't run lists of FVFs to do; I start with the oldest inventory and send a reminder, an NPB notice, or an FVF depending on what's appropriate, simultaneously searching mail files to see if there's a good excuse in there somewhere or a PayPal payment I missed.
posted on April 10, 2004 05:55:51 AM new
I think it would be great if VENDIO would put a box next to SELL PRICE on Sales Mgr Pro that would allow you to insert a Cost of Goods Sold. With their ARCHIVE feature you might be able to generate a report showing Profit (final Auction Price vs Cost of Goods Sold). It seems most of the reports one can generate only let you see Sales, but not Profit.
posted on April 10, 2004 08:10:03 AM new
I hear ya, Fluffy. I started out this year with great intentions carefully logging in all inventory into QB Pro, entering sales, printing packing slips and the like. It lasted two months. While the idea behind it is good, it just takes up too much of my time and energy. I get fairly good reports from the program I use to administer my store and the reports from eBay are good enough for now. I have a separate checking account for inventory purchases and can figure out what I've spent and what I've made fairly easily.
posted on April 10, 2004 10:31:18 AM new
1) Item
2) Auction number or other
3) Date auction closed
4) cost
5) Sale price
6) bidder ID
7) Bidder e-mail address
8) Bidder name
9) Shipping cost
10) Date shipped
