- or
1341 results found
-
Custom Report - Ability to decide if a formula row or column takes precedent
You can add formula columns and rows to a report, but from what I can tell, the column formula always takes precedent over the row. It would be cool if you choose if you want the row formula to calculate in the column formula column
5 votes -
Trial Balance with OPENING / CLOSING balance and and Movement from GL Summary Report
Team Xero
currently TB report shows ending balances for current year in db/cr two columns AND in single column Clubbed up remaining balances +/- in when COMPANRED to previous periods.I propose/request IT to make TB more classic by
- showing ALL remaining balances in two columns DB/CR when comparing previous years
- OPENING and CLOSING balances columns to be available (year selected from starting of fiscal year Jan20xx)
- TB report to ALLOW us to SELECT RANGE of dates (Range based TB)
- MOVEMENT (total Debits Total Credits) for the selected DATE and/OR RANGE should be available. CURRENTLY this is available in GL…
6 votes -
NZ GST Return- Ability to only show a single line per invoice on the Transactions report
When running the GST Transactions Report, each and every line from each invoice is reported separately, creating a ridiculously large report.
Perhaps there could be one single line per invoice, reporting the total GST for that invoice? Like it used to be?Thanks
3 votes -
Journal report - Export with Narration / description
Could we please have an update on Manual Journals, so if you extract the Journal report it would so the narration/ description we add the each line of the journal report.
Also if we can print PDF a specific journal so it flows well with the above information1 voteHi Navisha, our team have been making lots of development with Xero's new reports.
Yesterday we released the new Journal report where you'll find you can add both Narration & Description as separate columns in this report.
Once set up, you can export the report to PDF, Excel or Google Sheets 😁
-
AU BAS - Automatic detect for Simpler or Full BAS report
New Xero Activity Statement Report
It would be great if the new activity statement report automatically converted standard BAS to simpler BAS when importing into Xero Tax like the old ones has done for ages. We don't like having to produce two different types of reconciliations within our practice because then there are two different ways of doing things, which confuses junior staff. We want Xero to make things easier and automatically import the needed data as the old activity statement report does.
2 votes -
Business Activity Statement | GST Audit report - Add transactions source field
I would like the GST AUDIT REPORT to be permanently updated, so that the transaction SOURCE FIELD would be included in the report. Otherwise the report should be customisable to include this and many other fields / options, so any of us professionals and internal accountants can extract what we need to review client / business BAS data easier, and lodge the BAS's quicker. There are MANY ideas for the GST AUDIT report to be customisable and several are also relevant to me and my needs, but I couldn't find a request for this one and it is such…
2 votes -
Reporting - Calculate COGS for Untracked Inventory items: Opening Stock + Purchases - Closing Stock
To make the profit and loss report calculation is based on Cost of Goods Sold = Opening Stock + Purchases - Closing Stock.
Purpose: To get the figures easily in P&L report by deducting the closing stock from purchases.
14 votesHi community, in the way untracked inventory in Xero works it isn't possible to automatically calculate cost of goods sold for a period in your reports.
There is a way to go about this yourself through entering Manual Journals to account for the Cost of Goods sold, and adjusting the value of inventory on your Balance Sheet.
You'll want to enter your Conversion Balances into an account that has a Current Asset type rather than an inventory type (Inventory type is reserved for use with tracked inventory in Xero and can't be coded to on manual journals).
To avoid potential taxation and reporting issues - We highly recommend contacting your accountant to check whether this is suitable for your business, or if you need additional clarification on what journals to enter. -
Profit & Loss - Default date of Custom category column to follow report date
In response to the "Custom Report - Update-able date column" idea (now closed), you recently added the option to 'Follow report date range' so your custom date columns will automatically update based on the date you run the report for.
Why (on earth!) is this not the default behaviour? This is what I thought should be happening and have spent ages, included a support session, trying to sort out the implication of it not working as expected. The column date should normally reflect the report date, surely.2 votes -
Reporting - Include Draft invoices and Purchase Orders in the Sales by Item report
It would be great to have an option to run a sales report by item which includes draft invoices, delivery dockets, and purchase orders as well.
For example, I tried to run a sales report on qty of each product sold for the financial year to date and realised this information was inaccurate as we had sold a significant qty as draft invoices (using draft invoicing in lieu of delivery docket functionality), these products were not included in the sales report.
2 votes -
GST Reconciliation report - Common date formats
GST Rec - 2 Simple ideas.
In the GST Rec report you could add drop down dates (as you have in the other reports) so you can easily pick the prior financial year as an option rather than having to pick the dates.
A GST report that showed the late claims that relate to the prior financial year.
1 vote -
NZ Payroll - Report for current leave plus leave available to take in advance
A report that shows current annual leave hours, plus leave available to take in advance hours for each employee. It's very time consuming to have to calculate leave if you want to give an employee leave in advance. Using the "show leave available to take in advance" option in the employee set up tends to give the wrong balances on the employee payslip which leads to confusion.
6 votes -
Account Transactions report - Option to Group by and then summarise within a group
Account transaction report that can analyse multiple accounts in one report by grouping everything by account and then summarising each account by contact at the same time.
2 votesNot exactly what you're after here, however in lieu of not having the ability to summarise within a group you could use the column header to order by Contact within a grouping.
Being open, we don't have any plans for developing this capability in the near term.
-
Reporting - fields and functionality of old report pack.
Report fields and functionality of old report pack.
We are sad to see the old report packs being discontinued. We use these to complete all our company and trust resolutions as they are able to pull through shareholder salary fields as well as net profit before tax and net profit after tax. Whilst we can type these in manually, they can be prone to human error and is more time consuming. Please update the new reports so that this functionality is maintained or keep the ability to keep cusomised reports active. I don't mind if you discontinue all…
1 vote -
Account Transactions report - Show all related accounts for split transactions
In the Accounts Transactions Report - Show all related accounts to include ALL split transactions regardless of how many there are.
The current Report only display the first few, (please see upload) current format is not fit for purpose. Please under show related accounts, include split transactions not just the first few.2 votes -
Project Reports - Ability to edit Detailed Time Report
It would be great to be able to edit the detailed time report similar to how we can edit the P&L and balance sheet reports.
We simply want to add a timesheet sign off area at the bottom of the report, which would be easy to add if that feature was available.
1 vote -
Batch Payment - Ability to 'Bundle' Source Documents with Batch Payment Summary Report
It would be great if there was an option to automatically attach the supplier source invoices to the batch payment summary report.
For example, where an SME has an in-house accounts person raise the batch payment for approval, you would have the option to not just download the batch summary report but include the attached files as well (i.e. the supplier invoices).
Currently you have to down load the batch payment summary and attach the invoices separately. Whilst accounting practices may have document manager packages that can do this for them, SME owners may not and this feature would…
4 votes -
Contacts - Replace link for 'View recent bills' to filtered Supplier Bill Activity report
Can Supplier Bill Activity report be tied to this link (with auto-population of the supplier name in the report) so that I would not need to TYPE suppliers' names in the report every time I need to see the history of the supplier, which I do all the time?
Thank you,
Eugenia2 votes -
Run a report on a monthly basis to pay my employees expenses
If employees are putting their expenses onto Xero Projects then you should be able to pull a report and pay their expenses from it. Otherwise they are going to have to duplicate work by putting it on Projects and then submitting an expense claim.
4 votesMaybe a case of understanding your workflows here a bit better, Rachel. Currently when entering an expense through Xero Expenses you can assign to Projects so these'll attach and show against your Projects in Xero - Would be great to get more details if there's something in here which requires duplication.
-
GL report - Include tracking categories
General ledger reports include tracking categories
5 votesHi team, as previously noted although not in the General Ledger specifically it is possible to get this information running the Account Transactions report in Xero, this can then be exported if you'd like to make use outside of Xero.
We'll mark this idea delivered with the option above, if there's particular reason you need this detail in the General Ledger welcome to add this idea back in the forums and please detail your needs to be considered.
-
Reporting: Archive Custom Reports
In the custom reports menu, if you are no longer using a report but may need it again, the only option is to leave it there or delete. There is no option to archive the report. It would be good to have this option in case you need to refer to the report later.
5 votes
- Don't see your idea?