--- title: "How do I reconcile the Xero Export with payouts under net settlement?" slug: "how-do-i-reconcile-the-xero-export-with-payouts-under-net-settlement" description: "Understand how daily net settlement and fee changes affect funds in your Xero Export report, including ROLLER Payments and bank deposits." tags: ["Fix"] updated: 2026-11-10T12:43:32Z published: 2026-11-10T12:43:32Z canonical: "mysupport.roller.software/how-do-i-reconcile-the-xero-export-with-payouts-under-net-settlement" --- > ## Documentation Index > Fetch the complete documentation index at: https://mysupport.roller.software/llms.txt > Use this file to discover all available pages before exploring further. # How do I reconcile the Xero Export with payouts under net settlement? Under net settlement, ROLLER Payments takes payment fees out before your daily payout reaches your bank, but the Xero Export still shows the full amount guests paid. For example, if guests pay $5,000 by card in a day, the Xero Export shows $5,000 and your deposit is $5,000 less that day's fees. Knowing what sits between the two lets you match your Xero journals to your bank feed at month end. ## Match your bank deposits Match your bank deposits with the ROLLER Payments Payout Export, not the Xero Export. For each payout date, **Net Funds Paid Out** is the amount sent to your bank, and **Payment Fees** shows the ROLLER Payments fees and network fees taken out of each day's payments. One payout can include payments from several days, and funds usually reach your bank 0 to 2 business days after the payout date. | If you want to | Use | To learn more | | --- | --- | --- | | Match a deposit in your bank feed | **Net Funds Paid Out** for that payout date in the Payout Export | [ROLLER Payments reports overview](/v1/docs/roller-payments-reports-overview) | | See what else changed a payout (eg a chargeback, an adjustment or a ROLLER Capital repayment) | The rows under **Summary** for that payout date in the Payout Export | [ROLLER Payments reports overview](/v1/docs/roller-payments-reports-overview) | | Find payments that haven't been paid out yet at month end | **Pending Payout** for each transaction date in the Payout Export | [ROLLER Payments reports overview](/v1/docs/roller-payments-reports-overview) | | Record payment fees in Xero | **Payment Fees** in the Payout Export, or your monthly fee and tax statement | [Map GL accounts and tax rates for the Xero Export](/v1/docs/map-gl-accounts-and-tax-rates-for-the-xero-export) | ## Check the numbers yourself To check the numbers yourself, these three formulas take you from the Xero Export to your bank deposit. **Xero Export to Payout Export** (for the same dates): **Funds received (credit card)** = **Funds Received** + **Other Gateway Funds Received** − card tips **Each transaction date** in the Payout Export: **Funds Paid Out** = **Funds Received** − **Payment Fees** − **Pending Payout** If your export has a **Capital Grant** column, add it to **Funds Received**. **Each payout date** in the Payout Export, from the rows under **Summary**: **Net Funds Paid Out** = **Net Transactions** + the "Incl." rows (eg **Incl. Chargebacks** and **Incl. Adjustments**) − **Partner Fees** − **Capital Repayment** **Net Funds Paid Out** is the amount that reaches your bank. ## Record payment fees in Xero The Xero Export doesn't include a payment fee line, so add the fees in Xero yourself. If you post **Funds received (credit card)** to a holding account, the payouts and the payment fees together clear it. ## What sits between the card line and your payouts The card line in the Xero Export, **Funds received (credit card)**, won't match your payouts for the same days exactly. Here's what sits between them: - Payment fees: they're part of funds received and come out of the payout. - Tips: they're paid out to you, but the Xero Export moves them off the card line and onto **Gratuity payout**, which holds tips from every payment method. - Other card gateways: card payments you take through another gateway are on the card line but never reach your ROLLER payout. The Payout Export shows them in **Other Gateway Funds Received**. - Timing: payments taken at the end of the month are often paid out early the next month. Until then, they show in **Pending Payout**. - Refunds: ROLLER Payments reports show refunds net of fees. If the period includes refunds, compare with the [Detailed Transactions report](/v1/docs/detailed-transactions-report) rather than your ROLLER Payments reports. > [!NOTE] > If **Net Funds Paid Out** for a payout still isn't in your bank after 2 business days, contact your customer success manager or the [support team](/v1/docs/contact-roller-support). ## Related - [ROLLER Payments: Changes to the way fees are charged](/roller-payments-changes-to-the-way-fees-are-charged.md) - [ROLLER Payments reports overview](/roller-payments-reports-overview.md) - [Map GL accounts and tax rates for the Xero Export](/map-gl-accounts-and-tax-rates-for-the-xero-export.md) - [Xero Export (accrual accounting)](/xero-export-accrual-accounting.md) - [How ROLLER Payments handles settlements, payouts and refunds](/how-roller-payments-handles-settlements-payouts-and-refunds.md)