calculate-loan

01 Loan payments

Card Payment in Xero: Setup and Recording

Calculator No. 01-21847 · Updated · Formula and assumptions shown below

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

Card payment in Xero means recording customer credit or debit card transactions and reconciling the fees, and it also includes paying your own business expenses by card. This article explains how to set up card payment processing in Xero, record card sales and fees, handle refunds, and reconcile your bank account accurately.

Formula

The net deposit from a card payment is the sale amount minus the percentage fee and any fixed per-transaction fee:

Net deposit = Sale amount − (Sale amount × Fee rate / 100) − Fixed fee

  • Sale amount – the total charged to the customer, in dollars.
  • Fee rate – the percentage the processor charges, e.g., 2.9%.
  • Fixed fee – a flat amount per transaction, e.g., $0.30.
  • Net deposit – the amount that actually lands in your bank account.

Worked Example

Using the defaults: a $100 sale, a 2.9% fee, and a $0.30 fixed fee.

  1. Percentage fee = 100 × 2.9 / 100 = $2.90
  2. Total fee = 2.90 + 0.30 = $3.20
  3. Net deposit = 100 − 3.20 = $96.80

The calculator shows a net deposit of $96.80 and a total fee of $3.20, matching the formula.

Assumptions

  • The fee is a simple percentage plus a fixed amount, with no monthly or annual fees.
  • The full sale amount is deposited in one lump sum, not split across multiple payouts.
  • No refunds, chargebacks, or currency conversion are included.
  • Actual processor fees vary; check your merchant statement for the exact rate.

How Card Payments Work in Xero

Xero itself does not process card payments. You connect a third-party payment service (like Stripe, Square, or GoCardless) to your Xero account. When a customer pays an invoice online, the payment service charges a fee and deposits the remaining amount into your bank account. Xero then imports the bank transaction, and you match it to the invoice and record the fee as an expense.

The key steps are:

  • Enable a payment service in Xero under Settings > Payment Services.
  • Link the service to your bank account where deposits arrive.
  • Send invoices with a “Pay Now” button.
  • When the deposit appears in Xero’s bank feed, match it to the invoice.
  • Create a separate expense transaction for the card fee.

Recording a Card Payment Sale

When a customer pays an invoice by card, the full invoice amount is recorded as paid, but the bank deposit is less. For example, a $100 invoice paid by card results in a $96.80 deposit. In Xero, you:

  1. Go to the Bank Account and find the $96.80 deposit.
  2. Click “Match” and select the $100 invoice.
  3. Xero will show an imbalance of $3.20.
  4. Click “Add” to create a new transaction for the fee, selecting a “Card Processing Fees” expense account.
  5. Confirm the match.

This records the full sale as income and the fee as an expense, keeping your profit and loss accurate.

Recording Card Fees as an Expense

Card fees are a business expense. In Xero, you can either:

  • Create a specific expense account named “Card Processing Fees” or “Merchant Fees”.
  • Use the “Add” option when matching the bank deposit to the invoice.
  • Or manually enter a spend money transaction for the fee if it appears separately in your bank feed.

Make sure the fee is not accidentally deducted from the invoice amount. The invoice should show the full amount, and the fee should be a separate expense. This way, your sales revenue is not understated.

Common Problems and How to Fix Them

One common issue is the deposit amount not matching any single invoice because the payment service batches multiple transactions. In that case, you can:

  • Match the deposit to multiple invoices using the “Find and Match” tool.
  • If the deposit is a net amount after fees, create a “Bank Charge” for the total fee and allocate it proportionally or to a single expense account.
  • Use the payment service’s report to see which invoices are included in the deposit.

Another issue is forgetting to record the fee, which overstates your bank balance and understates expenses. Always reconcile the fee at the same time as the deposit.

Refunds are also tricky. When you refund a card payment, the payment service deducts the refund from your next deposit. In Xero, you should issue a credit note against the original invoice, then match the negative bank transaction to that credit note. The fee for the original transaction is usually not refunded, so you may need to adjust the fee expense.

Choosing a Payment Service for Xero

Different payment services have different fee structures, settlement times, and currencies. When choosing one, consider:

  • Percentage rate and fixed fee per transaction.
  • Whether there is a monthly fee or setup cost.
  • How long it takes for funds to reach your bank account.
  • Whether the service supports your country and currency.
  • Whether it integrates directly with Xero or requires a third-party connector.

Xero’s own payment services (like Stripe or GoCardless) are built in, but you can also use other processors and record the deposits manually. The choice affects your fees and cash flow, so compare current rates from the providers.

Costs and Fees

Card processing fees typically range from 1.5% to 3.5% plus a fixed amount per transaction, depending on the provider, card type, and volume. Some providers charge a monthly fee, while others charge only per transaction. There may also be fees for chargebacks, refunds, or currency conversion.

In Xero, you can track these costs by creating a dedicated expense account. This helps you see exactly how much you are paying in card fees each month. To estimate your net deposit for a given sale, use the calculator above with your actual fee rate.

Safety and Accuracy Tips

  • Always reconcile your bank feed daily or weekly to catch missing fees or duplicate deposits.
  • Use a dedicated expense account for card fees so your reports are clean.
  • Do not record the net amount as sales; always record the full invoice amount and the fee separately.
  • Check your payment service’s settlement report against Xero’s bank feed to ensure every deposit is accounted for.
  • If you accept international cards, be aware of currency conversion fees, which may appear as separate line items.

This estimate is for educational purposes; your actual deposit and fees depend on your processor’s terms, and your bank statement is the final source of truth.

Frequently Asked Questions

Does Xero charge a fee for card payments? Xero itself does not charge a fee for processing card payments, but the payment service you connect (e.g., Stripe) charges its own transaction fees. Those fees are deducted from the deposit before it reaches your bank.

How do I record a card payment fee in Xero? When you match the bank deposit to an invoice, click “Add” to create a transaction for the fee amount, selecting your “Card Processing Fees” expense account. This keeps the invoice fully paid and the fee as a separate expense.

Can I accept card payments directly in Xero? Yes, Xero integrates with payment services like Stripe and GoCardless. You enable the service in Settings, and your invoices get a “Pay Now” button. The payment service handles the card processing and deposits the net amount to your bank.

What if the deposit is for multiple invoices? Use the “Find and Match” tool to select all the invoices that make up the deposit. If the deposit is net of fees, you can add a single fee transaction for the difference, or allocate the fee across the invoices if you prefer.

How do I handle a refund for a card payment? Issue a credit note against the original invoice in Xero, then match the negative bank transaction (the refund) to that credit note. The original card fee is usually not refunded, so you may need to adjust your fee expense.

Do I need a separate bank account for card payments? No, you can use your regular business bank account. The payment service deposits the net amount into that account, and Xero imports the transaction via bank feed. Just ensure the account is linked in Xero.

Related

Formula used
in p | Sale amount | $ | 100 | 0.01 | 1000000
in rate | Card fee rate | % | 2.9 | 0.01 | 100
in fixed | Fixed fee per transaction | $ | 0.30 | 0 | 100
out net | Net deposit | $ | p - p * rate / 100 - fixed | 2
out fee | Total card fee | $ | p * rate / 100 + fixed | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →