Reporting | Budget Manager - Customise report layout
Ability to customise a budget manager layout.
Purpose: To make users able to get their preferred figures appear in the budget manager report.
Hi community, thanks for your support and engagement on this idea. We acknowledge your desire for enhancements in how you can Budget and forecast reporting within Xero, and being able to mirror custom Profit & Loss report layouts you've created.
While we understand the needs expressed by you here, we want to be open that we don't have immediate plans for developing this tool.
We're continuing to look ahead and assess the base needs of our customers when it comes to budgeting and working in Xero and will keep you updated of any upcoming developments that could support in your needs here. Thanks for your continued feedback and support through Xero Product ideas.
-
Marilyn Jeffcoat
commented
I personally developed an extremely useful spreadsheet which projected not only cash flow and profit and loss but also confirmed the figures in a related balance sheet.
This showed figures up to to 24 months in advance as auditors require you to prove you are a 'going concern' for 12 months after signing off the accounts - not just for the succeeding year.
I have been providing these figures to the bank and to directors for the last ten years. By inputting the SAGE TB onto a spreadsheet.
As I was concerned at the fragility of this system and its reliance on my input, I convinced them to move to XERO.
I now find that I can't generate even a simple 12 month forecast in a format they would recognise.
Your old formatting system could l do that. Whilst you work out a new system could you not re-instate that format. -
David Elsey
commented
Have a look at https://xpna.co - top-down / bottom-up / driver-based budgets are easy to build, and automatically consolidate tracking categories into overall budgets. And you can report on them in exactly the format you need.
Multi-entity is also supported, so you can budget entities individually, and get a consol budget for the group.
-
Michael van Klink
commented
i agree entirely. if you customise your P&L reports to suit the needs of the business then the ability to adopt the same structure in the budget manager (for budget data and forecast data) is a must.
-
Michelle Black
commented
Really need to be able to budget for non P&L items like loan repayments and asset purchases/sales. Reaaly needs to be able to flow through to a cashflow format, as well as the basic P&L
-
Anita Wildman
commented
Budget Manager needs some attention please per the comments on this post.
I also note there are multiple threads requesting the same thing - can the xero moderator please combine these threads to understand the true need for this? -
Rebecca Knowles
commented
to be able to inclulde budgeted cashflow on asset purchases is critical for the entity
-
Robert Sutherland-MacLeod
commented
I agree with the budget format should be the same layout as presented for the P&L reporting format, otherwise why have it at all!
-
Sarah Prime
commented
I would much prefer my budget manager (and other reports) to appear in account code order, not alphabetically.
When entering a new season's budget, it is time consuming constantly searching for accounts and seeing them listed out of context. I set up my chart of accounts so that they made sense by department, and the budget doesn't enable this to happen!
I am going to do our Farm Budget in another app and export the actuals from Xero (meaning I'll be manually inputting Budget to Actual data in Excel), because it will be quicker and neater. I shouldn't need to do this.
I love Xero for everything but this is a really big flaw in the software from a user perspective.
-
Julie Ambrose
commented
This cannot happen soon enough!
-
kirsten Reid
commented
Users: Please also vote for this Idea below to make changes happen! Many thanks
Reporting - Budgets by tracking category to integrate with master overall budget
-
kirsten Reid
commented
Users: Please also vote for this Idea below to make changes happen! Many thanks
Reporting - Budgets by tracking category to integrate with master overall budget
-
kirsten Reid
commented
Users: Please also vote for this Idea to make changes happen! Many thanks
Reporting - Budgets by tracking category to integrate with master overall budget
-
kirsten Reid
commented
A must have!!!
-
Lauren Ramsay
commented
Must be able to customise date range in budget manager - makes no sense otherwise when using the P&L custom date range. this is a very basic option that we should not need to vote on, it should simply be included.
-
Julie Curnow
commented
So much manual manipulation for something that should be a standard feature. Xero must think no one has to prepare forecasts.
-
Alfred Pardoe
commented
The ability to make groups from individual accounts in Budget Manager the same way you can in reports. This would be an extremely helpful ability if you were making consolidated budgets for multiple entities or "areas" within a single entity.
-
Andrew Babbage
commented
Is it possible to allow the budget module to simply import the layout and grouping of a selected P&L report format? These report layouts are stored somewhere in the data files and if they can be applied to the actual results of the GL accounts, can they also be applied to the budget screen GL accounts? Happy to discuss further as needed.
-
Divya Pereira
commented
A must as the PL gives so many ways to slice & dice results
-
Paul Ainsworth
commented
The ability to customize the budget layout is a must have. There is no point having the custom feature in the P&L but not the budget. I need to match the budget to the customized P&L layout, otherwise the budget manager feature is completely redundant for me.
-
Chris Braid
commented
Xero budget is terrible. Only give P and L not an actual cashflow budget. Should have the ability to select from your chart of accounts, to create the budget you require for your business