277 results found
-
Reporting - Set a default date for the Balance Sheet / P&L
If Xero could remember the last dates you input on the Balance Sheet and P&L, when you are flicking around to other pages it would save having to reenter them every time you go back to those reports. At the moment it seems to choose it's own default, which I think may be last year end.
2 votesHi team, with the ability to create and save custom reports. We'll shift the status of the idea here to Delivered - see our article on how to set up and save a custom report for steps 🙂
-
AU Payroll | Payroll Activity Detail Report - Export all data to Excel, not just PDF
Currently, when the Payroll Activity Detail report downloads to PDF, it includes deductions (including those that are not salary-sacrificed super) and reimbursements. However, when the Excel report is downloaded, those lines are missing. Please include everything that's in the PDF version in the Excel version.
2 votesHi all, as previously shared both reimbursements and deduction pay items will appear on the PDF and CSV exports of the Payroll Activity Detail report.
If these pay items are visible in the pay run, but aren't pulling through to your reports, please reach out to our support team for some troubleshooting. 😊
-
Reporting - Ability to have the chosen font size on PDF exports for draft reports
The font size for Xero reports has increased - great - much easier for clients to read their annual accounts. However, when Exporting to PDF from the Draft reports, it previews it in the default size, which is often the wrong size. In order to preview the reports as they will print, you have to publish the report, note where you need to move/add page breaks, then delete the published report and go back into the draft report to make those layout changes. This adds an extra 5 minutes or so on to every job which is not necessary.
Solution…20 votesThanks for the support and interest in this change, everyone. While it may not be obvious, for Xero Partners or staff connected to a Practice there's an option to adjust and change the font size of your reports by selecting 'Styled PDF' when exporting new reports from Xero - Detail here will help in setting & managing your Report Styles.
If not already you use Advisor Connect to find a Xero Partner that can meet your business needs.
-
Aged Receivables/Payables Detail Report - Running total
We need a running total added within each supplier to these reports as it is very frustrating when trying to balance to supplier statements or allocate a payment.
8 votesHi team, this is possible - Make sure you've added Total as a column to the Aged Payable/Receivable detail report and then Grouping by Contact.
If this is your preferred view for the report, you can save as Custom to select and run in this format whenever you need.
-
Statement of changes in equity - Default to current year
Changes in Equity Report: When I pull off a Changes in Equity Report for the end of February (2023) how about making the report pull up the report for the year requested rather than the year before? I understand the report has been designed like this so how about changing the design? Or the design team?
1 voteHi Adam, if you'd prefer a different common date format (this financial year) as a default you can set this in the report and save as custom. You can even make this the custom report the default when saving as custom if you'd prefer.
-
General Ledger Details - Show Account code
I would like to ask Xero if they can put an option in the Detailed General Ledger to allow codes
1 voteHi Leanne, within the newer version of the General Ledger Detailed report you'll find you can include Account Code as a column. 😁See my image below.
-
Trial Balance - Add tracking columns
Trial Balance - Compare Tracking. Ability to have tracking added to the formats in the same way that you can do for profit and loss in the left hand column. Being able to use the layout editor for trial balance would also be very useful.
2 votesHi community, you'll see we've just released a new General Ledger Summary and Detail reports.
While a slightly different report you'l find you can get what you're asking for here by running the General Ledger Detail report which has an option to include any Tracking categories that you've set up in your organisation as columns in the report. You can also Filter by Tracking too.
-
Invoices/bills tags
Add a tag feature to invoices/bills, which is only visible internally (not for customers/suppliers) and would allow to run ad hoc reports.
Example - tag sales invoices to sales rep and be able to run reports to see how much revenue that specific sales rep has brought in.1 voteHI Barbara, this is exactly what Tracking in Xero can be useful for. You have 2 tracking categories that can be used for different departments or sectors of your business that you'd like to be able to monitor - find out more here.
-
New Journal Report - Manual journal search
The old journal report allowed one to search for Manual Journals, the new report does not; it would be invaluable to drill down into the new journal report to search manual journals only :-)
1 voteHi Vanessa, great to hear you're using the new report! 🙂 If you click on the More option in the report you'll see this is an option that can be selected - see my image below.
-
Reporting some expenses only
I'd like to create some customised reports for particular costs and wondered if there's any option to just report on some costs of the business without having to lump all the other ones somewhere
1 voteYou should find the Blank report can be used to create what you're after here, Mary-Ann.
-
Journal report - Include account Type and Source
Showing Account Type and Source
1 voteHi Joanne, you can include both Account Type and Source as columns by running the General Ledger Details report which also allows you to view Journal ID 😁
-
Import data from Excel spreadsheet into Xero Invoices
Import data from Excel spreadsheet into Xero Invoices to save re-keying information. It would be great to have a feature that allows you to cut and paste data from spreadsheets directly into Xero. I do use the Copy invoice function when repeating invoices are raised however it would be great to be able to import data for the initial invoice. Some of our invoices are between 20 - 70 lines - would save a huge amount of data entry
3 votesHi Rachel, it's already possible to import customer invoices to Xero. It's catered for via the CSV, but you can use our template to enter (or copy & paste) invoice data when using Excel.
When imported to your Xero org, this'll create draft invoices that you can then quickly approve from the invoice list if you're confident in their entry, or open to approve each invoice individually - More on approving here 🙂
-
Xero Accounting app - Ability to change accounting basis for reports in app
Xero app to have accounting basis (profit and loss) able to change from only accrual to cash
You can only see accrual, it is one of the main features of the app for live information, I find it very hard to know how my current month is actually doing unless.6 votesHey community,👋 thanks for supporting this idea, I’m popping in to switch it across to delivered! The product team have been releasing this in phases and it’s now available for 100% of users 🎉
First, make sure your app is updated. To change the accounting basis, go to the Profit and loss screen, and on the upper right corner tap Options (iOS) or the 3 dots (Android) to go to ‘Set reporting preferences’.
I also just wanted to confirm that this functionality was already available on the web version check out our article about how to Select settings in a report. Note that updating this new setting in the mobile app will not change the setting for the web version. -
Bank Reconciliation - Undo last reconciliation
sometimes i get a bit gung ho on bank rec after its learnt.
particularly when teh bank feed has an inv number but as i click rec, i notice the transaction has an old number on it.
id like to see an "undo previous" button
3 votesWith no further activity fro my last update we will shift this idea to delivered.
As previously noted - There are a few ways you can undo a reconciliation already. 🙂
The Account Transactions tab will show you both reconciled and unreconciled transactions for a bank account. From here you can select 'the transaction where you'll get an option to Remove & redo.
Alternatively, if you're moving swiftly and aren't quite sure of the last transaction you reconciled, you can jump across to History and notes where you have filters to quickly zone in your most recent activity, click to open the transaction where you can Remove & Redo from the 'Options'
-
bank
Would like to see a way to turn off "Bank" status for an account that is no longer used (changed banks or go new credit card etc.). While I still need the account in my records, I don't want to see it coming up in my bank listing all the time.
1 voteHey Anna, if you'd like to remove a bank account from the bank screen, whilst keeping the account transactions, you can 'archive' the bank account.
To do that:
- In the Accounting menu, select Advanced.
- Click Chart of accounts.
- Select the checkbox next to the bank account you want to archive.
- Click Archive.
- Click OK.
This process is reversible😊 and you can restore an archived bank account at any time
-
Journal report - Export with Narration / description
Could we please have an update on Manual Journals, so if you extract the Journal report it would so the narration/ description we add the each line of the journal report.
Also if we can print PDF a specific journal so it flows well with the above information1 voteHi Navisha, our team have been making lots of development with Xero's new reports.
Yesterday we released the new Journal report where you'll find you can add both Narration & Description as separate columns in this report.
Once set up, you can export the report to PDF, Excel or Google Sheets 😁
-
Bank Reconciliation | Reconcile with statement amount at given date
I would like to complete a 'proper' bank reconciliation.
To be able to enter a figure from a bank statement and have xero compare that to the bank figure in xero for the same date. This feature is available in the package with the very annoying tv adverts and in old school sage.8 votesHey community, 👋 thanks for supporting this idea. I'm popping in to switch it across to delivered!
Our new bank reconciliation reports allow you to manually enter the closing balance of your account for a set date at the top of the report. This then shows in the report as the bank statement ending balance.
For more information check out our Bank Reconciliation reports support article 😊
-
Trial balance - Default sorted by account number
Can you please change the default account order of the trial balance to sorted by Account Number as this just makes a ton more sense for accounting. Or give an option to change the user's default ordering. I know you can click on the Account Number column heading to change the order, but I do this 100 times a day.
1 voteHi Christiaan, once you've sorted the report if you save as Custom you'll be able to access this same layout without having to set the sort each time. If it'd be useful as the default for your org you'll be able to set this too. 🙂
-
Journal Report - Filter by posted date
It would be really useful if the journal report could be filtered on posted date as well as transaction date, currently they can just be filtered by posting date.
That way you could quickly highlight transactions that were posted in a period, after a certain point like a VAT return submitted or trial balance exported for accounts preparation.
1 voteThanks for your idea here, Adam. Our reporting team have just release a new version of the Journal report where you'll find this is now possible!
Along with more detail, you'll find there's the ability to Filter by any column added, including Posted Date 😁
-
Reporting - Display currency report is run
Hi,
When we export the management accounts of the companies, the currency is never mentioned which is not convenient.
It would be great to add the currency on these documents as we have a lot of currencies.
Thank you.3 votesHi all, coming back in to confirm that as of today you'll find you can now run the Profit & Loss, Balance Sheet and Budget Variance reports in currencies the org has been using, and you'll be able to select and see the currency the report is run in at the top in the report settings. 😁
If there are other specific reports you'd like to see this developed in please do start a new idea in the site here and we can get a feel for the interest in each of these, too. Thanks!
- Don't see your idea?