Bank statement reconciliation processing - Cash and bank management reports
Finance utilities have additional reporting for the reconciliation facilities to enable better problem resolution and auditing.
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.
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 |
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 |
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 |