This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2022 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2022 Wave 2.
The first of the new functionality in the application section is better bank reconciliation for checks and improved reporting.
Bank reconciliation is a key task in every company and performing the task efficiently is important to every finance department. Better matching rules improve the speed with which bank reconciliation is done.
Enabled for: users, automatically
General Availability: October 2022
In bank reconciliation, there is now a match for check entries from the bank based on information from the check ledger. This gives a much higher degree of match confidence than only using information from the bank ledger. The matching rules are also made more clear, and more rules are added to increase matching success rates.
The test report has been changed so the G/L Account Balance field now shows the balance on the real G/L account at the statement ending balance date. This lets you easily detect direct postings to the G/L account. Direct posting to G/L accounts often leads to errors in bank reconciliation.
The G/L Acc. Balance (LCY) field will be calculated if you’re using a bank denominated in currency. In some cases, this can lead to differences in actual bank balances due to rounding, but it still allows you to detect direct postings to the G/L account.
The Sum of Differences field is the same as the total in the Difference column for the reconciled entries. It’s convenient to also have the sum in the header.
The Bank Statement report now includes payments that were outstanding when the bank reconciliation was posted.
Note
The report compares closing dates for bank ledger entries to the statement date to determine which entries were open when the bank reconciliation was posted. If you do bank reconciliation in reverse chronological order and you omit entries from a prior period (for example, and you also manipulate statement ending balances), entries might show as outstanding in the test report but not in the statement report. This is by design. If bank reconciliations are done consistently, both reports will show the correct entries.
The new features are available on the Bank Reconciliation page, where the test report is found, and on Bank Acc. Statement reports.
When you add a G/L account to a bank posting group on the Bank Account card, you will get a warning if the G/L account allows direct posting. This lets you decide whether to leave direct posting turned on, such as if you need to manage an opening balance.
New Functionality In Microsoft Dynamics 365 Business Central 2022 Wave 2
What should we write about next?
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.