306 results found
-
Bank Reconciliation: Automatically recognise and remove duplicate statement lines
Imported bank statements - propose for Xero to spot "duplicate" transactions as to remedy this situation I had to process a large number of lines one by one across a number of different accounts
8 votesHI everyone, returning to the idea here we're going to move this to Not planned. However, we understand wanting to ensure the accuracy of your bank statements and reconciliations in Xero.
As mentioned in my last update - Xero won't automatically delete duplicate statement lines for you, however you can run the Duplicate statement lines report to help identify and remove duplicates, so you can choose which of the statement lines in your bank account you'd like to keep and reconcile.
There is also the Statement exceptions report in the Bank Reconciliation report pack that'll show where statement lines have been deleted in an account due to being a duplicate.
-
Reconciliation | Find & Match - Set a range for search
While performing a task of Bulk Income Reconciliation , I have to add Invoice one by one likewise 70123 , 70124, 70125 and so on. This is very time consuming task.
Could we have range over there so that we can directly select all and reconcile the same.6 votesHi there 👋, for the example you've provided here you could enter "701" into the search field which would search all unreconciled invoices that include this detail in the Invoice Number field.
While not a definitive range this'd enable you to focus on a group of invoices in a sequence - Would this suit for what you're after here?
-
Bank Rules - Test Rule button
Have a 'Test Rule' button when making a Rule.
2 votesHi team, not getting a lot of traction from the community in this idea we will soon remove it from the forums.
Appreciate not the ideal solution but if you'd like to test a bank rules applications it would be possible to manually import some statement lines into the demo company to be able to set up and try out a rule.
If this is still important to you welcome to start it again to see if there is renewed interest. Thanks
-
Bank Rule - "Does not" criteria
Add a "not" argument to bank rules to allow for a greater control
e.g. bank text does not contain "example" or, amount isn't "x.xx"
30 votes -
Bank Reconciliation - Create a Batch Payment file from Spend Money transactions
Create batch files for spend money transactions so if a payment needs to be made to say the ATO can create a batch file and upload to bank without needing an invoice.
29 votes -
Bank | Account transactions - Show Total of selected transactions
When manually reconciling a bank clearing account, you have to manually add up the credits that you have ticked to make sure that they add up to the debit that you are reconciling to.
It would be great if there was a figure showing the total of all items ticked.
It would work exactly the same as when preparing a batch payment in the Purchases module where the total of all bills ticked is shown at the top.
It would save SO MUCH time if we could have a similar total showing in the bank transactions screen - there can…18 votes -
Bank Rules: Apply bank rules to Products and Services
Povide the ability for the bank rule to code to Items/Products/Services codes as well as GL codes
7 votes -
Uncoded Statement lines - option to show reconciled transactions
Our clients would like the option to show reconciled and uncoded options on the same uncoded items report. Moving from MYOB/Banklink they are used to reviewing all transactions and having the ability to add notes for us to then code and add in the accounting software. We have many clients who fill in this form for us to then enter into the software and at present then only way to show this is running a bank reconciliation report.
11 votesAppreciate familiarity to the way your clients may have worked with another system.
As noted in the initial idea while there's specifically a report for uncoded statement lines, the Bank Reconciliation report will provide a list of all statement lines (coded and uncoded) - Is there something missing within this report that you're looking for in this?
@Wayne, livestock trading is quite different to what's being asked for in this thread - you can join the idea for this across here.
-
Bank Reconciliation - Ability to make bank rec turn green even when there's something in discuss tab
Find and match on bank rec to still go green when there is an entry on the discuss tab.
Currently the right hand side of the bank rec will only turn green if there is a possible match and nothing in the discuss tab. If there is something in the discuss tab it will not turn green even if there is a match.
It would be great if the border of the box still turned green whilst displaying the comment to indicate that there is a possible match to allow the user to review and ok the transaction.
20 votes -
Bank Reconciliation - Make the Find & Match window expandable
On the find and match screen, can we have the ability to expand the size of the window showing the list of transactions, so we spend less time on scrolling. The find and match shows 50 invoices at a time, but you have to scroll to see them.
9 votes -
Bank Rule - Ability to default to 'All conditions match'
Since the change to the updated Bank Rules page, it now defaults to 'Any Conditions Match'.
I have to change this to 'All Conditions Match' literally every. single. time. I create a bank rule, otherwise it defaults to matching almost all transactions.
This is a disaster waiting to happen.
12 votesThanks for sharing back on the change, Alan. It's difficult to make changes to suit everyone's needs, and changing the default from 'All' to 'Any' was carefully considered as part of the recent updates to Bank Rules.
This was something users told us would be helpful as many more users create 'loose' rules to capture more statement lines.
Currently there aren't any plans to change this back. What would be more useful would be the ability to set your own default, but for now we'll begin to track the interest of this here.
-
Uncoded statement lines report - Common date formats e.g last month, last quarter, last year
Some xero reports can be run by last month, last quarter, last financial year etc. The above report can only be run by entering specific dates. Could this report have the same pre set date options added? This would be useful for client query lists for monthly/ quarterly BAS Returns, annual accounts/ tax returns etc
3 votes -
Bank Rules - Ability to set defaults for steps of Create rule
When adding a bank rule is it possable to change
No 5 Add rule details to deault to "all accounts" rather than the account you are currently in
A rule set up for fuel will be the same allocation no matter what bank account you are in
Where do you chande the system defaults?3 votesHi Greg, while there's no way to set your own defaults for Bank Rules in Xero.
The existing default will differ depending on where you start the Create rule flow.
- If you're in the process of reconciling your account (via the Reconcile screen or Cash coding) the default for '5. Add rule details > Run this rule on' is the bank account you were reconciling
- On the other-hand if you Create rule from the Bank rules screen, this'll default to 'All bank accounts'
While this isn't something we have plans for at present. Appreciate how you'd like to set up a default regardless of where you start this and have adjust the title of your idea, here and we'll keep an eye on the support for this.
-
Bank rules - Ability to assign Billable Expense
Banks Rules - Add Billable Expense
This will save the company a lot of time having to manually set a billable expense when we need to on-charge a certain % of a recurring transaction
14 votes -
Xero Accounting app - Bank reconciliation - allow foreign currency payments to be reconciled
Xero allows invoices to be created in a foreign currency (with the premium subscription plan) but when clients make these payments (which get converted to the base currency) they are not able to be reconciled in the Xero app as both the currency and amount are different so they don’t match.
On the web, there is an option that can be unchecked to show foreign currency items, which then allows the payment to be reconciled. In my case it is ‘show NZD items only’.
A similar item would ideally be added to the Xero app so those paid in a…
17 votes -
Cash coding - Keyboard shortcut for "Payee"
Cash coding currently has a keyboard shortcut to copy the nominal above, which is great..... Please can we have a keyboard shortcut made for the "Payee" that works in the same way as I often alphabetically sort these so it would be a huge time saver.
11 votes -
Reconcile - Create transaction without generating a new contact
Currently a new supplier is created in your contact list every time a transaction is made which results in too many contacts considering there could be very small items of spend at multiple stores on card etc. I only want to see key repeating suppliers in my contact list.
17 votesHi team, the Payable Invoice reports will generally help you zone into your top repeating suppliers and better view activity.
As suggested, if multiple contacts of a similar nature are being created merge may also help you manage these in your contacts list.
It'd be good to understand if there are other needs that this idea would help you with here - please do share any detail.
-
Bank Account Transactions - Ability to quickly Edit Reference from the list view
TIME SAVER: I would like to be able to quick edit the reference details in the transactions list view, instead of having to click on each transaction > edit > save.
13 votes -
Bank Reconciliation - Choose which columns to show on the Account Transactions and Bank Statements tabs
The columns visible in Bank Statements and Account Transactions under Bank Accounts are totally different. This makes it almost impossible to search for matching transactions. Can you have default columns that can be selected? Some of the columns are only available when the statement is uploaded and I'm not sure even how useful they are.
10 votesHi Ann, it'd be good to understand more of the detail that you're seeing on each of these screens that is useful to you - Perhaps there's a report we can suggest that gives all that you're after?
-
Bank Rules: Save account number using tab
Please bring back the ability to enter an account number with the ability to tab to continue.
5 votes
.jpg){kind=link}
- Don't see your idea?