posted on February 25, 2004 12:20:54 AM new
Hi all. I know I can use the calculator and laboriously add up all of the year's PayPal fees, but does anyone know an easy way to total them as a tax deduction? I'm sure the computer can do it somehow (a spread sheet or some such), but how do I isolate and export the fees from PayPal to my own computer? We have had well over a thousand PP payments in 2003, so it is no small matter. Thanks. Marshall
posted on February 25, 2004 04:13:34 AM new
Well Carguy, every year now I've emailed paypal about this inconvenience, and gotten a canned, get lost, reply.
The fact is that a competent programmer (apparently in short supply at ebay & subsidiaries) could easily add the code to give a weekly, monthly, or yearly running total of fees paid.
It's hard to understand why they wont do it...most businesses at least give you a yearly total...that's all we really need. What takes me hours of brain numbing work would take their computer a millisecond.
The cynical part of my mind says that it's because they feel it's an on balance cost to them.
I'll try another request today...fingers crossed....
posted on February 25, 2004 04:19:25 AM new
I use Quick Books and it's been a lifesaver. It prints out nice packing slips and tracks all of my income and expenses including seller fees. It also keeps track of all my inventory and I can print out purchase orders for inventory purchases. I like the sales reports that can be printed out. I have a separate business checking account and it also tracks that.
posted on February 25, 2004 05:13:39 AM new
QuickBooks would be a nightmare for me. I've looked at it. Since my stuff is not "buy a widget, sell a widget", but often more like "buy 20 widgets, sell 8, keep 5 for future use in crafting other widgets, scrap 7 widgets", inventory management makes no sense at all.
As for fees, you guys know PayPal has implemented Monthly Account Statements recently, right? They do give you a total of fees paid for the month. Unfortunately they are just for the last three months currently. But for 2004 you can print these out monthly as you go.
Doesn't help with 2003, I know. Sorry. For 2003 it's going to be a little more work. Go into History, select Download My History, choose Comma Delimited File (Completed Payments Only). Save the resulting .csv file. Then import that into Excel or your spreadsheet of choice.
posted on February 25, 2004 06:05:02 AM new
1. Find out what kind of car Meg is driving.
2. Determine how much ebay paid to buy it for her.
3. That's about how much your PP fees were.
posted on February 25, 2004 06:11:26 AM new
if you have a merchant account,your provider gives you a monthly statement,you are supposed to keep track of all expenses by month and year in your own bookeeping system.
besides paypal does not want you to realise how much they take from you,like jackwebb did
-sig file -------the lobster in the boiling pot of water who tries to prevent the others from climbing out.
posted on February 25, 2004 06:42:37 AM new
You guys know about PayPal's merchant rate, right? You have to be a "high volume" seller but that only means $1,000 a month in payments received over the last three months. $1,000 is nothing.
posted on February 25, 2004 07:18:32 AM new
What I did was go to your Paypal Merchant Acounts ~Downloadable Logs~and download to your Quicken Program.
From there you can get an instant tally of your fees.
posted on February 25, 2004 08:45:40 AM new
Wow Fluffy, thanks for the tip. I had not noticed the new monthly summary report.My bet would have been that Paypal would never volunteer to let you see your fees in one lump sum, lol.
Just pulled Nov thru Jan. This will make things a little easier for me.
posted on February 25, 2004 09:44:47 AM new
In preparing for the same thing, we did what Fluffy had suggested. You can sort payments and receipts and even those blasted fees. It's not that complicated when you get into it.
Wayne
Never explain -- Your friends do not need it and your enemies will not believe you anyway.
~ Elbert Hubbard