Namaste friends, welcome to another beautiful and practical
lecture.
Lighten up your mind, soften up your heart a little bit.
Sir, why soften up?
Because only if you keep it soft, the matter will touch
your heart.
Practical things should touch your heart.
If you keep it hard, the matter will come back.
So, soften up your heart a bit.
And today we are going to have a practical discussion.
It's going to be fun.
Friends, I already know that it's going to be fun.
You should also feel that it's going to be fun.
Because you should listen to me.
So, let's go.
Sir, let's listen.
Let's have a practical discussion today.
The two questions that I made you do,
I will make them practical and show them to you.
Right here, right now.
As Jaikant Shikre says, right here, right now.
I will do that and show you in today's lecture.
How does it happen practically?
I have also prepared a passbook for you.
And the rest of the questions will help us.
And we will prepare the cashbook ourselves in our teleprime.
And then we will compare the cashbook and the passbook.
And we will see what the difference is.
And then how to reconcile it.
We will see that today.
Let's start without any delay.
Let's have a go.
We will have to come to the question again, friends.
We will have to come to the question continuously in
today's class.
And first, we will have to prepare the whole framework with
you.
It's the same question.
Question number one.
In the passbook, there is a balance of Rs. 1.5 lakh for
every credit.
While in the cashbook, there is a balance of Rs. 1, 12, 0,
50.
On scrutiny of the two books, she ascertained the following
causes of difference.
She issued cheque amounting to Rs. 80, out of which Rs.
32,000 was only presented for payment.
Cheque amounting to Rs. 5,000 was recorded in the cashbook,
but was not deposited.
Cheque amounting to Rs. 22,000 was deposited, but was not
cleared.
Gupta deposited Rs. 1,500-Rs. 700 directly in our account.
Entry is not allowed in the cashbook.
And the bank has created interest of Rs. 1,500, which is
not entering the cashbook.
And the bank has deducted charges of Rs. 2,500.
Even they are not entering the cashbook.
Okay? Okay, sir.
So here we made BRS.
Now see, friends.
First, let's draft this whole scenario practically.
Let's draft this whole scenario practically in teleprime.
How will this happen?
Come on.
I am saying, you are talking about the concept.
So I am making a practical scenario of the question from
you.
How did this question reach here?
It will be solved later.
Don't worry about solving it later.
How did this particular situation happen?
I will take you there.
How did this particular situation happen?
I will take you on a whole journey.
After that, the solution of the situation.
Now this is not that you put the situation in front and
solve it.
You should also know how to get into the situation.
How did this situation come?
How did this situation happen?
You should also know this.
Okay? Okay, sir.
So come to teleprime, friends.
And create a company in the name of Bank Reconciliation
Statement.
Sir, don't create it in the name of humility.
Write humility in the bracket.
But it is more important to write BRS so that you know
later.
Okay, sir.
Come to teleprime.
Let's go.
F3
Create company.
C company.
No, no.
Don't make C company.
Make a company with Bank Reconciliation Statement.
Write humility in the bracket.
Okay? We are doing an example of humility in this company.
You will remember this.
Very good, sir.
Now put address on address as soon as possible.
Put address on address as soon as possible.
Here it is.
We have created a company here.
Enable GST, sir.
Where did GST come from?
You are crossing the line.
Where did GST come from?
GST is not to be discussed.
You have to talk to the bank.
What does GST have to do with each other?
GST is not to be enabled.
Okay, sir.
Come on.
Friends, friends, friends.
First of all, deposit cash on my request.
All people deposit cash.
Enter capital investment.
How much capital do you have to invest, sir?
Put it in the bank.
In the name of humility capital.
165050 Do what I am saying.
165050 The first step is that
Humility has invested capital.
Deposit money in the bank.
165050 It should have a voucher entry, friends.
Come to V for Voucher.
Tell me the entry of capital investment.
In which voucher will it be?
Purchase, Sale, Receipt, Payment, Journal, Contra
Sir, it will be in the receipt voucher.
We have already learned this in the very initial classes.
We don't have any tension about it.
F6 Receipt Voucher
What will be the credit?
Capital account of the owner.
That is, sir.
The capital account of humility will be credited.
Under the heading of
This is sir.
Under the heading of capital account.
Okay, sir.
Control it.
165050 I repeat.
165050 Delta to Alpha, Delta to Alpha.
Come in, sir.
I repeat.
165050 Okay, sir.
Create an Axis Bank in Debit.
Axis Bank
Under Bank Accounts
Put the account number.
Any fraud from your side.
And take control and save it.
Okay? Okay, sir.
Being Capital I am taking you to the question, friends.
To the question
How to make the situation of the question?
Capital invested by humility.
Being capital invested by humility.
Humility Control it.
Control it.
Very good, sir.
Okay? Okay, sir.
After that
Now what do you have to do?
Now you have to come to the next step.
Look at this.
She has issued cheques amounting to 80,000.
Out of which only 32,000 were presented for payment.
What does this line say?
We have issued a cheque to the creditor.
Out of which only 32,000 were cleared in the bank.
So as soon as we have issued a cheque to our creditor.
So 80,000 must have been deducted from the cash book.
Yes, sir.
Now those who are sitting without revision.
Those who are having trouble hearing this line.
What are you saying, sir?
How is minus?
How is plus?
Those people listen to me.
Do revision.
Then there is no use of it.
There is no use of listening to the class.
You are doing revision.
My words are crystal clear.
So it is good.
Otherwise, do revision again.
Then you have not read that thing properly.
So if you have issued a cheque.
Then we must have deducted 80,000 from our cash book.
While only 32,000 cheques have been cleared from the
passbook.
So how much has been deducted from the passbook? 32,000
Only 32,000 have been deducted from the passbook.
Okay.
I will show you the passbook in a while.
Okay.
For now, if we give cheques of 80,000.
Then we will enter 80,000 from our cash book.
Yes.
Because as soon as we cut the cheque.
We enter our cash book with naked eyes.
We will deduct from there.
We will enter the payment of 80,000.
Very good.
But do two pieces of 80,000.
Do two cheques.
One of 32,000 and one of 48,000.
There will be only two cheques.
Can there be one cheque of 80,000?
Which should be taken to the bank.
And the creditor should say.
Put 32,000 in my account.
Put it after 48,000.
Is it possible?
No.
If it is about 32,000.
Then there will be two cheques.
One of 32,000 and one of 48,000.
So make two cheques.
One of 32,000 and one of 48,000.
Okay.
So let's issue two cheques.
To our creditor.
Now come to teleprime.
This line is written.
Cheque issued to creditor.
80,000 rupees.
How do we issue cheques in tele?
We are going to see that.
We are going to do that.
We are going to do practical of each line and each word.
Okay.
So what is happening?
Payment is happening.
Select F5 voucher.
F5.
Payment is happening.
Cut the cheque and give it to the creditor.
Debit it.
Alt C.
No one will give.
We have to cut the cheque and give it to the creditor.
Debit in Alt C and name it Deepika.
Deepika under sundry creditors.
No.
I don't like it much.
Friend.
People are saying that now you can take Deepika's name
again and again.
I can take anyone I can take Katrina.
I can take Karinna.
I can take Nora.
I have no problem.
Okay.
There is no such thing.
Okay sir.
Control A.
So Deepika, we gave a cheque of 32,000.
We gave a cheque of 32,000 to Deepika.
He gave a cheque of 32,000.
How are you doing?
Okay.
So we gave Deepika a cheque of 32,000.
We gave Deepika a cheque of 32,000.
Give the credit.
Axis bank 32.
Okay.
And press A with control.
Okay, sir.
Give Deepika one more cheque of 48.
We gave Deepika two separate cheques.
One for 32 for one bill.
And the other for 48 for another bill.
48,000.
Axis bank 48.
With control.
Okay.
So we gave her a cheque of 80,000.
Come here.
D for display.
D for daybook.
Look, she is getting a cheque of 32 and 48 twice.
Yes, sir.
That means we gave her a cheque of 80,000.
We gave her a cheque of 80,000.
My dear friends.
Okay, sir.
No problem.
Okay.
If I show you the cash book in the account books, you can
find that we have given her a cheque of 80,000.
The credit is coming.
Okay, sir.
We gave her a cheque of 80,000.
What did the bank do?
The bank took a cheque of only 32,000.
so he has minus 32 from the passbook he has minus 32 from
the passbook we will see the passbook in some time now we
have to think from the angle of cash book we have to
prepare the cash book practically we have to ask the
question of that theory in our teleprime from the point of
view of cash book we will ask from the point of view of
passbook in some time
I will show you that ok sir let's come to the next point
she received a cheque of 5000 which she recorded in her
cash book so a cheque has come of 5000 from some debtor and
we have recorded it in the cash book so record it in the
cash book record the cheque of 5000 in teleprime it has
come from the debtor there will be an entry in the received
voucher no doubt sir no doubt sir what should we name the
debtor let's name the debtor as Ranveer oh my god sundry
debtors control A 5000 and debit bank account
Axis bank 5000
being cheque received from a debtor
Ranveer control A ok sir see the next point you will get
the entry of 22000 in the default display in the default
day book you have entered the receipt of 5000 you have
entered the receipt of 5000 if you open your cash book
display account books and see you will get 1,70,050
1,65,050 and 5000 5000 is also seen in the debit ok sir
what is the next point see I will flash cheque of 22000 has
come and we have deposited what do we do after depositing
we add it in our cash book so we have added this
of 22000 has not been cleared cleared means there is no
entry in the passbook we are preparing the cash book
situation so we have to add it in the cash book add this
cheque of 22000 in the cash book get this also from Ranveer
do one thing we have kept one debitor so we keep one debtor
also
Ranveer 22000 access bank 22000 another cheque received
from Ranveer control A
DAC see entry of 22000 and debit ok now now come to the
question ahead Mr.
Gupta has deposited 15700 rupees there is entry in the
passbook in the bank not in the cash book so you don't do
it in teleprime also and bank has credited 1500 rupees and
deducted 250 from our account there is entry in the
passbook not in the cash book you also don't do it in
teleprime in this situation balance is coming in my cash
book 11250 rupees in this situation balance is coming in my
cash book 11250 rupees my dear friends see this balance see
how it is coming you have added in your cash
165050 when you invested capital in teleprime yes sir issue
cheque of 8000 issue cheque of 32 and issue cheque of 48
minus 32 and 48 yes sir deposit of 5000 and 22000 in the
cash book and there is no entry in the cash book of
15700,1500 and 2500 in this situation balance is coming oh
this is the matter can we check once you also do it minus
32 minus 48 plus 5000 plus 22000 11250 112050 this is the
situation this is the situation that's why it is coming we
know the amount of capital how much
they have invested
I have told you if it was not written in the question
practically we know how much capital is invested there is
no problem oh this is the reason that there is a balance of
12050 in the cash book ok sir and in the passbook how is
the balance of 1.5 lakh for now how is the balance of 1.5
lakh in the passbook let me show you the passbook let's go
my friend you and I to see the passbook in its lovely
entries I don't want to cry
I don't know how to open in all the entries but if you keep
on singing we will definitely start crying
I have stopped singing
I am so sorry take this take this let me flash give me a sec
this is the passbook this is the passbook this is the
access bank passbook see this the statement is of April ok
sir the name of the account holder is namrata account
holder's name is oh my god account holder's name is namrata
yes sir this is the account number let's try to do some
fraud with this account number if you do fraud with this
account number then the biggest fraud will happen with you
how is that sir there is no such account number on earth
from where will you do fraud if you do then
else will happen then it will be fraud with you branch is
in Faridabad ok see this very carefully my friends very
carefully first of all capital investment so in the
passbook the bank has credited how much money 165050 will
the bank credit yes or no whenever your money will be
deposited in the bank the bank will credit we have kept
your money we have liability on our head whenever you come
we will return whenever you come we will give you ok sir
whenever the money will come out the bank will
that our loan is less we have given you some of the money
we will debit so the bank immediately passed the entry
165050 how much 165050 very good sir our next point was
80,000 cheque which we minus from the cash book 80,000
32,000 and 48,000 but see how many cheque has been cleared
in the passbook only 32,000 because 48,000 cheque has not
reached the bank 48,000 cheque has not reached the bank ok
sir after that what was the next point we are making the
situation in theory practically we are
it to you in teleprime and practical passbook that how the
situation is you forgot this what is the next point
5000 cheque has come which is not deposited in the bank so
how will their entry be in the passbook how will their
entry be in the passbook how will their entry be in the
passbook in the same way 22,000 cheque has been deposited
but it is not clear so how will their entry be in the
passbook so 5 and 22 this 27,000 entry we did in the cash
book we took cheque from Ranveer but this 5 and 22 27,000 I
should not see in my passbook because their entry has not
happened there so see if it is in the
it is not in the passbook because their entry has not
happened in the passbook after that
Gupta ji has deposited 15,700 in our account bank has
credited 15,700 you can see bank has credited 15,700 you
can see then bank has credited interest in our account and
deducted 250 for bank charges these 3 entries are not
happening in the last cash book but they are present in the
passbook ok sir take this calculator start 1,6,5,0,5,0 so
much money has been deposited in the account minus 32,000
which we have deducted plus 15,700 which has come more in
the account plus 15,700 which has come
and minus 250 which has been deducted how much is coming?
oh my god sir this is 1,50,000 so in this way we can see
balance of 1,50,000 in the bank in the passbook in this way
in the passbook the balance of 1,50,000 has come in this
way so we have prepared the whole situation we have
practically solved the whole question as I was promising
you while teaching that we will do everything practically
completely how 1,50,000 came in the cash book
I have shown you how the passbook reached 1,50,000
I have also shown you just now
I have also shown you ok sir now the real thing will come
now the real thing will come let's come back here for once
here it is
Very carefully, friends, everyone will write
And everyone will write
Everyone will write, please
Please Cashbook Passbook Cashbook Passbook Capital invested
Plused in the cashbook 165050 Bankers have also plused in
the passbook 165050 Everyone write, come on
Everyone write, come on
Plus in the cashbook means
Debit and plus in the passbook
Means credit
Then what happened?
Then we issued a cheque
One of 32
And one of 48
So from the cashbook
We deducted 32 and 48
Means credit
While from the bank
Only 32 has been cleared
So from the bank, only 32 was deducted in the passbook
No entry is coming of 48000
And from the bank
Minus 32
Means debit
After that, what was the next point?
The cheque came of 5000
In the cashbook
There is no entry in the passbook
Means in the cashbook debit, sorry, while they have not yet
entered in the passbook, they have not entered in the
passbook, in the same way, another cheque of 22,000 has
come, we have debited in the cash book, deposited it in the
bank, but they have not yet entered in the passbook, why?
Because that cheque has not been cleared yet, now that
cheque is in the process, it is in clearing, now that
cheque has not been cleared, my dear friends, no entry, yes
sir, after that, what is the next point we have?
Someone has deposited 15,700 rupees, means Gupta, so there
is a plus in the passbook, that is, there is a credit of
15,700, there is no entry in their cash book, there is no
entry in their cash book, friends, in the same way, the
bank has added a credit of 1,500 rupees in the interest,
there is no entry in their cash book, in the same way, the
bank has deducted 250 rupees, has debited from the passbook
in the name of bank charges, they have not yet entered in
the cash book, they have not yet
in the cash book, so in this way, 165050, minus 32, minus
48, plus 5000, plus 22000, here comes the debit balance of
12050, and here 165050, minus 32, plus 15700, plus 1500,
minus 250, credit balance of 1,50,000, in this, the credit
total is more, the debit is less, so the balance left is
the credit, in this, the total debit was more, the credit
was less, so the balance left is the debit, has there been
a difference? Yes, what was one line taught you at the
beginning?
In the cashbook and passbook, the more it should be plus in
here, the more it should be plus here, the more minus
should be, the more minus should be here, but this has not
happened, here minus 48, here it has not happened, here
plus 5 and 22, it has not happened here, here plus 1500,
1500, here it didn't happen, here minus 250, here it didn't
happen because of this difference came because of this
difference came
and this whole difference, whole scenario we have prepared
in teleprime we have prepared the cash book in teleprime we
have prepared the cash book in teleprime and the passbook,
the bank statement which comes printed out that bank
statement also I have shown you you don't have to make this
bank statement yourself bank people make it, you just have
to print it
from login id, login id password after logging in, ok? ok
sir bank statement, ok now the next thing is more important
than the limit more important than the limit when we had
asked our questions theoretically, then what did we adopt?
we adopted a method that pick up 1, 12, 0, 50 in that plus
minus adjustments and bring it equal to 150,000 start with
the balance of cash book and bring it equal to the balance
of passbook or start with 1,50,000 start with the balance
of passbook and bring it equal
1, 12, 0, 50 these two methods these two methods that start
from anywhere and finish anywhere they have only one
objective they have only one objective if we in cash book
in 1, 12, 0, 50 in plus minus bring it equal to 1,50,000 or
if we in 1,50,000 in plus minus bring it equal to 1, 12, 0,
50 then this is the indication that all the mismatches in
cash book and passbook we have found bank reconciliation
statement which you have been taught theoretically, here
look at the solution from this
we have obtained only one thing we have got only one
indication that 1,50,000 has reached 1, 12, 0, 50 or as I
had done 1, 12, 0, 50 has reached 1,50,000 so that's it now
1, 2, 3, 4, 5, 6 these are the 6 reasons for bank statement
and difference in cash book there is no other reason so
this BRS which I had made on paper this is not that BRS
which will rectify your passbook or cash book this BRS is a
separate statement it does not rectify cash book or
passbook difference in cash book or
in passbook does not rectify bank reconciliation statement
this is not medicine you will get medicine in teleprime
this is the lid of medicine in which you will put medicine
we have found these 6 reasons now you will rectify you will
rectify in teleprime then your reconciliation will be
complete then your mistakes will be rectified which is
missing in cash book or passbook now listen so we have
found the mistakes we have found 6 reasons now see the next
steps we have found 6 reasons because of
difference is coming now I am writing in red color first
reason this 48,000 has become minus here 5,000 has become
plus here 3rd reason 22,000 has become plus here 4th reason
15,700 has become plus here 5th reason 15,000 has become
plus here 6th reason 250 has become minus here it is not
there in cash book we have found these 6 reasons 6 reasons
of difference now friends we have to do reconciliation now
we have to rectify these mistakes listen carefully whose
first mistake whose first mistake
or bank's if we are giving 48,000 cheque to someone and
while issuing cheque we are reducing 48,000 from our cash
book are we doing something wrong no sir this is what we
have been taught if we give cheque to creator then we will
reduce 48,000 from our cash book of course this is what we
have been taught so sir we are not wrong cash book is
perfect reducing 48,000 from cash book is absolutely right
absolutely right 48,000 should be minus we have issued
cheque is it bank's mistake sir they have
taken cheque to creator
bank's mistake is also not there so you know what will
happen this will be kept on hold
no one can rectify this mistake now ask why we have not
done mistake how can we rectify we have issued cheque and
we have not given cheque to creator how can creator reduce
this is not creator's mistake this will be kept on hold
second mistake 5,000 cheque my dear friends came to us we
have deposited in our cash book did we do something wrong
no sir we have not done anything wrong but creator has not
kept cheque we have kept cheque we have not deposited
bank's mistake is also right this mistake
be kept on hold no one can rectify this neither we nor
bank's same situation in 22,000 same situation in 22,000 we
have received cheque we have added our cash book bank's did
not add passbook because technicality of cheque is not
clear technicality of cheque is being checked and till it
is not clear how can they deposit money in passbook third
point will also be kept on hold then what will happen let's
see fourth point 15,700 rupee has been deposited in our
account bank has entered we have not
we have not entered but as soon as we downloaded passbook
as soon as we downloaded passbook this is the passbook as
soon as we download passbook we will see we will know gupta
has deposited 15,700 rupee in our account we have not
entered should we enter our cash book we can rectify our
cash book yes sir we can rectify our cash book so we will
enter this in cash book so what we will do we will rectify
this we will rectify this 4th Mistake
How? By passing an entry in the cash book
This will be the case of 5th transaction
The bank put Rs.1500 in our account
We didn't know
As soon as we downloaded the bank statement
We came to know that
The bank has put Rs.1500 in our account
Here is Rs.1500
We should put their entry in our cash book
We are late, we didn't put their entry
So what we will do? We can improve our cash book
We will put Rs.1500 in our cash book
It will be the same
And what will be the 6th point?
We will put their entry in our rectification cash book
Because we came to know that
The bank has put Rs.250 in our account
And their entry is not in the cash book
So see my friends
Where there is no one's fault
Now we have to stop
Because we can't get Rs.48000 from the passbook
Because Because we didn't reach with the credit
That thing will be on hold
Where there is no one's fault
Where we have to stop
Like this Rs.5000 cheque
We have to stop, there can't be an entry in the passbook
Like this Rs.22000 cheque
We can't remove it from the cash book
And there can't be an entry in the passbook
Because it is in the clearance
So where there is only one solution
We have to stop it
We can't do anything about it
Where we can remove the shortcomings of our cash book
We should remove the shortcomings of our cash book
These three transactions are pending on behalf of the bank
Bank will put their entry
Can we put an entry in the passbook
We did it in our cashbook of Rs.48000
We did it in our cashbook of Rs.5000
Now there is a bank on hold
Now the bank is waiting
And when the entry is done
And when the technicality check is done
And when this Rs.48000 cheque reaches
Then the bank has to put an entry in the passbook
We have put it, we don't have to do anything
So we can't do anything for these three
We can't do anything in our teleprime
For Rs.48000, Rs.5000 and Rs.22000
We have already done what we could
We have entered Rs.48000
When we gave the cheque in the name of Deepika
We have entered Rs.5000 and Rs.22000 in the name of Ranveer
When he gave us the cheque
We did it in our teleprime
Now the bank will wait
And the bank will put an entry in the passbook
We have to put an entry in the bank's passbook
We can't do that work
Because we can't do anything in this
Our hands are tied
I am saying that even if it is not about time
We can't do the entry in the passbook
So the entry we have done in our cashbook
Is pending on behalf of the bank
We have to keep it on hold
We can't do anything about it in our teleprime
We have to keep it on hold in our teleprime
Okay sir
Yes, what we can improve here
We will improve that
Once my dear friend
We will improve that once
Okay sir
Let's improve that once
What all we have to improve now
Let's check this out
Sir, Rs.15700 is the deposit entry
And Rs.1500 is the interest entry
And Rs.2500 is the bank charges entry
Let's do these three improvements in our cashbook
What should be the balance after doing these three
improvements
Can anyone tell me
Pick up the calculator
What is the balance in the cashbook right now
Right now, it is Rs.12050
We will add Rs.15700 in that
And if we subtract Rs.2500
Then it will be Rs.1,29,000
In Rs.12050
We will add Rs.15700
We will add Rs.1500
And subtract Rs.2500
So it will be Rs.1,29,000
Sir, it is not Rs.
It is not equal to my passbook
Why will it be? I have a lack of money in my passbook
You have to bring the wrong balance in your passbook
Sir, this is what we used to do in theory
You don't have to improve anything, you just have to find
out the reason in the theory.
What is the reason for the difference?
If you know that, then move ahead from that point.
Now move ahead from that thought.
Now move ahead from that thought, my dear friend.
This will not be equal to 1.5 lakhs.
Because 1.5 lakhs itself is a wrong balance.
There are shortcomings in it.
Oh, okay sir.
So the final balance of my cash book will be 129.
Think very carefully.
If you think very carefully.
The shortcomings of my cash book.
I will remove it.
I will remove all three.
Then I will get the correct balance.
Which should come.
How much is that? 129.
1.5 lakhs is not the correct balance.
1, 12, 0, 50 is not the correct balance.
If all the transactions are included, then it is the
correct balance of 129.
And you will see.
When they will improve their scene in 1.5 lakhs.
These passbook people.
Then they will also come and stop at 129.
How sir?
Show me.
Take 1 lakh 50 thousand.
Write on the calculator.
Minus 48 which is happening in the cash book.
Tomorrow when our creditor.
Deepika.
This 48 cheque will reach the bank.
And it will be cleared.
So they will also minus the passbook.
48.
Yes sir.
When we will deposit this cheque of 5000.
They will add our 5000 there.
Absolutely sir.
And this cheque of 22,000 will be cleared.
Which we have deposited.
So they will also add this.
Yes sir.
So how much will it come?
Check it.
Sir, there is only 129.
There is only 129.
Take this.
If you will take 1.5 lakhs.
And you will minus 48.
Plus 5.
And 22.
So there is only 129.
In this way.
These two balances will match.
If we will remove the shortcomings of both.
Then they will come and stop at the right place.
The balance of the cash book and the passbook.
Should always be matched with each other.
But for some reason it was not happening.
Some shortcomings were in the cash book.
Some shortcomings were in the passbook.
As soon as you remove the shortcoming of the cash book.
And as soon as you remove the shortcoming of the passbook.
Then they will come on one balance.
Both will get 129,000.
This is the thing.
If there was any shortcoming in the cash book and passbook.
For example.
Then there would have been 29,000 here.
If there was no shortcoming in the cash book.
Then there would have been 29,000 here.
They match.
That's why there are shortcomings.
Okay sir.
Okay.
So now let's remove the shortcomings of our cash book.
Plus 1500.
And minus 250.
Come on friends.
It is very beautiful.
I am enjoying it.
Come on sir.
Come to teleprime.
Let's pass these entries.
Let's do it.
Receive 1500-700 from Mr. Gupta.
V for Voucher.
Take F6 for Received Voucher.
Credit.
Mr. Gupta.
Which is your debtor.
Undersundry debtors.
Debtor must have given the money.
Control A.
15,700 rupees.
Debit.
Bank.
Axis bank.
Bing.
15,700.
We didn't know this.
That's why we didn't enter it in the cash book.
In our teleprime.
As soon as we downloaded the bank statement.
We came to know.
And we entered here.
Bing 15,700.
Deposited by Mr. Gupta.
In our bank account.
By Mr. Gupta.
Directly.
In our bank account.
Control A.
Okay sir.
What else is missing?
Bank has given interest of 1500 rupees.
Add that too.
Received Voucher.
Alt C.
Credit.
Interest.
Income.
Interest from.
Saving bank account.
If it is current.
You can also write the current account.
Under indirect income will come.
Remember.
This interest is your income.
Friends.
You are getting interest from the bank.
This is your income.
Control A.
1500 rupees.
Debit.
Axis bank.
1500.
Control A.
Okay sir.
Bank charges.
Will cut sir.
This will have to be done in the payment.
F5.
Debit.
Alt C.
Bank charges.
Under indirect expenses.
Indirect expenses.
Control A.
250 rupees.
And credit will be bank account.
Because payment is being done from the bank account.
You must be understanding everything.
Why we first got you to do comprehensive entries.
You were taught to do the entry of expenses and income.
Why was your base made first?
Now these things are coming in use in BRS and DRS.
You already know.
If there is income.
Then indirect income will come.
And entry will be in received voucher.
If there is expense.
Then indirect expense will come.
And entry will be in payment voucher.
You know these things.
Okay sir.
Bank.
Bank charges.
Recorded.
In cash book.
Bank charges have been recorded.
We have taken control.
Come on.
Pressing SK.
Come to the gateway of telly.
Press DAC.
And see how much balance is coming.
1,29,000.
In the balance of 1,12,050.
All the shortcomings.
My dear friends.
You have removed it.
And what did you do?
You have reached it on the right balance of 1,29,000.
Let's take a look at the notes once.
Since when is this point pending?
We have not talked about it.
Look at this.
Adjusted cash book.
You guys were thinking.
When will it come?
It came.
If the business.
You can leave this line.
Ignore the first line.
Look at this.
The cash book.
Can be adjusted first.
To the extent it is logical and possible.
First correct your cash book.
In full.
Then make BRS after that.
When you will correct your cash book and make it BRS
Then only those items will be pending in it
Which is pending on the bank's behalf
Sir, we couldn't digest the matter
Now listen, I will make you digest
Did you remove the shortcomings in the cash book?
Did you bring it on 1.29?
Yes sir, we brought it on 1.29
Now what is left?
Sir, but the balance of the passbook is still at 1.5 lakh
Hmm The balance of the passbook is still at 1.5 lakh
Who will correct it?
Us or the bank?
The bank will correct it
So what do we do?
We will inform the bank
That we have reached till 1.29
And you also reach till 1.29 when these 1, 2, 3 entries are
done
We will inform the bank
We will do intimation
How sir?
Come here
Come to Teleprime
Press SK
Come out on the Gateway of Tele
Yes sir
And see this friends
For the first time we are going to enter in this
This is the banking tab we have
For the first time we will enter in this
Which word is highlighted?
N word is highlighted
Press N
And see below
Bank Reconciliation
Sir, we have seen for the first time
Today in Teleprime
We have seen Bank Reconciliation for the first time
Face recognition is required
Yes I can't see any cash in face recognition
I will give my credit card in face recognition
I have given face recognition to Bank Reconciliation
I have also given from your side
You don't worry
I have given
Okay Bank Reconciliation is happy
So Bank Reconciliation got face recognition
Now lift the veil
Bank Reconciliation's new wife
Now lift the veil
Now you got face recognition
To lift the veil
Press B
And open the access bank by entering
And see friends
A very new screen has opened in front of you
Which you have seen for the first time
A new screen has opened in front of you
See up here
What word is written here?
Reconciliation Reconciliation And see above
Bank Reconciliation Statement
Humility Aha Sir, we used to write this in the question also
In the solution
Bank Reconciliation Statement
Humility Yes The same format has come here
My dear friends
The same format has come
Now what you have to do
Now you know what you have to do
Now friends
Very carefully
The entries that are in the cash book
And are also present in the passbook
You have to clear them from here
So the same entries will remain at the end
Which we have done
And is pending on behalf of the bank
Then we can print it out and give it to the bank
That these entries are pending on behalf of you
Clear them
Oh ho ho ho
How will we do sir?
How will we do?
Listen Entry of 1650 is also happening there in the passbook
Yes sir
You just have to put the date
Which date has this entry of 1650 in the passbook
It has been done on April 1
All our entries will be done on April 1
So press enter
Entry of 32000 is happening in the passbook
It is happening in the cashbook
Now this cashbook is open, infront of you
You have to enter the date
This can enter the cashbook
Which date is it on the passbook
With the entry of 32000
Enter sir
Entry of 48000 is not happening on any date in the passbook
Is no date happening in the passbook
So let it go forward
Entry of 5000 is not happening on any date in the passbook
Let it go forward
Entry of 22000 is not happening on any date in the passbook
Let it go forward
Entry of 1500 is happening in the passbook
Yes Is it 1500? Yes.
And is it 2500? Yes. 1 April 2020.
By doing this, my dear friends, save it.
Save it. And open it again.
Open it again.
So you would find
You would find that the bank is showing a balance of 1.5
lakhs.
And it is also telling that this is not the final balance
because three transactions are pending on the account of
the bank of which we can't do anything.
Of which we can't do anything.
No. For now.
Now what will happen? What will happen next?
What you see in front of you
Now we have caught this reconciliation to the bank.
And the bank saw that here also 48 and 5 and 22 three
entries remain with us.
Now what should the bank do?
The bank itself knows that these entries remain with it.
Now this is not a reconciliation statement that you put the
bank.
48,000 will be put when the creator will reach.
5,000-22,000 will be put when the cheque will be cleared.
Hmm. Okay.
Now what happens?
We have caught this reconciliation.
The bank has kept it with itself.
And the bank has said that these three items are also
pending with us.
Do you know the objective of giving this reconciliation
statement to the bank?
So that the bank can cross-check and see that these three
items are pending with us.
These three items are pending with us.
We have also entered the rest.
There is no shortage in our passbook.
And these three items will also be according to the time.
We can't do anything about it.
The bank will say that the three items that you have sent
are also pending with us.
You have done it in your cashbook.
We will wait for a while.
And as soon as these three items cross, we will also pass
the entry.
The balance will be 1.29 at both places.
But now we can't enter the passbook.
It will take time.
These 48,000-22,000 entries will be with us on time.
We said yes.
We sent you that reconciliation so that you just see that
now you have those three items pending with you and you
don't have any other shortage.
He said yes, okay, no problem.
This is the objective, friends.
Okay, okay.
What will happen now?
Now assume some time has passed.
Some time has passed.
And after some time, I will flash the passbook on your
computer screen.
After some time,
the second check of DP has reached.
And that check has also been cleared.
I am writing it properly in front of you.
That check of 48,000 has also been cleared.
That means that 48,000 will also be withdrawn, that is, it
will be debited from my account.
That 48,000 will also be debited from my account.
Okay, okay, sir.
So 150 was still there.
Minus 48, now there will be a credit balance of
1,00,000-2,000 left.
A credit balance of 1,00,000-2,000.
Okay, sir.
Now, the check that I had deposited, 5,000, I did not
deposit it,
I deposited it and it was also cleared.
Okay, sir.
So in the passbook, now I will deposit 5,000.
Now I will deposit 5,000.
So the balance of my passbook will be 1,00,000-7,000 credit.
And there was one more cheque, which I had deposited, it
was not clear.
Suppose that cheque is also encashed, that cheque will also
be encashed.
So we will add 22,000 more in my passbook.
If we add 22,000 more, then it will be 1,00,000-7,000 and
22,000 will be 1,00,000-29,000.
1,00,000-7,000 and 22,000 will be 1,00,000-29,000
1,00,000-29,000 Okay.
Now when these three entries will be in the bank, we will
download the bank statement again.
Till now our bank statement was up to 1.5 lakh, we waited
for some time till next month.
Then we downloaded the bank statement again and we found
that these three entries are also coming in it.
These three entries are also coming in it.
As soon as we see these three entries there, we will come
back to our teleprime.
We will come back to our teleprime.
After coming back to teleprime, the date on which these
three entries will be coming in our passbook, whatever the
date will be, we will put that date here.
But friends, we are learning, so we are always taking 1
April.
You have to put that date in the bank date column that
which date of this transaction is entering in our passbook.
But we can use 1 April, so we are just a small difference.
If the entry is done there, then we will put the date here.
And you would find my dear friends, you would find my dear
friends, see below, balance as per company book 1.29 and
balance as per bank 1.29, amount not reflected in bank 0.
Now there is no item left pending for reconciliation.
Absolutely crystal clear, both balances have stopped at
1.29, both of us and our passbook.
Both of us and our passbook.
We will save it by pressing
A with CTRL and when we come back, we will find that no
item is pending in reconciliation.
Nothing is pending in reconciliation.
Not even a single item is pending in the reconciliation.
It is like this.
Okay.
Okay sir.
Now see friends, think a little more practically.
Now I have given you a scenario and completed it.
Now you must be thinking that yes, in bank reconciliation,
finally everything becomes empty as you can see now.
But friends, do you know what happens?
Next month's transaction comes again.
Then some mismatches happen.
So this always goes on.
Bank reconciliation always goes on.
Okay. So you pick a particular date that either we will do
it once in 2 months or we will do it once in 3 months or we
will do it at the end of the year.
You can do small business at the end of the year.
If you have made a quarterly balance sheet P&L, you are a
very big organization like Reliance etc.
who make their statements for every 3 months.
then you will do bank reconciliation every 3 months every
month you want to make financial statement or every month
you want to do reconciliation 12 months work should not be
collected for tomorrow then you can do every month
completely your choice you pick one date on that date only
see what is the balance in your cash book on that date only
see what is the balance in your passbook cross check both
of them and you will get reason for difference after
getting reason for difference further
we will correct our cash book as much as possible on behalf
of bank whatever incomplete work will be left we will make
a list and give it to bank then bank will wait for their
entry and bank will call and say yes my item is pending
here also no problem ok ok sir and if you want now I will
tell you more practical can we ever call bank? now come
more practical this call to bank was to explain concept to
you can we call bank? who will we call to bank? to manager?
to see our reconciliation? to
are they sitting for the same work? what they do? they put
their passbook there they put their passbook on your portal
you download from portal you will see in that only that
here only this item is left no other item is left so bank
will not check you will check in passbook that here only
these 3 items are pending their entry will come after
sometime so balance will be equal ok sir ok so once
revision is done once revision is done our cash book was
getting balance of 1,12,050 balance of
and in our passbook balance of 1,50,000 ok we picked up
cash book kept it on one side kept passbook on other side
we cross checked both we got 6 reasons for differences we
got 6 reasons for differences how we reached 1,12,050 in
cash book by doing 1,65,050 and then by doing some entries
and how we reached 1,50,000 in passbook that also I told
you then we got entries and we got to know there are 6
reasons for differences out of them all reasons for
differences we can correct on our behalf in our
book we corrected then same reason same 3 reasons for
difference remain 48,500 and 22,000 which were pending on
bank's behalf
then we checked in our passbook that yes this reason is
pending yes this reason is pending after sometime we
downloaded our passbook again so we found what we found
that that entry is also done went straight to bank's
reconciliation finished those 3 entries and got balance got
balance on any particular date then you can get balance
like this now it depends on you depends on your
organization whether you do it monthly quarterly annually
or how you do it ok sir now friends
see this we have some more things like you will go to
display in display here one more option is coming cash flow
click on this press c cash flow press enter so you will see
whole cash flow you will see whole cash flow you will see
whole cash flow
see this bank reconciliation statement is opened what is
opened bank reconciliation statement is opened
you can see whole cash flow you can see whole cash flow see
carefully 1,65,050 came absolutely sir then 42,700 came
from where from gupta 15,700 from ranveer 5,22 cheque
27,000 total 42,700 ok sir and 1500 came from bank 1500
came from bank yes sir after that creator got payment
80,000 32 cheque 42 cheque and bank charges paid 250 so the
money which came 209,250 209,250 209,250 and the money
which went 82,50 minus 82,50 how much is this 139,000 net
inflow see below net inflow how much is this
this was our answer net inflow this was our answer net
inflow ok sir so you can see in this way if you want inflow
total how much how much came and outflow total how much
came and net so from here you will get bank reconciliation
statement in this way you will get reflect ok sir press SK
and come out and you know in account books and cash bank
you will get this detail total inflow is reflected 209,250
total outflow is reflected 80,250 and enter you will get
entries you will get entries received
payment you will get entries received and payment if you
want to make changes in this if there is any error you can
correct and adjust in your
BRS and correct
BRS if there is any error in entries ok sir no problem here
ok ok ok if we print out this for example we have to print
out this for example come to banking and come to
BRS when 2-3 items are left we want to print them for
example you don't have to do anything you can see print in
top horizontal bar yes sir press P with ALT ok sir press P
with ALT and after pressing P with ALT if you want to save
it as a PDF just write file name save as
PDF and save it will be saved in
PDF I canceled for now
I canceled for now you can save it in PDF ok sir very good
sir we saw the whole process sir very good we saw whole
process we understood the whole concept reason is that they
understood one by one theoretically those reasons then we
practiced with one and two questions to make bank
reconciliation one with humility and one with this one with
humility and one with this when we learned to make
BRS with these questions then we went to teleprime we
drafted whole situation there 1, 12, 0, 50 how to reach
there in cashbook and I showed you passbook how to reach
1,50,000 passbook ok sir then the shortcomings on behalf of
cashbook we solved this problem in question number 2 how to
reach 6, 3, 4, 0 in cashbook because cashbook has negative
balance it is important to do once if you see negative
balance in cashbook it is important to do once if you see
positive balance in cashbook it is
to do once if you see negative balance in cashbook it is
important to do once if you see positive balance in If you
are thinking of a topic like BRS that we are listening and
watching and how the other person is doing it it is going
in our mind then you are doing a mistake you are letting
some overconfidence you are coming in an overconfidence
I am telling you that you will not be successful in this
BRS in this concept whether you will be successful in life
or not who am I to say that
I am saying that you will not be successful in BRS if you
are doing this work you have to do a revision
whenever you see the next clip this question this solution
you have to practice it twice otherwise you will win
otherwise you will win things will get more heavy you know
the practical scenario watching class after class is not
our objective after watching the class understand it
completely and after revision be able to explain it to
someone if you are thinking that I have understood
I have become a champion then ask yourself can you explain
it to someone else if you have understood then you should
be able to explain it to someone else if you are not able
to explain then you are done call a small kid and tell him
I will explain you BRS if you are not able to explain then
you are done then you are done come back do revision and
then watch the next class ok ok so friends we will end with
this note we will meet in the next lecture till then thank
you bye bye take care Thank you, bye bye and take care.