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!
-
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