528 results found
-
Trial Balance - Enable "Edit Layout"
As a workaround for an issue caused by the obsolete Xero payroll service, Xero support suggested that I use the "edit layout" feature to group 2 accounts in the report. However, Trial Balance does not have an "edit layout" button, so I am stuck displaying 2 accounts that have canceling balances. One of the accounts is the system Accounts Payable account so I am not able to resolve the issue "correctly" with a manual journal entry. Editing the report layout is my only option.
20 votes -
power query trial balance
Is there a way to create a sql report for trial balance or some other form of report that can be downloaded by excel power query? Eg a website link that could be accessed privately by sending and excel query? It gets very tedious repeatedly downloading trial balances again and again.
4 votesHi team, I would recommend engaging our Developer community with you idea here where we have experts in the space of exporting and syncing data outside of Xero.
-
Aged Payables Report - Group by Planned Date
Allow the Aged Payables Report to be grouped by the Planned Date.
2 votesHi Alison, while there's no direct option to group by Planned date in the Aged Payables Detail report atm, if you change Group to None, once run you can click the Planned Date column header within the report to re-order by this field and it'll group all payable invoices by Planned Date.
-
Reporting - Improve General Ledger Report performance for high transaction volumes
We have noticed that for our clients with large transaction volumes (90k+), Xero struggles to generate the GL detail report. Xero often takes 5 minutes+ to generate the report, or in some cases is not able to generate the report for the full fiscal year (either showing a blank screen or popping up an error - "there is no data to display"). Sometimes we have to pull the report piecemeal by account type and then aggregate, in order to present the full GL detail.
It would be great if Xero could focus on report performance, ensuring that the GL detail…
8 votes -
Trial Balance - Monthly movement report
Would be great to be able to run a report showing the monthly net movement on the trial balance for a year (ie. 12 columns)
11 votesAaah yes I get what you mean, thanks for coming back to clarify for me, Kevin. We'll leave the idea here to gather interest.
While this isn't something we have plans for atm, I'll update if there is any change around this to share.
-
Profit & Loss - Separate Expenses
Separate the INCOME TAX EXPENSE from the normal operating expenses in the Profit & Loss Statement. for example:
- Net Profit Before Tax
- INCOME TAX EXPENSE
- Net Profit After Tax
This is the basics of accounting apps.130 votes -
Income and expenses by contact - Filter using tracking category
We run multiple branches out of one Xero ledger. We find the income and expenses by contact report very handy to track sales data, however it would be much more useful if we were able to filter by tracking catagory (for our instance we track branch locaiton).
11 votes -
Reports - Generate a report for transactions without receipts attached
Users should be able to generate a report of transactions without receipts attached. This allows small business administrators to identify which transactions don't yet have receipts attached.
64 votesHi community, thank you for engaging with us about your needs in a report to view where attachments have not been uploaded to a transaction.
We get how this is a need for some businesses to validify expenses and process payments.
Right now, this isn't in the teams roadmap, however we'd like to keep tracking the interest around this and will share if it is picked up in any future planning with you all here.
-
Checking of Bank Reconcilaition
Would it be possible to have a report that shows the bank transactions and the bill/invoices that it was reconciled with? It's time consuming to check transactions one by one just to find a transaction that was incorrectly reconciled. Please see below example for your reference.
4 votesHi Marleth, the Account Transactions report can probably help you here.
You can customise the report to add a Related account column, where you could then run the report to view the bank account and related account each line was coded to. Does this solve your needs?
-
Attach Notes to the month column.
Attach Notes to the month column.
I produce monthly P&L custom reports and add explanatory notes for large variations etc., when I add a new month column, the notes are stuck to the column number rather than the month, eg. I add January, but the variation notes I entered for December are now on the January column and I have to unattach them then reattach them to the correct column.2 votes -
Tracking Summary report - Add currency column
For the line items in the Tracking Summary, please include a currency column! Historically this was available. Calculating commission now takes WAY longer. Seems like it should be an easy fix.
2 votes -
Cash Summary Report - Include Primary Person
Cash Summary Report to include Primary Person Please.
Can you get a cash summary report to provide in order 3 items as per below
Invoice No ... Contact ...Primary person
I cant seem to find a report for all three .
We send 170 invoices out client who pay sometimes do not include invoice number and we have to track by firm name or contact which can vary also on bank receipt information.
e.g.
I need "Primary person" to help "match" an unidentied payment. so searching for "primary person" identifies the invoice number or the right contact.2 votes -
Balance Sheet - Bank Account assignment with tracking categories
When using Tracking Categories on the balance sheet, we should be able to assign specific bank accounts to specific columns (or tracking categories). it would just be a feature where the balance "as of date" just displays in the column, regardless of all the prior transactions.
Additionally, when paying loans, if a tracking category is assigned for balance sheet tracking purposes using columns, the Bank Balance that is transferred to the note becomes a Liability on the balance sheet. This is crazy. You're essentially reducing the Note liability balance & then increasing it by the same amount as a negative…
2 votesIt does sound like you've set up the Balance sheet in a bit of a niche way to track what you're after here, Sal. Appreciate you wanting more flexibility on how you filter tracking and being able to add a secondary filter for bank account.
I want to be open that this isn't something that we have plans for. We'll continue to track interest from your idea here, but would need to see quite a bit of community support to look at making a change for this in the report.
-
Reporting - Remove Unrealised Currency Gains opening balance from Gains and Losses report
Foreign Currency Gains and Losses - remove opening balance from P&L account 498
Revaluation of the open positions is calculated from invoice/bill issued date to the report date and it is correct. Not sure where from opening balance are coming and are impacting the P&L balances.2 votes -
Reporting - Add Project features in Payable Invoice Detail report, or Filter option to show Bills or Expenses status
Can we have one more column or filter option containing Bills/ Expenses status like Paid, Awaiting payment, Awaiting approval and Draft to generate every details on project bills/ expenses record in "Project Details Report" or Project features in "Payable Invoice Detail" report.
2 votes -
Reporting | Current Financial Year by month - actual and budget
This report is great, I love it but we need to be able to customize it more. When you try and add columns it gives a message saying that you have to delete the total column first, then you need to manually add a total column which isn't the end of the world, but you can't select the the new total column in and of the formulas, like if I wanted to add the variance column (Which I would love to) but I can't.
17 votes -
Invoices - Add invoice notes to age receivable report
Receivable invoice summary- add notes column - if notes are made on why invoice are not yet paid. can we run an age receivables report, that also includes the notes on an invoice please
61 votes -
Reports - Export all excel reports in .xlsx format
Please create all excel exports from Xero in the currrent .xlsx format. Most still produce an old xls.file format (for instance Sales Tax Report) and need to be resaved to bring up to date.
6 votes -
Reporting - Flag when actual Retained Earnings doesn't match to the report value
A flag which shows when the profit & loss figure plus brought forward retained earnings does not add up to the retained earnings on the reports. This is usually due to a mapping issue where a figure is causing a transposition error. It only seems to flag if you opt to include a statement of changes to equity. Seems like there should be a more obvious flag for this issue to ensure it is not missed.
Also perhaps a reconciliation between the profit & loss figure in the company accounts versus the Xero business, appreciate this is likely to be…3 votes -
Option to disable rounding in Xero
I still don't understand why Xero rounds any amounts? Could we have an option to disable all rounding in Xero. I have just left MYOB after 10 years, they never did anything like this. I moved to Xero on advice from my accountant, starting to regret this! Leave it as an option for whoever is rounding stuff (very werid), but please give me a checkbox that totally disables rounding. Please!
46 votes
.png){kind=link}
- Don't see your idea?