Request for improvement to bank reconciliation format

@lubos I have noticed the improvement in the bank reconciliation feature and I love it especially how you can now easily see the discrepancies in reconciliation.

I however beg that you display the last successful reconciliation date of every bank account in a column in the bank accounts tab regardless of this new feature. Seeing the Status and Last Reconciliation date right in the Bank Accounts tab was very cool. I feel that the Bank Account tab has been robbed of something that made it very complete and a one-stop-shop.

Also, the application used to show details of reconciling items (Date, Description of transaction, Reference number and amount), we need that too as well as displayed in the picture inserted.

Thank you

1 Like

I prefer the previous format of the Bank Reconciliation Statement which listed the individual pending deposits and withdrawals

This made it much easier to explain the differences to auditors and non-accountants alike

3 Likes

To continue with my moan …
I have just carried out my first Bank Reconciliation since the new format was put into operation. Whilst I have no issue with the processing of the operation, the new report format leaves me a bit confused

Previously the report started with the “Closing Balance as per bank statement”, listed the pending deposits and pending withdrawals and arrived at an “Adjusted closing balance as per bank statement” and then had “Closing balance as per Balance Sheet” so it was very clear which totals were which

The new report has “Actual Balance”, pending deposit total and pending withdrawal total to give a “Cleared balance” and a “Discrepancy”. I had to look twice to understand that the term “Actual balance” meant the Balance as per Balance Sheet" and “Cleared Balance” meant the calculated balance which was to be compared with the Balance per Bank statement which is shown in the report header with the amount of the discrepancy, if any, shown below it

The previous report used a clearer and less ambiguous terminology IMHO

2 Likes

@lubos, I agree whole-heartedly with @Joe91 and @Abeiku. Something more like the old format would be better, even though the current process is improved.

I have moved these posts to a new topic and put them into the ideas category.

2 Likes

Urrgh… I like the Itemized Pending Listing So Auditor can trace it easily on their side.


Thinking about it further, this could be solved by a different default sort order:

  • At the top of the list show the most recent reconciliation for each account, sorted by account name (or account number if shown)

  • Then list all other reconciliations (probably in same order or reverses chronological order)

  • Other sort orders could then be selected by clicking on date or account heading

This would result in similar behavior as is used elsewhere in Manager where it shows the most relevant items at the top of the list.

1 Like

It 20:13 hours and I’m still in the office preparing account for external auditors from the UNFPA. Sad thing is that the new bank reconciliation workflow does not allow you to know the transactions which makes up the pending deposits and pending withdrawals. This is actually giving me a night mare here as I’m supposed do create a fund reconciliation statement for 13 bank accounts for 13 different project and I’m not done with 2 yet. I could have easily pickup up these reconciling items from the reconciliation statement but I can’t do that now.

We have communicated to @lubos about how we appreciate the new BRS but wish we could keep some old very useful features such as this one and the last reconciliation date showing in the bank accounts tab.

What is your view about this @lubos, do you have plans to bring back those features? I believe a reconciliation statements main purpose is to show reconciling items.

Guys If there is a way to get that information on this app please show me.

The only way to get this information currently Is to drill down on the pending deposits or pending withdrawals columns in the bank accounts tab.

Yes, but unfortunately that doesn’t give you the make up of what corresponds to the pending deposits or receipts on a specific reconciliation only what is pending currently. There really is no way after the fact to provide auditable back up for a reconciliation.

I agree it would be nice to either include the list of transactions or be able to click on the total pending deposit or payments number on the reconciliation and see what transactions resulted in the numbers.

I don’t disagree, @alasdair. Read my earlier post. I support returning to something more like the old report.

Yes @Tut it becomes impossible when you are preparing statements for past periods. I’m preparing Fund Account and Bank account reconciliation statements for past periods and timing difference with the General ledger and Bank statement is to be explained for every quarter’s reconciliation statements.