{"id":28525,"date":"2026-06-04T00:15:48","date_gmt":"2026-06-04T00:15:48","guid":{"rendered":"https:\/\/synder.com\/help\/per-transaction-how-to-use-transaction-reconciliation-with-xero\/"},"modified":"2026-10-07T15:17:35","modified_gmt":"2026-10-07T15:17:35","slug":"per-transaction-how-to-use-transaction-reconciliation-with-xero","status":"publish","type":"post","link":"https:\/\/synder.com\/help\/per-transaction-how-to-use-transaction-reconciliation-with-xero\/","title":{"rendered":"How to Reconcile Xero with Synder \u2014 Transaction Reconciliation Guide (Per-Transaction)"},"content":{"rendered":"\n

This guide shows you how to reconcile Xero with Synder<\/strong> using Synder’s Transaction Reconciliation<\/strong> feature in Manual mode. You’ll export an Account Transactions<\/em> 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.<\/p>\n\n\n\n\n

For the full explanation of how Transaction Reconciliation works \u2014 what each result bucket means, and which integrations support Automated or Assisted modes \u2014 see Transaction Reconciliation for Per Transaction Sync<\/a>. To get Xero connected to Synder in the first place, see How to Connect QuickBooks Online and Xero to Synder<\/a>.<\/p>\n\n\n\n

When to use this guide<\/h2>\n\n\n\n

Try Assisted mode first.<\/strong> If your integration supports it, Assisted mode<\/strong> is the recommended path for Xero Per-Transaction users. You export a single Account Transactions<\/em> report, upload it, and Synder normalizes and maps everything automatically \u2014 no manual column mapping<\/strong>, so there is no risk of a mismapped ID sending every row to Missing source. Assisted mode also recovers original source-currency amounts, which Manual mode cannot do for multi-currency or FX transactions. See Assisted Transaction Reconciliation for Xero<\/a>. Use the guide below if Assisted is not available for your integration, or if you prefer to map the columns yourself.<\/p>\n\n\n\n

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<\/strong>. You’ll export an Account Transactions<\/em> report from Xero, clean it up, and upload it into Synder alongside your payment-platform file.<\/p>\n\n\n\n

Step 1 \u2014 Export the Account Transactions report from Xero<\/h2>\n\n\n\n
  1. Open Xero<\/strong>.<\/li>\n
  2. Go to Reporting \u2192 Account Transactions<\/strong>.<\/li>\n
  3. Select the needed account<\/strong> \u2014 this must be the same account where Synder posts payments, fees, and refunds (the Clearing account<\/em> for that integration).<\/li>\n
  4. Set the date range<\/strong> you want to reconcile.<\/li>\n
  5. Choose these columns<\/strong>: Date, Source, Contact, Description, Reference, Gross, Net, Related account<\/em> (Xero will lay them out in this order in the export).<\/li>\n
  6. Set Grouping<\/strong> to None<\/em>.<\/li>\n
  7. Click Update<\/strong>.<\/li>\n
  8. Export the report as XLSX<\/strong>.<\/li><\/ol>\n\n\n\n

    Step 2 \u2014 Clean up the XLSX file<\/h2>\n\n\n\n

    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:<\/p>\n\n\n\n