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 bank
Means cheques deposited in the bank
How much?
Cheques amounting to Rs.
Deposited in the bank
As soon as we deposit cheques amounting to Rs.
In the bank
We will add Rs.
11,00,500 in our cash book
Yes We will add Rs.
11,00,500 in our cash book
Out of which only cheques amounting to Rs.
Only cheques amounting to Rs.
Have been credited
Collected by bank means
Cheques amounting to Rs.
Third point
A dividend amounting to Rs.
And rent amounting to Rs.
Received by the bank
Bank received a dividend amounting to Rs.
And rent amounting to Rs.
And entered in the passbook
But not recorded in the cash book
Cheques amounting to Rs.
Has been entered in the passbook
Cheques amounting to Rs.
Received a dividend amounting to Rs.
And rent amounting to Rs.
And entered in the passbook
But not recorded in the cash book
Insurance premium paid by the bank
Rs. 27,000 not entered in the cash book
Insurance premium
Bank has paid
Rs. 27,000
But not recorded in the cash book
The payment side of the cash book
Had been under casted by Rs.
I will tell you later
Bank charges
Rs. 1,500 in the passbook
But not in the cash book
When will we get to know all these things?
All these things
Are made from which steps?
This situation is made from which steps?
This situation
Is made from here
From here
When these two things
Are done
When the first two steps are done
When we match on the third step
The entries of the cash book and the passbook
Then it is made from here
After matching the cash book and the passbook
What we got to know
Yes After the third step
After this
Bill payable of Rs.
Had been paid by the bank
But was not entered in the cash book
Bill payable of Rs.
Bank has paid
Rs. 2,00,000 from our account
Not entered in the cash book
And a bill receivable of Rs.
Discounted from the bank
At the cost of Rs.
Means we got Rs.
And till now
Bank has put it in our account
Had not been recorded in the cash book
We have not made any entry in the cash book
Of Rs.
These are the points we have
How much was the bank balance coming?
Rs. 44,50,000
How did it reach to Rs.
In the beginning, there will be some balance
Then the first point
They must have issued a cheque of Rs.
To the creditor
Then Cheque of Rs.
Must have been added to the bank
Rs. 11,05,000
Entry of Rs.
6,40,000 in the passbook
Has not been made in the cash book
Entry of insurance payment in the passbook
Has not been made in the cash book
Payment side of cash book
Had been under cast by Rs.
Bank charges Rs.
Has not been entered in the cash book
And on Rs.
Has not been entered in the cash book
Now let's come to the fifth point
Payment side of cash book
Had been under cast by Rs.
But now you can do this
That Rs.
20,000 has been deducted from here
Sir, in the fifth step, the amount is Rs.
How are you writing Rs.
On my request, deduct Rs.
Then Rs.
44,50,000 is coming
Then Rs.
44,50,000 is coming
Rs. 44,50,000
What will be my initial balance?
Come on Calc
Write Rs.
Add Rs.
This will be the initial balance
In that Rs.
6,00,000 minus Rs.
And Rs.
20,000 minus
Rs. 44,50,000
How did our question come to know?
How did our question come to know that there is Rs.
44,50,000 in the bank?
Some entries have already been made in the cash book
Let's go to teleprime
Let's open the company which has already worked in the name
of Mr.
Yes
We have opened it
Now let's open the default day book
And see
Rs. 6,00,000 payment has been made
Rs. 20,000 payment has been made
And Rs.
11,05,000 plus has been made
And Rs.
39,65,000 is my opening balance
This has been invested in the business as a capital
After this work, the bank balance in my balance sheet is Rs.
This much work has been done in the cash book
My dear friends
Okay So the question
All these things
The question comes to know after matching the cash book and
the passbook comes to know after matching the cash book and
the passbook
Let's open the cash book
Statement for the month
Mr. Gopi's account number
Branch Faridabad
Rs. 39,65,000
Rs. 5,50,000 cheque and cash entry
Rs. 5,50,000
Rs. 6,40,000
Rs. 27,000
Rs. 25,000
What are our steps? Let's come to 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 cashbook.
Download passbook.
These two things have been done.
Some entries have already been made in the cashbook and we
have downloaded the passbook.
After that, we have to do matching.
Match entries in cashbook and passbook and look for the
entries pending to be passed in the cashbook.
Match entries in cashbook and passbook.
These give rise to your question.
The question I have written is written from here.
You will get the question from here.
You will get the situation when you do the job practically.
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 there is an entry in the cashbook and passbook,
our question is drafted.
Let's match the cashbook and passbook.
Let's see how these questions are made.
Let's see how these questions and situations are made.
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 by doing it.
Yes sir, we will get the first step by doing it.
Some entries would have already been passed in the cashbook.
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.
Let me reflect the cashbook 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 39,65,000 is here it
cut after that we can see 6,00,000 credit in cash book but
not in passbook don't cut this 11,05,000 debit is in cash
book but not in passbook don't cut this 20,000 credit is in
cash book but not in passbook don't cut this and all the
rest of the items 5,50,000 is in passbook but not in cash
book don't cut this don't cut, there are 46,000 in passbook
but not in cash there are 27,000 but not in cash 25,000 is
in passbook but not in cash there are 1,500 but not in
passbook 2,00,000 and 69,000 is
passbook but not in cash don't cut them
means now question will be made now question will be made
first of all question says
this line is written by the question that this 6,00,000
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 it has to be marked as red.
Mark it as red.
These 5000 are here.
1500 rupees.
It is not there.
Mark it as red.
20,000 rupees.
It is not there.
Mark it as red.
Cheque discounted 59.
It is not there.
Mark it as red.
It is not there.
Mark it as red.
By pressing control and s, save.
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 in passbook
cheque of 6,00,000 has been cleared so we will withdraw
6,00,000 after this cheque will be N- Cash cheque will be
N- Cash cheque will be N- Cash then it will be credits
deposits means credits 555.
So pick up the calculator 4960500 minus 600000 plus 555000
4915500 4915500 credit
When this entry is reflected here, then what is the next
step? The next step is to come back and update these items
in your cash book.
So we will come to teleprime and in reconciliation also.
NB ICICI bank, this is also clear.
The date on which 555 entry is coming in the passbook, put
that date here and 600000 1 april 22.
This is done, ctrl a save and you would find you would find
that how much is your bank balance? Here it is 4915500 and
how much balance was coming in your passbook? 4915500.
See this, I will show you how much balance was coming in
your passbook? 4915500.
See this, my dear friends, 491500 means you can say that
both the books have reached their final balance.
Both the books are there on their final balance.
4915500. Now listen, friends, do you know what will happen
practically? Practically, it may happen that both your
books are matching on the same balance.
transactions are going on every month.
So do you know what is the solution to this? The solution
to this is that you are making a BRS up to a particular
date.
You are making a
BRS up to a particular date. So the balance will be clear
up to that particular date.
The balance will be clear up to that particular date.
That means that if you are making a BRS up to 31st
December, then the BRS up to 31st December will be
completely clear.
After that, your bank balance and passbook balance may
start mismatching again.
Because different transactions will be coming again.
But the BRS you will make on a particular date, the balance
up to that date should be clear in both the places.
After picking up the passbook, all the entries up to 31st
December should be clear.
And all the balance should be equal up to 31st December in
the cash book.
Then you will move on to the next reconciliation.
After that, you move on to the next reconciliation.
Okay sir, let's go.
So friends, it is very important to write steps.
It is very important to write steps.
Okay sir.
And it is very important to revise them.
It is my habit.
I say it at the end of every class and I will keep saying
it further.
I devote the last minute to explaining to you.
Because I know that buying a course is on one side and then
seeing the course with interest is on the other side.
Not all children have the skill to buy it and then see it
properly.
That is why I am explaining to you again and again that
revision is as important as you can think.
We have discussed the topic of BRS in great detail.
The whole concept, then every single thing is practical.
Every single point is practical.
How will the situation be made? What kind of situation?
These questions are not questions.
These are situations that you will get practically while
working in the office.
You must have understood this.
In the beginning, you must be thinking, sir, why do they
ask questions?
We don't have to give any paper.
It is not a question, it is a situation.
You will get what you have made.
Before starting the time of reconciliation, we will listen
to you, we will do the revision.
Thank you very much.
We will meet in the next lecture.
Till then thank you.
Bye-bye and take care.