Connect Stripe and Xero with tray.ai — and Stop Doing Bookkeeping by Hand

This template watches for successful charge events in Stripe and automatically creates an approved invoice in Xero, linked to the matching customer contact. It handles field mapping between Stripe's payment object and Xero's invoice schema — line items, tax codes, currency included. A solid starting point for any business that needs real-time payment-to-invoice automation.

Steps:

• Listen for charge.succeeded webhook event in Stripe
• Look up or create the corresponding contact in Xero using Stripe customer email
• Map Stripe charge fields (amount, currency, description) to Xero invoice line items
• Create an approved invoice in Xero with correct account codes and tax rates
• Mark the invoice as paid and log the payment reference for reconciliation

Connectors Used: Stripe, Xero

This template catches refund events from Stripe and automatically generates a credit note in Xero, applying it against the original invoice. It handles partial and full refunds and matches the credit note amount to the Stripe refund exactly, including currency conversion logic for international transactions.

Steps:

• Trigger on charge.refunded or refund.created event in Stripe
• Retrieve the original Stripe charge and locate the matching Xero invoice
• Calculate refund amount and determine if refund is full or partial
• Create a credit note in Xero for the correct amount and currency
• Apply the credit note to the original invoice to zero out or reduce the balance

Connectors Used: Stripe, Xero

Built for subscription businesses, this template fires each time Stripe processes a renewal payment and creates a new invoice in Xero for the billing cycle. It captures the subscription plan name, billing period dates, and customer details so recurring revenue is properly documented and categorized in your accounting system.

Steps:

• Listen for invoice.payment_succeeded event from Stripe for subscription invoices
• Extract subscription plan details, billing period, and customer information
• Look up the existing Xero contact or create a new one if not found
• Create a Xero invoice with subscription line item, dates, and account code
• Record the payment against the invoice and tag with subscription metadata

Connectors Used: Stripe, Xero

This template automates reconciling Stripe payouts against your Xero bank account by breaking each payout into its underlying transactions, fees, and net totals. It creates spend money and receive money transactions in Xero that match exactly what Stripe deposits into your bank, so month-end bank reconciliation is straightforward.

Steps:

• Trigger on payout.paid event in Stripe and retrieve the payout object
• Fetch all balance transactions included in the payout via Stripe API
• Separate charges, refunds, and Stripe fees into individual line items
• Create a Xero bank transaction that matches the net payout amount deposited
• Post Stripe processing fees as a separate expense transaction in Xero

Connectors Used: Stripe, Xero

This template makes every new Stripe customer immediately available as a contact in Xero, so invoices can be assigned to the right account without manual intervention. It includes duplicate detection to avoid creating redundant contacts when a customer already exists in Xero.

Steps:

• Trigger on customer.created event in Stripe
• Search Xero contacts by email address to check for existing match
• If no match found, create a new Xero contact with Stripe customer details
• If match found, update the Xero contact with the latest Stripe data
• Store the Xero contact ID back in Stripe customer metadata for future lookups

Connectors Used: Stripe, Xero

This template triggers on a failed Stripe payment and does two things: updates the relevant Xero invoice to reflect the failure, and sends an internal alert to the finance team via email or Slack so they can act immediately. Your accounts receivable team stays informed and your Xero records stay accurate.

Steps:

• Listen for payment_intent.payment_failed or invoice.payment_failed event in Stripe
• Locate the corresponding invoice in Xero using the Stripe invoice or charge reference
• Update the Xero invoice status or add a note indicating the failed payment attempt
• Send an alert to the finance team via Slack or email with customer and amount details
• Optionally trigger a customer-facing payment retry or dunning email workflow

Connectors Used: Stripe, Xero