How do I reconcile the Xero Export with payouts under net settlement?

Prev Next

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

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

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

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

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 rather than your ROLLER Payments reports.

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.