Reconciliation - Bulk 'OK' for reconciling bank transactions
Ability to select multiple/all transactions during reconciliation.
Purpose: To save users time from having to reconcile the transactions one by one.
Hi everyone, we've been tracking this idea for some years now and truly value all the feedback we've heard on the desire and time saving reducing the manual steps in reconciliation
would achieve. We completely get wanting to skip that extra ‘OK’ click when you trust the suggested matches.
We’re excited to share that this idea is now in development. At Xerocon this year we shared automated bank reconciliation - Using JAX to automatically match and categorise your bank transactions with your Xero transactions.😊
It's in beta already and being tested by a small group of users atm, and as soon as we have more to share on this rolling out wider I'll give you another update here. Thanks again for helping us shape the future of Xero!
-
Yumei Lin
commented
Being able to auto reconcile/cash code the bank transaction when you import the bank transaction or the bank transactions processed through Xero
-
Karen Cronin
commented
It depends on your business model and banking arrangements
Reconciliation is crucial to mine and bank feeds not always appropriate.
Xero seems to only fit one style of operating. -
Claire Taylor
commented
Thanks for the update
I realise there is a lot of work needed in the background that we dont see but put simply for me a tick box beside transactions like in bills and sales and to be able to select all the transactions with 'OK' is really what I would like to save time in the reconciliation....
-
Tak Wun Wong
commented
I just clicked "OK" 5381 times. I think I might have developed carpal tunnel.
-
Hui ying Cheow
commented
My client not using bank feed, they just provide me their bank statement, so I need to key in manually. When bank reconciliation, it really take time !! We need to click all the transaction itself and mark as reconciliation. Quick book and others account software can just tick all the transaction you need and approve after you check and tally with your bank statement. Xero really need to improve, very not convenience for manually key in user. Quick book and others software cannot scan bill and upload like XERO, if not I already change to others software.
-
Bradley Whitford
commented
Bank Rules - Auto Reconciliation.
If there is an option for "auto-reconciliation", in Bank rule creation it will save time.
For example. We have created a bank received rule that says that if the "CITIZENS" condition is met, the item shall be recorded as "4200 - Merchandise". Instead of it shows as "Apply rule".
It should be automatically posted and reconciled. -
Mike Malone
commented
Most ecommerce clients have a direct feed from PayPal producing hundreds of OK's in bank rec. from invoices generated by their respected sales platforms.
If date and amounts match we need to be able to auto allocate, leaving only those identified as (other possible) unreconciled.
-
Naomi Harris
commented
great invaluabe idea
-
Jennifer Martin
commented
Yes need this for quickly matching credit card feeds, which match via an add-on application.
-
Samuel Boyd
commented
Yes, I need to bulk reconcile bank transfers - particularly from bank accounts to my paypal account. Would be an easy fix, and save hours of hassle.
-
Julian Versloot
commented
In today's era of electronic banking and connected bankfeeds, it seems pointless to have to do a bank reconciliation. The transaction gets fed into the Xero ledger therefore the bank balance should always match what the bank statement says. I know that I have to allocate each transaction using rules or manually, so really they're just "Unmatched Transactions". To have to "Mark as Reconciled" or perform a Bank Reconciliation process seems redundant to me. The notion of Uncredited Deposits or Unpresented Cheques is surely outdated, as this was only to work out what my actual bank balance was at any given point in time (ie when datafeeds were impossible). Could the reconciliation process be done away with?
-
Kevin Day
commented
Or a keyboard shortcut! That would be way faster than
click....
click....
click....
click....
click....
click....
click....
click....
click....
-
Matthew Cowell
commented
A system like the Cash Coding system where multiple transactions can be selected and reconciled in bulk.
It would need to be more flexible than cash coding though i.e. searchable and sorted by more detailed data.
-
Yau Pei Wen
commented
Agreed! Especially for those F&B company or those company that have many outlets.
-
Alice B
commented
Yes Russell you are right, good to get that clarified. I couldn't work out how a business with bills and invoices can use Cash Coding
-
Russell Trumm
commented
I also see someone posted about manually marking transactions as reconciled. This also is not an answer for this topic. Manually marking transactions as reconciled is ONLY for transactions that can not be imported via an electronic bank statement. Most of us use the importation of electronic bank statements. You will mess up your bank reconciliation if you manually mark transactions as reconciled when those duplicate transactions come through via electronic bank statement. I hope this helps!
-
Russell Trumm
commented
I'm posting this because a couple of people have responded with "cash coding" as the answer. Cash coding does not resolve what is being asked for here. Cash coding only works to create new spend and receive transactions. Cash Coding does not work for payments against invoices and bills already generated. What we're asking for is to make better use of screen space (or even a scrolling screen) with the ability to "ok" multiple matched payments at one time without a screen refresh between each matched payment. I hope that clarifies it.
-
Christian Morales
commented
Cash Coding already does this.
-
Nikki Velinsky
commented
You can reconcile multiple lines in the Bank transactions tab but you need to enable the function. This article tells you how to do this - https://central.xero.com/s/article/Reconcile-an-account-transaction-without-an-imported-bank-statement#Enableordisablemarkasreconciled
-
Susan Lucas
commented
Unfortunately, cash coding is not available if clients are on the Starter plan. :-/