317 results found
-
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.
-
Reporting - Option to run reports in different currencies
i would like to have the option to run a report with USD , at the moment i have the option to British pounds
thanks
Astrid2 votesHi Astrid, sorry we haven't got back on your idea here sooner. You'll find since you first raised this here we've released the ability run reports in different currencies your organisation uses.
-
Invoices - Payment terms to default to customers existing payment terms when the issue date is changed
When you create an invoice the payment terms default to what is set for each customer (ie. 45 days from end of month, 60 days etc) however if you then change the issue date of the invoice, it defaults back to 30 days for every client regardless of their terms. We are looking for it to caclulate to each clients correct terms whenever the invoice date is changed
3 votesHi team, with some recent changes we made to the date picker in new invoicing you should find this is now working correctly for you. When creating a new invoice the default due date is triggered by the invoice settings, or where set for an individual contact this'll be the date used, also as noted in my update here - now if you update the issue date after a due dates entered, it does not automatically update the due date when you make issue date changes.
If you're still finding any discrepancies in what you're expecting I'd recommend raising a case with our specialists at Xero Support so we can get more detail and confirm the behaviour you're getting.
-
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 - Add custom Watermarks
Would be nice to add multiple permanent Custom Watermarks to your reports (i.e. one that says "For Internal Management Purposes Only" or something similar).
2 votesHi team, thanks for sharing with us here. Custom Watermarks are available for Practices when using Export > Styled PDF.
You'll see a Watermark option with a few pre-selections or the ability to add a Custom watermark where you can enter the text you want including; letters, numbers, common symbols and punctuation marks.
-
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. 🙂
-
Allocate invoices against overpayments or credits
At present, the only way to allocate an overpayment or a credit note against an invoice is to open the overpayment or credit, and click on "allocate payment" which brings up a list of invoices. If there are a large number of small credits, this can be very time consuming. It would be helpful to add an "allocate overpayment or credit" option to the invoice payment drop down, so that you could open an invoice, and allocate the required credits or overpayments against it at once.
5 votesHi Heather, if there is unallocated credit in your organisation for a contact, you'll be prompted if you'd like to allocate this next time you raise an invoice for them.
This prompt appears for an overpayment, prepayment or credit note - See detail in our help here, and I've attached an pic of what the prompt should look like in new invoicing 🙂
-
Budget Variance Report- Tracking categories in edit layout
Regarding the budget variance report, I wish to be able to add a column and select both tracking categories i.e. by program and session in "edit layout". Our goal is to produce a report which we can see the actual v budget of each program by session i.e. Columns as follows; Budget 'Program' Session 1, Actual 'Program' Session 1, Budget 'Program' Session 2, Actual 'Program' Session 2, Budget 'Program' Session 3, Actual 'Program' Session 3.
If you create a new budget variance report, you can initially filter by both tracking codes. However, if you choose to "edit layout" and add…
13 votesHey Community 👋
Earlier this year we rolled a change to our budget variance report, that allows you to select multiple tracking categories when adding a new column in the Edit Layout mode.
I've attached a screenshot of where these tracking categories can be found, but for more info, check out our Budget Variance article on Xero Central!
- Don't see your idea?