This guide shows you how to reconcile Xero with Synder using Synder’s Transaction Reconciliation feature in Manual mode. You’ll export an Account Transactions report from Xero, upload it into Synder, and match it against your payment platform data so every payment, fee, and refund posted by Synder lines up with what’s in your Xero clearing account.
For the full explanation of how Transaction Reconciliation works — what each result bucket means, and which integrations support Automated or Assisted modes — see Transaction Reconciliation for Per Transaction Sync. To get Xero connected to Synder in the first place, see How to Connect and Set Up Xero with Synder.
When to use this guide
Use this guide when your payment integration is in Manual reconciliation mode (for example Square, WooCommerce, or another platform without a built-in Synder reconciliation connector) and your accounting platform is Xero. You’ll export an Account Transactions report from Xero, clean it up, and upload it into Synder alongside your payment-platform file.
Step 1 — Export the Account Transactions report from Xero
- Open Xero.
- Go to Reporting → Account Transactions.
- Select the needed account — this must be the same account where Synder posts payments, fees, and refunds (the Clearing account for that integration).
- Set the date range you want to reconcile.
- Choose these columns: Date, Source, Contact, Description, Reference, Gross, Net, Related account (Xero will lay them out in this order in the export).
- Set Grouping to None.
- Click Update.
- Export the report as XLSX.
Step 2 — Clean up the XLSX file
Xero adds a few header rows to the top of the export (report title, account name, date range). Synder expects column headers on row 1, so open the file and:
- Delete the first 4 rows so that the column headers (Date, Description, Reference, Contact, Gross, Net…) sit on the top row.
- Save the file.
Sample file: Download an example Xero Account Transactions export to see the raw layout (4 metadata rows on top, headers on row 5) and what it should look like after cleanup.
Step 3 — Upload the file into Synder
- In Synder, go to Transactions → Transaction Reconciliation.
- Click Add reconciliation and set the date range to match what you exported from Xero.
- Under Accounting, set the Automation mode to Manual and upload the cleaned Xero XLSX file (up to 100 MB).
- Under Integration, select your payment platform and upload its file the same way (or use Automated mode if that platform supports it).
- Click Map columns and map Synder’s required fields to your Xero columns:
Primary ID → Reference (Xero stores the transaction reference, e.g. INV-0013, here). Secondary ID → Reference (use the same column if Synder asks for both IDs). Amount → Gross (or Net, depending on what you’re matching). Date → Date. Description → Description. - Optional: save the mapping as a template so you can reuse it next time.
- Click Apply mapping, then Start matching.
Step 4 — Review your results
Synder will compare the two files and group results into Matched, Discrepancy, Not Matched, and Ignored. For a full explanation of each bucket and how to act on discrepancies, see the Understanding your results section of the main Transaction Reconciliation guide.
Tips and tricks
- Use Gross vs Net consistently. If your payment platform file reports gross amounts (before fees), map Synder’s Amount field to Gross; if it’s net of fees, map to Net. Mixing the two will produce phantom discrepancies.
- Pick the right clearing account. If your Synder integration posts fees and refunds into a separate account from payments, run the Xero report against the payments-and-refunds account — that’s where matches will line up.
- Stay inside your sync window. Only reconcile dates that Synder has actually synced to Xero. Reconciling beyond your last sync will surface false “Not Matched” rows.
Related guides
- Transaction Reconciliation for Per Transaction Sync — full overview of automation modes and result buckets
- What Is Smart Reconciliation, and How Does It Work?
- Payouts, Clearing Accounts, and Reconciliation — Comprehensive Guide
- Automatic Xero Clearing Account Reconciliation — the automated counterpart for Xero users
