1081 results found
-
Budget | Export - Separate column for Account Code
I would like to see the budget csv download with a separate column for ledger code. That way it could easily be sorted by ledger code rather than alphabetically.
12 votes -
Report templates - Support General Purpose Financial Report (GPFR) templates
Financial Statements-General Purpose Financial Statements template published will be much appreciated so the accountants have more options
32 votes -
Report Templates - Allow "Current date" to be inserted in reports at the client level.
There is no options to insert automatic date formatting into the reports at the client level. When the "current date" insert field doesn't work you have to manually enter the date all the time. It would be easier to be able to insert "current date" field.
18 votesHi everyone, back to share that this feature is in roll out to all customers using Report Templates.
As mentioned in my last update, this change prevents a report field from being edited once added and run at the client level. So this field will stay connected and continue to automatically update.
This will be live to all customers in the coming weeks and I'll come back to share once it's fully out.
-
Reporting: New P&L Report - Include archived Tracking Category used in date range
"Compare Tracking Category" in the Old Format P&L Report includes columns for all Tracking Category Values USED in the date range; irrespective of whether the value is ACTIVE or ARCHIVED.
"Compare Tracking Category" in the New Format P&L Report is different: it includes columns for ACTIVE Tracking Category Values. This represents an incomplete view because ARCHIVED Tracking Category Values USED in the date range are not included.
Please can you enable reporting of USED Tracking Category Values in the New Format P&L Report before you remove Old Format Reports in July 2023.
Custom reports don't provide a viable solution due…
7 votes -
Financial Accounts - Switch rules effect notes
Would like to see switch rules work in the notes to the financial accounts the same way they work on the balance sheet - allowing for reclassification of accounts with negative balances, for example negative current asset to current liability or negative non-current liability to move to non-current asset.
These issues are particularly acute when an account goes from positive to negative and vice-versa between current year and prior year.
On the basis the switch rule does not operate correctly in the notes to the financial accounts, means that in many cases the switch rule is rendered an unusable feature…
55 votesHi community, I'm Brigitte, a Senior Product Manager from our Xero reporting team. We’re doing some research on how partners manage notes in Y/E financial reports, and we’d love to hear about your current workflow using report templates.
How you can help:
- This conversation will take about 30 minutes via video call
- We'll ask you to share your screen to walk us through your current process of preparing/reviewing notes
If you're interested, please use this link to choose a time that best suits you.
If none of the available times work, just reply to my update with a preferred time, and we’ll do our best to accommodate!
We greatly appreciate your constant support & valuable input for the reporting team! Thanks so much.
-
New Account Summary Report - Search by Account Code
The new Account Summary Report needs the Account Code in the drop down list. Currently it only has the names of the accounts. There is no option to show or hide the Account Code. Sometimes I work with the account codes and not names. I need the ability to type the code in as well.
8 votes -
Account Transactions report - Move selected date range a period forward or back
When in account transactions (or any report where you can select a date range) have a button to move that date range one month forwards or one month back.
For example if you have the date range selected as 01.08.2022-31.08.2022 have a backwards button that would change this automatically to 01.07.2022- 31.07.2022 or a forwards button that would change this to 01.09.2022-30.09.2022 without having to go in and manually change the date to every month.
This would be very helpful when doing detailed reconciliations on a monthly basis so you can move between the months much quicker. I know you…
24 votesHi everyone, we appreciate interest in a setting within the Account transactions report that would allow you to move forward a period or back a period from what's currently set.
In openness, this isn't something we have any plans for developing in the near term but we will continue to track the community interest of here.
While not exactly what's being asked in this idea I did want to highlight the Common date selections that are available within the report atm with the ability to easily select 'This month' or 'Last month'.
If there is any news of improvements for dates that'd accommodate what you're after here, we'll update you all.
-
VAT group feature - Option to prepare and finalise individual returns for non-MTD VAT organsiations
It would be great to see a feature that was specific to VAT groups so it's an easy experience (rather than importing and exporting figures)
49 votes -
Reporting - Option to default include GST in Debtors & Creditors reports
Can you add a option in the standard reports to include GST in debtor & creditors without having to create a custom report
2 votesThanks for sharing, Paul.
Appreciate it's a few steps to set up and add the columns, however once formatted as you like, if you save as Custom you can then set this as the default so it's a onetime effort.
Understand this may be more cumbersome if working with many organisations. Being open this isn't something we have plans for currently. We'll watch the interest in this, here.
-
Profit & Loss - Ability to add variance columns for YTD Actuals & budget
Added features to P&L report design to be able to add variance between YTD Actuals and YTD budget on the P&L report
7 votes -
Reporting - Set default date columns from oldest to most recent
A button you can click to reverse the order of the columns in Reporting
Typically the reports show the month in question closest to the account descriptions and then the prior months in columns to the right but we'd like to look at our current year starting with the earliest month in the column next to the account descriptions and the remainder of the year in columns to the right. This is particularly useful when building out projected cashflows.30 votesYou can re-order the columns of your report with the layout editor, Robbie. 🙂
Once you've got the report set up as you like you can Save as Custom to easily access the report with this layout.
If you're like to make this the default layout there is also an option for this - see our help here & here
-
Reporting - Filter Inventory reports by Tracking
Please add ability to filter inventory reports by tracking codes, so you can see quality purchased and sold by tracking code.
35 votesHi team, while not available in the Inventory reports directly you could run the Receivable or Payable Invoice Detail reports where you'll find your can group and filter by Item and Tracking which should help you get a picture of quantities purchased and sold by category 🙂
-
Profit and Loss - Filter tracking category by actual and budget
The new Profit and Loss report does not filter the actuals AND budget by tracking category. You have to manually add the correct tracking category budget to the report. When you have 40 plus tracking categories this becomes time consuming and silly.
The old profit and loss report did this easily. So the new report is a major step backwards
Ensure the filter for the new profit and loss report filters BOTH actuals and budget, so the report is easy to produce and has meaning. Do not expect users to add the correct column for budget - particularly those less…
51 votes -
Profit & Loss report - Filter by project
Project reports are very difficult to follow and understand. The ability to click a transaction and open the source is not possible unlike all standard Xero reports. A Profit and Loss by project is crucial. Project transactions need to be combined into the audit trail so that standard reports can be ran to include project information.
91 votesReally appreciate those who’ve taken the time to share how this’d help in your day-to-day. We know being able to filter a Profit & Loss report by project would make it easier to understand how your jobs are performing.
Right now, the best workaround is to export your data and make adjustments for this in Excel, but we get that it adds extra steps.
There’s also the Profitability dashboard feature in Xero Projects, which gives a quick view of how each job is tracking, and may be helpful.
We’ll keep an active eye on the interest this idea continues to build through votes, but do want to be transparent that this is not in our roadmap for the foreseeable future. Thanks again for your input through Xero product ideas.
-
Profit & Loss Reports - Change variance column for costs
The variance columns in the current P&L reports don't make sense - increased costs show as positive variances, despite the red arrow. The formula is fine for revenue and profit, but needs to be the other way round for costs. Is it possible to have this, or to add a column with different formulae for different sections?
10 votesHi team, to confirm how the Budget Variance report works currently it'll show;
- Green arrows for favourable amounts
- Red arrows for unfavourable amounts
- Increases in the amount from budget will have an upward arrow
- Decreases in amounts from budget will have a downward arrow
We appreciate your feedback here however being open, there are no plans to change the way this logic is applied in the report, or to extend the arrow colouring across the figures/amounts in the report.
-
Reporting - Ability to Bulk Archive Published Reports
It would be useful if we were able to select published reports in bulk to archive them, rather than having to do them one at a time.
9 votes -
Reporting - Create folders to manage reports (Custom, Published and Archived)
Under Custom Reports
I send out reports to my departments each month, this morning it took 4 hours to add the tracking codes to the new P & L reports (we love the new report and so do our Department Heads).
I was wondering if there is a way of saving each custom report for each individual dept with their tracking within a folder. We have a Junior and Senior Campus and about 45 departments at each. We already have a lot of custom reports so having a folder system would allow each Admin staff member to access what they…40 votesThanks for the example, Shellee! That's a good few departments 😮
There's no facility to create folders in the Reports Centre for this sort of categorisation atm.
We'll begin tracking support in this here.
-
Profit & Loss - Ability to sort expenses
Ability to sort expenses on a Profit and Loss report from largest to smallest.
8 votes -
Reporting - Switch layout between left-right and right-left
When you download a P&L / BS report (whether old or new templates), and include comparative periods, there should be an option to choose left to right, or right to left. If i have downloading for Jul-22, with 12 months of comparatives, i want the oldest month to be on the left, and Jul-22 to be all the way to the right. That is typically how all excel financial models are built, and the basis of these models is historical financials.
20 votes -
CIS - Verify Subcontractor without specifying CIS rate
Using the new Contracts form, when verifying a subcontractor, you are now asked to enter the CIS Tax Rate (Gross, 20% or 30%) before you verify the subcontractor.
You cannot save and verify with HMRC unless this field is completed. Without verification, you cannot be certain as to the tax rate.The error could occur where you choose a rate for the purpose of being able to 'save and verify'. If the verification failed and you required to speak to the contact, or in most cases wait for HMRC to add a subcontractor to the CIS scheme which is currently…
7 votes
- Don't see your idea?