277 results found
-
Reporting - Aged payables report: default to today's date
Aged Payables Report
This new report defaults to todays date, and you cannot create a template that defaults to the end of the current month. I need this report to show the actual invoices owing, as if I use today's date it shows invoices owing that I have already sent to my bank for payment at the end of the month. The old report worked great and defaulted to the month, but it would be great if this was an option for the new report.5 votesHey everyone - Just a quick update to let you know we’ve tweaked the default date picker on this report 😊
Now, if you open the Aged Payables, the date will default to the end of the month, and not today’s date - replicating the behaviour of the old version.
Thanks again for all your feedback on this!
-
Find & Recode - Tracking
Tracking Category Find & Recode - Please add the ability to do find and recode on tracking categories. Having to manually update tracking categories one by one on each transaction is unreasonable when there are a lot to get through.
1 voteHi Morgaine, it's already possible to add or change tracking through Find & recode.
Might want to try it out in the demo co. first to see how it works 🙂
-
Groups in Reports - alphabetical ordering (accounts within the group)
Can you please sort accounts within a "group" on the P&L / Balance sheet as alphabetical? Currently they are random it and looks unprofessional
1 voteHi Tara, to offer flexibility users can drag & drop accounts to change the order of where they appear in Financial reports (including within a group) through the Layout editor.
Being open we don't intend to create an auto ordering feature with this option available.
-
Make expense claim photo feature available for bills
Enable the expenses app to analyse photos of bills and post them as draft bills instead of draft expense claims.
1 voteHi Tom, there are a couple of ways you can auto create draft bills in your org already. Your organisation will have a unique email you can send your bills to your Xero org or you could look to connect Hubdoc to Xero and publish documents from Hubdoc to your Xero org.
-
New reports - Ability to automatically include budget that linked to department without editing the layout
The change of reports from the old version to new new version reports. Could the same features be included. The old version of reports are user friendly and had features such as including budget to linked to the department.
However, the new version does not have this facility without the change in edit layout. Which is time consuming when Xero is all about reducing time producing reports. I would like these as standard reports so more time is spent on analysis of reports.7 votesHey community - just a quick update to let you know that this is now live!
Earlier this this month we rolled out an update to the Budget Variance reports, allowing you to to add and choose which budget you view when running the new reports.
You're now able to select budgets from the 'budget picker' drop down pictured in my screenshot.
-
Balance sheet - Only show summary of a group
Balance Sheet - to be able to add a formula to balance sheet lines instead of grouping lines together. Example, I would like to be able to see only the total asset line on the balance sheet rather than seeing the cost line and the depreciation line i.e Computer Cost - Computer dep'n. Currently you can group the lines to then show a total for the grouping, however you still need to have both lines showing on the report. it would be good if we had the option to add a formula to calculate both lines removing the lines we…
1 voteHi Erin, this is already possible. Within the Edit Layout view, if you select to show Total and click the group heading to only view the group title within the edit layout screen when you save the report you'll see this is reflected when you run the report.
-
Journal Report - Option to include the description or reference.
Journal Report - Layout
Ability to edit the layout of the report to include the description or reference.
6 votesHi team, not long since my last update we have now gone live with our new Journal report in Xero. 😁
Thanks again for your engagement in community, here.
As noted earlier, with the new version of this report along with more detail and abilities to sort and filter you'll find 'Description is now a column that can be included and filtered by in this report!
-
Profit and Loss - Compare by active clients
The new Profit and Loss has lost the functionality to compare by active client column (active within the chosen time period).
The old layout should not be removed in July 23 - it should stay until Xero reinstate the basic existing functions.
Xero for our company doesn't even have the option in 'common formats' to compare by client at all. I have read many complaints and some answers suggesting that if you have 60 tracking categories, then the option won't appear in 'common formats'. I don't know if that is the reason as I can't find any answers from Xero…
1 vote -
Report which shows which Bank Account something came from
I have multiple bank accounts in Xero in which I reconcile payments to the same Chart of Account. I would like to be able to run a report which shows me how much logged against a particular Chart of Account came from each bank account. While at the moment it will show you this in the report it will not total it meaning I have to export to excel and add another step.
1 voteHi Stephen, with the Account Transactions report you can include 'Related account' as a column.
If you then select the Bank Account you're wanting to look at and Summarise by Account this will allow you to view all transactions through your banks and see the chart of account it was coded too.
-
Financial statement
There should be a high level financial P&L that can be ran that will report total department spend or total department spend vs. total department budget that does not include account level information. This is a report that can be better shared without driving the report into the minutiae of the account level details. I have seen that most ERP software have this type of reporting.
2 votesHi Alvin, it's possible to create a summarised version of the Profit & Loss yourself through the use of the Layout editor.
In the editor you'll be able to group accounts to show a summarised total rather than the individual account figures.
You can then run the profit & Loss to include the relevant columns (Tracking or budgets) as you choose.
Once you have the report set up as you please, save as Custom to run and use this report regularly.
-
Bulk matching invoice receipts from a Direct Debit run
For a company that takes Direct Debits from customers and the receipt appears as one line on the bank statement it would be useful to be able to bulk match the receipt to multiple customers rather than having to manually select every invoice the receipt relates to. You could do this by being able to import invoice payments in the same way you can import invoices into Xero.
3 votesComing back to this idea we're going to switch this to delivered - you can make use of Batch deposits to group and match payments.
-
Bank Rule - Set tax treatment (Inclusive, Exclusive, No Tax)
We have some suppliers that charge tax (e.g. VAT) and others who do not (e.g. from abroad).
On the bank rule creation/editing page, it would be useful to be able to specify the default taxation status (i.e. Tax Inclusive, Tax Exclusive, No Tax) for all transactions being processed by that rule.
This would save having to manually select the correct tax category on every bank rule transaction during reconciliation.
3 votesHi team, not having any response to our last update we will move this idea to delivered. To confirm - when using bank rules to create transactions you can specify the tax rate that should be applied to the transaction within step 3 where you allocate line items.
For example you can set if the bank rules created from certain suppliers would have VAT rate 20%, zero rated or No VAT.
-
Filter to manual reconciliation screen
It would be useful to be able to filter the account transactions page between reconciled and unreconciled transactions, as well add a date range. I have to do lots of manual reconciliations so being able to filter the transactions that actually need reconciling is quite important
1 voteThis is possible, Katie 🙂
If you click Search from the Account transactions tab of a bank account, you'll see an option to enter a date range and select Status 'Unreconciled'
Here's a pic
-
Account transaction reports - View description and account coded to
It would be very useful to be able to create Account Transaction reports for individual or grouped bank accounts that show detailed descriptions and split transactions and which account (chart of accounts) each item in the split transaction is allocated to.
1 voteYou can already do this in the Account Transactions report, Ann.
You can select to add Description and Related account as columns so you can see the detail and account each line was coded too.
-
Bills - Approving supplier invoices
Why do we now have to approve supplier invoices once entered in Xero?
There has obviously been an update to change this. How do we revert back to once a supplier invoice has been entered it shows straight away under awaiting payment?
1 voteThis may depend on how you enter bills in your org and their set up.
Manually entering, there has been no direct change to behaviour and you should see options at the bottom of the create bill screen where you can Save (which will save as Draft) or Approve.
Hubdoc has options that can be selected to determine the status a bill is published from Hubdoc to Xero with, whereas both email to bills and eInvoicing have always generated Draft bills that require manual approval.
-
Create custom customer report by group
Ability to download a simple customer group report with only Contact name and relevant email addresses to enable easy mail merge with existing software.
1 voteHi Bethany, if these contacts are set up as a group in Xero you can export just those contacts from the Contact list view.
This file will contain the Contact name, Email as well as other details.
-
Calculate unit prices in invoices and bills
It would be great if when entering invoices and bills, in the unit price you can enter multiple numbers. Like you would in a cell in excel. Eg. =100+500+100. and when you tab across to the next field, it totals it up to show 700.
Thanks.2 votesHi Michelle 👋 - Xero has an inbuilt calculator. You can find out how this works in our help here
-
Xero Accounting app | Dashboard - Remove overall cash balance
Remove the Overall Cash Balance section from the mobile app. It takes up too much space. There is already a bank account summary section so it is unnecessary and if it must be there put it at the bottom.
2 votesHey Community, good news! You can now have those widgets in any order you like 😊
We've made some improvement to the Xero Accounting app, to enable users to rearrange widgets on their dashboard.
You can place that Overall Cash Balance widget wherever you like. Even if that's right at the bottom, Matthew 😉
The screenshots below have a visual of the new change.
-
Reconciling a credit-card bill for which "points" (vs real money) have been applied as payment
We need to be able to reconcile a credit card bill for which "points" (vs real money) have been applied as payment.
The next month's credit card bill came in with all the credits as single-time items to "reconcile". Xero Support wasn't able to give instruction about how to reconcile those credits. They told me to post here for a new feature.
1 voteAppreciate your were sent to the idea forum here however there are ways to reconcile these payments in your Xero account currently, Cheryl.
If you have both the bank you're making credit card payments from and the Credit Card connected to your Xero organisation, you would be able to create 'Transfer money' from the bank account to bring down the balance of your credit card in Xero - More on managing credit cards in our help here
When you receive a 'points' on your credit card that pay off the balance it sounds like you also receive a statement line for this in Xero? If this is something you commonly deal with, you could look at creating an account in your chart of accounts that you'll be able to create 'Receive money' transactions and code these statement lines to.
It'd be best to check in with your Xero advisor…
-
Report - All Excel exports in up to date version of Excel
Please create all excel exports from Xero in the currrent .xlsx format. Some are still produce in the old file format (for instance General Ledger Report) and have to be resaved to bring up to date.
3 votesHi team, as you'll all likely be aware our older reports are going to be retired on 31 July this year(2023)
You'll find all of Xero's new reports where you select to Export Excel come in a .xlsx format 😁
- Don't see your idea?