ⓘ This article is for small businesses who use Xero
- Reconcile a bank statement line with a batch deposit or batch payment already created in Xero
How it works
When you create a batch payment or batch deposit in Xero, you need to reconcile the bank statement line with the batch, rather than with the individual bills and invoices.
If you haven’t created a batch, use find & match to reconcile the statement line with the individual transactions instead.
If the statement line matches the batch exactly, you can reconcile as normal. Otherwise, you might need to edit or recreate the batch, or use find & match to reconcile the statement line.
The batch matches the bank statement line exactly
If the bank statement line matches the batch payment or deposit exactly, Xero suggests a match in the bank reconciliation screen.
If the suggestion is correct, click OK to reconcile.
There are multiple statement lines for a single batch
If the payments show as separate lines on your bank statement rather than as a single payment, reconcile the statement lines with the individual transactions rather than the batch. To do this:
- Find the batch payment or batch deposit and note down all the bills or invoices included.
- Delete the batch payment or batch deposit to remove all payments and return the transactions to awaiting payment status.
- Reconcile each bank statement line with the individual invoice or bill as normal.
ⓘ Tip
There's a single bank statement line for multiple batches
If you have multiple batches that cover a single bank statement line, reconcile using find & match to select all batches that make up the bank statement line.
The bank statement line doesn't match the batch total
How you reconcile a bank statement line when the amount is different to the total of the batch in Xero depends on the situation.
- A bill or invoice included in the batch hasn’t been processed – Edit the batch to remove the bill or invoice that hasn’t been processed. Then reconcile the bank statement line with the amended batch transaction.
- The statement line includes payment for bill or invoice that’s not included in the batch – You can’t add an invoice or bill into the batch. Use find & match to reconcile the statement line with the batch and the invoice or bill.
- Payment was recorded incorrectly on one of the invoices or bills in the batch – If you accidentally record the wrong payment amount on the invoice or bill, or the amount paid was different than expected, you can edit the batch deposit or batch payment to correct it. Then, reconcile the bank statement line with the amended batch transaction.
- An invoice or bill was overpaid – Remove the invoice or bill from the batch, record the overpayment, then reconcile as normal.