Track Individual Invoices Within a Consolidated Supplier Account
We operate using a monthly statement from Capricorn Society, which includes multiple suppliers (e.g. Burson, Repco, Motorpass etc..) under one account.
In Xero, we’re currently forced to enter this as one total bill and manually allocate expenses — which means we lose all supplier-level detail.
What’s needed:
- Ability to create a main account (e.g. Capricorn) for the monthly payable
- Ability to enter each supplier invoice individually as it comes in throughout the month
- Each invoice treated like its own supplier record (sub-account), capturing:
- Invoice date
- Invoice number
- Part numbers / descriptions
- Individual invoice totals
- Ability to link all sub-invoices to the main account for one consolidated payment
Example workflow:
- Create main supplier: Capricorn
- During the month, enter invoices individually:
- Burson invoice → coded to parts, tagged as supplier “Burson”
- Repco invoice → coded accordingly
- Motorpass transaction → entered with full detail
- Each invoice is linked to the Capricorn master account
- End of month:
- Capricorn statement arrives
- System matches all entered invoices to the statement total
- One payment is made to Capricorn
- Reporting shows spend by each supplier (Burson, Repco, etc.), not just Capricorn
Key requirement:
Maintain one payable to Capricorn, while retaining full visibility and reporting by each underlying supplier.
Why this matters:
- Accurate supplier spend tracking (e.g. Burson vs Repco)
- Better reporting and rebate tracking
- Cleaner reconciliation against monthly statements
- More efficient workflow (no end-of-month breakdown required)
Business impact:
The current limitation can lead to missed supplier rebates, reduced visibility over purchasing trends, and increased risk of errors during reconciliation and audits due to the lack of invoice-level detail tied to actual suppliers.
Workshop systems like Mechanic Desk already support Capricorn-style billing structures by linking individual supplier invoices to a central billing account. This highlights a clear gap in Xero’s ability to support the same workflow within an accounting system.
This is a significant limitation for automotive workshops using Xero.
Nicole Boskovich
shared this idea
Hi! Did you know it's already possible to do this in Xero? The best way to manage this in Xero today would be to use Tracking for the underlying suppliers while keeping Capricorn as the supplier you pay at the end of the month.
You could create one tracking category and then add tracking options for each supplier, such as Burson, Repco, Motorpass, and any others you need. This would allow you to enter the bills during the month and report on spend by supplier, while still making a single payment to Capricorn.
To add this to bills, you would first set up the tracking category and supplier options in Accounting settings. Then, when entering each bill, select Capricorn as the supplier and choose the relevant tracking option for the bill line, such as Burson, Repco or Motorpass. Once saved, this means the bill remains under Capricorn for payment, while the tracking gives you the supplier-level reporting detail.
If you'd like help setting this up for your organisation, please raise a case with Xero Support through Xero Central: Get help from Xero support
Sources:
😊
-
Nicole Boskovich
commented
Thank you for looking into this as I know it has been a common roadblock for a lot of Xero users for a number of years now and it would be nice for something to be implemented by Xero to accept this functionality.