posted on October 22, 2001 11:02:19 AM
I track all of my auction activities through Excel including inventory.
I do NOT do a record of all of my fees though - that'd be a wee bit time consuming and usually a review of my billing statement is sufficient for me...
posted on October 22, 2001 01:10:54 PM
I use an Excel sheet for all fees, income, buyer's name, when shipped, when paid, etc. This is used for my income tax info. also.
posted on October 22, 2001 01:16:28 PM
Katiyana, How do you set your worksheet up - How do you integrate it with Auctionwatch ? Ive been trying to decide on what to trackand how to set things up -It'd be a big help to hear from you.
Thanks much
Ed
posted on October 22, 2001 05:01:35 PM
I'd love to hear more about how you do this, anyone - I am getting swamped with paperwork with 800+ auctions per month - how to be more efficient. I sell antiques and collectibles, difficult to even keep track of inventory!
posted on October 23, 2001 07:38:20 AM
I don't use Auctionwatch's services anymore since they started charging fees, so I can't tell you how to integrate an Excel Spreadsheet with AW.
What I do is copy/paste between My Ebay & individual auction listings into my spreadsheets for Ebay, and similarly for all other venues I sell in.
I currently have one sheet for each Ebay selling account, one for A4A auctions I've listed, one for Half.com, one for Yahoo, one for Other venues (basically any/all sales from the little freebie sites I list at, I don't track them separately).
On each sheet I track auctions with bids & sales only, not all auctions listed - I haven't found a need to track that level of detail yet. I have columns for (and doing this from memory) - Date closed, ID#, Title, High Bid, S/H collection, COGS (cost of good sold), High bidder ID, email, Date payment is received, Date item is shipped. This helps a lot in tracking NPBs or late payments because I filter my list to show only outstanding items.
I don't track the Ebay fees by item, but I do track them on half.com, and include a column for half.com fees on that spreadsheet.
I then have my receipt forms in another sheet, and just copy/paste into them to print packing receipts.
I then run monthly reports summarizing my sales activity for inputting into my accounting software. I don't track individual customers & vendors in my accounting software, only total Receivables & payables and found a nice freeware accounting program to handle it.
I'd be happy to email my spreadsheet system to anyone interested - I've got a blank copy available.
posted on October 23, 2001 07:40:21 AM
Forgot about Inventory - this is a fairly straight forward listing of items available sorted by type (I have a separate inventory code in my accounting software for each category of inventory I carry).
I track purchases, sales, and a carrying balance and reconcile that to my General Ledger each month when I run my financials. That'd be even easier to set up for someone.
