So many, many things in this release that are awesome, wish I could discuss them all but that would almost be like writing a book! So I will focus on Bank Reconciliation with Copilot. In my humble opinion this is a huge improvement to bank reconciliations.
Copilot’s ability to analyze text with its language intent and language processing combined with it’s simple problem-solving capabilities, substantially improves the matching of bank transactions to those posted in Business Central. The original BC algorithm for matching is still utilized, while the Copilot feature reviews and works to match what BC did not.
It’s also nice that you can choose to utilize the bank reconciliation without Copilot but why not take advantage of extra automatic matching. Especially, when it comes with the ability to propose those general journal transactions that you need for things that went directly to the bank. Add to that, the ability to ‘save’ those proposals for future use!
This seems like a win-win proposition for me to use the Bank Rec with Copilot.
Let’s look a little deeper. First, as you start a bank reconciliation, you will notice you have the option for New and the option for Reconcile with Copilot
Assume that you start as you’ve been doing and simply click New. The following screen will appear and looks very familiar but you have a couple of additional options relating to CoPilot.
You may see the trend that things related to Copilot have a special icon symbol of
Nice simply way to know which are the new features and easily see the new Copilot features.
You can continue to populate your bank rec as you have in the past. Select your Bank Account No. and let the system populate a Statement No. Next, though you can use the old Suggest Lines feature, my recommendation is to import a bank file.
On a side note:
Many users think this is too hard to setup the system for importing a file but it’s not. In fact, it’s super simple and there is a wizard to assist you. But ask your partner if you need help or feel uncomfortable with the wizard.
Why do I prefer the import to suggest lines? Because the import brings in the records from the bank. And in my bank rec, I really do want to match what the bank has processed to what I’ve processed in Business Central.
Back to our bank reconciliation, after populating the ‘bank statement lines’ you can continue as you have. Or from the Home menu or the Matching menu, you can choose Reconcile with Copilot even though in your first step, up to this point, you simply chose New.
What if you started your Bank Rec with the option to Reconcile with Copilot? What would be different? Microsoft states that what will be displayed is a ‘new type’ of dialog box. At first glance it just looked like a page like another other.
And then I realized that the option buttons are on the left rather than the right. And it was pre-populated for me. The reason there is a bank account populated, is because I only have one bank account with a statement definition assigned which indicates to the system that I expecte to use transaction data from an imported file.
If your bank is linked to your BC bank account, the use data from will display ‘online bank feed’.
Since the above example is to import transaction data, clicking on those words or the ‘attach’ button to open a window to select your file. As with other such windows in BC, you can browse to the file or drop a file into the window.
Once you complete the file selection, the statement date from the file and an auto-assigned statement number are populated. The dialog page is updated and the ‘generate’ button is green and available to be used. Note the page has it’s selections on the bottom left.
PS, I am so visual that I love the generate button becoming green when I can use it. You will notice a few other places where options and text are green which means they are ready to use or providing data.
The generate button is important to your Copilot reconciliation. It imports the data from your file, runs the BC automatic match followed by the Copilot match, prepares a list of proposals for transactions posted by the bank but not in BC, for transactions that are multiple entries at the bank that match to one BC entry and gives you an analysis of the status of the reconciliation. The following screen is displayed when generate completes, be a little patient here, as generate is doing many steps.
The screen above shows how many lines were matched by BC, 45 of 48, in this case which is a very high percentage and those matched or found by Copilot needing to be posted. This screen follows the same new dialog box formatting with options on the bottom left.
To be clear in the above proposals, Copilot is recommending that these two bank entries ($250 each) be matched to one bank entry of $500. This was not a feature in prior versions of the BC bank reconciliation, to match two bank entries to one BC entry. WOW! Screenshot below shows the match details for the two applied lines.
And the third line is a charge posted to the bank that is suggested to be applied to an entry in BC but it does not totally match. You can client on the proposal to see the entry application suggestion.
In the above case the bank has $495 but we posted $100 in BC. We can keep it, which for this example, we will do OR we can delete the line from the proposals. We will need to match this bank entry to another BC entry to complete our reconciliation. So when we choose ‘keep it’, we receive the following message:
And the bank reconciliation page opens for use.
Note: the toggle button entitled ‘Post if Fully Applied’ would be available is their were no proposals with ‘apply to entry’. You could toggle to the ‘on’ position and when you choose the ‘keep it’ button, the reconciliation would post and your done.
Here’s another example of the same bank rec but the file had one other entry in it:
I know you are saying….this looks exactly like the prior screen, but notice the number of lines and the fact that this is only 98% matched
When I chose ‘Keep It’, I received the same message screen’ the bank account reconciliation is not posted yet. Do you want to open it now?’ I can complete the bank rec as I’ve been doing, transferring entries to the General Journal but let’s try the ‘Transfer to G/L Account’ option with the Copilot logo.
I received a message telling me to identify the lines that have a difference to be transferred, so I used Select More to flag the lines. Note, if no lines have a difference, then you cannot select them. You can see these in the grey window of the next screenshot. Selecting ‘transfer to GL account’ again, here’s what I received:
As the screen title says, these are the proposals for transfers the amounts to the general ledger. It’s not a general journal but I can ‘choose G/L Account’ by clicking on each line in the Proposal column. This brings up the Text-to-Account Mapping page where you enter the general ledger account for the transaction. Note you need to identify a debit and a credit account.
Populating the mapping will save the general ledger accounts to be used in the future. The next time that Copilot suggests the GL Account, you need to nothing more than to choose the ‘keep it’ button. The ‘Keep It’ button on the GL Account Transfer Proposals page, will not only create the general journal but it will post the journal and mark the bank rec entries as matched.
Because we had entries to apply and GL account entries to make, you will have to manually post the bank reconciliation. The goal is to get to the point that Copilot gets your matching to 100% and without further ado, you post when fully applied!
Before you can start using Copilot, you need to do two things.
- Enable the feature – Enable using Copilot capabilities in Bank Account Reconciliation
2. Verify Copilot and AI are Active for Bank Reconciliations
I really believe that you will enjoy this new feature for Bank Reconciliation with Copilot in Release 2024, Wave 1. CoPilot in other areas as well! And there are many other improvements, if you use Service or Jobs, you are in for several treats!