Adding totals to the bank reconciliation
We have quite a few internal controls at our Foundation. One of them involves the matching of debit and credit numbers between the bank reconciliation and the bank statement. Because we are a one person finance department, Someone checks some of the work I do such as reconciliation of bank and investment accounts. The bank reconciliation has no totals on anything to reconcile back to the bank statement. We are used to having deposit/credit amounts, checks/debit amounts, interest, and fees summarized at the very least. Looking at the reconciliation from CSuite – if a debit total and credit total could be added at the bottom of the reconciled section that would help us with our reconciling.
-
Barb Charney commented
Also it would be nice if the order on the reconciliation is by Date then "Check Num"
-
Courtney Brown commented
Any ETA for the Reconciliation History Report?
-
Here's what I'm hearing the revamped total area should look like,
Total Checks:
Total Deposits:
Total Fees:
Total Interest:With an ongoing variance area as you reconcile for what is left in each bucket.
Seems to be a lot of interest so will put this into the roadmap, but still open to other details if this isn't what everyone is after.
-
Deb Pfledderer commented
We would want to be able to print it out as part of the reconciliation. We use the current section that shows the book balance also. It is a quick reference for the supervisor to check and sign off on.
Deb
-
The current calc area could be revamped to be just the totals for the transactions in the display or we could add the debit and credit totals for the lines on screen in the calc area. Which option is preferred?