How to Download PayPal Transactions with a Running Balance

In this blog post, I’ll show you how to download your PayPal transactions to a CSV file with a running balance.

Quick Instructions:

  1. Click Activity in top menu
  2. Select All Reports
  3. Click Activity download in the left side menu
  4. Select Balance affecting in the Transaction type drop-down menu
  5. Select a Date range
  6. Click the Create Report button
  7. Your report will appear in the Activity reports list
  8. Click Download in the Action column
  9. Scroll to the right in the CSV to find the Balance column

Keep reading for a complete walkthrough with screenshots:

Download The Balance Affecting Report

To get our list of transactions we’re going to use the Balance Affecting Report. 

To get to this report click Activity in the top menu and select All Reports.

Opening the reports screen in PayPal.

In the left side menu click Activity download.

In the Transaction type drop-down menu select Balance affecting. Select a date range. Leave the format as CSV. Click the blue Create Report button.

Download a CSV of the Balance affecting report in PayPal.

The report will appear in the Activity reports list. When it’s available to download a blue Download link will appear in the Action column.

Here’s an example of what it will look like:

PayPal Balance Affecting report CSV

Where’s the running balance? Scroll to the right. I have it highlighted so you can see what it looks like:

The Balance highlighted in the Balance affecting report CSV downloaded from PayPal.

You now know how to download a report showing your PayPal transactions with a running balance. Scroll down for a video walkthrough.

☕ If you found this helpful you can say “thanks” by buying me a coffee… https://www.buymeacoffee.com/gentlefrog

If you have questions about PayPal reports I suggest contacting PayPal customer service.

Need some one-on-one QuickBooks assistance?
Share Now

This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

Leave a Reply

Your email address will not be published. Required fields are marked *

Read similar articles

Testing SupaClerk Bank Statement Conversion to CSV for QuickBooks Online Import

Learn how to convert a PDF bank statement into a CSV and then import it into QuickBooks Online.

How to Upload Checks for Printing in QuickBooks Online Using SaasAnt

Learn how to use Saasant to upload multiple checks to QuickBooks Online for printing.

Have a QuickBooks / Bookkeeping Question?

Let me know what you’d like to see in future videos, blog posts, and courses.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.