135

Suggested by Annaick Boudin Completed 

Advanced bank reconciliation has been designed but no bank statement report provides clear information.

Bank statement report is required base on cutoff date. This report should have option to detail

* reconciled transactions

* Un-reconciled transactions

Customer should be able to have a statement at date of what is in his bank account for Audit, cash management, management decision.

Status Details

Bank reconciliation report will be redesigned in 2024 wave 1. Enhanced bank reconciliation statement report | Microsoft Learn

Comments (11)
  • In addition to the comments the report needs following improvements:

    • In the new transactions section print mapped GL and GL name. When finance manager reviews the report before approving a journal they need to see to which GL the amount will be posted.
    • Also all the subsections need their subtotals
    • Currently the report has only unreconciled transaction section so when printing the report for an audit it does not show any transactions if we have a complete match. It needs a section for reconciled transactions as well so you can match your totals from the header section of the report to the subtotals for new, unreconciled and reconciled transactions. That provide a complete view on what is happening inside of the journal.
    • Add description field from a bank transaction in addition to the reference field. Some banks will put valuable description in different fields on the same format like BAI2 so it is good to see Reference field and Description field on this report.