If you’re not a fan of connecting your PayPal account directly to QuickBooks Online (QBO), maybe for security, privacy, or control reasons, you’re not alone. Plenty of people prefer to manage their bookkeeping workflows by uploading data manually.

In this post, I’ll walk you through the process of how to upload PayPal transactions into QuickBooks using a simple Excel file.

It’s quick, effective, and gives you total control over how your data is handled.

If you’d rather not rely on a direct bank feed or third-party integration, this is a great option.

This tutorial is based on a real workflow I use for my own business.

I’ll show you how to prep your spreadsheet, import both gross amounts and fees, and clean up any quirks QBO might throw your way.

Why Upload Instead of Connect?

QuickBooks makes it easy to connect PayPal directly, but with ease can come confusion.

Sometimes transactions don’t import cleanly, or the automatic feed can miss details you want to track.

If you prefer having full visibility into your data before it enters QBO, uploading is the way to go.

Step 1: Export Your PayPal Data

First, log in to PayPal and export the Balance Affecting Activity Report as a CSV file.

This report will show you payments received, payments sent, refunds, fees, and bank transfers and includes the information:

• Gross payment amount

• PayPal fees

• Net amount

• Transaction date

• Description or type

This gives you the flexibility to import both sales and fees accurately into QBO.

Step 2: Prep the Excel File

Once you open the exported file in Excel, review the columns. You should have one for gross amounts, one for fees, and one for net.

Here’s the key part:
You must manually insert negative signs for any fees or money leaving your account.

QuickBooks needs to know what’s going in vs. what’s coming out.

You can upload all the data in one shot, or break it into two uploads (sales and fees separately). Personally, I like keeping things clean and doing two uploads.

Step 3: Upload to QuickBooks

1. In QuickBooks, go to Transactions > Bank Transactions.
   

2. Click the Drop-down arrow next to Link Account, then choose Upload from file.

4. Drag and drop your prepared CSV or Excel file, then click Continue.
   

5. Select the account where the data should go (e.g., PayPal). If you don’t have one yet, click the +Add new link and add your account. Then click Continue.
   

6. Choose how many columns your file has for amounts, usually one.

7. Match your columns:

   • Date

   • Description (choose “Type” or whatever makes sense from your file)

   • Amount (I used Gross for the first upload)

8. Click Continue

9. Review the transactions and click Continue

Make sure everything looks right. If you see fees or other negatives that weren’t flagged correctly, fix them in your Excel file and re-upload.

Step 4: Upload PayPal Fees

Once your sales are uploaded, repeat the steps above to import the fees. Use the same Excel file and map the Fee column this time.

Don’t forget, these values should have negative signs!

After this second upload, your PayPal account in QBO will reflect both your incoming funds and the corresponding transaction fees.

Step 5: Clean Up and Categorize

Now that the transactions are in QBO, go back to the Bank Transactions tab and review what’s been added.

QBO may try to match these imported transactions with existing ones if you’ve previously entered sales manually or received payments.

Double-check:

• That each transaction is categorized correctly

• Fees are matched to their related sales (if needed)

• No duplicates are created

A Few Tips from Experience

Here are a few things I’ve learned doing this more than once:

• Positive/negative mistakes are easy to make. If your numbers aren’t balancing, check for missing minus signs.

• Upload gross and fees separately. It’s easier to manage and troubleshoot.

• Customize your Excel file for clarity. If the descriptions from PayPal (usually in the “Type” column) aren’t useful, modify them before uploading.

• QBO sometimes shows weird totals at first. If you upload 10 transactions and only see 8, give QBO a moment or try refreshing. It usually catches up.

When Manual Uploads Are Better

You might want to upload PayPal transactions into QuickBooks instead of connecting your account if:

• You only use PayPal occasionally

• You prefer to reconcile everything manually

• You need more control over what shows up in QBO

• You’ve had issues with the automated feed missing fees, double entering transactions or showing incorrect dates

Final Thoughts

Uploading PayPal data into QuickBooks Online doesn’t have to be a headache. Once you’ve done it a couple of times, you’ll find your rhythm.

Whether you’re a business owner doing it yourself or a bookkeeper helping clients, knowing how to upload PayPal transactions into QuickBooks gives you more flexibility and accuracy than relying solely on automatic connections.

If you’d like to see more examples or need help figuring out the best import process for your business, check out my other videos.

Want Help with Your PayPal Imports?

If importing PayPal data feels overwhelming or time-consuming, I can help! We can walk through your spreadsheet, clean it up, and upload it together.

You can book a training session. I’d be happy to work with you to streamline your workflow.