476 results found
-
Banking | Manual import - Option to reverse Credits and Debits columns
A common problem importing bank files is the reversal of Debits and Credits. This is especially common with Credit Cards.
The "fix" that Xero recommend is to modify the file with a spreadsheet editor. This is only possible with CSV files and is error prone.
A setting to reverse credits and debits when importing bank files would be immensely useful when your credit card provider statement has it's debits and credits reversed.
Or maybe allow a bank to be treated as a Liability?
8 votes -
Batch Payments - Ability to 'split' when reconciling
Currently a client can upload a number of invoices and then create a batch payment for these invoices. When they make a payment for 1 of the invoices in the batch, you have to remove and redo the payment then match the separate invoice up, and then recreate the batch payment, excluding the amount which has now been paid. Would be easier if like with invoices, the batch payment could be split, saving the new to remove and then recreate the batch payment.
345 votesHi team, we appreciate hearing how splitting batch payments could make reconciliation faster and less manual, especially when only one invoice from a batch is paid and the rest remain outstanding.
We agree there’s a real opportunity here to simplify the process. While this isn’t something we’re building right now, it’s part of a broader set of ideas we’re considering as we look at how to make reconciliation more flexible and efficient.
For UK and US customers we have online bill payments that make the batch and reconciliation process much simpler - If you’re not too familiar with online bill payments you can get to know more through Xero Central and learn if this solution is right for you;
Similarly, we are working on a solution for our AU customers and will be sure to share more as…
-
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 Reconciliation - Indicator of Unreconciled Items in Drop-down Menu
When completing Bank Reconciliations (especially for those customers with 5+ bank accounts) it would be useful to see an indicator of Unreconciled Items in the drop-down list at the top left corner of the screen. This could either be the number of unreconciled items, or simply an asterisk to indicate there are items to be reconciled.
I often use this drop-down to switch between their most-used bank accounts, but if there was something to indicate which accounts still have unreconciled items, this would be immensely helpful and save a lot of time switching back to the main Bank Accounts screen…
9 votes -
Reconciliation - Foreign payment from foreign currency (different)
It would be useful to be able to reconcile a payment from one foreign bank account (eg USD) for another foreign currency.
We tend to have predominately USD customers and a lot of EUR suppliers, so we find that quite often we make a payment to our EUR supplier out of our USD bank account.
When reconciling this in the bank we have to post a payment to a manual clearing account to then be able to post the payment to the EUR Supplier account to clear the invoices.
It would be useful if the feature shown when reconciling (show…
50 votes -
Bank reconciliation report - Set default date period
New bank rec reports are based on the start of the month to the current date as a default. The old bank rec report just had an end date. Would like a fast way to move end date field and not have to also alter the start date.
13 votesHey community! As a few of you have rightly pointed out, the previously posted workaround isn’t suitable if your end date is prior to your start date. In this case, you will have to update both start and end fields.
Thank you to everyone that flagged that, and apologies for the confusion.
Because the the Bank Reconciliation summary lives in the Bank Reconciliation reporting pack, the date picker available is the same as the other bank reports (Bank Statement and Statement Exceptions).
Understand that some users would prefer an ‘as-at’ date instead, similar to the older report. In the meantime, you can select the same date in both fields to achieve this.
As that doesn't quite solve this for some users, we're leaving this idea open to continue to collect and share your feedback with our product team.
-
Find and Recode - Find by Item Code
Add an option to find all transactions by Item Code
Example: I recently had a client who put the wrong sales accounts on some of their inventory items but had been making sales transactions for 14 months without noticing. The P&L did not accurately reflect the sales of the actual inventory categories because of this.
There is currently no ability to find all the transactions by inventory item code to quickly recode the original transactions.
The work around is painful for 1000's of sales - Run a report on transactions by item code, save to excel, add a column for…
22 votes -
Reconciliation - Add Reference without clicking add details
It would be helpful to access the reference field in the bank reconciliation screen without needing to click "add details"
15 votesHi team, thanks for sharing how this idea could make your workflow a little simpler when reconciling. While we're continuing to work on efficiencies to reconciling in Xero, I want to be open that adding the reference field to the main screen is not in our short term plans. We're continuing to stay engaged with the interest from our community across ideas in this space and if there is any news we will share with you, here.
-
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 -
Cash Coding - Ability to attach file
It would be nice to have the option to attach files when using cash coding on the bank. To attach a file, I have to go back to the bank recon tab, find the entry and then attach the file. This wastes a lot of time. A small attach file icon or the option to attach a file on the drop-down will save a lot of time.
15 votes -
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.
-
Bank report - Date last reconciled
Can we have a report showing the last date of bank reconciliation completed for clients?
This would be beneficial for me, listed by clients but also for the client.
4 votesHi Renu, you could run the History & Notes to see the last date of reconciliation in an org. If you search for 'reconciled ' this'll help you zone into the action if there's a lot of activity - See my image below.
Alternatively, you may find the Assurance dashboard useful where you can get a view of user activity and Bank Account activity.
-
Reconcile - Multiple invoices in different currencies paid in one payment
When you have two or more invoices in multiple currencies from the same payee, you are currently unable to reconcile them to one payment.
28 votes -
Lock dates - Ability to add password protection
Dear Xero product team,
Please could we have an option to Password protect Lock Dates.
Where certain user can only unlok Lock dates i.e. Accountants or Subscriber
At the moment anyone can unlock the Lock dates which defeats the purpose of the Lock Dates.
158 votesThank you for your engagement and feedback on this idea. We’ve seen some great suggestions in this thread on how a password-protected lock date could work. The current lock date feature prevents new transactions from being entered and can only be removed by Advisor level users, but we recognise that some users would benefit from introducing password protection.
As part of our new Xero Product Idea process, we have recently reviewed the idea and shifted this to “Accepted”. This reflects that this is an idea we’d like to develop, but that this isn’t currently on the roadmap. We'll be back with another update as soon as we have more to share.
-
Bank Reconciliation: Add the ability to search by contact account number when matching transactions
Bank Reconciliation - Match Does Not Work with Contact Account Numbers
The ability to search by contact account numbers when matching bank transactions is essential as most deposits on the bank statements are referenced with the client/customer account number only. The bank reconciliation ignores contact account numbers in totality.
55 votes -
Bank Rec: Option to add pre-defined bank fee to subtotal when reconciling payments
My payment provider has recently started taking their fee percentage prior to the deposit, versus charging me at the end of the month.
This has caused each of my deposits to mismatch the invoice total.
Meaning, I need to add a bank fee on each individual transaction.
It would be EXTREMELY useful to have a "default bank fee" or "default credit card fee" button that would:
1) Remember the Contact as [Payment Provider] (currently have to type that in manually)
2) Add a default description "Credit Card Processing Fee"
3) Allocate the charge to an account [5150 - Credit Card…9 votes -
Chart of Accounts: Code numbering template
Chart of Accounts - need a suggested code numbering template to enhance uniformity and save time dreaming up numbers.
6 votes -
Chart of accounts - Add support for subaccounts
Xero should have the ability (similar to QuickBooks) to have sub accounts in Chart of Accounts.
87 votesHi community, thanks for continuing to engage, and sharing your needs in adding more layers to your chart of accounts structure.
We know especially for some of our US customers that this can sometimes be a show stopper in using of Xero.
Right now, we do have a product team that have begun exploring the efforts that'd be required to implement a change of this nature - while we can't commit to any development at this point we'll share any progression with you all here. Thanks
-
Transactions: Built-in month end close process
Need a process to close month end. After this process has been executed the month is locked and changes are not posted to it unless we unlock it first. This feature is available in other accounting packages
10 votes -
Find & Recode - Ability to bulk update exchange rate of multiple transactions
Batch change exchange rate
Currently, once a receipt has been entered the only way to change the exchange rate is to go into each individual transaction and edit transaction->change the exchange rate. I have a situation where i have hundreds of transactions that have been allocated the XE.com rate, but i would like those transaction to have the user defined rate. Also in receipts entered using the iOS app will use the XE.com rate even if there is a user defined rate set in settings.
I would like a feature like "find and recode" so i can filter for all…19 votes
.jpg){kind=link}
- Don't see your idea?