990 results found
-
Trial Balance report: More than 36 months historical comparison
Could we please have the functionality of running TB reports with more than 36 months historic comparative months, thanks
4 votesHI community, thanks for your support here. While this isn't something we have plans for extending comparatives beyond 36 periods atm, it'd be good to get more detail on the ideal # of comparatives you'd be looking to run the report for, and what this would help your business do - Please do comment to share your views.
Other options you'll see you have with the new report, is that you can change the comparative period between Day, Month, Quarter or Year.
-
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.
14 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
33 votes -
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…
56 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.
9 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 -
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
8 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.31 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.
36 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.
92 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…42 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.
23 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 -
VAT Return — View invoice numbers
Could the VAT transactions report in the VAT return include the invoice number as well as or instead of the reference?
This would make the review to see if there are any missing invoice numbers much simpler. Our invoices are created in another software package by a number of people who sometimes include text as well as the invoice number and it makes sorting by numerical order time consuming. Having the invoice number as a field would make it very easy to sort in numerical order and identify missing numbers.
9 votes
- Don't see your idea?