290 results found
-
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 😁
-
Receivable Invoice Summary - summary by calendar month
Run a report to show me (based on calendar months) my total invoices
The Receivable Invoice Summary does not appear to allow me to do it by month, only by Invoice date with is too fine a detail. There should be an easy option for per month3 votesSounds like you'd to be able to run the report for different date other than the invoice date? This is possible via the Date Search field, select the drop-down arrow and you'll see you can run the report for the date range entered based on the Created date, Due Date, Expected Date, or Invoice Date 🙂
-
AU Report templates - Add Tax Depreciation Schedules
Add tax depreciation schedules in report packs.
Currently, only have the option of accounting depreciation but can't change it to tax depreciation.10 votesHi community, thanks for contributing your support and interest for adding Tax Depreciation Schedules to report packs. With a recent update we've made it possible for Partners to include Tax Depreciation schedule as a report in Report templates.
You'll find the Depreciation Schedule, Disposal Schedule, Pooling Summary and Pooling detail all options when adding reports to a template from your practice. 🙂
-
Income by Contact - Show Total Contacts
On the Income by Contact Report, it would be helpful to have a total of the customers so we do not have to add them manually. At the moment there is only a total of their spend.
3 votesHi Caryn 👋, though not in the report itself you'll find the fixed bar at the bottom of the page will give a total items for the report. 😉
See my pic of what this looks like - Hopefully this helps from those manual calculations!
-
See Double Entry
To be able to view the double entry journal for each and every transaction
2 votesHi Carla, you can run the Journal report to view the impacts of each entry. 🙂
-
Bills - Bulk assign lines to a Project or customer
It would be good to assign multiple rows of expenses to a customer and/or a project at once. The use case is I travel to a client site for a week and have multiple expenses, hotel, travel, subsistence etc to re bill in one hit. At the moment I have to go through multiple steps for each line of expense to assign to a customer and it takes a very long time.
2 votesHi Matthew and Michelle 👋 thanks for engaging in community here. It's actually already possible to assign multiple lines of a Bill to Project in Xero.
From within the Bill or Spend money, once you've added your lines, just click the 'Assign expenses to a customer or project' this'll open a modal from which you can select all and pick the Project or Customer you'd like to assign all lines too.
We also have another idea for assigning multiple bills to a Project at once that you may be interested in supporting across here. 🙂
-
Balance Sheet Report - Title showing as "CASH BASIS"
Balance Sheet Report Title is always "CASH BASIS"
At the top left of the report it always says "Balance Sheet - Cash Basis" even when you choose Accrual. And when the file is downloaded, it always says Cash even if the report is Accrual. Note that in the actual report, it DOES indicate correctly whether it is accrual or cash.
1 voteGreat to hear, and thanks for returning to confirm resolved for you, Ann 😁
-
Account Transactions Report - Show Reference for Transfer transactions
The new Account Transaction report doesn't show the reference from Transfers which the old report did. There is a reference column in the new reports but it is blank for transfers - can it be updated to show this?
3 votesHi everyone, returning to the idea here we're going to move this to delivered. When using Transfer and you've included a reference this'll appear when running the Account Transactions report in Xero. Check out our earlier status update for an image of what this looks like.
- Don't see your idea?