Bank Reconciliation - Show Total of selected transactions
When manually reconciling a bank clearing account, you have to manually add up the credits that you have ticked to make sure that they add up to the debit that you are reconciling to.
It would be great if there was a figure showing the total of all items ticked.
It would work exactly the same as when preparing a batch payment in the Purchases module where the total of all bills ticked is shown at the top.
It would save SO MUCH time if we could have a similar total showing in the bank transactions screen - there can be a LOT of sales to match to a single merchant deposit - ticking them off then adding them up is incredibly inefficient.
Karen Bussing
shared this idea
-
Camille Lambert
commented
Having the Account Transactions list total the selected lines would make things so much easier when trying to find which items relate to a certain amount during reconciliation or at other times when you need ot know the total of certain items on that page.
-
Jacqui Bates
commented
This would make manually reconciling a till account so much quicker. Due to delays in the card money hitting the bank, I can't always get it to come back to a running total
-
Jade Hendriks
commented
Very important when reconciling clearing accounts. With timing delays of payments the account doesn't always come back to a $0 running balance.
-
Martin Keenes
commented
I agree with the other posters. It would be great if there was continuity across all screens where you already show the number of items selected but now need to add the TOTAL value of those selected items as well. Just like you already do for the AWAITING APPROVAL tab & AWAITING PAYMENTS tab. Please mirror this.
Currently we screen grab the data and paste into Excel to faff around a bit to get the total!
Thanks for merging the ideas into one.
-
Martin Keenes
commented
PAID Transactions tab. Include the TOTAL of the ITEMS selected, not just the number of items.
ACCOUNT Transactions tab. Include the TOTAL of the ITEMS selected, not just the number of items.
The AWAITING APPROVAL tab & AWAITING PAYMENTS tab already show both correctly. Please mirror this.
-
Margie Murphy
commented
It would be really handy to be able to see a 'sum' total of items selected, when checking transactions off in the account transactions screen, like you can when you highlight a selection of numbers on a spreadsheet. It would be great if it added a total as you select each one, the same way it does when you are selecting items to pay in the bills / awaiting payment screen.
-
Claire Greenslade
commented
I've been wishing Xero could do this ever since we started using it. Fabulous idea.
-
Tom Mitchell
commented
THE ISSUE
We use bank accounts to reconcile settlements by merchant account providers and transactions automatically posted by our EPOS (card and cash = 2 reconciliation accounts). When in a reconciliation account the credit (transferred from the bank account into which the settlement is paid) will be the sum of several debits (transactions from the EPOS); i.e. there is a one to many relationship. We match them off manually then "Mark as reconciled".THE SUGGESTION
This task would be easier if when selecting the tick box (in the Bank Statement screen) a total was visible in order that we can see that the value of transactions selected total 0.