Automated Invoice Generation from 'Closed-Won' CRM Deals to Xero (Zapier)

Streamline the quote-to-cash cycle by automatically syncing customer data and invoices to Xero.

Tools: CRM → Xero

Platform: Zapier

Short Answer

As soon as a deal status reaches 'Closed-Won' in your CRM, Zapier automatically finds or creates the contact in Xero and generates a draft invoice with correct line items, tax mapping, and billing details.

The Problem

Manual data entry between a CRM and Xero causes delayed invoicing, transcription errors, and fragmented customer records. Sales teams often forget to notify finance when a deal is won, leading to cash flow bottlenecks.

The Outcome

As soon as a deal status reaches 'Closed-Won' in your CRM, Zapier automatically finds or creates the contact in Xero and generates a draft invoice with correct line items, tax mapping, and billing details.

Step-by-Step Guide

1. **Create the Zap**: Log in to Zapier and click 'Create Zap'. Name it 'CRM Deal to Xero Invoice'. 2. **Set up Trigger**: Search for your CRM (e.g., Pipedrive, HubSpot). Choose the event 'Updated Deal Stage' or 'New Won Deal'. Connect your CRM account using OAuth or API Key. 3. **Add Filter by Zapier**: Add a step and select 'Filter'. Set the criteria so the Zap only continues IF the Deal Stage matches your 'Closed-Won' identifier. 4. **Format Data (Date/Time)**: Add 'Formatter by Zapier' -> 'Date/Time'. Convert the CRM deal close date into `YYYY-MM-DD` format to ensure Xero accepts the invoice date. 5. **Format Data (Text)**: If your CRM uses a single 'Name' field, use 'Formatter by Zapier' -> 'Text' -> 'Split Text' to separate First and Last names for Xero's contact fields. 6. **Find or Create Contact in Xero**: Add a 'Xero' step. Choose 'Find Contact'. Map the CRM Email field to the 'Search' criteria. Check the box 'Create Xero Contact if it doesn't exist yet' and map the CRM Company Name and Address fields. 7. **Map the Invoice Line Items**: Add a 'Xero' step. Choose 'Create Sales Invoice'. Use the ID from the previous 'Find/Create Contact' step in the 'Contact' field. Map Deal Title to 'Description', Amount to 'Unit Amount', and set 'Status' to 'Draft'. 8. **Standardize Account Codes**: Hardcode the 'Account Code' (e.g., 200 for Sales) or use a 'Lookup Table' in Formatter to map CRM Product Categories to Xero Chart of Accounts. 9. **Update CRM (Optional)**: Add a final step to your CRM to 'Update Deal'. Paste the 'Invoice Number' or 'Xero Link' from the Xero step into a custom field in the CRM for visibility. 10. **Enable Error Handling**: Click the '...' on the Xero step and select 'Add Error Handler' to use Zapier Manager to alert you via Slack/Email if the sync fails.