329 results found
-
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.
-
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.
-
BAS | Activity Statement report - Ability to type custom date range
When looking for BAS transactions for your own date range under the activity statement report section, currently there are limited view period options, meaning that you have to select the dates in a calendar. Being able to type a custom date range is not an option.
It would be a lot more efficient to be able to type a custom date range as can be done with other reports.3 votesHi Community 👋
Thanks to everyone that has added their vote to this idea. We’ve just rolled out a change to Activity Statements, allowing you generate a BAS report for custom date ranges.
To check this out yourself, you can click ‘View custom date report’ in the Activity Statement page.
For more information on this change, check out our ‘View BAS reports for a custom period’ support article.
-
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.
-
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 🙂
-
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.
-
Sales day book
I need a report that simply lists all sales invoices by date, customer and total amount. It would look very similar to the invoice data that shows up when you go from the dashboard to Business - Invoices. The only way to export this data is limited to 500 transactions. Thats no good to me as Ive got 1000+ sales items a month. This would be one of the most easiest reports for Xero to create and give more joy to your users than you can imagine. But I cant see that its ever been created. Please help. Call it…
3 votesHi Geoff, you can use the Receivable Invoice details report to view he information as you're asking here.
You'd set the Date range you're wanting to view, group by Contact and then can sort results by date once you've run the report.
When set up save as custom so you can rename and easily access the report anytime you need.
-
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.
-
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.
-
Difference of Invoice template between Preview and PDF format
I have discovered that the invoices as they appear in the Preview button of an invoice only gives a preview of how the online invoice will display. This is therefore different from the PDF version of the invoice when it is downloaded as a PDF or sent to my clients. The PDF version looks a lot messier and looks far less professional. It was informed that, it is currently not possible to make the PDF version appear like the Preview version, or vice versa. I would like to know if anyone else has some ideas of how to align the…
20 votesHi everyone, recently we made a change to the Preview option in new invoicing. Now, when you select to 'Preview' in new invoicing this'll open a new browser tab with a view of the PDF of the invoice. This means you can also see how your invoice will look to the customer with a docx / advanced branding theme applied.
Our team are also doing more to look into how preview works and how your invoices look. We'll update again if there's more development to share.
-
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…
-
Payable invoice detail report - Filter to show "No VAT" transactions
Payable Invoice Detail reports - Ability to Filter VAT Rate Name and VAT Rate (as one can in Receivables)
In the Receivable Invoice Detail Report, the filters include both the "VAT Rate Name" and "VAT Rate". These are not currently available in the Payable Invoice Detail Report, but would greatly assist anyone trying to reconcile the figures in this report with those shown on the VAT Return. As such it is essential to ensure that the figures submitted in Box 7 of the VAT Return are accurate.
2 votesHi team, the Payable Invoice Detail report has filter options for both VAT Rate and VAT Rate Name. Including an option under VAT Rate Name for 'No VAT'
-
Analytics | Short term cashflow - Remove BAS & PAYG Payments
When a BAS payment is due it shows up in Analytics Plus on the due date. However when the bas or payg payment is paid early there is no way to remove it from the cashflow and it skews the cash flow workings. Can we create a way to remove these system populated entries when they are no longer correct.
4 votesHi all, we've just released an update to Short term cashflow(STCF) so you can now exclude individual BAS/PAYGW amounts from your orgs projection breakdown, when the due date falls within the selected date range of the STCF.
You can always add back any excluded amounts to the projection at a later date. 🙂
-
Bank Reconciliation Report - Ability to run for multiple bank accounts at once
In the new format Bank Reconciliation report, can we please add a 'select' option for the bank account field, similar to the 'Account Transactions' report and how we can 'select' multiple CoA codes to look at at the same time?
I have a client that has 30+ bank accounts, and having to run the bank reconciliation report 30 times to check if they are reconciling/have errors is very painful.
123 votesHey community, just following on from Kelly’s update a few weeks ago, you can now add multiple bank accounts to the Bank Reconciliation report 🎉
In the new Bank Reconciliation report pack, you can now click ‘Add report’ to add in a new Bank Rec Summary report for each of your accounts - removing the need to run the report again each time you change bank accounts.
Thanks again for all your feedback on this one 😊
-
Balance sheet - Only show summary of a group
Balance Sheet - to be able to add a formula to balance sheet lines instead of grouping lines together. Example, I would like to be able to see only the total asset line on the balance sheet rather than seeing the cost line and the depreciation line i.e Computer Cost - Computer dep'n. Currently you can group the lines to then show a total for the grouping, however you still need to have both lines showing on the report. it would be good if we had the option to add a formula to calculate both lines removing the lines we…
1 voteHi Erin, this is already possible. Within the Edit Layout view, if you select to show Total and click the group heading to only view the group title within the edit layout screen when you save the report you'll see this is reflected when you run the report.
-
Xero Ledger - split payment
There should be a way to input dates when we want to split the payment to multiple items (invoices/bills) when we reconcile (e.g. cash code or find and match).
Right now, if I want to input multiple invoices/bills that is linked to a one payment, all invoices/bills will need to have same date as the payment date which is technically incorrect.
1 voteHi all, returning to the idea we're going to shift this across to delivered. As noted i my earlier response you can manually enter a payment amount and date of payment on an invoice or bill - Meaning if you need the payment date to differ to the date of the statement line imported this could be manually entered on the invoice or bill pre-hand and matched to the one payment when reconciling.
Alternatively, when reconciling a transactions through find & match in Xero you have the option to 'split' where you can apply a set amount of the payment to the transaction rather than the full amount.
-
Hide Columns on Statements and Amend Headings on Statements
I am creating statements for an estate agent to send to landlords. Some of the exisitng headings on the statement are confusing for landlords and I would like to change them. I also want to hide the activity column as this is not required - the statement simply needs to show rent has come in and rent has been paid out. Can we please have the option to hide columns and change column headings. Thanks.
1 voteHi Nollaig, this is possible through the use of templates. To remove columns you'll need to use an advanced template with DOCX branding and amend the details that are shown using Microsoft Word.
If you're not too familiar with these - we have a community discussion where many users are happy to help and offer advice for your needs. 🙂
-
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.
-
Bank Feed - Connect to existing bank account
If you already have bank accounts setup then you wish to add a bank feed, the bank feed will only create another bank account. It is not possible to merge data or start feeding the data into an existing bank account. The support team has suggested other manual workaround instead.
Please consider adding appropriate functions so for those who have transitioned from other accounting systems and have existing bank accounts or for those who didn't start bank feed right away and would want to do it now to have a much seamless adoption of the function.
Thanks!
4 votesHi team, if you've set up a bank account and decide to connect a bank feed later on this is possible without having to set up a new bank account in your organisation.
If you've set up a bank account that there is a feed available for, you'll see a 'Get bank feeds' option in the widget on your Dashboard.
If this does not appear you may need to Edit Account Details to make sure these have been entered correctly.
Should you have any troubles through the process, you can raise a case with our team of specialists to check in an confirm the process for your bank account.
- Don't see your idea?