Skip to content
← For small businesses

Enter your idea

For small businesses: Accounting features

Categories

(thinking…)

Reporting - Budgets by tracking category to integrate with master overall budget

Ability to integrate budgets by tracking categories with the master overall budget.

Purpose: Because it can automatically flow through the master budget, so users don’t need to manually reconcile during this process.

160 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

AdminXero Team (Admin, Xero) shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Not in pipeline  ·  AdminKelly Munro (Community Manager, Xero) responded  · 

Thanks for your passion and the detailed feedback on this idea, community. We can see how much time is spent manually consolidating tracking category budgets, and why having this roll-up automatically would make a big difference.

As noted by others in the thread, one option for now is to use a third-party app from the Xero App Store. Some in the community have mentioned tools like Spotlight Reporting or Budget Consolidator are great for this, and it’s a good way to get the insights you’re after.

While we understand the value this feature would add, it isn't on our immediate roadmap to build right now. We know that's not the news you're hoping for, but we want to be transparent about what's in our current focus - You can get a view of some of the changes coming in the next quarter through our website, The Long and Short of it.

We’ll be sure to post an update here if our position for this idea changes.

Show previous admin responses (1)
Comments are closed An error occurred while saving the comment
  • David Eagle commented  ·   ·  Report

    We currently have to manually do this process offline via Excel after downloading P&L by Tracking Category, then entering these extracted figures against individual Projects (Tracking Categories) into Excel budget sheets. The data entry and reconciliation is very labor intensive.

  • Wayne Muncaster commented  ·   ·  Report

    How come this hasn't been done 10 years after it was suggested? It seems like basic functionality and would certainly make reporting easier.

  • David Elsey commented  ·   ·  Report

    Have a look at https://xpna.co

    Tracking category budgets roll up automatically into the overall budget, and you can make top-down / bottom-up / driver-based changes easily.

    It also allows for custom hierarchies within tracking categories, so you can consolidate and report on multiple tracking categories at once.

    Start a 15-day free trial, or reach out for a personalised demo.

  • Joanna Rees commented  ·   ·  Report

    We just moved from QB to Xero as the former lacks custom reporting but I feel like we may actually have gone backwards as I'm having to spend so much time reconciling the sum of tracking budgets to departmental budgets - rolled up budgets should be standard functionality.

  • Harriet Foxon commented  ·   ·  Report

    It would be good to hear if there is any update on this. I spend hours externally to Xero trying to consolidate budgets to create variance reports. It would be great if not only would it auto consolidate into a master, but if you could choose individual budgets to consolidate too, I.e We have 2 retails functions which have their own budgets, and online sales etc, but we also need to look at the overall retail function variance which incorporates all 3 budgets, and it takes me ages to download the variance reports then merge them together, it wastes so much time.

  • Marcus Daff commented  ·   ·  Report

    Has been a failing for too long. Xero, please address this issue.

  • kirsten Reid commented  ·   ·  Report

    This is crucial. Why set up tracking categories e.g. Deprtments if we can't get Budget v Actuals to monitor them!? e.g. Staff wages costs by Dept as set up within Xero Payroll. Many thanks for your urgent attention to this

  • Timothy Rudling commented  ·   ·  Report

    Some aspects of our business need their own PL and budgeting.
    These then need to roll up to the overall single ABN and to have it auto consolidated is very much a need.

  • Charlotte Norris commented  ·   ·  Report

    We have over 40 practices and growing that are monitored by tracking category - this would save me having to create over 40 custom reports showing each month vs individual budget for each site accountant

  • Zakri Toma commented  ·   ·  Report

    Has there been ANY update on this idea? Xero is becoming increasingly unusable as we need to easily be able to import budget figures into our ledgers by account code and tracking category so they flow into the master overall budget.

  • Trey Pruitt commented  ·   ·  Report

    Managing Xero budgets in Excel wasn't working for me (too much time, potential errors, etc). So I created a tool to solve this problem.

    It now takes me less than 5 minutes to consolidate multiple tracking budgets into an "Overall Budget".

    You can try it out here: https://www.budget-consolidator.com

  • Arna H commented  ·   ·  Report

    So far setting up the budget in Xero has taken me far far too long, i should have been able to complete this in a couple hours, rather than it taking me days to set up as I'm having to go load each department, then checking each, against the full company. We should be able to upload one file, with each account, and each tracking account, and then report on it. Please fix.

    this was only raised TEN YEARS ago.

  • Maya Kemp commented  ·   ·  Report

    Xero don't bother to action anything we ask for even if it's over 300 votes. They just like to make things look pretty. The 'enter your idea' is just a way to make themselves look like they 'value' the customer.

  • Justine Dalla Riva commented  ·   ·  Report

    This is critical, interest to know how many votes are needed before this is actually actioned?

  • Francois du Plessis commented  ·   ·  Report

    Yes, this would be great to have one budget imported, but be able to split GL code amounts by the various tracking categories as required.

  • Brad Ruoho commented  ·   ·  Report

    Please make this a top priority, it seems simple and is so important to our business.

  • Ryan Vu commented  ·   ·  Report

    Please make this a priority. It would set you apart from QBO.

  • Marcus Daff commented  ·   ·  Report

    Every year when annual budgeting occurs and during the year when re-forecasting, my love of Xero plummets as I sigh at having to prepare tracking category budgets as well as bringing this altogether manually into the overall budget. A big time commitment and huge potential for errors.

  • Jean Hamilton commented  ·   ·  Report

    Budget by project/tracking category useless without being able to bring together into an overall budget for the organisation. Get sorted!!

2 4