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.
-
Richard Jarratt commented
I would like that very much. It will save time and finger trouble errors.
-
Bethany Haughey commented
There is a risk of errors where I need to upload budgets per tracking category and then another budget which sums them all together for an overall budget. I have no way of checking that the tracking category budgets actually total the overall budget total. It also means I have the data in the system twice - once in the tracking category budget and then again as part of the overall budget. This is messy !
-
Ivalin Petkov commented
Yes I would really like this!
-
Brian Deasy commented
We have 14 tracking categories which means we have to create 14 budgets then add them up and create an overall budget. Ideal would be to post budget amounts and select the tracking category into an overall budget.
-
Jason Wright commented
Would be great if there were software that takes budgets from multiple companies (Xero accounts) and consolidates them into one.
-
Trey Pruitt commented
I created an app to solve this specific problem. Takes less than 5 minutes to consolidate multiple Xero tracking budgets, view a consolidated P&L, and import an Overall Budget into Xero. Saves me a lot of time and reduces manual errors. Plus, I can use Xero for budget reporting rather than learning another tool.
You can try it out here: https://www.budget-consolidator.com
-
Mark Gateson commented
why is there no response from XERO on this? i can see external software such as spotlight reporting that can do this but it would be so much easier in XERO...
Come on XERO acknowledge this!!
-
Laura Rous commented
Yes - please can this be a priority
-
Maggie Kavanagh commented
Xero Budgets - Xero needs the function to allow users to total up multiple individual budgets (in the same way the actual business is for all our clients in the P&L. Xero budgets are currently useless to companies with multiple budgets.
We enter about 50 client budgets into budget manager annually, but it's a totally pointless stand alone operation. We have to put everything into Excel so that we can actually manage budgets, actuals and variances through the year.
-
Maturin Piyakhun commented
This feature is a deal breaker for my client to move across from MYOB. So without it, still no Xero.
-
Sean Trengrove commented
Enabling this feature would streamline the budgeting system for us by making it easier to agree cost centre budgets and understand their impact across the business with confidence
-
Kate Gloudemans commented
I have spent ages setting up new reports and bdgets and was mortified when i realised i couldnt consoidate the different tracking budgets without excel. crestfallen
-
David Eagle commented
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
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
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.
-
David Shepherd-Cross commented
I agree this would be very useful, rather than using overall figures.
-
Joanna Rees commented
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
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
Has been a failing for too long. Xero, please address this issue.
-
kirsten Reid commented
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