Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
A bank reconciliation is the matching process between a company’s cash account balance and its bank account balance (displayed on the bank account statement).
Generally, a company prepares bank reconciliations on a monthly basis.
The bank statement received by a company shows :
All transactions recorded in both the company’s records and the bank’s statement (with exact same data) have to be identified as « cleared ».
The manual bank reconciliation is performed directly from the bank account form. (Access path : Cash & Bank Management > Bank accounts > Bank accounts)
Bank reconciliation in Dynamics 365 enables to:
Important : it is not possible to reconcile a bank account statement with a bank account if any of the checks or deposit slip payments listed on the statement currently have a status of “pending cancellation”.
You can Initialize Bank reconciliation from the Bank Account form previously opened :
The bank statement opens up as shown below (header data) the form automatically displays a new line where some fields have to be filled in (in yellow)
Enter the following in the above screen :
Then click Save
From the former screen, you can now mark cleared transactions :
Note : It’ also possible to simultaneously mark a range of check numbers by using the “Mark check interval” button at the top of the form.
In case some bank fees or interest charges (for example) appear on the bank statement, you can add transactions:
As an example, “bank transaction types” can be classified as displayed below
The above explained “bank transaction types” can also be grouped together, thanks to “bank transaction groups”, which can look like the following :
This classification is useful to allow summarized views of reconciliations – as shown further.
You can view a summary of transactions. Go in Cash and bank management > Bank accounts > Bank accounts.
When clicking on the “Show cleared transaction summary” button, on the right of the screen, all cleared transactions are summed up by transaction groups (as mentioned previously).
For each transaction group, indicated by its code, are displayed :
The « Print » functionality button enables to print:
The Reconciliation Summary report :
Case 1 : only “Reconciliation summary” set to Yes.
Case 2 : only “Cleared transaction detail” set to Yes.
You can also print the bank reconciliation report :
L’article Bank reconciliation in Dynamics 365 for Finance & Operations est apparu en premier sur D365Tour.