- or
923 results found
-
Batch Deposit - Reference to pull through to bank reconciliation
When I enter a reference in batch deposit, this does not pull through to the bank reconciliation. On the bank reconciliation report, the Description is "Payment: multiple items" and the Reference field is blank. This is not useful as I have to go into each transaction and see which company the receipt has come from. Why enter a reference when it does not appear on the bank reconciliation report? When I try to search to match deposits using the company name, these deposits do not appear as the Description is unhelpful. If there are smaller batches which add up…
11 votes -
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.
-
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.
45 votes -
Bank Reconciliation - Reconcile against Statement
We would like the ability to reconcile transactions against a statement in addition to just reconciling from the bank feeds.
There have been so many issues with bank feeds, that often we find the statement balance does not match Xero. The issue with running the reconciliation report is that some banks will have some transactions from the closing date in the current statement and some of them on the next statement. The only way for us to break it out and match the balance is to export transactions to a spreadsheet and then change the date of those transactions…
80 votesHey everyone, thanks for your patience! We're excited to announce that period reconciliation is now available for all US and CA organizations.
As per my last update, you'll find a new "Reconcile Period" tab within your bank accounts. If you have the Standard or Advisor role, you can easily enter the statement period dates and balances. Xero will then automatically display and select all transactions within that timeframe. Once you've reconciled the period, you can close it to ensure no transactions are accidentally deleted or unreconciled.
We know that many of you in other regions are also keen to access this feature. So we can track this separately, I've created a new idea and have added all users that had voted here (outside of CA and US) to. If there are any updates we will share news with you all there.
Thanks for your feedback!
-
Bank Reconciliation - Contact match by additional contact details
Bank Reconciliation suggestions. The ability for Xero to identify a name within a customer contact and match it to the name on the bank feed and suggest this as a match. for example John Smith is the contact for ABC pty ltd. when he makes payment he only references John Smith. Xero will recognise John smith is a contact for ABC pty ltd and suggest their invoice in the bank rec.
14 votes -
Bank Transaction Report - Add reconciliation Status
In the Basic Account Transactions Report (Common Format Bank Account Transactions) Can you please add the Reconciliation Status for each Bank Transaction. Both as a field and a filter.
1 vote -
Bank Reconciliation - Remove 'Great Job!' messages
There should be a way to remove unnecessary motivational responses like "Great Job!" when finishing a bank reconciliation.
I do the bank reconciliation every day and don't consider the task difficult or special, so the "Great Job!" just seems patronising. A simple "You've reconciled all the transactions for this account" is all that is necessary for a business application like Xero. Some people might like it but I'd prefer my accounting software to not pretend to have a personality like that.
3 votes -
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 😊
-
Bank Reconciliation report - Default to show decimal places
Can we please have the bank reconciliation reports default to show decimal places. I've never seen a bank rec that rounds off the decimals until Xero introduced it.
3 votesHey Barbara, thanks for sharing your idea!
Earlier this year we rolled out a change to the Bank Reconciliation report, it now defaults to including decimal places. This can be changed by deselecting 'Decimals' from the 'More' menu. I've attached a screenshot as an example 😊
-
Bank Reconciliation - Add notes and attachments when reconciling
To be able to add notes, to explain why Xero has imported an amount to the feed with a different date to the actual bank statement for example. I have to be able to explain to our accountant why the Xero bak balance is different to the bank statement. It shouldn't do this anyway but it does and I have no way of logging this date error. And add attachments (ie actual bank statements) to a published bank reconciliation, you can upload docs to any transaction but not the actual reconciliation??
4 votes -
Bank reconciliation report to show contact reconciled to
Bank reconciliation - A report that will show each bank transaction and then which invoice it has been reconciled against, as a way of having a quick way to check something has been reconciled incorrectly. Currently, the only way is to view each transaction through the account transaction report.
8 votesGood to hear you're aware of how you can run the Account Transactions report to view this information, Catherine - Is there a reason or something missing from this report that would help you when reviewing transactions?
-
Bank Reconciliation - Show current bank feed balance
Add the ability to display the current actual bank balance from the bank feed alongside the statement balance and Xero balance. This would help users quickly see their true available funds without needing to log into their bank separately.
Currently:We can only see the statement balance and Xero balance
Must log into bank separately to see actual current balance
No way to quickly verify available funds within XeroProposed Solution:
Add a "Current Bank Balance" column that pulls the real-time balance from the bank feed, similar to QuickBooks Online. This would:Display alongside existing balance columns
Update automatically with …2 votes -
Bank reconciliation - View date last manually reconciled
Is there an option to show "Manual Bank Reconciliation Date" rather than Reconciled Date? The reconciled date is system generated and it does not mean much if the balances are out to start with. This would allow the user to know when bank rec was actually performed by a human.
4 votesHi Jo-Ann - when you say you'd like to view the date the bank account was manually reconciled would this be on the org's Dashboard?
As a means of viewing this information at present - you could run the History & notes and view only Bank transaction items where you'll see the name of the user and date that the last transaction in the org was reconciled. 🙂
-
Xero Accounting app - Bank reconciliation: Show notes first
I have a client who is VERY mobile active. I noticed on the bank reconciliation page that notes are multiple taps away. On a transaction, three dots, then view note, and then one more click to go back. It was be fantastic if the default on the bank reconciliation page on mobile was to show notes first, like the discuss tab is defaulted to show first on the web application. Then I could instruct my client to view the bank reconciliation on their mobile to see what information I am requesting.
2 votes -
Bank reconciliation - Apply bank rules automatically by default
Ability to automatically apply bank rules by default.
Purpose: To save time from having to manually choose to turn-on bank rules.
58 votesHeya team, with some of the exploration our team were doing we shifted this idea to Under review a few months ago. However, reassessing current priorities as many here may also be interested in our team are currently in the depths of work for enabling the ability to view more statement lines and providing search on the Reconcile screen.
While this may be something we consider developing for later down the line, it's not something we have plans for atm and we'll shift back to Submitted to continue monitoring the interest here. Thanks
-
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 Reconciliation - Import bank transfer
Import and reconciled bank transfer
5 votesHi Sandra, could you provide a bit more detail of the idea you have here? Would this be for the ability to automatically reconcile transfer transactions from one bank account to another?
-
Management report pack - Adding Bank Reconciliation
You've created these great packs or ability to create one, but for majority of businesses when they are reporting for the month that was in a meeting they want a bank reconciliation or a transactions listing with opening bank balance, transactions and closing bank balances!
Can we please have this as an option to add into the Report Packs.1 voteHi Natasha, with lots of change to reporting over the last few months we've been making a few more reports available in the Management report 😊
You can now add the Bank Reconciliation Summary, Bank Statement, and Statement Exceptions as reports into your pack.
-
Reconciliation | Bank fee - Cursor default to contact
When adding a bank fee adjustment during the details entry of a reconciliation, it'd save a click to automatically place the cursor focus on the contact field. This already happens when we click to add details to a reconciliation, so it makes sense for the same behavior to occur when we click to add a bank fee adjustment. One click...hundreds of times...lots of efficiency!
1 voteThanks for your suggestion, Matthew. I'll share back with our product team. In the meantime lets start to get sense of community interest through your idea here and we'll let you know here if there are any changes planned.
-
Bank Reconciliation - Upload files within the "Match" option
Upload AR Remittance Advices within "Match" option within Bank Reconciliations
I have noticed that when processing the Bank Reconciliation and matching bank deposits to raised AR invoices, the Remittance Advice can't be uploaded directly to the receipt under the "Match" option (see attached screenshot).
However, under the "Create" option (next to Match then clicking "Add Details") there is the option to Upload files.
Not being able to do this directly within Bank Rec matching means it is an inefficient process where I have to go back to the Customer account, look for the Invoice(s) that were paid and open…10 votes
- Don't see your idea?