Overview
CardUp Collect bundles multiple customer invoice payments into a single bank deposit. Because your Xero bank feed displays only the total lump-sum deposit, Xero will not automatically auto-match it to individual invoices. You must use Xero’s Find & Match feature to select and reconcile all included invoices together.
Prerequisites
Before starting, ensure you have:
Admin access to your CardUp Collect dashboard.
Access to your Xero organization's bank reconciliation page.
Step-by-Step Reconciliation Guide
Step 1: Identify the invoices in the payout (CardUp Collect)
1. Log in to the CU Collect dashboard.
2. Go to Grouped Payouts and open the specific payout that matches the bank deposit amount/date.
3. In the payout details, note down the list of invoice transactions included - specifically each invoice number. (You can also download this as a CSV for easier reference.)
Step 2: Match the statement line in Xero
1. From the Xero homepage, go to your bank account and select Reconcile.
2. Find the bank statement line for the payout amount, and click Find & Match.
3. Search using the invoice numbers you noted from the Collect payout details. You can also search by name, amount, reference, or cheque number, or sort by clicking a column heading.
4. Select the checkbox for each matching invoice transaction.
5. Once the total of selected transactions equals the statement line amount, click Reconcile.
Tip: If the payout has many invoices, downloading the CSV from Grouped Payouts and keeping it open alongside Xero's Find & Match makes it much faster to check off invoice numbers as you go.