A2X Payout Summary to Xero with Multi-Channel Reporting (Make.com)

Automate ecommerce reconciliation and tracking category assignment using Make.com's advanced mapping engine.

Tools: A2X → Xero

Platform: Make.com

Short Answer

A seamless, hands-off workflow where A2X payout summaries are validated, enriched with Xero Tracking Categories, and posted as Draft Invoices. This ensures a 1:1 match with bank feeds while providing granular reporting by region or product line.

The Problem

Manual reconciliation of ecommerce payouts (Amazon/Shopify) is error-prone due to hidden fees and tax complexities. While A2X flows directly to Xero, accountants often need secondary data enrichment—such as assigning specific tracking categories or logging payout history to external BI tools—that the native integration doesn't handle natively.

The Outcome

A seamless, hands-off workflow where A2X payout summaries are validated, enriched with Xero Tracking Categories, and posted as Draft Invoices. This ensures a 1:1 match with bank feeds while providing granular reporting by region or product line.

Step-by-Step Guide

1. **Create Webhook in Make.com**: Add a 'Webhooks > Custom Webhook' module. Copy the unique URL provided. 2. **Configure A2X Notification**: In A2X settings, paste the Make.com Webhook URL into the 'Post-Posting Notification' section to trigger the scenario whenever a payout is finalized. 3. **Add Xero Connection**: Add a 'Xero > Create an Invoice' module. Click 'Add' to authorize your Xero Organization. Ensure the 'Tenant ID' is correctly selected. 4. **Set Up Search/Match Logic**: Add a 'Xero > List Tracking Categories' module to retrieve your dynamic 'Region' or 'Department' IDs for accurate mapping. 5. **Configure Router**: Use a 'Router' module to differentiate between 'Marketplace Application' (e.g., if source = Amazon vs Shopify) to apply different Tax Types. 6. **Map Invoice Header**: In the 'Create an Invoice' module, map the `Payout Date` to 'Date' and the `A2X Payout ID` to the 'Reference' field to prevent duplicates. 7. **Map Line Items (Iterator)**: If the A2X payload contains an array of lines, use the 'Iterator' module followed by 'Xero > Add an Item to an Invoice'. 8. **Apply Complex Functions**: Use Make.com's `formatDate()` for the invoice date and `ifempty()` for descriptions to ensure Xero's API doesn't reject null values. 9. **Implement Error Handling**: Right-click the Xero modules and select 'Add error handler'. Use the 'Break' directive to store the execution and retry later if Xero's API is temporarily down. 10. **Finalize Tracking**: Under 'Line Items' in Xero, map the Tracking Category ID retrieved in Step 4 to ensure the revenue hits the correct P&L segment.