# Import Payments into Xero Against Invoices

- Author: SimpleBankConvert (https://simplebankconvert.com)
- Published: 2026-10-17
- Category: Invoices, bills and lists
- Canonical: https://simplebankconvert.com/blog/import-payments-into-xero

> How to import payments into Xero against invoices: the routes that exist, applying each payment to the right invoice and matching the bank line.
To import payments into Xero against invoices, import the bank statement lines that carry the payments, then match each line to its invoice on the Reconcile tab. Matching records the payment and marks the invoice paid. Use a batch deposit when one bank line pays several invoices. Never use a precoded statement import for invoice payments.

## Routes for recording payments against Xero invoices

Xero records a customer payment against an invoice in three main ways: by entering it on the invoice itself, by creating a batch deposit across several invoices, or by matching a bank statement line to the invoice during reconciliation. For a batch of payments, reconciliation is the route that scales, because the bank lines arrive as a file or feed.

| Route | How the payment gets in | Best for |
| --- | --- | --- |
| Payment on the invoice | You type the date, amount and account on the approved invoice | One-off cash or check receipts |
| Batch deposit | You tick several invoices and deposit them as one payment | One bank line paying many invoices |
| Reconciliation match | You import or receive bank lines and match each to its invoice | A month of payments at once |

The routes can be combined. Batch deposits and invoice payments both still need their bank line reconciled afterwards. Reconciliation by itself creates the payment and reconciles it in one step. That last one is the nearest thing Xero has to importing payments, and it is where the rest of this post spends most of its time.

### Invoices first, payments second

The invoices must exist and be approved before any payment can apply to them. If the invoices are not in Xero yet, bring them in first. For QuickBooks users reading along, the equivalent first step on that side is [uploading invoices to QuickBooks Online from a spreadsheet](/blog/upload-invoices-to-quickbooks-online).

## Why can't a precoded Xero statement import pay invoices?

A precoded statement import creates new spend and receive money transactions and reconciles the bank lines to them straight away. It never looks at your open invoices. So a customer payment imported this way becomes fresh income, the invoice stays unpaid, and the sale counts twice. Xero Central warns against it for exactly this case.

Xero Central's article on [importing a precoded CSV bank statement](https://central.xero.com/s/article/Import-a-precoded-CSV-bank-statement) says it plainly: if lines in a precoded file match invoices, bills or other transactions already in Xero, importing the statement will introduce errors into your data, and those lines should go to the Reconcile tab instead. The precoded file suits costs and income with no invoice behind them, like bank charges or small cash sales.

### What the right file looks like

For invoice payments, import a plain bank statement: a CSV or OFX with dates, amounts, payees and references, but no account codes. The lines then wait on the Reconcile tab, unmatched, for you to pair each one with its invoice. A reference column helps a lot here, because many customers quote the invoice number in their payment reference.

## Matching each Xero bank statement line to its invoice

Matching a Xero bank statement line to its invoice is what turns a deposit into a recorded invoice payment. On the Reconcile tab, Xero suggests a match for each line by comparing its details with open transactions, including invoices. Click OK on a right suggestion, or use the other matches or find and match.

Xero Central's guide to [reconciling your bank account](https://central.xero.com/s/article/Reconcile-your-bank-account) explains how suggestions are chosen. Xero compares everything in the statement line with everything in each account transaction and offers the one with the most in common. Where several fit, it looks for the closest due date. That last rule matters when one customer has several open invoices for the same amount.

### A worked example

Here is a made-up month for an example landscaping business. All figures are examples. Open invoices at the start:

- INV-0410, Maple Court HOA, 1,200.00
- INV-0411, Maple Court HOA, 1,200.00
- INV-0412, Rivera Dental, 450.00
- INV-0413, Grant Family, 780.00
- Several smaller invoices that customers paid by card through Stripe, adding up to more than 2,310.00 because Stripe keeps its fees

Bank lines imported for the month, and what to do with each:

| Bank line | Reference | Amount | Match to | Note |
| --- | --- | --- | --- | --- |
| 05/04 | MAPLE CT HOA INV0410 | 1,200.00 | INV-0410 | Reference names the invoice |
| 05/11 | RIVERA DENTAL | 450.00 | INV-0412 | Only open invoice for that contact and amount |
| 05/18 | GRANT | 400.00 | INV-0413, part | Leaves 380.00 owed |
| 05/25 | MAPLE CT HOA | 1,200.00 | INV-0411 | Not 0410, which is already paid |
| 05/28 | STRIPE TRANSFER | 2,310.00 | Batch deposit | Covers several card payments |

Work down the list. The first line's reference names the invoice, so the suggestion is easy to confirm. The fourth line could fit either Maple Court invoice by amount alone, but 0410 was paid by the first line, so only 0411 remains open. The third line is a part payment, and the last line pays several invoices at once. Each of those is covered below.

### Check before clicking OK

Accepting a match marks the invoice paid. Before clicking OK, read the contact name and the invoice number on the suggestion, not just the amount. Two customers can easily owe the same sum.

## Xero batch deposits when one payment covers several invoices

A Xero batch deposit records several invoices as paid in one payment, so that one bank line can match it. Use it for a stack of checks banked together, or one transfer paying several invoices. In Sales, then Invoices, open the Awaiting Payment tab, tick the invoices, click Deposit, fill in the fields, and click Deposit again.

Xero Central's article on [creating a batch deposit](https://central.xero.com/s/article/Create-a-batch-deposit) gives the limits. A batch deposit holds at most 50 invoices. It works only for invoices in your base currency and only into a base currency bank account. You cannot include overpayments. When the matching line appears on your statement, you reconcile it against the one batch transaction instead of hunting for each invoice.

### Fields to fill in

- **Payment date:** the date the customers paid, or the date you bank the checks.
- **Reference:** something you will recognize on the Reconcile tab, such as the deposit slip number.
- **Bank account:** the account the money goes into. Credit card and foreign currency accounts are not available.
- **Payment column:** lower any amount where the customer paid only part.

### When a check bounces

If one of the payments in a batch fails, such as a returned check, Xero Central says to remove that invoice from the batch deposit so the total matches the bank statement again. The invoice then goes back to awaiting payment.

### Card processor transfers

The Stripe line in the example is a different kind of grouped payment: a processor pays out many card payments at once, minus its fees. A batch deposit can gather the invoices, but the fee still has to be recorded so the total matches. Sales through a till work the same way; the QuickBooks side of that pattern is in [importing POS sales into QuickBooks Online](/blog/import-pos-sales-into-quickbooks-online), and the same totals logic applies in Xero.

## What about part payments and overpayments on Xero invoices?

A part payment is recorded by lowering the payment amount to what was actually received, leaving the rest owed on the invoice. An overpayment is more than the invoice, and the extra belongs on the customer's account as credit, not as a bigger invoice payment. Neither can be forced through a match without adjusting the amount.

In the example, Grant Family paid 400.00 against a 780.00 invoice. When matching, find the invoice and set the amount applied to 400.00. INV-0413 stays on the Awaiting Payment tab with 380.00 left. When the rest arrives, match that line to the same invoice.

Xero Central's batch deposit article says overpayments cannot be included in a batch deposit and should be deposited separately. Keep that rule in mind even outside batches: record the invoice payment for the invoice amount, and handle the extra on its own so it shows as credit you owe the customer.

### Short payments you will not chase

Sometimes a customer pays a little less, such as a bank charge deducted on an overseas transfer, and you decide not to chase the difference. Apply the payment as received, then deal with the small balance on the invoice deliberately, for example by writing it off to a bank fees account. Leaving it open makes the customer look like they still owe you.

## Bank lines that are not payments for Xero invoices

Not every bank line is an invoice payment. Card sales without invoices, interest, bank fees, loan repayments and transfers between your own accounts have no invoice to match. On the Reconcile tab, create a spend or receive money transaction for those, or a transfer, and Xero reconciles the line at the same time.

Loan repayments deserve care, because one bank line usually splits into principal and interest. The split is the same in any software; the walk-through for [importing loan payments into QuickBooks Desktop](/blog/import-loan-payments-into-quickbooks-desktop) shows how to work it out from the lender's schedule.

### Getting the statement lines into Xero

Everything above starts with bank lines on the Reconcile tab. A bank feed brings them in daily. Without a feed, you import a statement file, and if your bank only provides PDFs, the file has to be made first. [SimpleBankConvert](/) is being built to turn a PDF bank statement into a CSV laid out the way Xero's statement import expects, with payee and reference in their own columns, which is where the invoice numbers customers quote end up.

### A month-end check

When the Reconcile tab is empty for the month, compare two figures. The Awaiting Payment total in Xero should equal what customers really still owe you, and the bank account's statement balance in Xero should equal the closing balance on the real statement. If either is off, look for a payment matched to the wrong invoice, or a deposit coded as income that should have paid one.