A fully automated workflow where every new sale triggers the creation of a contact, an itemized invoice, and a corresponding payment in Xero. This ensures real-time P&L visibility and eliminates the need for manual end-of-month reconciliation.
The Problem
High-volume ecommerce sellers often struggle with manual data entry, leading to reconciled accounting lags and human error. Transitioning orders from multi-channel managers to Xero requires precise mapping of tax codes, payment accounts, and customer details to maintain financial integrity.
The Outcome
A fully automated workflow where every new sale triggers the creation of a contact, an itemized invoice, and a corresponding payment in Xero. This ensures real-time P&L visibility and eliminates the need for manual end-of-month reconciliation.
Step-by-Step Guide
1. **Authenticate Trigger**: Log into Zapier, click 'Create Zap', and select your Multi-Channel tool (e.g., Linnworks, Sellbrite). Choose the 'New Order' or 'New Paid Order' trigger.
2. **Filter Valid Sales**: Add a 'Filter by Zapier' step. Set the logic to only continue if the 'Order Status' matches 'Paid' or 'Processed' to avoid syncing draft orders.
3. **Map Customer Data**: Add a Xero 'Find Contact' action. Use the buyer's email from the trigger as the search value. Check the box 'Create Xero Contact if it doesn't exist yet' and map Name and Address fields.
4. **Format Dates and Currency**: Add a 'Formatter by Zapier' (Date/Time) step if your tool provides timestamps in a format Xero doesn't recognize (Xero prefers YYYY-MM-DD).
5. **Handle Multi-Line Items**: If your Multi-Channel tool sends line items as a single string, use 'Formatter by Zapier (Utilities) > Line Itemizer' to break them into arrays that Xero can process.
6. **Configure Invoice**: Add the Xero 'Create Sales Invoice' action. Map the 'Contact ID' from Step 3. Under 'Line Items', map the Product SKU, Description, Quantity, and Unit Price. Set 'Status' to 'Authorised'.
7. **Dynamic Tax Coding**: Use a 'Formatter (Lookup Table)' step to map the shipping country to your specific Xero Tax Types (e.g., US = 'Tax on Sales', UK = '20% VAT on Income').
8. **Record Payment**: Add a Xero 'Create Payment' action. Map the 'Invoice ID' from the previous step. Select the 'Bank Account' (e.g., Clearing Account) and map the 'Total Amount' and 'Payment Date'.
9. **Initialize Error Handling**: Click the '...' on the Xero Invoice step and select 'Add Path'. Create a path for 'If Step Fails' to send an email notification or Slack alert so no revenue is lost.