To import PayPal transactions into QuickBooks Online, treat your PayPal balance as a separate bank account. Download PayPal's activity report as a CSV, cut it down to date, description and amount columns, then upload it to that account. Record withdrawals to your bank as transfers, and keep PayPal fees on lines of their own.
Setting up PayPal as its own bank account in QuickBooks Online
PayPal holds money for you the way a bank does, so it needs its own bank-type account in QuickBooks Online. Sales land in it, fees come out of it, and withdrawals move its balance to your checking account. If PayPal lines go into checking instead, the checking register stops agreeing with your bank statement.
You can create the account during the upload itself. Intuit's manual upload help page shows an Add New option on the screen where you pick the QuickBooks account, which creates a bank account on the spot. Name it plainly, such as "PayPal" or "PayPal business", so nobody confuses it with checking later.
Two choices matter at setup:
- The start date. Pick the first day you want PayPal tracked in your books. Everything before it is history you will not upload.
- The opening balance. Enter the PayPal balance as it stood at the end of the day before your start date. PayPal's report can show a running balance column, which makes this number easy to find.
If you also accept Venmo or Cash App, give each of those its own account too. The Venmo import guide and the Cash App import guide follow the same pattern with their own file quirks.
Which PayPal activity report columns does the upload need?
The QuickBooks Online bank upload reads only a date, a description and an amount, either as one signed amount column or as separate credit and debit columns. PayPal's activity report has many more columns than that, so you download it, keep the few the upload needs and delete the rest before you upload.
PayPal's Activity Download report documentation describes the report: you pick a date range of up to 12 months per report, within the last seven years, and choose a format. CSV is one of the formats, and CSV reports are capped at 50,000 records, with bigger reports split into several files inside a ZIP. The same page lists the columns that matter here:
- Date of the transaction.
- Type, which names the event, such as a payment received or a withdrawal.
- Gross, the full amount, including fees.
- Fee, the PayPal fee on that transaction.
- Net, which is usually gross minus the fee.
- Balance Impact, which says whether the row was a debit, a credit or a memo.
- Transaction ID and Reference Txn ID, which tie a refund or reversal back to the payment it undoes.
For the upload, keep Date, a description you build from Name and Type, and the money columns you plan to use. Delete the rest, then check the file against Intuit's rules on the same help page: 350 KB or less, up to 1,000 lines, one date format throughout, and blank cells instead of zeros in the money columns.
PayPal's documentation gives three Balance Impact values: Debit, Credit and Memo. A memo row is neither a debit nor a credit to your balance, so delete those rows, or the uploaded account will drift away from PayPal's own balance.
Gross, fee and net: two ways to book a PayPal sale
A PayPal sale can be booked at its gross amount with the fee on a separate line, or as a single net amount. Gross with a separate fee is the better choice for most businesses, because sales stay at their true size and PayPal fees add up to a real expense figure on your profit and loss report.
Booking net only is quicker, but it hides the fee inside your income. A year of sales then looks smaller than it was, and you have no fee total to check against PayPal's annual figures.
A worked example in four columns
The table below shows five made-up PayPal rows and the upload file they become. The values are examples only.
| PayPal row (example) | Date | Description | Credit | Debit |
|---|---|---|---|---|
| Payment received, gross 120.00, fee 4.18 | 03/04/2026 | Example Client A payment | 120.00 | |
| Same payment, fee | 03/04/2026 | PayPal fee Example Client A | 4.18 | |
| Payment received, gross 45.00, fee 1.92 | 03/09/2026 | Example Client B payment | 45.00 | |
| Same payment, fee | 03/09/2026 | PayPal fee Example Client B | 1.92 | |
| Withdrawal to bank, 150.00 | 03/12/2026 | Transfer to checking | 150.00 |
Each sale became two rows: one for the gross amount and one for the fee. In a spreadsheet that means copying each sale row, putting the fee in the copy's money column and labelling its description "PayPal fee". The headers read Credit and Debit, without the word "amount", as Intuit's upload page asks.
Check the total before you upload. The credits less the debits in this example come to 8.90. That figure should equal the change in PayPal's running balance from the start of the period to the end. If it does not, a row is missing or a memo row slipped through.
Once the lines are in, a bank rule that sends anything with "PayPal fee" in the description to a merchant fees expense account saves you categorizing them one by one.
PayPal withdrawals to your bank, booked as one transfer
A withdrawal from PayPal to your bank is money moving between two accounts you own. It shows up twice, once in the PayPal upload as money out and once on your bank statement as money in. Book it once as a transfer between the two accounts, and match the second appearance to that transfer.
When the PayPal line comes up for review, choose transfer as the transaction type and pick checking as the other account. When the bank line arrives a few days later, QuickBooks should offer it as a match to the transfer you already recorded. Accept the match instead of adding the deposit as new.
The usual slip is adding the bank deposit as income. Your PayPal sales were already counted as income when they came in, so a withdrawal booked as income counts the same money a second time.
Dates rarely line up exactly. The bank may post the deposit a day or more after the withdrawal shows in PayPal. A gap of a few days is normal and should not stop the match.
Are PayPal refunds, holds and currency conversions special cases?
Refunds, holds and currency conversions are the PayPal rows that do not behave like plain sales. Each still needs a line in the upload if it changed your balance. What differs is the description you give it and the category you choose once it is in QuickBooks.
- Refunds. A refund to a customer is money out of PayPal. Give it a description that names the customer and the word "refund", and categorize it against the income account the original sale used. The Reference Txn ID column links it to the original payment if you need to trace it.
- Holds and releases. A hold moves money from your available balance into a reserve, and a release moves it back. If the report shows them as balance-changing rows, upload them as a pair and categorize both to the same holding account so they cancel out. If they show as memo rows, leave them out.
- Currency conversions. If a sale in another currency appears in your report with conversion rows beside it, upload the amount in your home currency and leave out the foreign-currency side, so the PayPal account stays in one currency.
When one of these rows is too odd to describe cleanly, leave it out of the file and enter it by hand afterwards. Payments that arrive with extra details, such as a check number, can lose them in a plain upload. Importing checks with their numbers shows how to keep that detail when it matters.
Double-counted PayPal sales from two import routes
Double counting happens when the same PayPal money reaches QuickBooks Online by two routes. The most common case is uploading PayPal activity while also booking each bank deposit from PayPal as a sale. Another is running a PayPal connection or app alongside a manual upload of the same months.
Pick one route for PayPal activity and one for the bank, then let transfers join them. A quick check after each month catches the problem early:
- Compare the PayPal account's closing balance in QuickBooks with PayPal's balance on the same date.
- Look at income for the month. If it is roughly the sum of your sales plus your withdrawals, a withdrawal was booked as income.
- Search the bank register for deposits from PayPal that are not linked to a transfer.
If you find a duplicate month, undo that upload and import it again with only the missing rows. For the next upload, start the file the day after the last transaction already in the PayPal account, which is the rule Intuit's upload page gives for avoiding repeats.
PayPal's report also offers IIF, for US accounts only, and QIF, a Quicken format. IIF suits QuickBooks Desktop rather than Online. If you are filling in years of history in Desktop, importing old bank statements into QuickBooks Desktop covers that route. For the bank side of the transfer, SimpleBankConvert is being built to turn a PDF bank statement into an upload file, so the deposits from PayPal arrive ready to match.