Finance Utilities

Bank statement reconciliation processing - Cash and bank management reports

Return to main page
-->

Cash and bank management reports

Finance utilities have additional reporting for the reconciliation facilities to enable better problem resolution and auditing.

Bank Reconciliation Report

Users can reach the Bank reconciliation report by navigating to Cash and bank management > Inquiries and reports > Bank reconciliation reports > Bank reconciliation.

In the report parameters, select the following:

Note: Ensure that all statements are reconciled and the statement posted before printing this report.

Reconciliation summary

Content Heading Description  
Header Checking date Bank statement end date  
    Bank account From the selection
    Bank account currency Currency from the bank account
    Description Bank account description
    Bank account statement date From the selection
    Reconciled date Reconciled date from the bank reconciliation
  Balances Closing balance per bank statement Closing balance as per last posted bank statement up to Checking date
    Unreconciled bank transactions Bank transactions not yet reconciled up to Checking date. If Uncleared transaction details was set to Yes, the transaction details can be viewed on Unreconciled bank transactions
    Expected closing bank account balance Closing balance per bank statement PLUS Unreconciled bank transactions
    Actual closing bank account balance Actual D365 bank account balance at Checking date
    Difference Difference between Expected and Actual bank account balances

Unreconciled bank transactions

If parameter Uncleared transaction details was set to Yes, the following will be printed for all unreconciled bank transactions to the Checking date. The Grand total of this section should equal to the Unreconciled bank transactions on Reconciliation summary.

Content Heading Description
Header Bank account As selected
  Name Bank account name
  Routing number Bank’s routing number
  Bank account number Bank’s account number
  Ledger account Bank’s ledger account
Transactions Bank transaction type Bank transaction type for the transaction
  Date Date for the transaction
  Cost Center Cost center for the transaction
  Payment reference Payment reference for the transaction
  Transaction text Transaction text for the reference
  Currency Currency for the transaction
  Amount in trx. Currency Amount in transaction currency
  Amount Amount in bank’s currency

Bank statement matching report

Users can reach the Bank statement matching report by navigating to Cash and bank management > Inquiries and reports > Bank reconciliation reports > Bank statement matching.

In the report parameters, select the following:

Content Heading Description
Header Bank account As selected
  Bank statement Bank statement identifier(s) (from the Reconciliation)
  Bank account statement to date Shows the most recent bank statement’s date, if not selected in To date
Matched Transactions Date Transaction date
  Match ID When transactions have been manually matched on the bank reconciliation. This would be blank where the transactions were matched with a Reconciliation matching rule.
  Type Bank transaction type
  Payment reference Payment reference for the D365 bank transaction or bank statement line
  Transaction text Transaction text
  Amount Debit or credit transaction amount
  Voucher D365 bank transaction’s voucher. When voucher is blank, the transaction is from the bank statement lines
© DXC Technology Company