- This topic has 1 reply, 2 voices, and was last updated 8 years ago by
.
-
Posts
-
-
Hello Everybody
Not sure if this has been discussed but I found it really helpful and thought I would share.I keep Excel spreadsheets on all my transactions so I can sort by type of item sold, amount sold for, recieved sales tax, which charities I paid etc. I also then can generate pivot tables that will give me Monthly and Year-to-Date totals by category (paid shipping, buying, profit or loss, etc.).
I was dismayed when it appeared PayPal stopped including the Item Title of what was paid for in my Monthly Statements! I just found it by going to Reports, Activity, All Transactions, Put dates you want, then click Custom Report Fields and make sure you check at the bottom: Include shopping cart details as line items under each transaction. I can then download and copy and paste into my existing sheets without having to stop and pull up individual transactions.
Elizabeth -
Hey CRE… Check out Auction Tracker. Been discussed about a year ago here so you can search for that thread. Auction Tracker is a huge spread sheet running on a ton of Macros. The developer sells it for $50 per year. It does everything you mention plus a whole lot more.
I think you can download a free trial. It goes back and pulls everything from Ebay into it and then presents everything in a bunch of different ways, costs, fees, sales and profit by month, quarter, year. Keeps track of inventory, mileage, tons of stuff. and at 450 a year it is great for those who love spread sheets. this guy knows how to build a monster SS.
The only draw back is that it will go back and gather all of the data but only for the past 90 days. So if you want a full year of data, you need to buy it during the last quarter of this year or before March of next year. That way you will be able to start off on Jan. 1st, 2019 with all your data.
The trial version is a fully working version only it just goes back and gathers 30 days of data for you to see.
It hooks up to your Ebay account via a “Token” which is what Ebay uses for 3rd party access and will allow this SS to access all of your pertenent data for tracking and analysis.
We used this SS for a couple of years but wanted something more robust and that would list and track on multiple sales platforms, so we went with a third party app called WonderLister and so have several other SL members. T-Satt here on SL uses SixBit.
Take a look at the Easy Auction Tracker web site, look over all the screen shots, check out the demos and even try out the trial. Unless you can build a monster of a SS and code it to do all these multitude of interlinked function, it is so much easier to just buy this spreas sheet app at $50 a year and be done with it and save all that time. Plus they run sales during the last part of each year, so if you buy early it is even less expensive. Current users also get an additional discount when you renew.
Here is the web site link: http://www.easyauctionstracker.com/
They also have several YouTube videos, so check it out and see if a pre-made spread sheet may be a much better fit. We realised reall quick that by using our spread sheets we were trying to re-invent the wheel and that our wheel was not going to be as good as this one was by a long shot.
But if PayPal provides even more data that you rely on, then maybe not. But maybe you can manually add the PP data. Easy Auction Tracker does allow edits and they also provide support and can add columns and function by request.
Good luck.. Hopefully this will provide more data for you to analyze.
Mike at MDC Galleries and Fine Art
-
- You must be logged in to reply to this topic.