Automate Your Xero Proforma Invoices: Step‑by‑Step Template Builder for 2026
Creating a proforma invoice in Xero can be tedious if you do it manually every time. This guide walks you through building an automated template that pulls data from your Xero account, formats it into a professional proforma invoice, and sends it directly to clients—all with minimal clicks. Whether you’re a freelancer, a small business, or a large enterprise, this workflow will save you hours and reduce errors.
Why Automate Proforma Invoices in Xero?
Proforma invoices are pre‑sales documents that outline the terms of a sale before the final invoice is issued. Automating them in Xero offers:
- Consistent formatting and branding.
- Instant updates when product prices or tax rates change.
- Reduced manual data entry and the risk of mistakes.
- Faster client approvals and smoother sales cycles.
Prerequisites
Before you start, make sure you have:
- A Xero account with API access.
- Admin rights to create and edit templates.
- Basic knowledge of Xero’s reporting and export features.
- Optional: billgenerate.com for quick PDF styling.
Step 1: Set Up a Custom Report in Xero
1. Log in to Xero and navigate to Reports & Analytics.
2. Click + New Report and choose Custom Report.
3. Select the date range that matches your sales cycle (e.g., the current month).
4. Add fields: Invoice number, Client name, Item description, Quantity, Unit price, Tax rate, Total.
5. Save the report as Proforma Template.
6. Export the report to CSV for the next step.
Step 2: Import Data into a Spreadsheet
Open the CSV file in Google Sheets or Excel. Use formulas to calculate subtotals and apply your company’s branding:
- Subtotal = Quantity * Unit price.
- Tax = Subtotal * Tax rate.
- Total = Subtotal + Tax.
Insert your logo and contact details at the top. Format the table with borders and shading for clarity.
Formatting Tips
- Use bold for column headers.
- Apply a light gray background to header rows.
- Set number formatting to currency for price fields.
- Include a footer with payment terms and bank details.
Step 3: Convert Spreadsheet to PDF
Once your spreadsheet looks polished, convert it to PDF. You can do this directly in Google Sheets:
- File > Download > PDF Document (.pdf).
- Choose Landscape orientation and adjust margins to fit the invoice layout.
Alternatively, use billgenerate.com to upload your PDF and apply a professional template if you need more styling options.
Step 4: Upload PDF to Xero as a Proforma Invoice
1. In Xero, go to Business > Invoices.
2. Click Create New Invoice.
3. Choose Proforma Invoice as the type.
4. Fill in client details and line items manually or use the Import feature.
5. Attach the PDF you just created by clicking Attach.
6. Save and send the proforma invoice to the client.
Automation via Xero API
For tech‑savvy users, you can automate the entire flow using Xero’s API:
- Fetch sales data via the
/v2/Invoices endpoint.
- Generate a PDF using a library like
pdfkit or jsPDF.
- Upload the PDF back to Xero with
/v2/Invoices/{id}/Attachments.
- Set the invoice status to
Draft or Sent as needed.
Integrating with Recurring Billing Software
If you’re already using Recurring Billing for subscription services, you can sync your proforma invoices so that recurring payments start automatically once the client approves the proforma. This integration reduces manual follow‑ups and ensures a seamless billing experience.
Best Practices for Proforma Invoices
- Keep the document concise—no more than two pages.
- Use clear, professional language for terms and conditions.
- Include a unique proforma number for tracking.
- Set a clear deadline for client approval.
- Store all proforma invoices in a dedicated folder in Xero for easy retrieval.
RentInvoice: Your All‑in‑One Rental Management Solution
If you manage rentals—whether it’s clothing, equipment, or vehicles—RentInvoice offers a comprehensive platform that handles invoicing, inventory, and client communication in one place. With RentInvoice, you can:
- Create and send proforma invoices instantly.
- Track rental periods and due dates automatically.
- Integrate with Xero for real‑time accounting.
- Generate detailed reports on rental revenue and outstanding balances.
- Use barcode scanning for quick inventory updates.
RentInvoice’s intuitive interface means you can set up your first proforma invoice in under 10 minutes, freeing up more time for customer service and growth.
FAQ
- What is a proforma invoice? A proforma invoice is a preliminary bill sent to buyers before the final invoice, outlining prices, quantities, and terms.
- Can I automate proforma invoices in Xero? Yes—using custom reports, spreadsheets, and the Xero API.
- Do I need to attach a PDF? Not mandatory, but attaching a PDF ensures a consistent look and protects your brand.
- How do I sync with recurring billing? Use the API or integration tools from Recurring Billing to link proforma approval to subscription activation.
- Is it possible to add taxes automatically? Yes—Xero calculates taxes if you use its built‑in tax rates.
- Can I customize the layout? Absolutely—edit the spreadsheet or use a PDF template from billgenerate.com.
- What if I need to send multiple proformas at once? Batch upload via CSV or use Xero’s bulk invoice feature.
- Do I need developer skills? Basic automation can be done with spreadsheets; deeper integration requires API knowledge.
- How do I keep track of sent proformas? Use the
Status field in Xero and filter by Proforma.
- Can I convert a proforma to a final invoice? Yes—open the proforma in Xero and click
Convert to Invoice.
Conclusion
Automating proforma invoices in Xero streamlines your sales process, reduces manual errors, and speeds up cash flow. By following the steps above—setting up a custom report, formatting your data, converting to PDF, and uploading to Xero—you’ll have a repeatable system that scales with your business. If you’re in the rental industry, consider RentInvoice to centralize invoicing, inventory, and client management—all while keeping your Xero data in sync.
Additional Resources