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.
Depika Under sundry creditors.
Take any name.
I can take anyone I can take Katrina, Karina, Nora.
I have no problem.
Okay.
There is nothing like that.
Okay sir.
Controlling So we gave Deepika 32,000 cheque.
We gave the check to Deepika 32,000.
I gave you a cheque of 32,000.
Credit it.
Axis bank 32.
Okay.
And press A with CTRL.
Okay, sir.
Give another cheque to Deepika.
48.
We gave two cheques to Deepika.
Different.
One for 32.
For one bill.
And the other one for 48.
For the second bill.
48,000.
Axis bank 48.
CTRL A.
Okay.
So we have entered 80,000 payment.
Look at this.
You come here.
D for Display.
D for Debook.
Look.
The payment entry is coming twice.
32 and 48.
It is definitely coming, sir.
It means that we have entered the payment of 80,000.
We have done 80,000 minus from our cash book.
My dear friends.
Okay, sir.
There is no problem in this.
Okay.
So I will show you this cash book in the account books.
So go inside and you can find.
Look at this.
We have entered the payment of 80,000.
Credit is coming.
Okay, sir.
We have entered.
Now what did the bank do?
The bank only took a cheque of 32,000 from this.
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 of 48000 is coming there
And from the bank
Minus 32 from the passbook means
Debit 32
After that, what was the next point?
Cheque of 5000 is attached to the cashbook
No entry in the passbook
Means in the cashbook
Debit While there is no entry in the passbook
There is no entry in the passbook
In the same way, another cheque of 22000 has come
We have deposited it in the bank
But there is no entry in the passbook
Why? Because that cheque has not been cleared
Now that cheque is in the process
Now that cheque has not been cleared
My dear friends
No entry
After that
What is the next point?
15700 Someone has deposited
Means Gupta
In the passbook, plus means credit 15700 There is no entry
in their cashbook
There is no entry in their cashbook
In the same way, the bank has added 1500 rupees of interest
There is no entry in their cashbook
In the same way, the bank has deducted 250 rupees
Debited from the passbook
In the name of bank charges
There is no entry in their cashbook
So like this 165050 Minus 32, minus 48
Plus 5000, plus 22000
Here is coming
Debit balance of 12050
And here 165050 Minus 32
Plus 15700
Plus 1500
Minus 250
Credit balance of 1,50,000
In this, the total credit is more
Debit is less
So finally the balance left is credit
In this, the total debit was more
The credit was less
So finally the balance left is debit
Is there a difference?
What did I teach you?
In cashbook and passbook
Here should be more
Here should be less
But it didn't happen
Here is minus 48
Here is plus 522
Here is plus 1500
Here is minus 250
Because of this, there is a difference
And this whole difference
We have prepared the whole scenario in teleprime
And the passbook bank statement
Which is printed out
I have shown you that bank statement
You don't have to make this bank statement yourself
You just have to print it
Login from login id
Login from login id password
Bank statement
Now the next thing is
More important than the limit
When we asked our questions
What did we adopt?
We adopted a method
Pick up 1,12,0,50
Make adjustments in it
And bring it equal to 1,50,000
Start with the balance of cashbook
And bring it equal to the balance of passbook
Or start with 1,50,000
Start with the balance of passbook
And make it equal to 1,12,0,50
These two methods
Start from somewhere and finish somewhere
They have only one objective
If we make the balance of cashbook
And make it equal to 1,50,000
Or we pick up 1,50,000
And make it equal to 1,50,000
And make it equal to 1,20,0,50
This is the indication that
All the mismatches in cashbook and passbook
Have been found
Bank Reconciliation statement
Which has been taught to you
Here is the solution
From this solution
We have obtained only one thing
We have got only one indication
That if 1,50,000
Has reached 1,20,0,50
Or as I made it
If 1,20,0,50 has reached 1,50,000
Then that's it
Now 1,2,3,4,5,6
These are the reasons
For bank statement and
Difference in cashbook
There is no other reason
So this BRS that I made on paper
This is not that BRS
That will rectify your passbook
Which is the deficiency of passbook
Or the deficiency of cashbook will rectify the cashbook
This BRS is a separate statement
I told you
This does not rectify cashbook or passbook
The deficiency in cashbook
Because of which the difference is coming
It does not work to rectify
This bank reconciliation statement
This is not a medicine
You will get the medicine in teleprime
This is the lid of the medicine
In which you will put the medicine and drink
We have found these reasons
We have found 6 reasons
Now you will rectify these reasons
By going to teleprime
Then your reconciliation will be complete
Then your mistakes will be removed
Which is the deficiency of cashbook or passbook
Now listen
So we have found the mistakes
We have found 6 reasons
Now look at the next steps
We have found 6 reasons
Because of which the difference is coming
Now I write with red colored pen
First reason
This 48000 has become minus here
Second reason
This 5000 has become plus here
Third reason
Fourth reason
Fifth reason
Sixth reason
Cashbook has become minus here
Cashbook has not become
We have found these 6 reasons
Now friends
We have to do reconciliation
Now we have to rectify these mistakes
Listen very carefully
Whose is the first mistake
Ours or bank
If we are giving someone a cheque of 48000
And while issuing the cheque
Are we doing something wrong
No sir, this is what has been taught
If we give the cheque to the creditor
Then we will minus 48000
This is what has been taught
So sir we are not wrong
Cashbook has become good
It is absolutely right to be 48000 minus from the cashbook
We have issued the cheque
Is it the fault of the bank
Sir, the creditor has not yet taken the cheque
It is not the fault of the bank
So you know what will happen
It will be kept on hold now
No one can rectify this mistake
Ask why
We have not made a mistake
We have issued the cheque
We had to minus 48000
It was our mistake
And the cheque has not yet reached the bank
There is no fault of the bank
The second mistake 5000 cheque
My dear friends
It came to us
We deposited it in our cashbook
Did we do anything wrong
No sir, we did not do anything wrong
But the bank has not yet kept it plus
Because we have not yet deposited it
We kept the cheque with us
Forgot to deposit
The bank is also fine
This mistake will be held
No one can rectify this
Neither we nor the bank
This is the same in 22000
We got the cheque
We deposited it in our cashbook
The bank has not yet kept it plus
Because the cheque has not yet cleared
The technicality of the cheque is being checked
See the rhyming
And until it is not clear
How can we deposit the money in the passbook
This is also fine
What will happen then
Let's see
The fourth point
Mr. Gupta has deposited it in our account
Has deposited the cash
The bank has entered
We have not entered
But as soon as we download the passbook
As soon as we download the passbook
See this
As soon as we download the passbook
We will see this entry of 1500-700
We will see
We will immediately know
Mr. Gupta has deposited 1500-700 in our account
We have not entered in the cashbook
Should we enter this in our cashbook or not
Tell the truth
We can improve our cashbook
Yes sir we can improve our cashbook
So we will enter this in the cashbook
So what we will do
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 We didn't take the creator
That thing will be there
Where there is no one's fault
Where we have to stop
Like this Rs.5000 cheque
We can't get their entry
Like this Rs.22000 cheque
We can't get their entry
Because they are in clearance
So where there is only one solution
We have to hold it. We can't do anything about it.
Yes, where we can remove the shortcomings of our cash book,
We should remove the shortcomings of our cash book.
Look, these three above transactions are pending on behalf
of the bank.
The bank will put their entry.
Can we put an entry in the passbook?
We did it in our cash book of 48, 5 and 22, where we could
have done it.
Now the bank is on hold, right?
The bank is on hold.
So now the bank is waiting and when it happens, the entry
is clear with the bank.
And the process to check the technicality should be
completed.
And when this 48,000 creditor arrives with this cheque,
then the bank has to put an entry in its 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 48, 5 and 22.
We have already done what we could have done.
We have entered 48,000 in the name of Deepika when she gave
the cheque.
We have entered 5 and 22 in the name of Ranveer when he
gave us the cheque.
So we did what we could have done in our teleprime.
Now the bank will wait and the bank will put an entry in
its passbook.
The entry has to be put in the bank's passbook.
We can't do that work, that's why it's on hold.
Because we can't do anything in this.
Our hands are tied.
I am saying that even if it wasn't about time, we can't do
the entry in the passbook.
So the entry we made in our cashbook is pending on behalf
of the bank.
We will 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.
We can't do anything about it.
Okay sir.
Yes, what we can improve here, we will do that improvement
once.
We will do that improvement once, my dear friend.
We will do that improvement once.
Okay sir.
Come here.
We will do that improvement once.
What improvements do we have to do now?
Let's check this out.
Sir, 1500 and 700 is the deposit entry, and 1500 is the
interest entry, and 250 is the bank charges entry. Okay, we
will do these three improvements in our cashbook.
After doing these three improvements, what should be the
balance?
Can anyone tell me?
Pick up the calculator.
How much is in the cashbook right now?
Right now, it is 12050.
Right now, it is 12050 in the cashbook.
In that, we will add 1500 and 700 in a little while.
And if we add 1500 and minus 250, then it will be 1,29,000.
In 12050, we will add 1500 and 700.
And if we add 1500 and minus 250, then it will be 1,29,129.
Sir, this is not 1,50,000.
This is not equal to the passbook.
Why will it be?
There are shortcomings in the passbook as well.
Do you want to bring the balance of your cashbook equal to
the wrong balance of the passbook?
Sir, this is what we used to do in theory when you told us.
So, we don't have to do any improvement in theory.
In theory, we just had to find out the reason.
Now, 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,50,000 because 1,50,000 itself
is a wrong balance.
There are shortcomings in it.
Oh, okay, sir.
So, the final balance of my cashbook will be 1,29,000.
Think very carefully.
If you think very carefully, the shortcomings of my
cashbook, plus 1500, 700, plus 1500 and minus 250,
I will remove it.
If I remove all three, plus 1500, 700, plus 1500 and minus
250,
I will get the correct balance which should be there.
How much is that? 1,29,000.
1,50,000 is not the correct balance.
1,20,000, 0,50,000 is not the correct balance.
If you add all the transactions, then 1,29,000 is the
correct balance.
And you will see that when they improve their scene in
1,50,000, then they will also stop at 1,29,000. How, sir?
Show me.
Take 1,50,000 and write it on the calculator.
Minus 48, which is happening in the cashbook, tomorrow when
our creditor, Deepika, will take this 48 cheque to the bank
and it will be cleared, then they will also minus 48 from
the passbook.
Yes, sir.
When we deposit this cheque of 5,000, they will add our
5,000 there.
Absolutely, sir.
And this cheque of 22,000 will be cleared which we have
deposited.
So, they will also add this.
Yes, sir.
Take 1,29,000.
If you take 1,50,000 and minus 48, plus 5 and 22, then it
will be 1,29,000.
In this way, these two balances will match.
If we remove the shortcomings of both, then they will stop
at the right place.
The balance of the cashbook and the passbook should always
match with each other.
But for some reason, it was not happening.
Some shortcomings were in the cashbook and some in the
passbook.
As soon as you remove the shortcomings of the cashbook and
remove the shortcomings of the passbook, then they will
come on one balance and both will be 1,29,000.
Oh! This is the thing.
This is the thing.
If there were any shortcomings in the cashbook and
passbook, for example, then there would have been 1,29,000
here. If there were no shortcomings in the cashbook, then
there would have been 1,29,000 here.
That's why there are shortcomings.
Okay, sir.
Now, let's remove the shortcomings of our cashbook.
Come on, friends.
It's very beautiful.
I'm enjoying it.
Come on, sir.
Let's pass these entries.
Let's do it.
Receive 1,500-1,700 from Mr. Gupta.
V for Voucher.
Take F6 for Received Voucher.
Credit Mr. Gupta.
This is your debtor.
Under-sundry debtors.
The debtor must have given the money.
Control A.
15,700 rupees.
Debit Axis Bank.
Being 15,700 We didn't know this.
That's why we didn't enter it in the cashbook.
In our teleprime.
As soon as we downloaded the bank statement, we came to
know.
Being 15,700
Deposited by Mr.
Gupta in our bank account.
By Mr.
Directly in our bank account.
Control A.
Okay, sir.
What are the other shortcomings?
Add the interest paid by the bank for 1,500 rupees.
Received Voucher.
Credit interest income.
Interest from bank account.
Under-indirect income.
This is your income.
You are getting interest from the bank.
Control A.
1,500 rupees.
Debit Axis Bank.
Bank charges.
It will be deducted.
In F5.
Debit.
Bank charges.
Under-indirect expenses.
Control A.
2,500 rupees.
Credit from the bank account.
You must be understanding everything.
Why did we teach you comprehensive entries?
Why did we teach you to enter expenses and income?
Why did we make a base?
You already know that if there is income, there will be
indirect income.
If there is expense, there will be indirect expense.
You know these things.
Bank.
Bank charges.
Recorded.
In cash book.
Bank charges are recorded.
Control A.
Press Esc.
Gateway of Tally.
Press D, A, C.
Balance is 1,29,000.
Let's see in notes.
We haven't talked about when this point is pending.
Look at this. Adjusted cash book.
You were thinking when will it come?
When will it come?
It's here.
You can leave this line.
Ignore the first line.
The cash book can be adjusted first to the extent it is
logical and possible.
Fix your cash book first.
Then make BRS.
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 32,000 is happening in the passbook
It is happening in cashbook
Now this cash book is open in front of you
You have to put the date
What date is the entry of this cash book
Entry of 32,000 is one on April 2
It is applied
Entry of 48,000 is not possible in any date in the passbook
Does not happen to any date in the passbook
Then let go ahead
Entry of 5,000 is not going to any day in the passbook
Leave forward
Entry of 22,000 is not going to any day in the passbook
Then leave it
Entry of 1500 is happening in the passbook
Yes Entering of 1500 here and 250 here 1 April 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 the balance as per 1.5 lakhs and it is also
telling that it is not the final balance because three
transactions are pending on the account of the bank above
which we cannot do anything for which we cannot do
anything, for which we cannot do anything for now, what
will happen now, what will happen in the
what you see in front, 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, see and put the reconciliation statement, 48,000
will be put when the creator will reach, 5,000, 22,000 will
be put when the cheque will be cleared, okay, okay, now
what happens, we caught this reconciliation, the
kept it with us and the bank said yes, 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 yes, these three
items are pending with us, these three items are pending
with us, no one else is 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
cannot do anything, the bank will call, the
will say yes, the three items that you have sent are also
pending with us, you have done it in your cashbook, it is
absolutely fine, we will wait a little and as soon as these
three items are crossed, we will also have an entry pass,
the balance will come to both places, 29 will come to you
and to us, but now we cannot enter the passbook, it will
take time, it will be on time, these 48, 5 and 22 entries
will be with us, we said yes, we sent you, that's why it
was reconciliation, so that you
see that now you have those three items pending, there is
no shortage of anyone else with you, they said yes, there
is no problem, this is the objective, friends, ok, ok, what
will happen now, what will happen now, now assume that some
time has passed, some time has passed and after some time
, I will flash the passbook on your computer screen, after
some time, I reached with the second cheque of DP and that
cheque was also cleared, I am writing it in front of you,
that cheque of 48,000 was also cleared, that means that
48,000 will also be withdrawn, that is, 48,000 will be
debited from my account, that 48,000 will also be debited
from my account, ok, ok sir, so 150 was still minus 48, now
1,00,000-2,000 credit balance will be left, 1,00,000-2,000
credit balance, ok sir, now the
that I deposited, I did not deposit it, it was 5,000, it
was deposited and it was also cleared, ok sir, so in the
passbook, now it will deposit 5,000, now it will deposit
5,000, so the balance of my passbook will be 1,00,000-7,000
credit, ok sir, and there was one more cheque, there was
one more cheque, the cheque that I deposited was not
cleared, that cheque will also be n cash, that cheque will
also be n cash, so we will add 22,000 more in my passbook
bank, we will add 22,000 more, so it will
1,00,000-7,000 and 22,000 congratulations, 1,00,000-29,000,
1,00,000-29,000
will be completed, 1,00,000-29,000, 1,00,000-29,000, ok,
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, so
we found that these three entries are also coming in it,
these three entries are also coming in it, as soon as we
will see these three entries there, we will come back to
our teleprime, we will come back to our
after coming back to teleprime, whatever date these three
entries will be putting there in our passbook, whatever
date it will be, we will put that date here, but friends,
we are learning, so we are taking 1 april always, you have
to put that date in the bank date column here, that which
date is entering in our passbook, but we can use 1 april,
that's why we are taking 1 april everywhere, that's the
only difference, yes, entry is done there also, so we will
put the date here also, and you would
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 no item is
pending for reconciliation, crystal clear, both balances
stopped at 1.29, we and our passbook also, we and our
passbook also, we will save it by pressing a with control
and when we will 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
reconciliation, it is like this, ok, ok sir, now see
friends, think a little more practically, now I made a
scenario and gave it to you and got it done, now you must
be thinking that yes, in bank reconciliation finally
everything becomes empty as it is visible now, but friends,
do you know what happens, the next month's transaction
comes again, then some mismatches keep happening,
bank reconciliation always keeps going on, ok, so you take
a particular date that either we will do it once in two
months or once in three months or at the end of the year,
mix 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, who
make their statements for every three months and go to the
balance sheet P&L.
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 other things like you go to display
in display another option is coming cash flow click on this
press C cash flow press enter then you will see whole cash
flow you will see whole cash flow you will see whole cash
flow
see above bank reconciliation statement is opened what is
opened bank reconciliation statement is opened
you can see whole cash flow how 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,000 cheque 42,000 cheque and bank charges paid
250 so the money which came 209,250 209,250 209,250 and the
money which went how much is here 80,250 minus 80,250 how
much is this 1,29,000 net inflow see
net inflow how much is this 1,29,000 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 of inflow how much
how much came and total of outflow how much went and how
much net left so from here also you will get bank
reconciliation statement in this way you will get reflect
ok sir press SK and come out little and you know go to
account books and go to cash bank book and see so you will
get full detail total of inflow is getting
209,250 total of outflow is getting reflect 80,250 and
enter so here you will get entries here you will get
entries received and payment received and payment all
entries if you want to make any changes any error you can
go inside and correct and then in your BRS you can adjust
and correct BRS if there is any mistake in entries ok sir
no problem here ok ok ok ok ok ok if we want to print out
this for example like in our bank reconciliation so we have
to print out for example so come to banking
come to
B for bank reconciliation when 2-3 items are left we want
to print them for example so you don't have to do anything
in top horizontal bar you can see print yes sir press P
with your mouse and right left so I am right left left now
I have to come outside so I have to print them out ok so I
have to understand the whole concept what is the reason?
the reason is that they understood one by one theoretically
we practiced those reasons with one or two questions to
make the whole bank reconciliation
with humility and one with this one with humility and one
with this when we learned to make BRS with these questions
and learned to find out that these are the 6 reasons for
differences and there are no other reasons then we went to
teleprime we drafted the whole situation 1, 12, 0, 50 how
to reach there in cash book and I showed you the pass book
how to reach there in 1.5 lakh then the shortcomings that
were there in cash book we solved them, explained to the
bank waited for some time and then
shortcomings were solved and both stopped now what will be
the next process? we will follow question number 2 in the
same scenario same to same
I will show you the pass book of question number 2 in
question number 2 how to reach the balance of cash book
I will show you and because there is a negative balance of
cash book it is necessary to do this for once, if there is
a negative balance in your cash book it will be necessary
to do that it will be necessary to tell you that how you
will reconcile the bank in that case ok we will draft this
in teleprime and then we will remove all the items from our
side and then we will go in teleprime ok sir, no problem we
will be ready for that but it will not be in this clip it
will be in the next clip now
the next clip, if you want to get ready and there were some
great people who were sitting here very relaxed and those
who are continuously watching the class class on class
class on class, date on date did not get justice those who
are continuously watching the class friend, this is wrong
this is bad if you are thinking about a topic like BRS that
we are listening and watching and how the other person is
doing this is going in our mind then you are doing a
mistake you are letting some
dominate you, you are coming in an overconfidence
I am telling you you will not be successful in this BRS in
this concept whether you will be successful in life or not
I am telling you you will not be successful in BRS if you
are doing this you have to do revision and sit whenever you
see the next clip this question this solution practice it
twice otherwise otherwise things will get heavier you know
the practical scenario watching class on class is not our
objective after watching the class understand it completely
do revision and become capable that you can explain this to
someone if you are thinking that I understood can you
explain this to someone else if
understood then you should be able to explain this to
someone else if you are not able to explain then you are
done whenever you call a small kid and ask him to sit
I will explain even if he doesn't sit force him to sit and
start talking if you are not able to explain then you are
done then you are done and then watch the next class ok
friends we will end with this note we will meet in the next
lecture thank you stay healthy and enjoy the festival Thank
you, bye bye and take care.