MT940 Bank statement import

foreign

welcome to another uh

topic

in Microsoft Dynamics if Andrew

it's very important topic uh in cash and

Bank management module

bank statement import uh mt940 mt940

bank statement import what are the

setups we need to do and how we need to

import the bank statement what are the

prayer uh setups required and how bank

statement format looks like these all or

uh covered in this topic and in this

video

let's get started uh first of all first

setup is that we need to go to

electronic reporting from the workspace

and uh we need to go to the uh

repositories let's

go to

repositories in this repositories

mt940

related

uh documents we need to import the

latest versions uh once it is imported

just click on import so that uh

will ask for the version and it's

already imported in my system latest

version

latest version is already imported for

imported for all the

configurations uh mt940 model format and

statement mapping uh

and

once this import

thing is completed we need to go to the

bank statement cash in Bank management

module and

we need to set up the bank statement

format in the bank statement format uh I

already create once the bank statement

format is created uh

this is the bank I have

he is my bank statement format uh

statement format this is the format just

it it is just like uh creating new

uh select the

select the name and statement format

Electronic Reporting it will be enabled

and which format of import are yours

importing the bank statement what is the

format of that Mt 940 is our format I

have selected

mt9 phone

the E is this this is the format and

once the format is defined that we need

to map that format to the particular

bank account

which is used for advanced bank

reconciliation so in this is the another

uh setup we need to do uh once these two

setups are mapping the format and

creating the format once it is done

we can import the bank statement uh bank

statement uh normally this is the uh

format it a standard bank statement md9

phone it looks like first

of all uh

so first we have 20

20 is uh date of the bank statement when

the bank statement which bank statement

on uh day which bank statement is we are

going to import like uh whether it is

April first bank statement which date

bank statement you are going to import

format

and next 21 is

um 21 is

belongs to uh

sorry not 21 25 this is the format 25

usmf like uh bank account name and bank

account number

is 25 and 28 C is

statement ID

and 60 yeah 60f is that

um

opening balance opening balance of the

bank statement DeVito credit posting

date currency amount that is the format

and 61 is valued at posting date debit

operated amount posting key references

and these are the two transactions uh 61

and the 86 is the transaction

details uh 61 looks like value date

posting date debit and credit account

everything and uh 686 refers to the

transaction details like JVC code

posting test remittance information Bank

code bank account and name

pay those details will be available in

86 and the end 62 F 62 f is uh

closing interim balance debit or credit

posting date currency amount this is the

format so I have created one simple

format 20 and this is the date

HDFC is our bank right so sorry

HDFC is our bank

and our bank account number is one two

three four five and statement ID I given

uh now I am giving two

and

you

three thousand why because I have

already imported One bank statement if

you go to bank statement for this Bank

you can see one of the bank statement

which I

a ending balance is it is showing eight

thousand actually there is one issue in

this bank statement I will explain later

first of all uh I'm going to prepare

one more bank statement

this is our bank statement

and I'll give 21

sorry

I have imported

is 620 so 621 I am giving and uh

statement ID is 2 and my opening balance

is

three thousand

and this is my transaction

I'll I'm giving 5000

if you have two transactions or three

transactions these two lines will be

repeated

one

once again I suppose 5000 is one

transaction and six thousand is one more

transaction

and my closing balance is three thousand

uh opening balance and David David

uh three thousand five thousand eight

thousand eight thousand plus six

thousand

fourteen thousand is my closing balance

so I'll mention here

let's save it

once uh bank statement is prepaid let's

try to import the bank statement

[Music]

um

so first of all you need to select the

bank

and statement from weight

knows

search for your

um

import

so now two bank statements imported

so let me

see here if once the bank statement is

imported we need to validate when while

validating it's not import

it's not validating the bank statement

because of overlap of dates

as well as one more issue is there here

actually uh ending balance it is showing

8 000 but opening balance zero and there

is a transaction of three thousand it's

supposed to be ending balance also three

thousand because uh opening balance

progress current

if I want to validate it again I am

getting some error message

uh one has the same uh two date as

statement line okay so to date and uh

to date of statement one and two is

mismatched

so

let's take

this one

this

let's validate this one now

there is no bank statement from

um sixth only

net amount 8000 does not balance okay

see

does not balance with

the

balance in the statement lines

see validating

validation pass

so once the bank statement is validated

you can do your reconciliation

again statement two is getting some

error message uh 21

um

not align with the minimum

okay

this is

see

we given from date as 21 and 22 and we

have given the uh

uh statement lines date booking date as

20. it is not at all in between these

two dates from date and today so that's

why it's causing the issue because

actually while preparing the bank

statement itself I have given wrongly uh

to show these errors uh so that you will

come to know right so I've given I

didn't change the dates

so let me change the dates 21

okay

and here 21 we even

okay let

just delete this bank statement and

re-import it

so those are the validation errors uh

will not allow you to validate the bank

statement if the uh if there is any

validation issues

like day two overlaps or any balance

mismatch is there it won't allow

so those are some basic error messages

that I want to show that's why uh in the

statement format I didn't change the

dates

oh

again some validation errors is there

okay

this is from date and to date issue I

guess

so now it's validated

so once the bank statement

imported we can user end users can do uh

Bank reconciliations

so here new

select the bank that you want to do the

reconciliation and cut off date till

which date you want to perform your

reconciliation see ending balance it

came automatically based on your

statements available

once we click on worksheet we'll get

both the d365 transactions as well as

bank statement transactions so that uh

end users can match and they can perform

the bank reconciliation

for that particular period

see these are bank statement

transactions and Bank transactions

nothing is there because I didn't posted

any transactions which are really

relates to this particular Bank there is

no payments receipts nothing I posted

for this bank so that's why it is empty

once that bank transaction was the d365

transactions posted by the users it will

appear in this place once it is posted

we can match with the bank statement

transactions

how to match it

click on select and select this side uh

which um which is related to this

particular

transaction d365 transaction we will

select and click on Match so that it

will move to match transactions so in

this way they will perform the bank

reconciliation

so I have

mentioned here like 20s date of the

statement and 25 is bank account bank

account number statement ID I'll show

you that as well

this

let me open

bank statements

so we have imported two statements right

second statement zero two

this which I

this is the statement I have prepared

right so

this is date of the bank statement date

in the sense this one

and

the date

this is bank account

bank account and bank account number is

inside the bank moisture we have bank

account number that will be the

format This One bank account number one

two three four

and this is D for David date of the

transaction currency and the amount

60f 60 this is opening balance not a

transaction balance and 61 and 86 is a

transaction date

posting date and uh transaction date and

repeat amount and your reference of the

transaction 86 details of the

transaction same way one more

transaction is there 6000 and 62 f is

our closing balance

okay

so that's about a bank statement Mt 940

bank statement input uh the in this

setups or major setups is that importing

the latest version of the versions for

the statement models required models and

bank statement format we need to Define

once the bank statement format defined

we need to assign to that particular

Bank

statement format looks like this and

these are the detailed explanation of

the statement

and Sample bank statement I have

provided

that's about

2940 bank statement

okay we'll discuss a new topic in next

uh video

see you later thank you all

thanks