Bank Reconciliation - Select multiple statement lines to reconcile against transactions
We have a major customer who pays multiple invoices but splits their remittance across more than a single bank statement line. There does not seem to be ability to match a bulk deposit against more than one bank statement line.
David Truran
shared this idea
Hi!
Thanks for sharing your idea about how you'd like to see the reconciliation process improved.
We've reviewed your idea, and now it's up to the community to get behind and support it. Make sure you share your idea with any colleagues that this could benefit, so they can add their votes and comments about how this would be helpful for them, too!
-
Angela Nicol
commented
Allow multiple payments to be matched to a bill quickly, in the same way multiple bills can be matched to one payment. I have a monthly Stripe bill, which is paid with around 70 small payments. When doing month end, this is really time consuming to go into each bank transaction, match to the bill and split the payment. I have to do this approx. 70 times for a £45 bill. Is there a way something could be set up either through the bank feed, cash coding screen, or in the bill itself, where you can currently enter the payment details which would then match it in the bank, could you make it so there's also a button to 'find payment(s) in the bank feed' - select the relevant bank, tick all the relevant payments and match? Or similar in the bankfeed screen, tick all the payments and match to a specific bill?
-
Anna Mehrtens
commented
This requirement also applies to company-card expense claims. Wise and merchants such as Uber can produce several statement lines for one purchase—for example, a $29.92 debit and a $0.23 credit, while the employee submits one supported Xero Expense claim for the final net charge of $29.69. We need to select both statement lines, have Xero calculate the $29.69 net amount, and match the group to the existing expense claim. The functionality must support mixed debit and credit lines, not only several receipts or instalment payments. Fully reversed authorisations, such as a $16.72 debit and matching $16.72 credit, should also be capable of being grouped and reconciled as a nil-net pair. The current workaround requires artificial Spend Money, Receive Money or clearing-account transactions, creating unnecessary work and increasing the risk of duplicated expenses, GST errors and an unclear audit trail.
-
Jeffrey Austin
commented
I have numerous situations where I make one payment to a vendor for airline tickets (in this case Expedia) but multiple charges show up on my credit card -- a charge for each different airline or ticket. I would love it if I could match multiple credit card charges to a single bill. Instead, I am forced to create separate bills for each individual airline ticket -- in this case I have 4 separate bills. This is a lot more work.
-
Gavin Anderson
commented
Hi team, I would like to take multiple deposits and reconcile them in one group, against multiple GL lines please