Hello friends
In this series
The next question comes to us
Question number 8
Which is flashed on your computer screen
Someone named Gopi
You have to work on his question
According to the cash book of Gopi
There was a balance of
Rs. 44,50,000 in his bank
On 30th of June 2019
On investigation
You find that
You got to know on investigation
Debit balance of Rs.
Cheques amounting to Rs.
Issued to creditor have not been
Presented for payment till date
Cheques amounting to Rs.
Issued to creditor have not been
Presented till date
Cheques amounting to Rs.
Only collected by the bank
Cheques paid into the bank
How much?
Rs. 11,05,000
Cheques deposited in the bank
As soon as we deposit cheques of Rs.
11,05,000 in the bank
We will add it in our cash book
Rs. 11,05,000
We will add Rs.
Out of which only cheques have been added to the passbook
Collected by bank means they have been added to the
passbook only Rs.
Third point
A dividend of Rs.
40,000 and a rent of Rs.
6,00,000 received by the bank
The bank received a dividend of Rs.
40,000 and a rent of Rs.
The bank received a total of Rs.
6,40,000 and entered in the passbook but not recorded in
the cashbook
Rs. 6,40,000 has been entered in the passbook
We have purchased a share of a company and a dividend of Rs.
40,000 and a rent of Rs.
Rs. 6,40,000 has been added to the passbook but not
recorded in the cashbook
Insurance premium paid by the bank
Rs. 27,000 not entered in the cashbook
Insurance premium paid by the bank
Rs. 27,000 not entered in the cashbook
The payment side of the cashbook had been under-casted by
Rs.
The payment side of the cashbook had been under-casted by
Rs.
I will tell you how this is
Bank charges Rs.
1,500 can be seen in the passbook but not in the cashbook
You tell me, when will we get to know all these things?
All these things that are written
From which step are these questions raised?
From which step is this situation raised?
This situation, my dear friends is raised from here
straight from here
When these two things are done
When the first two steps are done
When we match the entries of the cashbook and passbook on
the third step
When we match the entries of the cashbook and passbook on
the third step
Then this question is raised
What we got to know after matching the cashbook and passbook
After the third step
Yes sir
After this
Bill payable of Rs.
2,00,000 had been paid by the bank but was not entered in
the cashbook
The bank paid the bill payable of Rs.
Not entered in the cashbook
And a bill receivable of Rs.
We got it discounted from the bank at the cost of Rs.
Means we got Rs.
And we have put it in our account
Had not been recorded in the cashbook
We have not entered any entry of Rs.
59,000 in the cashbook
We have not entered any entry of Rs.
59,000 in the cashbook
So these are the points we have
How much bank balance was coming?
Rs. 44,50,000
How would it have reached Rs.
Balance will be L
Then the first point
He would have issued a cheque of Rs.
Then Cheque of Rs.
He would have added Rs.
Yes Sir
Entry of Rs.
6,40,000 in the cashbook
Not entered in the cashbook
Entry of insurance payment not entered in the cashbook
Payment side of cashbook
Not entered in the cashbook
Bank charges Rs.
Not entered in the cashbook in the cash book.
Okay, it is not yet entered in the cash book.
And it is not yet entered in the cash book on Rs. 2,59,000.
Now let's come to the fifth point.
Payment side of cash book had been under casted by Rs. 5000.
I will explain later.
But now on my request, just do this that Rs.
20,000 has been deducted from here.
Sir, in the fifth step, the amount is Rs. 5000.
How are you writing Rs.
On my request, just deduct Rs. 20,000.
Only then Rs. 44,50,000 is coming.
Only then Rs. 44,50,000 is coming, my dear friends.
Rs. 44,50,000.
So what will be my x, i.e., initial balance?
Come to Calci, write Rs. 44,50,000.
Come here and add Rs. 6,00,000.
Rs. 6,00,000.
Come here and deduct Rs. 11,05,000.
Rs. 11,05,000.
And come here and add Rs. 20,000.
Rs. 39,65,000.
Rs. 49,65,000.
Rs. 39,65,000.
This will be the initial balance.
In that, Rs. 6,00,000 minus Rs. 11,05,000 plus and Rs.
20,000 minus.
So we have reached Rs. 44,50,000.
How did our question come to know this?
How did our question come to know that there is Rs.
44,50,000 in the bank?
He checked the cash book.
Some entries have already been made in the cash book.
Come, let's go to Teleprime.
And let's open the company that has already worked in the
name of Mr. Gopi.
Yes, we have opened it.
Now, let's open the D4 Daybook.
And see, there is an entry of Rs. 6,00,000 payment.
There is an entry of Rs. 20,000 payment.
And there is an entry of Rs. 11,05,000 plus.
And my opening balance is Rs. 39,65,000, which has been
invested as capital in the business.
And my opening balance is Rs. 39,65,000, which has been
invested as capital in the business.
After this work, my bank balance in the balance sheet is
Rs. 44,50,000.
So much work has been done in the cash book.
So much work has been done in the cash book, my dear
friends.
Okay, sir.
So, all these things are known to the question after
matching the cash book and the passbook.
It is known after matching the cash book and the passbook.
Now, I open the passbook.
Now, I open the passbook in front of you, my dear friends.
Here it is.
Statement for the month.
Mr. Gopi account number.
Branch, Faridabad.
So, the Rs. 39,65,000 which was invested in the beginning,
it was there and it is here too.
Rs. 39,65,000.
After that, there is an entry of Rs. 5,50,000 cheque in
cash.
It was not there in the cash book.
Rs. 5,50,000.
It was not there in the cash book.
Okay, let's see.
Rs. 6,40,000.
Dividend and rent.
It was there and it was not there.
Rs. 27,000.
Insurance premium.
It was there and it was not there.
Cheque cleared Rs. 25,000.
Bank charges Rs. 1,500.
Cheque cleared Rs. 2,00,000.
Cheque discounted Rs. 59,000.
We have seen this by downloading the passbook.
So, my dear friends.
Now, let's match them.
What are our steps?
Let's come to our steps.
Let me flash the steps in front of you once.
Some entries would have already been made in your cash book.
Download passbook.
These two things are done.
Some entries are already in the cash book and we have
downloaded the passbook.
After that, we have to match.
Match entries in cash book and passbook.
And look for the entries pending to be passed in the cash
book.
These words.
Match entries in cash book and passbook.
These words.
Match entries in cash book and passbook.
These give rise to your question.
The question I have written is written from here.
You will get the question practically from here.
You will get the situation practically when you do the job.
Some entries would have already been passed.
And you will download the passbook and sit.
You have to start the work from the third step.
That's why our questions are also made from the third step.
Our questions are also drafted from the third step.
As soon as entries are made in the cash book and passbook,
our question is drafted.
Now you see, we match the cash book and passbook.
And let's see how these questions are made.
How these questions and situations are made.
And where do we need this question practically?
You must be thinking for a long time.
Sir, where do we need this question?
You are making us understand this question.
How will we need these questions practically?
This is not a question, this is a situation.
Why are you thinking it as a question?
Think it as a situation.
This situation will come in front of you practically.
What you have to do is, you will get the first step.
Yes sir, we will get the first step.
Some entries would have already been passed in the cash
book.
Absolutely right.
You will download the passbook and sit for the second step.
Now on the third step, you have to match.
Let's take you on matching.
Take this.
Let's make a question from here.
I will reflect the cash book in front of you.
you will get a cash book and you will get a downloaded
passbook or which you will download by yourself or maybe
you haven't made a cash book yet, so what's the problem now
here you will open the cash book and you will see the
entries in it and write it on a paper it will be a little
easier to understand, so write it on a paper
39,65,000 debit 6,00,000 credit
11,05,000 debit and 20,000 credit ok, so these were the
entries in my cash book this was the first step, the
entries in the cash book second step
I downloaded my passbook and some amounts are reflecting in
it 39,65,000 credit 5,50,000 credit 6,40,000 credit 27,000
debit 25,000 debit 1500 debit and 2,00,000 debit and 59,000
credit 59,000 credit write all these ok sir, we have
written all ok now do match the cash book and passbook now
put these words put these words my dear friends
some entries already passed download passbook now these
words will be applied match entries in cash book and
passbook means a question will be made now a question will
be made how will the question be made? let me show you now
we are going to match the cash book and passbook so this
question will be made which is flashed on your computer
screen we started matching yes we saw 39,65,000 it is here
and here cut it cut both the places cut both the places
39,65,000 is here and here it is cut here
we can see 6,00,000 credit in cash book but not in passbook
don't cut this 11,05,000 debit in cash book but not in
passbook don't cut this 20,000 credit in cash book but not
in passbook don't cut this and all other items 5,50,000 in
passbook but not in cash book don't cut this 46,000 is in
passbook not in cashbook 27,000 is in passbook not in
cashbook 25,000 is in passbook not in cashbook 1500 is in
passbook not in cashbook 22,000, 69,000 are in passbook not
in cashbook don't cut this now the
will be made now the question will be made first point the
question is check amounting to 6,00,000 issued to creditor
have not been presented for payment till date the line
which the question wrote that this 6,00,000 this 6,00,000
is 6,00,000 in cash book
This is not in the passbook.
Why? Because the cheque is not present now.
We found out.
We found out that 6 lakhs are coming in the cashbook.
But why is the entry not coming in the passbook?
So we called the creditor.
The creditor said that I have not taken the cheque to the
bank yet.
That's why this became a reason.
And your question wrote and presented here.
That this is the situation, brother.
The cheque of 6 lakhs has been issued.
But it will not be present.
Okay.
After that, cheques of 11.5 lakhs have been deposited in
the cashbook.
You have added while depositing.
You said in the bank that why is the entry not happening in
the passbook?
You went to the bank to find out.
So the bank said that out of the cheques of 11.5 lakhs,
cheques of 5.5 lakhs have been cleared.
The rest have not been cleared.
It will take some time for the rest.
You went to the bank.
So the bank told you this.
So the 5.5 lakhs credit that you see in the passbook, out
of the cheques of 11.5 lakhs, 5.5 lakhs have been cleared.
The rest are left.
Oh, the rest are left.
So this question wrote the second line here.
Cheque paid into bank amounting to 11.5 lakhs, out of which
cheque amounting to 5.5 lakhs only collected by the bank.
Oh, okay.
Then we came to the next point.
We said that the credit payment of 20,000 is visible in the
cashbook.
The payment of 20,000 is visible in the cashbook.
Look at your tally.
The payment of 20,000 is visible in the cashbook.
But it is not there anywhere in the passbook.
It is not there anywhere in the passbook.
So we got the news from the bank that the 25,000 rupees
that are being debited in the passbook, this is the cheque
for which you have entered 20,000 in the cashbook.
The cheque for which you have entered 20,000 in the
cashbook was actually a cheque of 25,000.
Correct your mistake.
This became your point number 5.
Payment side of the cashbook had been undercasted by 5,000.
You have put 5,000 rupees less in the payment voucher in
the cashbook.
We came to know this.
Oh, oh, oh.
So this became the next point.
Yes.
After that, 5.5 lakhs of credit in the passbook.
This has happened.
6.4 lakhs of credit is coming in the passbook.
We got to know from the bank what was in the passbook.
This 6.4 lakhs is not coming in our cashbook.
The bank said that this is a dividend and rent.
So the question wrote this third point that the dividend
and rent of 6.4 lakhs has been entered in the passbook.
It is not in the cashbook.
Then we got to know about the 27,000 rupees that are being
debited in the passbook.
So they said that the insurance premium is being paid which
is not being entered in the cashbook.
The question wrote the fourth point.
The bank paid the insurance premium of 27,000 rupees.
There is no entry in the cashbook.
After that, 1500 rupees debit.
1500 rupees debit is coming in the passbook.
We said that it is not in the cashbook.
The bank said that the bank charges are there.
This is written in the statement.
Do not ask the bank every time.
It will be written in the statement that the bank charges
are 1500 rupees.
You will understand by looking at it.
This is 1500 rupees bank charges.
The question wrote the 6th situation.
That 1500 rupees are not there.
And similarly, your 7th point.
2,69,000 rupees.
They are visible in the passbook but not here.
In this way, the points that come out of the match between
the passbook and the cashbook are presented here as a
question.
Now you have to go to the next step.
Sir, now we have learned everything.
We have also learned how to make a question.
We have also learned from which situation the question
comes.
And you have to make the question situation practically.
What you have written on the pen and paper, on the diary,
what have you done?
You have made a question.
So what do you have to do practically?
You must have got teleprime there.
Yes.
You have to download the passbook from there.
After matching, you have to make this first.
Then you have to take the next step.
And making this means you have to make a question.
This is a question.
This is a situation.
Question means situation.
Okay, sir.
What does our next step say?
The next step says, look for the entries pending to be
passed in the cashbook.
Just see.
What are the entries that are in the passbook but not in
the cashbook?
Just see.
You just have to see which entries are there.
So, which are in the passbook and not there.
So look at the passbook.
This is an entry of 5.5 lakh rupees.
Is it in the cashbook or not?
Now you will say no.
Is it in the cashbook?
This 5.5 is also hidden in 11.5 lakhs.
Is it in the cashbook?
This 5.5 is hidden in 11.5 lakhs.
This is an entry in the cashbook.
11.5 lakhs of cheque has been deposited.
They have added all of it.
In that, it was also of 5.5 lakhs.
This has been cleared from the bank.
There is nothing left.
That's why there is nothing left in the bank statement.
Okay.
6.40.
There is no 6.40.
So mark 6.40 as red.
Mark 6.40 as red.
Take this.
Mark 6.40 as red.
It is not there.
Next.
27,000 is also not there.
Mark it as red.
25,000 is here.
But there is 20,000.
So mark it as red 5000.
Mark it as red 5000.
5000 is here.
It is not there.
1500 rupees.
Here.
It is not there.
Mark it as red.
2 lakh rupees.
Here.
It is not there.
Mark it as red.
Cheque discounted 59.
Here.
It is not there.
Mark it as red.
Here.
It is not there.
Mark it as red.
Save it by pressing the control S key.
save it by pressing ctrl s ok so what is our next step what
is our next step pass the entry selected in step 3 to fully
update your cash book leave only that thing which is wrong
in bank was there any mistake in bank this time there is no
mistake in passbook this time there is no mistake in
passbook this time ok sir ok ok ok so we have to pass those
entries which are here and not there which are here and not
there we have to pass those entries come let's do it
quickly pass those entries in teleprime
first of all 640 dividend and rent pass it together come in
v for voucher select received voucher select credit
dividend and rent dividend and rent under indirect income
under indirect income 640,000 640,000 debit bank 640,000
save it by pressing ctrl a ok and black mark it there
I will do it
I will not flash it in front of you
I will do black mark then 27000 insurance premium select
payment voucher F5 select debit insurance premium select
debit insurance premium insurance premium under indirect
expenses ctrl a amount 27000 select credit
ICICI bank ctrl a and black mark it there after that there
is entry of 5000
so increase 20 and make it 25 come to tally, d4 display, d4
debug go to 20 voucher, dpka, make it 25 25, this was your
mistake ok, save this mistake by pressing ctrl A and black
mark it again after that enter bank charges of 1500 in
tally prime v4 voucher, payment voucher, alt c bank charges
under indirect expenses
credit ICICI bank, 1500 save it by pressing ctrl A, black
mark it there
2 lakhs cheque is cleared, you didn't enter from there so
you have to make a payment of 2 lakhs to dpka make a
payment of 2 lakhs to dpka
bill payable is cleared, in payment voucher create debit,
bills payable, what is bill payable entry? bill payable to
bank, bill payable will come under current liability ctrl
A, 2 lakhs
bank credit will be done, ICICI bank, 2 lakhs ctrl A, after
that go there and black mark it and those who are receiving
59,000 rupees those who are receiving 59,000 rupees also
enter them in the received voucher credit, bills
receivable, bill discounted so credit bill receivable, bill
receivable credit credit bill receivable, total 60,000
debit, how much are you getting in ICICI bank? only 59,000,
I told you what is discounting cleared it today, it was a
cheque after some time, so bank gave
deducted 1000, that is your loss, that will be debit in
what name, discounting charges, under indirect expenses
ctrl A, 1000 in this way, by pressing ctrl A, we passed all
the entries here we passed all the entries here which was
in the passbook, it was not here we black marked 59,000 in
the passbook now we have to do the next step our very next
step go for bank reconciliation and reconcile the entries
which are present both in cashbook and passbook, let's do
this let's come to teleprime n for
b for bank reconciliation let's open ICICI bank
49,65, it is here and there put the date and clear it,
6,00,000 6,00,000 it is not there it is not 6,00,000
11,00,000, 5,000 it is not there 5,50,000 is there but it
is not there now how will we do this you did not have to
put the entire entry of 11,00,000, 5,000 if the cheques
were different then you should have put different entries
so never make this mistake 5,55,000 cheque will be made and
5,50,000 will be made how to improve delete 11,00,000,
5,000 and add 2 new vouchers 5,55,000 and
press ALT A and credit Ranveer and write 5,55,000 and again
ALT A and credit Ranveer 5,50,000 press CTRL A now it is 2
pieces of 11,00,000, 5,000 now go to bank reconciliation we
made a mistake never do teleprime 2 cheques are different
so write 2 cheques and remember 6,00,000 it is not there
25,000 is there and here 26,000 is there and here 27,000 is
there and here 2,00,000 is there and here 59,000 is there
and here save this and open again now come on to the next
step
what is next step
only those items will be pending for reconciliation which
are pending on bank's behalf and errors in cash book only
those items are pending on bank's behalf so we will send
this sheet to bank we will send this sheet to bank we will
send this sheet to bank we will send this sheet to bank
according to us only those items are pending on bank's
behalf we will send this sheet to bank bank will say
5,50,000 cheque has been deposited and 6,00,000 cheque has
been issued bank will say there is no error
we have to wait for some time these entries will be
reflected in passbook these entries will be reflected in
passbook and then we will do reconciliation so let's come
to passbook
in passbook cheque of 6,00,000 has been cleared so we will
get 6,00,000 in withdraw so we will get 6,00,000 in
withdraw so we will get 6,00,000 in withdraw and then
cheque will be encashed cheque will be encashed 5,55,000
5,55,000 5,55,000 5,55,000 take calculator 4960500 minus
6,00,000 plus 555,000 49,15,500 credit save 49,15,500 credit
when entry will be reflected then next step update these
items in your cash book in cash book update this numbers
time put the date 6,00,000 this is control A save and you
would find how much is your bank balance 49,15,500 and how
much balance was coming in your passbook 49,15,500 let me
show you how much balance was coming in your passbook
49,15,500 see this my dear friends 49,15,500 means you can
say both the books have reached their final balance both
the books are there on their final
49,15,500 now listen friends do you know what will happen
practically? practically it may happen that both your books
are matching on the same balance
because transactions are going on every month so do you
know the solution for this? the solution for this is you
are making a BRS of a particular date you are making a BRS
of a particular date so the balance of that particular date
will be clear so the balance of that particular date will
be clear means means if you are making a BRS of 31st
December so the BRS of 31st December will be clear after
that your bank balance and passbook balance may start to
mismatch again because again different
will come but on the particular date on which you will make
a BRS the balance of both the places should be clear
after picking up the passbook the BRS of 31st December
should be clear and the balance of cash book should be
equal till 31st December then you will move to the next
reconciliation after that you will move to the next
reconciliation ok sir so friends it is very important to
write the steps it is very important to write the steps ok
sir and it is very important to revise them it is my habit
I say this at the end of every class and I will keep saying
this one last minute
I devote myself to explaining you
because I know that to buy a course is one side and to see
the course with dedication is the other side not all
students have the talent that even if they buy it they are
seeing it in a good way that's why I am explaining you
again and again that revision is as important as you can
think the topic of BRS we have explained in detail the
whole concept then every single thing is practical every
single point is practical how the situation will be what
kind of situation these questions are not
these are situations which you will get practically while
working in the office you must have understood this in the
beginning you must be thinking sir, why do you ask these
questions we don't have to give any paper it is not a
question it is a situation it is a situation which you will
get before starting the time for reconciliation ok sir, we
will listen to you we will revise it for sure
I said ok if this is the case then thank you very much we
will meet in the coming lectures till then thank you bye
Bye-bye and take care.