Reconcile Bank Accounts in Business Central - Import, Match, Post Bank Statement | BRS Matching Rule
Agenda of the Video▶️ Part-3: Learn How To Match Automatically Bank Accounts Reconciliation (or BRS) in Business Central (D365BC).
Hint: You may check the Posting Tab of "Bank Account Card" (for Viewing Posted Bank Account Reconciliation Number, and Bank Reco. Updated Last Statement Balance), after Posting the related Bank Account Reconciliation Statement.
➡️Suggested Two Fields Names are as follows:
1️⃣ Last Statement No. ✅
And
2️⃣ Balance Last Statement. ✅
▪️▪️▪️▪️▪️▪️▪️▪️
Read the Related Short Blog:- ➡️https://navisionfunctionalexpert.com/...
Hint: You may check the Posting Tab of "Bank Account Card" (for Viewing Posted Bank Account Reconciliation Number, and Bank Reco. Updated Last Statement Balance), after Posting the related Bank Account Reconciliation Statement.
➡️Suggested Two Fields Names are as follows:
1️⃣ Last Statement No. ✅
And
2️⃣ Balance Last Statement. ✅
▪️▪️▪️▪️▪️▪️▪️▪️
Read the Related Short Blog:- ➡️https://navisionfunctionalexpert.com/...
Category
📚
LearningTranscript
00:00Hello friends, welcome to my channel, I am Filas Verma Gavi, and as you can see, today
00:13we are recording the third part of two videos that we have posted on the topic of bank reconsolation
00:21and in the third part, what we are going to learn is like bank account reconsolation.
00:28First, what will we learn in this video?
00:31What will we learn?
00:32We will do an overview of the bank account reconciliation page,
00:36after that we will import the bank statement,
00:40and after that we will match and post it.
00:43And after this, I will give you a small briefing,
00:47how to send the service line, match manually and reconciliation line in general.
00:54If your bank statement and the bank ledger entries on your system are not matching,
01:05the bank ledger entries that you have posted in the ERP system,
01:10there are some less entries in it, which you forgot to post,
01:14but through the bank statement, you know that these 2-4 entries should have been there.
01:19So when you post those entries in the system according to the bank statement,
01:24then how can you do it?
01:26This 4-point will cover that scenario.
01:30So this 4-point is real.
01:32This is the Business Central screen.
01:34First of all, we will check a bank account,
01:37which I have made, I have made a new bank,
01:40and it is important for you to know the prerequisites.
01:45As I have made a bank, I will show you by viewing it.
01:50As this is a bank, now you will see some ledger entries in this bank,
01:54and look at its balance, its balance is coming in minus,
01:57credit balance is 9516.95.
02:00Now if we click on it, you will see how many entries I have posted.
02:06So I have posted 22 entries, document type payment,
02:09see the document number, CV, PCV, this is my contra voucher,
02:14Posted Contra Voucher, PBP, Posted Bank Voucher, PBR, Posted Bank Received.
02:21So in this way, you can also see the description,
02:24I deposited cash in the contra voucher in the bank,
02:28I made a payment to my vendor,
02:35and I used the received document to receive the customer's payment in the bank.
02:45So in this way, you will also see the amount, this is its amount.
02:49And the value that was being adjusted in between,
02:52you must have seen on the screen, that was 9515.95.
02:58So we have to show this value in the reconciliation,
03:02and this statement should also be of the same value,
03:04how many bank entries have been posted in my system,
03:07have been posted in my bank account card,
03:09and this bank account card is also hitting my financial.
03:12Now let's come to the bank account reconciliation screen.
03:14I have made a shortcut on the system, you can also make it.
03:17Like what I did, I have bookmarked it.
03:20So I will open it from here, you can also open it by searching.
03:33Like this, this is the bank account reconciliation screen.
03:37Now I have created it,
03:41now see it has opened on the system like this.
03:45Now you must be seeing both the side entries,
03:47so what I do, I select more,
03:52and delete it like this.
03:57Because we will import it fresh.
04:01Now you can see the statement number,
04:07if you want, you can also change this statement number.
04:10There is a change in the statement number in the action function.
04:13Now if you want to make any changes in this,
04:16then you can make those changes.
04:18Like DBI is written, if you want,
04:21the bank word should also be written in it.
04:24By the way, the smaller the better,
04:29so I have changed the statement like this.
04:32You can make small changes on the screen.
04:36Now I will show you the related tab of this,
04:40we will go to the card.
04:43The tab related to bank reconciliation,
04:47what I have done on it,
04:50I have put a shortcut link,
04:53which is related to a block,
04:57which tells you what are the matching criteria,
05:00and how you can match them.
05:03How you have to match the transaction.
05:06This is match automatically functionality in bank reconciliation.
05:11On this, go to the following criteria to contribute to a score.
05:16This means which column will match with which column.
05:21Remaining amount with statement amount,
05:24description will match with description,
05:27you can match according to related priority,
05:30you can match according to additional transaction information,
05:33transaction date will match with posting date.
05:36So you can see like this,
05:39and if your bank statement is out of the range,
05:42then it will not match.
05:45Now let's come to the system,
05:47we know what are the matching criteria,
05:50you can paste the link shortcut here,
05:53so you can open it.
05:56So I have seen on which basis it will match.
05:59I have taken one thing,
06:04my transaction date will match with posting date.
06:09So let's make it a basis,
06:12that my transaction date will match with posting date.
06:16And these bank ledger entries I have shown you earlier,
06:19these are the entries which are coming from my bank payment,
06:22bank received and bank counter.
06:25These are the entries which I have shown you in bank ledger entries.
06:29So these were posted on 22nd,
06:32from different document numbers.
06:35Now like this,
06:37debit amount was this much,
06:39credit amount was this much,
06:41remaining was this much,
06:43all are open entries.
06:45I have not touched any external document number.
06:48Now as these will be applied,
06:50it will be fixed.
06:52Now let's see on this side,
06:54these are the entries which are posted in my ERP system business center,
06:57regarding DBI bank,
06:59bank payment,
07:01bank received,
07:03and contra voucher.
07:06And these entries will be the entries of the bank statement which I will import.
07:13Now it is empty because I have not imported any bank statement.
07:16Now we are going to import the bank statement.
07:19To import the bank statement,
07:22first let's check the columns,
07:25transaction date, type,
07:27bank ledger entries, check ledger entries,
07:29reference, document number, value date,
07:31as I told you,
07:33I have made the data exchange definition,
07:35statement amount,
07:37applied amount,
07:39whatever amount will be applied,
07:41you can check here also.
07:43And with this,
07:45description,
07:47description means
07:49the short details of the transaction,
07:51if there is any difference,
07:53related party name,
07:55as I told you,
07:57if there is any hide, you have to activate it,
07:59additional transaction info,
08:01check number, and applied entries,
08:03after applying, you will see.
08:05Columns are at the front and back, so you can select it.
08:07Now we will import,
08:09import bank statement.
08:11Now if you have made a file,
08:13and in CSV,
08:15you have converted it,
08:17as I have converted here, DBI import,
08:19we will import it.
08:21Now system will process it,
08:23and system will bring it to the screen.
08:25Now as you can see, three lines have come.
08:27Now these three lines have come.
08:29Now I am using the educational version,
08:31which does not have any license.
08:33So there is a date issue in this.
08:35This is my on-premises version.
08:37Now I have to match it.
08:39And how to do that?
08:41Match automatically.
08:43So which columns I have taken?
08:45I have taken date,
08:47type is auto,
08:49I have taken document number,
08:51I have taken value date,
08:53value date is 228,
08:55and I have taken statement amount,
08:57which was posted by me,
08:59bank also gave me the same,
09:01exactly the same was in the bank.
09:03Applied amount, when I will automatically match,
09:05then it will match with the system,
09:07on the basis of transaction date,
09:09and posting date.
09:11So according to that criteria,
09:13it will match.
09:15So when it will match, applied amount will come here.
09:17So you see, what will be the biggest difference
09:19automatically after the match?
09:21This difference, one, two, three,
09:23three lines, it will become 0, 0, 0.
09:25Because what will it do?
09:27It will adjust with your statement amount,
09:31applied amount.
09:33So from where it will pick up?
09:35It will pick up the applied amount
09:37from this bank account ledger entries.
09:39It will see the increased on this date,
09:41this is the debit amount,
09:43first line, first transaction,
09:45first date,
09:4718,483.05,
09:4918,483.05,
09:51it will pick it up from here
09:53and match it.
09:55And as soon as it will automatically
09:57match and apply,
09:59as soon as it will come here,
10:01it will adjust it
10:03and make the difference
10:05zero.
10:07Now you can see the difference.
10:11Now you can see the difference.
10:13After automatically matching,
10:15it will be seen in the applied amount,
10:17it will adjust
10:19and post.
10:21And see the total balance,
10:23total balance is 9516.65.
10:25Statement ending balance is also same.
10:27If at any time,
10:29you can't get the statement balance,
10:31then you can copy and paste it here.
10:33Copy from here
10:35and paste here,
10:37whatever is the balance of the statement.
10:41You have to select the date.
10:43And like this,
10:45everything is done.
10:47Now I will show you in my excel file.
10:49What all I took in excel file?
10:51Whatever I took in excel file,
10:55I will show you that
10:57how many columns I took
10:59and what all I took.
11:03Now see this is my excel file.
11:05I took the transaction date and description.
11:07And I took the statement amount.
11:09You can keep any text.
11:11Value date.
11:13If there is a column of date,
11:15then there should be a date.
11:17If there is a column of description,
11:19then there should be a description.
11:21Like sequence in our data exchange definition.
11:23I took the value date,
11:25and after that,
11:27third party name.
11:29Here I didn't write
11:31what should be its caption.
11:33It will take the field caption on the system.
11:35Then I gave the document number.
11:37So I took all these things.
11:39I took the credit value with minus sign.
11:41And if you want to make a minus sign,
11:43then what you have to do is
11:45simply
11:47take the bracket
11:49at the front and back.
11:51It will already become a minus sign.
11:53In this way,
11:55the plus debit amount remains the same.
11:57If you want to give any reference
11:59in third party name, then give it.
12:01Save it.
12:03If you save it well and give a name
12:05like August import file
12:07as bank statement,
12:09then you can easily recognize it
12:11while importing.
12:13So this file is working like this.
12:15After this, it comes on our system.
12:17Now all the things are on our system.
12:19We have changed
12:21the name of the file.
12:23Before posting it,
12:25it is very important to know
12:27if we can see any test report.
12:29You have to check
12:31if there is a test report on the system.
12:33It is in the action button.
12:35There is a test report in the action button.
12:37You have to see this test report.
12:39It will tell you how well you are doing.
12:41If there is any outstanding transaction,
12:43you can also check for it.
12:45If not, the system will not show it.
12:47You just have to
12:49cross-check
12:51how your entries are working.
12:53Let's see.
12:55The system will show
12:57exactly what we are going to post.
12:59The combination of left and right side
13:01left side is our bank statement
13:03and
13:05right side is our
13:07bank ledger entries
13:09which we have posted on our system.
13:11Let's make it bigger.
13:15See this.
13:17This is your
13:19bank account statement.
13:21This is your before posting test report.
13:23You can see it in the action tab.
13:25It tells you about the
13:27recancellation and currency.
13:29I have one foreign currency and
13:31two INR currency.
13:33I have put the conversion
13:35and it has been converted to INR.
13:37You can check
13:39whatever you have.
13:41I have not applied yet.
13:43The system is telling
13:45that the total difference is this much.
13:47Now I will apply it
13:49automatically with the match.
13:51Then the difference should be 0
13:53and it will be 0.
13:55In this way, the total outstanding
13:57bank transaction is showing this much.
13:59Because you have outstanding
14:01bank transaction.
14:03Now how can we correct it?
14:05Let's go back.
14:07Now I have to apply.
14:09As I told you
14:11that the date issue is coming.
14:13It will match with the date.
14:15If you are working
14:17with the educational version,
14:19then if your entry
14:21is not posted on the same date
14:23but different dates,
14:25then when you go to matching,
14:27it will ask you to match automatically.
14:29Then you have to tell
14:31the difference of how many days.
14:33In your bank ledger entry
14:35and in your bank statement.
14:37Now my reference
14:39is
14:41240 days.
14:43Because in the system
14:45entries are showing on January.
14:47Now I will click on OK.
14:49Now the system will work.
14:51And whatever
14:53the difference of days will be,
14:55because in the educational version
14:57entries are showing on January.
14:59Now I have matched
15:013 reconciliation lines out of 3.
15:03Now if
15:05I had to
15:07match it and post it,
15:09because it is an educational version,
15:11it is not allowing me to take
15:13the same date of the transaction.
15:15So what I did, I automatically
15:17used the match and I saw
15:19that the bank account ledger
15:21entries and the statement
15:23entries, what was the difference?
15:25How many months were there?
15:27I converted the months into days.
15:29So as soon as
15:31you use this functionality,
15:33the tolerance date,
15:35here you have to put the same date.
15:37If it is not there, then put 0.
15:39If it is the same date,
15:41if I get
15:4322nd August here,
15:45in the license version,
15:47then I put a simple
15:490 in it.
15:51Here I had to put
15:53simply 0, if it is the same.
15:55But if it was not the same, then I put days.
15:57Now
15:59we have to see
16:01what all things can be matched.
16:03Now the system will match.
16:05Now see what all thing is going green,
16:07transaction date,
16:09posting date.
16:11Now what all
16:13things it is matching,
16:15that is
16:17match the amount.
16:19Amount.
16:21It is matching the
16:23amount, it is greening the amount also.
16:25First it holds the transaction date
16:27with posting date.
16:29Next it holds
16:31statement amount,
16:33matching the remaining amount with the statement amount.
16:43Remaining amount is matching the remaining amount with the statement amount.
16:46Is there anything else in green?
16:48You can understand what all the system is matching with green.
16:51Transaction date with posting date.
16:54Statement amount with remaining amount.
17:02Now I have seen that the description is also green.
17:06If the description is green, then I will have to scroll here also.
17:10Here also my description was there.
17:14See, it matched the description with the description.
17:18So it caught these three points.
17:20And see, tick, tick, tick.
17:23Applied, applied, applied.
17:25This button is for applied.
17:28Specifies if the bank account ledger entry has been applied to its related bank transaction.
17:34So this is tick.
17:36So you can read the criteria that I showed you in the short block.
17:40Now what all it is not matching, it is not matching the related party.
17:44And it did not go on the document number and did not go on the value date.
17:48So it caught two or three points from which it could match.
17:52See, applied amount.
17:55Now if you want to see the record of where it was posted, where these entries came from.
18:01So you can check one by one.
18:03Which entry did you post in this?
18:06Which entry did you post in this?
18:08Where did its record come from?
18:10What is its history?
18:11So you can check the history like this.
18:13Because what is it doing?
18:14You can check the history only on the applied amount.
18:17Not on the statement amount.
18:18Because the connection of the statement amount is with the CSV file that you have uploaded.
18:23But the connection of the applied amount is with your bank ledger entries.
18:28The bank ledger entry that has been posted.
18:30It has a connection with the bank ledger entries on the system.
18:34That's why it will show you the history of this transaction.
18:37That matching happened and where were the matching values coming from?
18:41Applied entries 1.
18:42Applies entry 1.
18:43Applies entry 1.
18:44Now I will show you the difference.
18:46It is also very important to see the column of difference.
18:49Because the difference has become 0.
18:52Yes.
18:53The whole difference has become 0.
18:55Three lines have matched.
18:56Now as soon as we post it, it will also be posted.
18:59So that's all you have to do.
19:01And because this is an educational version, you can ignore the date.
19:05You can test with the tolerance date.
19:08Because I make my maximum videos on educational versions on-premises.
19:13So you can ignore the date.
19:16And I have explained the concept of the date to you.
19:18What is the concept of the date?
19:21Now what do we do with this?
19:23Check all the tabs one by one.
19:25You will get a suggestion line.
19:26You will get a transfer to general.
19:28For this, we will record chapter 2 in the next session.
19:34Check all the tabs once.
19:36What options are you getting?
19:38And whenever there is a matching detail,
19:40If you want to remove or check the matching details,
19:43Then click on it and see.
19:45The system will tell you the match details.
19:46But according to the line, the line you have clicked,
19:49According to that line.
19:50Like I clicked on this last line,
19:52So it was for this last line.
19:54If I click on this, then the matching detail will be for this line.
20:02So in this way, you can check all the details of each line.
20:07Now what do we have to do simply?
20:09Check all the buttons.
20:11The options you are getting, you will get a lot of options here.
20:15If some things match, some do not match.
20:18If you want to post the transaction twice,
20:21Then you can post it with the match one.
20:24What you have to do is,
20:26Take the show non-match and delete it.
20:29You don't want them.
20:31In that way, post the rest of the lines.
20:34In the function tab, you will get a lot of things.
20:37Like the change statement number I told you in the starting.
20:39You can do your import statement.
20:43In matching, you will get all the matching options.
20:46Now in the posting tab,
20:48In posting, you will get the test report, post and print.
20:52If you don't want to print, just post and print.
20:55Then you will get it in print.
20:57Attach a report in print.
20:59Posted bank statement.
21:01Sorry, posted bank account reconciliation report.
21:06So you will get that report on the generator system.
21:09Let's click outside.
21:12If you go directly to this posting button,
21:15You will not get the test report option.
21:18So you have to check in this way,
21:21Which report you are getting in which tab.
21:24If I want both post and print,
21:27I will click on post and print.
21:30Now the system will ask,
21:31Do you want to post and print the reconciliation?
21:33Yes.
21:34Now it will be posted.
21:45This is after posting.
21:53See the magic.
21:57The magic is that your report will come according to this.
22:00This is the after posting report.
22:03As soon as I posted, the system showed me this report.
22:06If I want to download, I will download.
22:09It is downloaded.
22:11If I want to print, I will print.
22:14Save as pdf.
22:17It will ask me the location.
22:20Now you have to give the name.
22:36By giving the name in this way.
22:38If you want to write the month,
22:40You can write.
22:44In this way, it will be saved.
22:47I have saved it.