277 results found
-
Account Transactions Report | Paid or Unpaid Bills / Invoices
I wish to see if invoices are paid on unpaid when pulling account transaction reports.
Accounting - Account Transaction Report - Columns - (add if we can see if bill/invoice paid or unpaid)
There is no way currently when pulling this report to see if the bills are paid or not.
7 votesApologies for not seeing your response here sooner, Jayden. Thanks for sharing that image. I do hope you've got your answer already but to confirm for anyone viewing here - That screenshot appears to be the Account Transactions report.
To view paid or unpaid invoices or bills you'll want to run the Receivable or Payable Invoice Detail reports. This is a slightly different report to what you're looking at and can be found in the Payables and Receivables section of the reports centre.
-
Bank Reconciliation report - Default to show decimal places
Can we please have the bank reconciliation reports default to show decimal places. I've never seen a bank rec that rounds off the decimals until Xero introduced it.
3 votesHey Barbara, thanks for sharing your idea!
Earlier this year we rolled out a change to the Bank Reconciliation report, it now defaults to including decimal places. This can be changed by deselecting 'Decimals' from the 'More' menu. I've attached a screenshot as an example 😊
-
Reporting - Trial balance as favourite
Trial balance should be included as Favourite in reports.
1 voteHey Syed, you can mark any report as a 'Favourite' by selecting the star icon next to the Report name in your Accounting > Reports screen.
I've attached a screenshot as an example 😊
-
Profit&Loss New-Report in multi-currency
Ability to run the profit and loss new in a currency other than the organisations base currency
36 votesHi everyone, thanks for your contributions to the idea and to those who jumped in to help test and play with the multi currency before the full release.
Today I can confirm we've released the ability to run the Profit & Loss, Balance Sheet and Budget Variance reports in other currencies an org has been using to all users. If you're using multi-currency in your org you'll find this extra option in each of these reports settings. 😁
-
Reporting - Duplicate a customised report within advisor report pack
We would like to have the ability to duplicate a customised report in a financial accounts pack within the advisor reports.
For example, when preparing monthly reports, they will include a YTD profit and loss report then a month by month profit and loss report.
The P&L reports can have quite a few customisations like grouping and added formula's etc, so it would be a huge time saver if we could duplicate the YTD P&L then edit to make it month by month, rather than having to start customisations from scratch with a new P&L report.8 votesHi team, this is possible through the use of the Management report in a Xero org.
If you click the 3 dots next to Management report you'll see you can Create new report pack where you'll have the option to add any of your custom reports that have been saved in the org. 🙂
-
Reporting - Include journal ID
Include the unique transaction ID (from the Journal Report) on other reports including Account Transactions / General Ledger reports / Project reports / Inventory Item Details report.
Purpose: So we can easily see which transactions have gone through since the last month end / close, as the transaction ID's are unique and incremental. We cannot rely on the dates of transactions as invoices will come in with old dates which will appear like they were posted in a previous month, but are a new transaction. I believe having the transaction ID's on reports will be a significant improvement for the…
39 votesThank you all for your support and feedback to the idea here. We now have the new General Ledger Detail report that includes the option to add Journal ID as a column in the report live to you all!
Within the report itself you'll be able to rearrange columns to drag and drop this where you'd like it to sit in your report, and once you have set up how you like save as a Custom report to access this format whenever you need. 😁
-
General Ledger Reports | Excel export - Improve applied formatting
Hello
Would it be possible to have the old v1 General Ledger report in blue Xero that was recently replaced with a new General Ledger Summary and General Ledger Detail report still available to be used.
The new versions a good and can be formatted to look close to the old report but the old report exported to Excel really well with gridlines still showing and reasonable column and row sizes so large amounts of data can be viewed at once.
Many Thanks
5 votesWe've just released the change! 😁 As per my last update - you should now find the report easier to read and work with with updates to some of the sizing of fonts, consistency in the format of cells, and overall reduced zooming of the reports when you export to Excel. Thanks again, for your support in helping us make reports better for you.
-
Accounts transactions report - Set default for archived accounts
The show archived accounts checkbox is unchecjed in the accounts transaction report as default, or able to be unchecked. Currently it is ticked and needs to be unchecked every time you go into the report.
3 votesHi Vanessa, next time you open the report and uncheck this option you can save the report as Custom, then choose to make this the default. That way the box will remain unchecked each time you go to it in the future 🙂
-
New Bank Reconciliation report - Include note for foreign currency exchange
Exchange rate on bank reconciliation report
For foreign currency bank accounts, the old bank reconciliation report used to include a note stating that the exchange rate per xe.com that was used to translate the bank balance to the home currency at the report date. This was very useful information to include, as it confirmed the rate and the source of where that rate was obtained. This is not included on the new format bank reconciliation report pack. Please could this note be brought back on the new format reports?7 votesHi community, apologies we've not returned to this sooner. Pleased to share that foreign currency disclosures are now available in the Bank Reconciliation Summary report.
-
Invoices - Option to bulk upload line items
Ability to upload invoice lines into sales invoices (like journal upload) When you have to produce large multi line sales invoices the ability to upload from an excel file would be a huge timesaver instead of having to enter each line individually.
2 votesHi team, as noted earlier - You can import invoices with a CSV file. If you'd like to add multiple lines for the same invoice you just need to use the same invoice number for each row of the file. See our help and tips on the formatting of the file. 😊
-
Reports - Delete custom reports
We need the ability to delete a custom report. Many times a custom report is necessary for a period of time then no longer needed. I see no way to delete it. That would be VERY helpful.
2 votesHi Suzette and Tristan, this is already possible 🙂. A user with the Advisor role in an organisation can select to delete a Custom, Drafts, Published or Archived report from the relevant tab in the Report Centre.
-
VAT201 - Export return to PDF
It would be great to have the ability to Export the VAT 201 to PDF, or the Summarised version to Excel.
1 voteHi Barbara, it's now possible to export your VAT return to PDF! 🎉
You'll find this as a drop down from the Export option in the top right of the VAT return. Thanks for your input on this here 🙂
-
Bank Reconciliation - Remove imported statement balance
Bank Reconciliation
Remove the Imported Statement Balance as at best it does not work at all and at worst it imports the wrong value, which is very upsetting for clients.
7 votesHi everyone, sorry we've not updated you again sooner on this. With the new Bank Reconciliation Summary report you'll find there is now an option from the 'More' button at the top of the page to uncheck the 'Imported Statement balance' which will then hide this from the report. 🙂
-
History - Record changes to lock dates
A report to show who and when the account lock dates were changed.
If transactions are entered into lock periods this causes Xero to ot match the closed periods where accounts may have been submitted already. Currently there is no way to see who or when the dates were locked.
18 votesHey community, thanks for all your interest in this idea! It’s clear from the comments that identifying when changes are made, and who has made them would be really helpful.
This morning we rolled out an update to the financial settings screen for all Xero organisations to enable History & Notes 🎉
When you add a lock date, it will appear on the History & Notes table below and, for advisers, the History & Notes screen.
I’ve attached a screenshot so you can see this in action and, for more information, you can check out our Xero Central article Set up your organisation's financial settings.
-
Xero App - Receive money via app
The Xero mobile app currently only allows invoice creation. This creates a two step process to separately record the payment against the invoice. Having the ability to Receive Money via the mobile app without having to use to desktop interface would be a much simpler, efficient and time saving approach for business owners.
2 votesHi Gene, it sounds like you're wanting to add a payment to an invoice, from the mobile app. It is currently possible to do this! Just open the invoice you want to receive a payment on and select the add payment option. You'll be taken to another screen to add the necessary details. Our article Record a payment on a customer invoice has more info for you.
In case you were wanting to add a spend or receive money cash transaction in the mobile app, you can do this from the Bank reconciliation screen. From the bank statement line you want to create a bank transaction (spend or receive money) for, select Create. Then you'll be asked to populate the details. I've attached some screenshots showing you how and this article steps it out in more detail.
-
Connect expenses to Projects within Xero Expenses
Currently it seems the only place to add an expense to a project is within the Projects module. But what if your employees use Xero Expenses to input all of their expenses? There's even a field in Xero Expenses that says "Assign to customer or project" - but no projects can be selected.
Please can we associate expenses to a Project when submitting an expense through Xero Expenses?
3 votesAs noted(Thanks for the direction here, Leah!) if the user has access to both Xero Expenses and Projects they will be able to create expenses through the Xero app and assign this to an existing Project - see more entering expenses in our help
When assigning the permission, start searching for the project where you'll see a list of the related projects then pop up for selection. 🙂
There's no way to assign a project to a spend money that's being created through the Xero accounting app atm, this is a bit of a different idea to what's been raised here but you're welcome to start an idea for this that we can get a view of the demand and keep you updated through.
-
Profit and Loss report - Include account codes
Include account codes on profit and loss and balance sheet new reports, the same as you can with the old reports.
22 votesHi everyone, sorry we've not rounded into the idea here sooner! We've made some updates to the Profit & Loss as well as Balance Sheet reports where you'll find you now have options to select More and show Account code 🙂
-
Payments - Add Tracking Categories
I would like to be able to assign a tracking category to the payment. I have the expense going to Tracking Category A but I want the payment from the bank account to go to Tracking Category B.
1 vote -
Reporting - Report Page Numbering (non Partner)
Exported reports should include page numbering (ie: Page 4 of 5). This was part of the old style reports but seems to have been overlooked in the New Format reports.
19 votesHey community, thanks to everyone that shared their feedback on this idea! This is now live 🎉
This week we’ve released an update to reporting, so you’ll now see a page number when exporting any report to a .pdf. Previously, it was only possible to add page number to Advisor reports.
I’ve attached a screenshot with an example of this in action, but for more information, check out our Export and print a report Xero Central article. -
Account Transactions Report - Show VAT for Bank Accounts
To enable VAT to be shown on Account Transaction Reports for BANK ACCOUNTS
.
When reconciling the VAT to the VAT Reports, it is necessary to pick up the VAT from each type of transaction. We can pick up some of the outputs from the Sales Day Book (Receivables Invoice Detail) and some of the Inputs from the Purchase Day Book (Payable Invoice Detail) but what of the VAT which is dealt with straight from the Bank Account with no related Invoice / Bill.VAT Inspectors require a clear audit trail and although the VAT Reporting itself shows each transaction,…
7 votesHi Graham and Susanne, we've recently released a new common format for the General Ledger Details report that provides a more direct overview of the tax entered for all transactions in an org - You'll see this is now available from the left side panel named 'Account Transactions with tax rates'
This view includes all transactions that have a tax implication to the ledger regardless of where they came from. 🙂
- Don't see your idea?