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.
Hi 👋 your idea is being looked into by our Community team. We'll be in touch soon to update you once your idea has been reviewed.
Did you know you can join our Xero Research panel to be involved in early testing and research? Find out more and sign up through our website 🙂
-
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.