Xero invoice number on commissons report?

How I can add Xero invoice number to the HubSpot commissions report?

Hi @EMatika! Thank you for your post. Can you share more about the commission report you are referring to? Is this a custom HubSpot report or something from the Xero integration?

To add Xero invoice numbers to HubSpot commissions reports, sync invoices using Cloudify’s connector, map the Xero invoice number to a custom HubSpot property, link invoices to deals via identifiers, update deals when invoices are issued or paid, include the custom property in the report, filter by relevant fields, and automate the flow using workflows.

If you are looking for HubSpot Xero integration to create invoices/ quotes, then I will suggest Hubspot - Xero integration app. It will help me with automatic deal-to-invoice conversion in Xero. You can Create and customize Xero invoices/quotes directly from HubSpot Deals with complete control over taxes, amounts, discounts, and products. You can split invoices by percentage ratio for complex billing scenarios, review drafts before syncing, and maintain flexibility for special requirements while saving time on manual entry.

HubSpot doesn’t store Xero invoice numbers by default, so if you’re building a commissions report and need that invoice data tied to deals or contacts, Coefficient can help bridge the gap.

With Coefficient, you can pull Xero invoice data and HubSpot deal data into the same Google Sheet. From there, it’s easy to align the records based on a shared identifier — like company name or email.

What’s especially useful is that once you’ve mapped the invoice numbers to the right HubSpot records, you can also push those values back into HubSpot as custom properties using Coefficient’s export feature. That way, the invoice number becomes part of your HubSpot dataset for ongoing use — reporting, workflows, or even just visibility in the CRM.

It’s a simple but powerful workaround if you need tighter alignment between sales activity and finance data without building a full-blown integration.