.png)
If you use PayPal to collect payments and Xero to manage your books, you’ve probably noticed that the numbers don’t always line up the way you’d expect. A $100 sale might show up as a smaller deposit after fees, be grouped into a payout with other transactions a few days later, or even be converted into another currency before it reaches your bank. One customer payment can affect your books several different ways.
Getting PayPal and Xero to reconcile comes down to four main steps: connect the two platforms, add PayPal as a bank account in Xero, reconcile each type of transaction correctly, and check that everything balances as it should. This guide covers each step, along with the situations that usually cause the most confusion, including processing fees, refunds, chargebacks, payment holds, and multi-currency payouts.
TL;DR
- PayPal doesn’t behave like a regular bank account. It deducts processing fees before sending payouts, folds refunds into later payouts, and converts foreign currencies, so the amount that reaches your bank usually won’t match the original sale.
- Record the full sale, not just the payout. Post the gross payment as revenue and record the PayPal fee as a separate expense. If you only record the net deposit, both your revenue and your expenses will be off.
- Choose the right reconciliation method for your transaction volume. The native Xero feed works well for lower volumes. As transaction counts grow or your setup becomes more complex, summary automation, sync tools, or manual journals may be a better fit.
- Treat fees, refunds, chargebacks, and payment holds separately. Each affects your books differently. Combining everything into one net deposit makes reconciliation harder and usually leaves your PayPal balance out of sync.
- Set up multi-currency carefully. PayPal uses its own exchange rates, which don’t always match Xero’s. Clearing accounts and separate mappings for each currency help keep your records accurate.
Why your PayPal deposit and your Xero bank line don’t match
Open your Xero bank feed and compare a PayPal deposit with the sale that generated it. Most of the time, the numbers won’t match. A $100 order might reach your bank as $96.02 after fees, be included in a payout with other transactions a few days later, or arrive after PayPal has converted it into another currency. The difference between what your customer paid and what actually reached your bank is behind most PayPal reconciliation problems.
There are three main reasons this happens. PayPal deducts its processing fee before sending the payout. Refunds and chargebacks are usually included in later payouts instead of being tied back to the original sale. And for international payments, PayPal uses its own exchange rate when converting currencies. It’s common for a single payout to include all of these at once, which is why the bank deposit won’t match your Xero bank line until each piece has been recorded correctly. The sections below explain how to handle each one.
How to connect PayPal to Xero
The first thing to do is connecting PayPal and Xero. You can either import your PayPal activity yourself or let it sync automatically. In practice, that gives you three options. Which one works best depends on how many transactions you process, how many details you want in Xero, and how much time you’re willing to spend on reconciliation.
Manual journal entries from PayPal reports
If you only process a small number of PayPal transactions each month, or you want complete control over every entry, you can skip the feed and work from PayPal’s monthly reports instead. Some accountants prefer this approach when cleaning up complicated books. Instead of working through dozens of imported transactions, they disconnect the feed and record one journal entry based on the monthly report. Every payment, fee, refund, and transfer still needs to be split and coded manually, so it’s accurate, inexpensive, and practical for low transaction volumes. Beyond a few dozen transactions each month, it usually becomes too time-consuming.
The native Xero PayPal feed
Xero’s built-in PayPal feed adds PayPal as a separate bank account and imports your activity automatically. Payments, fees, withdrawals, and refunds each appear as their own transaction, and there’s no extra cost beyond your Xero subscription. Importing the data is only the first step, though. The feed brings the transactions into Xero, but you still need to decide which lines are sales, which are fees, which are transfers, and how to deal with holds or currency conversions. For a consultant sending the occasional invoice or a business with a small number of subscription payments, that may be enough. As transaction volume grows, the number of individual feed lines can become difficult to manage.
Third-party automation tools
Third-party tools connect PayPal to Xero, and many of them pull data from your other sales channels too. Instead of recording each payout as one transaction, they break it down into the sales, processing fees, refunds, transfers, and other activity behind the payout before anything reaches your books.
How much detail you get depends on the tool.
- Some tools sync every individual order, giving you a complete transaction history.
- Other solutions create summarized settlement entries, which keep your ledger shorter and easier to scan.
- Some, including Synder, let you switch between detailed transaction sync and summary entries, so you can choose the approach that works best for your business.
There’s a subscription cost, of course. Once your transaction volume starts growing, the time you save will usually make up for it.
Synder syncs all PAyPAl transaction details into Xero automatically, including the transfer from PayPal to your bank account, so it can be matched against the bank statement. Instead of importing raw feed lines, it breaks each payout into the underlying sales, fees, refunds, and chargebacks, then matches those records against PayPal’s own data. If something doesn’t balance, it flags the transaction so you only need to review the exceptions.
Gross sales and processing fees are recorded separately, PayPal’s own exchange rates are used for multi-currency transactions, and income can be categorized by product or service for more detailed reporting. Because it also syncs data from more than 30 sales and payment platforms, you can manage PayPal alongside Shopify, Stripe, Amazon, and others in one place, using either per-transaction sync or summary sync depending on how you want your books structured.
| If you’d like to see how that works with your own accounting setup, you can book a demo with Synder. |
Quick comparison of methods
The table below maps each method to the business it fits.
| Method | A good fit if… | Handles fees automatically | Cost |
| Entering journal entries from PayPal reports manually | You only have a few PayPal transactions to record each month. | No | Free |
| Using Xero’s built-in PayPal feed | You mostly send occasional invoices or don’t process many PayPal payments. | No | Free with Xero |
| Connecting PayPal with a third-party tool (e.g., Synder) | You handle a high volume of transactions or sell across multiple channels. | Yes | Subscription |
When should you choose an automation tool?
A few common signs can help you tell when you’ve reached the manual reconciliation limit.
Transaction-volume signals
For many businesses, manual reconciliation starts becoming difficult at around 500 transactions a month. Work that used to take a few minutes can turn into hours of reviewing transactions one by one, and it’s easier for mistakes to slip through. Synder’s 2025 survey of 424 senior finance leaders across ecommerce and SaaS found that automating work such as reconciliation saved teams an average of 8.36 hours per employee every month, about the equivalent of a full workday. If reconciliation is taking that much time every month, it’s probably a good time to look at automation.
Multi-channel signals
The same order can come into Xero through two different connections and end up being counted twice, while reconciling PayPal, Shopify, Stripe, and Amazon separately means repeating the same work over and over.
For instance, Tentho, an accounting firm whose clients sell across PayPal, Stripe, Shopify, and Amazon, ran into exactly that problem. Their systems didn’t consolidate the different sales channels, and complex PayPal transactions were being grouped into single journal entries. After automating, the firm consolidated all of those platforms into clean books, saving about 150 minutes a month on PayPal reconciliation and around 10 hours a month overall. As Tentho’s Strategy and Finance Manager put it:
Synder’s more user-friendly than the other platforms. Everything can be housed under one roof, rather than individual accounts. We can deliver more detailed information to the client, more advice, more guidance. We can lean less towards the data entry and more into streamlining the financial side of the business.
Edward Dick, Strategy and Finance Manager at Tentho
Multi-entity signals
Multiple PayPal accounts feeding into the same Xero file are difficult enough to handle. Add different currencies or business units, and keeping everything straight by hand becomes a real challenge. Every account has its own payouts, processing fees, and currency conversions to reconcile. A tool that consolidates all of those accounts into one Xero file and breaks each payout into its individual parts makes the whole process far easier to keep on top of.
How do you set up PayPal as a bank account in Xero?
Before you can start reconciling PayPal transactions, you’ll need to set PayPal up as its own bank account in Xero. The setup only takes a few minutes:
- Open Accounting in Xero, go to Bank Accounts, and select Add Bank Account.
- Search for PayPal, sign in with your PayPal credentials, and choose the correct currency for the account.
- Create a separate PayPal account instead of linking PayPal to your main bank account. Keeping them separate makes transfers between the two much easier to reconcile later.
- Assign PayPal processing fees to a processing-fee or bank-charges expense account, so they appear correctly on your profit and loss statement instead of being rolled into the net deposit.
- If you accept payments in more than one currency, enable multi-currency before connecting the account. From there, decide whether you’ll convert everything into your home currency or maintain a separate PayPal account for each currency.
- Choose the feed start date carefully. If you go back too far, Xero can import historical PayPal transactions you’ve already recorded.
If you need to import historical PayPal data, you can use the feed start date, a CSV file, or an automation tool. Just stick to one import method for each time period. Combining a bank feed with a CSV import for the same date range is one of the most common causes of duplicate transactions.
How do you reconcile PayPal fees, refunds, and chargebacks in Xero?
With PayPal set up as its own account, the rest of the reconciliation process becomes much more straightforward. You need to record each part of a transaction separately instead of treating the net deposit as a single amount.
The transaction types below are the ones that most often cause reconciliation problems.
Recording PayPal fees as a separate expense line
PayPal processing fees usually appear in Xero as their own “spent” transaction. Record the fee with a Spend Money transaction and assign it to your processing-fee expense account. Keep it separate from the gross sale, which should be recorded as revenue. Recording the two separately gives you an accurate picture of both your sales and your processing costs.
PayPal’s standard US rate for invoicing and checkout is 3.49% plus $0.49 per transaction, while standard card payments are typically charged at 2.99% plus $0.49. The exact fee depends on the payment method, your region, and PayPal’s current pricing, so the amount can vary over time.
Posting refunds and credit notes
A refund is recorded much like a sale, just in reverse. Create a credit note in Xero, then match it to the refunded PayPal transaction. That way, both your revenue and your customer records stay accurate.
If you’re issuing a partial refund, enter only the amount that was actually returned, not the full invoice value. Matching the refund to the original sale, instead of recording it separately, keeps your revenue from being overstated.
Handling chargebacks and disputes
A chargeback cancels out a payment you’ve already recorded, so it needs to be recorded the same way. Create a journal entry for the reversed payment along with any dispute fee, then reconcile both against the matching PayPal transaction.
If a chargeback isn’t matched properly, your accounts receivable stays higher than it should, and the difference can continue carrying over from one reconciliation period to the next.
Reconciling PayPal hold and release transactions
PayPal sometimes places funds on hold before releasing them, especially for newer accounts or higher-value orders. The money may appear in your PayPal balance, but it isn’t available yet.
Record the held amount in a suspense account instead of posting it directly to sales, and note in the description whether the transaction is a hold or a release. Once PayPal releases the funds, move the amount out of the suspense account and into sales or your bank account. That brings the suspense balance back to zero and keeps a temporary hold from affecting your revenue.
Reconciling multi-currency PayPal balances in Xero
Multi-currency transactions are often where reconciliation starts to get difficult. PayPal and Xero don’t usually use the same exchange rate, so even when everything else is correct, the numbers may not line up. The good news is that you can avoid most of those differences by setting things up properly from the start. Before you connect any PayPal account that receives foreign payments, make sure multi-currency is enabled in Xero.
When PayPal converts a sale before payout
If PayPal converts a foreign-currency sale before sending the payout, it uses its own exchange rate. That rate is often different from the one Xero would apply, which is why the amount recorded in Xero may not match the amount that reaches your account unless you use PayPal’s actual conversion rate for the transaction.
A clearing account helps keep everything in balance. Record the payment to the clearing account first, post the sale, then transfer the funds from the clearing account to your checking account. Once the payout is complete, the clearing account should return to zero.
If you’re still holding a foreign-currency balance at the end of the reporting period, run Xero’s revaluation tool to recognize any unrealized foreign exchange gains or losses.
Holding multiple PayPal currency accounts in Xero
If you keep PayPal balances in more than one currency, you’ll need to decide how you want to organize them in Xero. One business that came to us had eight PayPal accounts, each handling more than ten currencies. Mapping every account and currency one-to-one would have meant creating about 80 separate accounts in Xero.
Most businesses choose one of two approaches. You can consolidate everything into your home currency to keep your chart of accounts simpler, or create separate sub-accounts for each currency to preserve the original currency values. In the second setup, each currency has its own clearing account and checking account, so nothing is converted unless you decide to convert it.
Learn more about PayPal bookkeeping and accounting.
How do you know your PayPal-Xero reconciliation is working?
A simple way to check that everything is set up correctly is to compare the PayPal balance in Xero with your actual PayPal balance on the same date. If the numbers match, you’ve recorded everything correctly. If they don’t, the difference usually tells you where to start looking.
Before you rely on the process for all your PayPal transactions, try it with a small batch first. Reconcile a few recent transactions, including a sale with a processing fee, a refund, and a transfer, then check that each one was recorded the way you expected. If you work with multiple currencies, include a converted payment as well and make sure the clearing account returns to zero after the payout.
Make the same comparison every month instead of leaving it until year-end. Finding one missing transaction is usually quick. Finding the cause of several months’ worth of differences is a lot more work.
Conclusion: keeping PayPal and Xero in sync
Reconciling PayPal in Xero starts with recognizing that the amount arriving in your bank account usually won’t match the original sale. PayPal deducts processing fees, customers request refunds, chargebacks happen, payments can be placed on hold, and exchange rates affect international transactions. Record each of those separately instead of treating the net deposit as a single sale, and your revenue, expenses, and cash balance will stay accurate.
The best approach depends on how much PayPal activity you’re dealing with. If you only process a small number of transactions, Xero’s built-in PayPal feed or monthly journal entries may be all you need. As the number of transactions grows, or if you’re selling across multiple channels or working with multiple currencies, keeping everything updated manually takes a lot more effort. That’s when automation often becomes the more practical option.
Whatever method you use, compare the PayPal balance in Xero with the balance in your PayPal account every month. It’s much easier to track down one missing transaction while you’re closing the books than to work through several months of differences later.
FAQ
What are the payment processing fees for using Xero?
Xero doesn’t charge transaction processing fees. You pay for your Xero subscription, while the payment processing fees come from your payment provider, in this case, PayPal. Record those PayPal fees in Xero as a separate expense. They aren’t a Xero charge.
Do I need a clearing account to reconcile PayPal in Xero?
Not necessarily. If you only use one currency and your PayPal activity is fairly simple, you can reconcile everything without a clearing account. Once you’re working with multiple currencies or using automation, though, a clearing account becomes much more useful. It gives payments, currency conversions, and transfers a place to move through before they’re matched, making it easier to check that every part of a PayPal payout has been recorded correctly.
Why is my PayPal balance in Xero different from PayPal?
Usually, the difference comes down to something small. You might have missed a processing fee, recorded a transfer as income, forgotten to match a refund or chargeback, or imported the same transaction twice. Sometimes a transaction doesn’t get imported at all. The easiest way to find the problem is to run reconciliation reports for the same date range in both PayPal and Xero, compare the totals, and work through the differences until the balances match.
How often should I reconcile PayPal in Xero?
At least once a month. If you’re processing a larger number of PayPal transactions, it’s a good idea to reconcile every week instead. Keeping up with it regularly makes it much easier to spot missing or duplicate transactions while they’re still fresh, instead of untangling a much bigger list of differences at month-end.
