154 results found
-
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 team, we wanted to return and provide a further update to the idea here understanding it's still getting some attention. As mentioned in my last post we introduced a common format('Account Transactions with tax rates') within the General Ledger Details report that provides a more direct overview of the tax entered for all transactions in your organisation. It includes all transactions that have a tax implication to the ledger regardless of where they came from.
To provide a bit more on how tax treatment is shown and how Xero works - Xero automatically splits transactions to record the tax element of a transaction based on the tax rate selected on lines of your transactions, this saves you time having to record the apportionment in separate lines.
Bank transactions that are shown in reports are the amounts that have been received in your actual bank account and there fore they…
-
Bank Account | Imported statement balance - Ability to edit
In the case of no transaction in a bank account, we can't import a blank CSV and so the statement balance date stays the date of the last import transaction.
I wish that we could modify the statement balance date to today's date even if no transaction occurred since the last import.
12 votesHi team, back again to confirm that this has now been rolled out to all regions.
As note in my last update the new Bank Reconciliation Summary report now gives you the ability to enter a Bank statement ending balance.
If you don't have an imported statement balance or the imported statement balance doesn't match your actual bank statement you can enter an amount and Xero will calculate the balance out by based on your input.
-
GST return - Include number of transactions in the GST Audit report
Item Count for Purchases , Income and No GST Transaction seperately and then total on end as it Count it as item number already.
1 voteHi Guramit 👋 The new New Zealand GST experience is now available to everyone. As noted previously, the Transactions tab now shows the number of transactions in each section displayed on screen. 😁
Thanks for sharing where you'd like to see change in Xero.
-
Report - Show Opening & Closing Balance, Total Debit & Credit for All Accounts in Columns
To have a report that can check the information of opening balance, total debit, total credit, and closing balance during the date range for the all the accounts in columns.
1 voteThe Account transactions report in Xero can give you the information you're asking here, Jiin Chiang.
If you don't want to see all the account detail you could 'Summarise by Account'
-
Reconciliation - Edit imported bank statement CSV directly in Xero
For manual reconciling, the bank statement file can be generated using a CSV template and requires inputting details like the Date, Description, and Reference. However, users, especially those with high monthly transactions, may want to change/edit the descriptions after the file has been uploaded and reconciled.
Currently, to do so, the bank statement needs to be deleted and re-uploaded, which means unreconciling previously reconciled items and repeating the entire process. If there are many to be amended, this process may need to be repeated multiple times. It would be beneficial if we could directly edit the contents of the bank…3 votesHi team, with the new Bank Reconciliation report you can now enter a Bank statement ending balance.
This means, if you don't have an imported statement balance or this doesn't match your actual bank statement balance you can enter the balance yourself, update the report and Xero will show the Calculated balance out by amount.
-
NZ GST: Widen the GST Audit report
Widen the display of the GST Audit report. When viewing the GST return I also check the GST audit report. When viewing the GST audit report I cannot see the date on the left side without scrolling to the bottom and using the scroll bar to move the report from side to side. It will not show all the columns at once.
6 votesHi everyone, our new New Zealand GST experience is now available to all users.
As noted in my last update there is no longer a GST audit report. The transactions tab provides options to toggle different columns on or off.
The new experience also auto scales the page to fit information in one screen, so no more need to scroll. Thanks for all your feedback and contributing to the idea here.
-
Files - Move the Upload File option to the top of the page
Please add the upload files / upload from library feature to the top of the list, I add my statements to my suppliers each month and have to scroll all the way down through years of documents to get to the upload feature.
1 voteHey! This function has changed and the 'Upload file' button is now toward the top of the screen 🥳
-
Report Settings - Option to set defaults for cover page & content page
for blue xero, we have to continually tick COVER PAGE, CONTENT PAGE, and other functions. Please allow us to set a permanent setting so we can generate the reports more quickly
4 votesHi team, while not completely obvious this is already possible from Xero HQ.
In Xero HQ, when opening a report template there is an Options button which contains Publishing defaults where you can choose to automatically include or exclude Contents page and Cover page.
-
Short Term Cashflow - Include repeat transactions
Short Term Cashflow Tool Improvements:
- Able to add recurring money in money out entries
- Able to print Graph and money in/out list to PDF
- Able to review past transactions (old dates)12 votesHey community - the team have been working on the ability to include repeating transactions in Short-term cash flow, and I'm happy to announce that it's being released today 🎉
Since this idea was updated to reflect the first point in the description, I'm switching it over to delivered.
As mentioned in our last update, if you're interested in print/export functionality for Xero Analytics Plus you can add your vote to the idea here
I can’t see any other ideas about the ability to review past transactions but can confirm that's not currently planned. If it’s still important to you feel free to start a new idea for it.
-
Profit & Loss - Show Invoice Numbers
Currently there is no functionality in Xero to populate the invoice number in the Profit and Loss report while the reference field is filled out. Would like to have the invoice number to be shown as well for easy reference and checking.
3 votesHi team, as noted in my last update you can click on the figure in the Profit & Loss which drills down to the Account Transactions report.
You'll find that you can adjust the report settings to add 'Invoice Number' as a column so you can see both pieces of information on the report.
-
Banking | Account transactions - Show attached files
Whilst reconciling bank transactions it is often useful to look at the account transactions tab. When doing so it would be really nice to see the files link as an entry so you can easily see the transactions associated with a bank transaction
16 votesHi everyone, I wanted to share that the file icon will show against all Account Transactions that have been created with an attachment 📂. Clicking on this icon will allow you to quickly preview the attachments. Invoice/Bill payment transactions will show the file icon when files have been attached to the payment transaction. As this is an Account Transactions list only, to see if the individual invoices/bills have attachments, you can head to the invoice/bills lists.
A separate idea has been raised for the Account Transactions Report to Show Files icon & number attached which you can add your vote to if that’s something else you’d like to see.
-
Report templates - Annual accounts templates up to do date and in line with legislation
The Trust - Annual Accounts Xero SPFR template for trusts > Notes to the Financial Statements > 1. Reporting Entity states "Legal or Trading Name is a trust established by a trust deed dated [insert field: trust deed date], and subject to the Trustees Act 1956." this is incorrect as the Trusts Act 2019 passed on 30 July 2019 has replaced the Trustee Act 1956. Xero have advised "While the team is aware the templates may need updating given current focus being on the expiration of old reports they do not have the capacity to give it a priority at…
2 votesHi team, templates have now been updated to refer to the new legislation. Thanks for your contribution and sharing in product ideas, here.
-
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. 😊
-
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 😊
-
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.
-
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.
-
Reports - Show headers on each page of report
It would be great if when you download a report into PDF that the headings for each column are on each page like the sticky headings. If you have a multiple page report and you only get the headers on the first page you have to keep scrolling back to the top to remember which column is which.
4 votesHi Ann, as you may have found with Xero's new reports, now when you export a report to PDF if you have multiple pages column headers will be shown at the top of each page.
Sorry it's taken a little to round back on this here and thanks for sharing your idea in community here.
-
Inventory - Reporting sale evaluations
WE NEED TO BE ABLE TO GET MONTHLY SALES TOTALS OF THE INDIVIDUEL PRODUCT ID CODES
IS THERE CURRENTLY ANY WAY TO DO THIS
WE HAVE THREE WAREHOUSE LOCATIONS PREFIXED WITH WAREHOUSES CODE AND 20 VARIATIONS OF PRODUCT IN SIZES AND TYPES AND WE NEED TO SEE EASILY WHAT IS SELLING MOST ETC IN EACH OF THOSE PRODUCT CODES
IS THIS POSSIBLE
PETER J FCA1 voteHI team, returning to the idea here we will mark this as delivered. As noted in my last update - With the Inventory item Summary report you'll be able to filter to only select the items you're wanting to view and can add columns to view Opening & Closing Balance or Quantities, as well as those sold in the period the reports being run.
Alternatively, you could run the Receivable Invoice Detail report. This'll only include sales of items, and the report includes the Item Code column by default.
You could also set the report up to Group by Item Code, so sales of each item are listed together, complete with totals for the date range.
-
Chart of accounts - Ability to export chart of accounts to .csv file
It would be great if the Export button in Xero could export the chart of accounts to .csv such that the Type of account appears in the .csv file as it is displayed in Xero.
Xero Support advises
- that right now it’s not possible to export the chart of accounts with the account type exactly as it is in Xero; and
- it doesn’t look like this idea has been raised as yet.This really is not a new idea it is only an idea to have the Export button in Xero produce an export file that represents the…
3 votesYou can now use the new export button on the Chart of Accounts page to export any HQ library chart templates. Both Xero and custom templates can be exported to .csv files. To find out more check out this Xero Central article!
- Don't see your idea?