Monthly report showing amount paid in PayPal fees?

Cieslak
Contributor
Contributor

I need to know how much I pay each month in PayPal fees for tax purposes. I cannot find a way to get a report that includes this information. The only way I have managed it is to generate a monthly report for "balance affecting transaction" and compare it to the total monthly reported income on my 1099. There must be amore efficient/accurate way to do this!

Login to Me Too
7 REPLIES 7

sharpiemarker
Esteemed Advisor
Esteemed Advisor

@Cieslak 

 

Activity > Statements > Custom > Activity Download

Select Transaction type, date range, customize report fields, and report format.


Kudos & Solved are greatly appreciated. 🙂
Login to Me Too

Cieslak
Contributor
Contributor

I'm sorry, this does not answer my question. I have tried every type of report, "All transactions," "Balance affecting," and "Completed," and not a single one of them has line items listed that show the PayPal fees.

 

More specifically: I sell through an external merchant. The average product costs $8. Every report I see that has $8 sales shows them as $7.47, because I paid .53 in PayPal fees. I need a report that shows how much I paid in PayPal fees, not how much I received *before* or *after* the fees were paid. 

 

If I take one of those reports and get the grand total of money in and compare it to the amount listed on my 1099 for that month, the amounts differ. I assume the difference is the fees, but I am not certain. I need a way to have a report that tells me how much I pay in PayPal fees ONLY MONTHLY.

Login to Me Too

Jflorinki
Contributor
Contributor

I am also in need of this report and have tried all of them but do not see a field for fees.  

Login to Me Too

Posy
New Community Member

The best option I have come up with to quickly show each month's total fees without having to download & open 12 monthly statements is to use Excel (my solution for everything...). In PayPal's Report section, select Activity Download, I just used the Balance Affecting option, select the dates for the financial year and CSV format.

After downloading & opening the spreadsheet I deleted the columns I didn't need (just to determine the monthly fees you'd really only need the Date & Fee columns), changed the date format to mmm-yy then used Excel's Subtotals function to total at each change in date, and there they all are quickly ready for entry into your accounting system.

Though it's probably a good idea to save/print out each month's statements for tax documentation purposes.

 

Not sure why PayPay can't just add a simple report function though - any reason why this has to be so hard PayPal????  

Login to Me Too

Treacle100
New Community Member

Hi - I have just found this on all on page 2 of the Activity Summary reports (just create them per month) or you can view under Activity-> All reports -> Financial Summaries

Login to Me Too

Jflorinki
Contributor
Contributor

I do not see a page 2 on any of my reports.

Login to Me Too

Jflorinki
Contributor
Contributor

I see them now in the monthly statements now.  I was hoping to have this information available in the CSV file all in one document without recreating another.

Login to Me Too

Haven't Found your Answer?

It happens. Hit the "Login to Ask the community" button to create a question for the PayPal community.