Hello friends, as promised in the last class, we have come
to the next clip about the next question and it has a
negative cash balance and as I explained to you at the end
of the last class, I will also hope that you have reviewed
it completely and are sitting with us.
Let's start reading this question, we are going to do its
entire post mortem today.
From the following particulars, ascertain the balance that
would appear in the bank passbook of A on 31st December
2019.
Its entry has been done in the passbook, it has not been
done in the cashbook.
The bank has deducted bank charges of ₹ 400.
Its entry has been done in the passbook, it has not been
done in the cashbook.
If you have issued a cheque, then you have immediately
deducted ₹ 11,68,000 from the cashbook, but not cleared.
Cashed means it has not been cleared, so there will be no
entry in the passbook.
Cheques paid into the bank but not cleared before 31st
December 2019 were for ₹ 22,17,000.
We have deposited the cheque, what do we do as soon as we
deposit the cheque?
Paid into the bank means deposit.
What do we do as soon as we deposit?
Sir, we add it to the cashbook.
So we added ₹ 22,17,000 to the cashbook.
But it is not clear in the passbook, so there will be no
entry.
Interest on investment collected by the bank and credited
in the passbook is ₹ 12,00,000.
Interest on investment is ₹ 12,00,000 and it is credited in
the passbook.
There will be an entry in the passbook, but there is no
entry in the cashbook.
First, I will tell you the negative balance of 6340.
What will be the process of our question?
First, we will see how the negative balance of 6340 came in
our cashbook.
Why did this happen?
Because there is a negative balance of 6340 in our cashbook.
After that, the reason for the difference in the balance of
the cashbook and the passbook is 1,2,3,4,5 Then what we
will do?
We will analyze these 5 reasons.
What does it mean to analyze?
We will check which reasons we can correct in our cashbook.
Then we will adjust them in our cashbook and correct them
quickly.
Then whatever pending reasons are left, we will take out
the reconciliation of pending reasons and will tell the
bank that it is pending on your behalf.
Now you can enter it here.
And then we will know how much balance is coming in the
passbook.
Come on, let's start.
Come to teleprime and you have to create a company in the
name of Mr. A.
Come quickly.
Alt F3 is pressed.
Yes, we will come to create company.
Create company.
Put Mr. A in the name.
Put the address as soon as possible.
And I am saying that you are doing bank reconciliation.
Select the state and finish it.
Control A.
There is no need to enable GST.
We will do it quickly.
Now what happened in this, friend?
What happened in this?
In the beginning, overdraft balance was running from the
bank.
So create ledger.
Create ledger.
Put ICICI bank in the name.
Yes, sir.
Put ICICI bank in the name.
This bank account will come under.
Put all these fake details, whatever you want to put.
Okay, sir.
One minute, one minute, one minute.
I have saved it.
I have to go to the alter.
You stay there.
And put the opening balance below.
It is like this.
This business has been going on for many years.
And they have never done bank reconciliation.
Now suddenly you have joined.
And they want to do bank reconciliation.
Will we get such cases practically?
Absolutely.
There is no argument.
There is nothing to say or think.
Absolutely.
So when we are doing bank reconciliation for the first time.
So, friend, their balance from the last few years.
They must have entered the bank.
Will everyone come doing it?
No, sir.
So what do we have to do?
Pick up the balance from the beginning of this year.
And only do the reconciliation of this year.
Or if they start in a particular month.
Then pick up the opening balance of this month.
And start from there.
Yes, sir.
So you will put its opening balance.
1055340
1055340 Sir, where will we get this practically?
Now you are telling.
Where will we get practically?
Practically, you pick it up from the bank.
If you have not done accounting yet.
There is no problem.
Then whatever balance is coming in the bank passbook.
You will have to pick it up and start here.
Okay, sir.
Bank passbook.
You have not given your question.
You will get practically.
You have not given the question.
Practically, it is not possible.
Get the bank entry.
Login.
Download.
Okay, okay.
Negative balance.
Negative.
Negative balance.
CR credit.
Negative balance.
Oh, oh, oh.
Negative balance.
1055340 Credit.
In the bank account.
Negative balance means credit.
Say yes and save it.
Saved, sir.
Now come back to your notes.
Here it is.
First point.
Interest on overdraft for 6 months.
Ending 31st December 2019.
160 is entered in passbook.
6 months interest has been entered in the passbook.
Not in the cashbook.
Okay.
There is no problem.
I have to reach 6340 now.
Now don't tell me.
Sir, it has not happened in the passbook.
So do it in your cashbook.
You are late.
You should do this entry in your cashbook.
No, no, no.
Don't give me that knowledge now.
I have to reach 6340 now.
So how will I reach 6340?
I will reach 6340 in this way.
The work that I have done in my cashbook so far.
I will enter them in teleprime.
If I enter them in teleprime.
So we will reach 6340.
After that.
The work that will be left.
We will do them.
It will be the process of reconciliation.
Okay.
Now I have to reach 6340.
Leave what is left in the cashbook.
Because 6340 means.
It is not a matched balance.
Something is left in it.
If you don't leave anything.
If you do all the entries.
Then what will be the reconciliation later?
Okay sir.
Third point.
The bank has deducted 400 rupees.
Entry is happening in the passbook.
You don't have to do it in the cashbook now.
You don't have to do it now.
Because I have to reach 6340 now.
I have issued a cheque.
How much is it? 1168.
So as soon as the cheque is issued.
We enter in our cashbook.
Yes.
So enter 1168000.
Come quickly.
Enter 1168000.
Come quickly.
V for voucher.
And issuing means.
Payment means.
The payment will come in the voucher.
To our creditor Deepika.
The name is the same.
Deepika.
Under sundry creditor.
The payment will be done to the creditor.
Deepika under sundry creditor.
How much is the payment? 1168000.
1168000.
Payment of 1168000.
Credit will be done to ICICI bank.
Press ctrl A.
Okay sir.
Press ctrl A.
After that come.
Here it is.
Cheques paid into bank.
Cheque deposited.
22,17,000.
So as soon as the deposit is made.
We enter in the cashbook.
Yes.
So as soon as the deposit is made.
Enter in the cashbook.
Will it be of the next point?
No, no, no.
That has been entered by the bank.
We have not done it yet.
Interest on investment of 12 lakhs.
We will do it at the time of reconciliation.
Now to reach 6340 means that.
Out of these 5 points.
Whatever work has been done in the cashbook.
You enter them in your teleprime.
That is why the balance of 6340 must be coming.
In teleprime.
Otherwise, how would it be coming?
The entries that have been done.
Do it.
Those that remain.
Do not do it now.
Okay sir.
So let's do a receipt.
F6.
22,17,000.
Our credit is 22,17,000.
The balance is 22,17,000.
I have put similar values in it.
Then it will come.
So let's do a receipt.
F6.
22,17,000.
Our credit.
Debtor Ranveer.
Debtor Ranveer will always be.
Control A.
22,17,000.
Debit ICICI control A.
Now press SK and reach the balance sheet.
Come out.
Do F1 and open.
Look at this.
The balance of the bank should come here.
It is coming here on the left side.
6340 meaning.
What will happen?
How will it happen?
It has been received.
Welcome.
Bank balance is 6340
What does it mean?
It means negative balance is coming
And this is what we had to get
Negative 6340
Now listen to me
Now come to the writing pad
Now listen to me again on the writing pad
See this friends
We had opening balance
How much?
Minus 1055340
Then we issued more cheques
Minus 1168000
Entered in our cash book in teleprime
This was the opening balance in teleprime 1055340 And
entered to issue this cheque
Then deposit some cheques
Enter their entry, plus 2217 in teleprime
So now we are standing in negative 6340
Means these 3 works are already done in our cash book
Opening balance 1168 and 2217
Means this point has entered in our cash book
And this point has entered in our cash book
After that these conditions are being made 6340
My dear friends, ok sir
And second point has entered in our cash book, no
Third point has entered in our cash book, no
Sixth point has entered in our cash book, no
Second, third and sixth point has not entered in our cash
book
My dear friends
But for now what will be the balance in my passbook
Let's find it first
For now there is a balance of minus 6340
For now, before doing reconciliation
What will be the balance in the passbook, how will it be
found
I will tell you what will be the balance in the passbook,
how will it be found
Come, I will show you the passbook
Your question did not show, but I will show you the passbook
Because practically it will be available for you
ICICI bank statement for the month of April
Account holder name Mr.
A, account number something
Now look at it very carefully, it is necessary to look at
it very carefully
How much is the opening balance 10,55,340 rupees debit, it
should look absolutely right
Because we are starting from here
What did we do, we started accounting
And before this, there was no entry in teleprime
So we took out the passbook printout and found 10,55,340
Debit balance, seeing this
We will put the opening balance in the teleprime bank
account 10,55,340 credit, which you had put a while ago
I said you will get it from the passbook, we have put the
passbook from here
If there is a debit balance here, then there will be a
credit balance there
You know this, there is a negative balance
After that, now friends come to your question
And think that the bank people
Which entry would have been put
Which entry would have been put by the bank people
The second entry has been put by the bank 4th and 5th, no
And 6th entry has been put by the bank 2nd, 3rd and 6th
entry has been put by the bank 160, 400 and 12,00,000
Now come back to the passbook 160 entry has been put by the
bank
400 entry has been put by the bank
And 12,00,000 entry has been put by the bank
The balance of the passbook is 144,100
The balance of the passbook is 144,100 144,100 Okay, okay,
okay
Means see very carefully
Now come back to the pad, you know that
There is a negative balance in your cashbook 6340
And the balance in your passbook
There is a credit or positive balance 14400
There is a positive balance in the passbook
Okay, see this
How these reasons for difference are made 2, 3, 4, 5, 6,
how these reasons for difference are made
Very carefully
They are doing such a deep analysis
I am saying that nothing will be left
The second point is how the reason for difference is made
Sir, its entry has been done in the passbook 3rd point, its
entry has been done in the passbook
Has not happened in the cashbook, this is the reason for
difference 4th and 5th points have been entered in the
cashbook
And has not happened in the passbook, this is the reason
for difference
And the entry of interest on investment has been done in
the passbook
Has not happened in the cashbook, this is the reason for
difference
That's why there are five reasons
Because of which the difference is coming
So we have seen in the present condition
If we do this entry, we will reach 6, 3, 4, 0
And if we do the entries in the passbook, we will reach
144, 100
Now there is no right balance in this, remember
Neither the negative balance of 6, 3, 4, 0 is final in the
cashbook
This is also not final or correct balance
Because there are shortcomings in the cashbook
Which shortcomings are there in the cashbook?
These points, 2nd, 3rd and 6th are not included in the
cashbook
And neither the balance in the passbook of 144, 100 is final
This is also not final, why?
Because this entry in the passbook is 4th and 5th 4th and
5th
That's why no balance is practical
No balance is final
What did I show you?
I showed you how this situation is prepared
I showed you the situation in teleprime
I showed you how to reach the negative balance of 6, 3, 4,
0 in the cashbook
How did you reach?
You started with 10, 55, 340
And you put these entries in the cashbook 4th and 5th
So you reach here in the negative balance of 6, 3, 4, 0
Now 6, 3, 4, 0 is not final
Because some entries are left in it
Which ones? 2nd, 3rd and 6th
How did the balance of 144, 100 come in the passbook?
You started with 10, 55, 340
And you put 2nd, 3rd and 6th points in the passbook
You didn't put 4th and 5th points
You put 2nd, 3rd and 6th points
You didn't put 4th and 5th points
That's why your balance in the passbook is different
There is no final
Because it is less in the passbook
You didn't put 4th and 5th points in the passbook
So what will happen now?
Now friends, I presented this situation in teleprime
How did you reach 6, 3, 4, 0 in teleprime?
And I showed you the passbook
How did the passbook reach 144, 100?
Yes, I showed you the passbook
However, you will never have to make the passbook
You will always get the print of the passbook from the bank
Still, I am showing you
I am making you analyze
So we have made this situation
Now what do we have to do?
Sir, from these points
The pending things on behalf of the cashbook
Let's do their entry
By going to our cashbook
And then the points that will be left
Then the points that will be left
Which is pending on behalf of the bank, not on behalf of us
We will give it to the bank
And the bank will deal with it at its end
Yes sir
So come and tell me
Come and tell me friends
Which things are pending on behalf of us?
Sir, tell us a little practically
What do you have to do practically?
You don't have to do anything practically
Practically, get the printout of the passbook
Okay sir
And in the cashbook
This cashbook
If you are starting a new bank reconciliation
This is what you have to do in it
Pick up the opening balance from the passbook and see
And all the transactions that have happened
Ask the master
Whatever you have entered in the cashbook so far
He will do it
The pending thing from the passbook
Do it at the time of reconciliation
That's all
Nothing else
Let's go
Let's go ahead
Let's do it ahead
Now listen to me
Which things are pending?
Whose entry do we want to do in the cashbook?
Second, absolutely right
Third, absolutely right
And, and, and, sixth
Second, third and sixth
Interest 160, bank charges 400
And interest on investment 12 lakhs 160, 400 and 12 lakhs
Let's do their entry
My dear friends, come here
Come to teleprime
V for voucher
Let's do the entry first
Interest on overdraft
Take payment voucher F5
Debit, alt C and enter the account whose name is interest
on overdraft
This will become your indirect expense
That's why take it in indirect expenses
Control A and enter 160 rupees 160 rupees
Yes Credit ICICI bank 160 rupees
Very good
Enter the bank charges
Debit, alt C and enter the bank charges account under the
heading of indirect expenses
Control A 400
And credit ICICI bank 400
Very good
And, and, and, and
Interest on investment
You have to do this in the received voucher
Credit the reason for receiving the money which is interest
on investments under the heading of indirect income
Control A 12 lakhs 12 lakhs, 12 lakhs
Debit ICICI bank
Yes And control A and save
Control A and save
So what happened now
My cash book is complete
What happened
Some item was pending in my cash book
Now it is complete
Come again and listen again
Come again on the pad and listen again
I
I have seen transactions in the business
What all are there inside
The pending from that
I passed that entry on the basis of my cash book
So finally
Cash book
It has reached its final balance
Ask how
Because all the entries were put in the cash book
This was already put 4th and 5th 2nd, 3rd and 6th
We just put it
So my cash book has reached its final balance
Now see the balance in my cash book
That is final
The balance in my cash book is final
Absolutely correct
Absolutely perfect
All postings have been done
There is no pending reconciliation
Nothing is left
Check in B for balance sheet
If you want to check, then it is coming
There is a negative balance of 11,93,100 rupees
All entries are put
Sir, he is not eating the match from the passbook, he
should not even eat
Because this balance of the cash book is final
And the balance of the passbook was not final
So how will this final balance eat the match from the
non-final balance
All entries have been put in it, it is pending now
Some entries have not been put in the passbook yet
Absolutely right, some entries have not been put in the
passbook
Okay, okay, okay, okay, okay
Okay, now what you have to do
Come back to the pad
You have finalized the balance of your cash book
Yes sir, we have finalized the balance of our cash book
Now you know that all entries have been put in the cash book
All entries have been put in the cash book
Now this was number one
Now I will write the steps for you
I will write the steps after finishing this question
How do we proceed, what are our steps
Okay sir, now after this we have to do reconciliation
In our teleprime
After this we have to do reconciliation in teleprime
My dear friends, after this we have to do reconciliation in
teleprime
Come on
Teleprime Before this, take a look at the passbook
Take this, take this, take this
Which entries have been put in the passbook, just see this
160, 400 and 12 lakhs 160, 400 and 12 lakhs
Now come to reconciliation in teleprime
Banking before bank reconciliation
ICICI bank
Which entries are here
And have also been done in the passbook
Reconcile them
Reconciliation means mixing
That the entry is also here and there
Didn't I tell you the meaning of reconciliation
On one side there is a cash book and on the other side
there is a passbook
You mix it, you match it
Which entry is here and which entry is not here
Okay, so listen
Here the cash book is open in front of you
Cash book is open, it has an entry of 11,68,000
Go to the passbook and see if there is an entry of 11,68,000
Come to the passbook and see
Is there an entry of 11,68,000 in the passbook
There is no
Means this item is pending reconciliation
Now it will not be reconciled
Okay, leave it, move on to the next point
There is an entry of 22,17,000 in the cash book
Is there an entry of 22,17,000 in the passbook
There is no sir, this item is also pending reconciliation
We can't do anything about this
Why? We can do one thing in our cash book
These two things are pending on the basis of the bank
What should we do? 11,68,000 and 22,17,000
The bank has to do the entry, we don't have to do it
So what should we do in this?
Interest on overdraft 160 is here and there
Here and there
So take April 1, 2022
Here and there
Bank charges
Take April 1, 2022
Here and there
And this
Rs. 12,00,000
Here and there
So the date on which this entry is coming in the passbook
160, 400 and 12,00,000
Put that date here
After putting
You will enter
And you will find
Look below
The bank is written on the balance
Rs. 1,44,100
This is the balance
Which is the non-final balance of the passbook
This balance has come out
Non-final balance of the passbook
And what we will do
Now we will save it by taking control
And open it again
So you can see
Two things are pending in it 11,68,000 and 22,17,000
Which is in our cash book
Cash book is coming in front
It is in our cash book
But we have not put any bank date in it
Why? Because the entries are not present in the bank
We will inform the bank about this
That two entries are pending on your balance
Then what will happen?
What will happen at the next step?
At the next step
After some time
These entries will also be seen in the bank passbook
11,68,000 and 22,17,000
After some time
Come here
Now come in the passbook
After some time
Rs. 11,68,000 cheque
Which we have given to our creator
The bank will also withdraw money from it
Will withdraw from our account
Will give to our creator
The bank will withdraw from our account
How much?
Rs. 11,68,000
Okay sir
And then
The cheque which we have deposited
That cheque will be encashed by the bank
Money will also come in our account
In deposit
How much?
Rs. 22,17,000
In deposit
Rs. 22,17,000
So see
Pick up the calculator
How much will it be?
Rs. 1,44,100
Credit means positive balance
In passbook
Credit means positive
Don't put negative
Minus Rs.
Because withdraw
Means money will be deducted from the account
And plus
Rs. 22,17,000
Because deposit
Means money will be plus
And you would find
How much will come?
Oh my god
This also reached the final balance
This also came
Rs. 11,93,100
Credit balance
The same which is coming in our cashbook
In teleprime
This balance also reached there
This balance also my dear friends
Reached there
Oh ho ho
Very very good
This balance also reached there
My passbook also updated completely
Reached to the final balance
And my cashbook also updated completely
That also reached to the final balance
Okay sir
Now come in notes
Come in notes
Write steps
Now see
Which steps will be written in the steps
Which you have to do practically sitting on the table
Which you have to do in your office
Those steps will be written
Here we have done a little extra work
We have reached 6,3,4,0 to teleprime
So that you learn extra
And how did we reach the passbook
I have shown you that
While you don't have the passbook
You don't have to do anything
Just have to download
Okay So now come my dear friends
What do you have to do
How will the steps be
See this
How will the situation reach the bank reconciliation
When will you start doing bank reconciliation
And when you start doing bank reconciliation
What steps do you have to apply
And which work would have been done by then
I am telling you this
Number one
Number one my dear friends
Some entries
Would have
I will make you write in the local language
Already been made in your cashbook
Would have
Already been made in your cashbook
In your cashbook
Means sir
When you start bank reconciliation
Some entries are already in the cashbook
Yes or no
Yes sir
Like we just asked this question
Before doing bank reconciliation
Which entries did we do in the cashbook
Fourth and fifth
So after these entries
We reach a balance 6340 Oh oh
So some entries would have already been done
You would have done this a while ago
And you would have reached the balance of 6340
And now you want to do reconciliation
So I did not pick up from here
Want to do reconciliation
I took you two steps back
Okay sir
Okay Then what is the second work
You have to download the passbook
Please download passbook
Okay sir
After downloading the passbook
What do you have to do on the third step
Match
Entries in cashbook
Match Entries in cashbook and passbook
And look for
Look for the entries
Pending to be passed in the cashbook
Step number 4
Pass the entries
Selected in step 3
What did it mean
Means download the passbook
And mingle with your cashbook
The third step says
Match the cashbook and passbook
And see what are the entries
Which are such entries
Which have been done in the passbook
But you did not do in your cashbook
You did not do in your cashbook
What are the entries
Which have been done in the passbook
You did not do in your cashbook
Then you pass those entries on the fourth step
On the third step you have to select the entries on the
third step you have to select the entries which are also
there in the passbook not in the cashbook then you have to
come to the cashbook and pass those entries on the fourth
step through which your cashbook will be updated pass the
entries selected in step 3 to fully update your cashbook
through this your cashbook will be updated completely to
fully update your cashbook to fully update your cashbook
Number 5, when your cash book will be completely updated,
number 5, go for bank reconciliation in teleprime, go for
bank reconciliation in teleprime, then you have to go for
bank reconciliation in teleprime, how will you go, press n,
press n and then press b, n for banking and b for bank
reconciliation, press n, then b, press n or b and then go
for bank reconciliation.
Reconcile the entries
Which are present
Both in cashbook and passbook
Which are present in both cashbook and passbook
Put a date on them and reconcile
Cashbook date will be coming already
When you have entered in cashbook
And the same entry is present in passbook
Put that date, that item will be reconciled
After step 6
Only those items
Will be pending for reconciliation
Only those items
Will be pending
For reconciliation
Only those items
Will be pending for reconciliation
Which are pending on bank's behalf
Only those items will be left
Which are pending on bank's behalf
Only those items will be left
After that on 8th number
Later on
When the pending items in step 7
Are also passed in passbook
Come back to cashbook
And reconcile those pending items also
Come back to cashbook
And reconcile those pending items also
At last
Both the cashbook and passbook
Will reflect
Correct updated balance
Correct and updated balance
And after doing these 8 steps
Cashbook and passbook both
Will reach final updated correct balance
11,93,100 rupees 11,93,100 rupees
Write it down
And in the coming questions
We are going to apply these steps
In the coming questions
Okay
Note it
If anything is left here
Note it
If anything is left here
Note it
If anything is left here
Pause and note it
Here Write quickly
Let's write this out
It's coming
Yes Don't worry
Okay We have noted it
Yes sir
We have noted it
Okay Keep these steps in mind
Keep these steps in mind
My dear friends
Now I will ask you a question
In that
There must be some entries in your cashbook
Means 6,3,4,0 We must have reached 6,3,4,0
We must have reached 6,3,4,0
How will the passbook be downloaded?
I will show you the downloaded passbook
Okay sir
Then what will we do?
We will match and see
Which entries are in the passbook
Which are not in the cashbook
Then we will update the cashbook
By putting those entries in the cashbook
Then we will go to tally
To do bank reconciliation
Then we will reconcile those entries
Which are present in both places
After doing this
Only those entries will remain pending
Which is pending on the account of the bank
Then after some time
We will inform the bank
And those entries will be in the bank
Those entries will be reflected in the bank's passbook
After some time 11,8,7 and 22,17
Then we will come back to our cashbook
And we will send the passbook to the correct balance
We will come back to tally prime
And we will do bank reconciliation
Sorry And then both the cashbook and passbook
Must have reached the final balance
The passbook must have reached earlier
The passbook must have reached the final balance
Okay Okay And the cashbook was already there
What do we have to do after coming back?
We have to reconcile those items
Which were left
Like come back to this question
Come back to this question
Look at the passbook
Now this item is also there in the passbook 11,8,7 and 22,17
The passbook has reached 11,8,7 and 22,17
Yes the passbook has reached
Now what do you have to do?
Which step is this?
This is this step
We have completed this question till this step
Till the 8th step
No no
Till the 7th step
Only No man
One minute
Later on when the pending items
In step 7
Are also passed in the passbook
This question is completed till here
That the pending items 11,8,7 and 22,17
Those are also reflected in the passbook
Those are also entered in the passbook
Now what do you have to do?
Come back to the cashbook
And do reconciliation
Come back to tally prime
Instead of come back to cashbook
Write tally prime instead of come back to cashbook
Come back to tally prime
And reconcile pending items also
Reconcile the pending items
Come here
Come to tally prime
These are the items
Which were pending in the reconciliation
Now these are also reflected in the passbook
So what we will do
We will put the passbook date here
The day their entry is coming in the passbook
And We will open the control
See my balance as per bank
Is also seen 11,93,100
And my balance as per company books
Is also seen 11,93,100
Company books means cashbook
And balance as per bank means passbook
Both are final updated
Have reached the correct balance 11,93,100 11,93,100
11,93,100 11,93,100 Okay okay
While asking this question
What I have done
I have taken one step back from here
I have taken two steps back from the first step
How did 6340 come
I have shown you by passing some entries
And I have shown you a glimpse of the passbook
Okay okay
But now we will do totally practical
Now knowledge is also achieved completely
Went to the last step
Now it will be totally practical approach
And try to work a little faster
So now let's go to our next question
Now we will move to the next question
And we will follow these steps
In our next question
Let's read our next question
That is question number 3
I will do some preparation
I have to show some steps
I will do some preparation
Till then you can look at the question
How is it
I have to change the screen
I will do preparation for this
I have to change the screen
I will do preparation for this
Wait a minute
Just a minute
Okay Now let's read the question
On 30th September 2019
Bank account of X
According to the bank column of cash book
Was overdrawn to the extent of 4062
There is a negative balance of 4062 in my cash book
Some entries must have already been done
In my cash book
You have to start from there
Assume that you have reached a company
And there is 4062
There is already a negative balance in the cash book
Sir, if it is not already
If it is not already
Download the passbook
And start the opening balance from 10, 55, 340
Okay So, now I'll show you the cash book
Let's get to teleprime
There is a negative balance of 4062
The left side is a negative balance
There is a negative balance
There is a negative balance 4062 Okay, let's move forward
Okay, let's move forward
And on the same date
The credit balance in the bank statement is 20,758
I'll show you the bank statement and the passbook
It has a credit balance of 2758
I downloaded this from the bank
Login with id password and download the statement of any
month
See what balance is coming in this
Credit balance of 20758 is coming in this
Absolutely right
Now you think how questions will be made
Think how questions will be made
Questions are made like this
In teleprime, wherever it goes and is seen
How much balance is coming there
Negative 4062
So that line is written in the question
Not teleprime from question
There is a question from teleprime
There is a question from the passbook, not the passbook
from the question
Oh oh oh
Situation is made from them
From cashbook and passbook
Not from cashbook and passbook
It is made from situation
Okay So Listen again
So what did our question maker do?
He checked
He made the situation
He checked that yes 4062 is coming in teleprime
He wrote the line
Cashbook showing negative balance of 4062
Then downloaded the passbook and checked the passbook
Then wrote
Passbook showing credit balance of 20758 20758 Then what
will we do?
Then what will we do next step?
Now we will check both places
We will check both places
My dear friends
Follow your steps
These are our steps
The first step
Already some entries must have been done
Yes After which the balance is coming
How much?
Negative balance of 4062
Okay So the first step is complete
The first step is complete
I take
Extra thick
The first step is complete
The second step
Download the passbook
Downloaded the passbook
Then Downloaded the passbook
Downloaded the passbook
Checked the balance
How much is coming? 20758 Credit balance
Third step
Match the entries in the passbook and cashbook
And see
Which entries are not happening in the cashbook
Which you can do in the cashbook
Okay Okay So now we try to match our cashbook and passbook
So see
You have to see in the third step
Which entries are happening in the passbook
Pending to be passed in the cashbook
Not happening in the cashbook
So what you have to do
You have to check in the passbook
Basically Basically check in the passbook
My dear friends
Check in the passbook
Sir, the entry is happening in the passbook 16000 117400
580 and 20000 16000 117400 580 and 20000 16000 117400 580
and 20000
Write somewhere on the paper
Entry of 16000 payment
Entry of withdrawal means payment
You don't have to change the screen again and again
That's why I am telling you to write
Entry of 16000 payment is coming in the passbook
Entry of 117000 receipt is coming
Entry of deposit
Entry of 580 payment is coming
Entry of 20000 receipt is coming
Okay Payment and receipt are from creditor and debtor
And this 580 rupees is in the name of bank charges
Okay sir
Now we have to go to our teleprime
Which entries are not happening in the cashbook
We have to go there and see
Now come to teleprime
And we will check the cashbook
Now we will check the cashbook
How will we check the cashbook sir?
Come to gateway of tele
Press DAC
And press enter many times
And reach this screen
After pressing DAC
Press enter many times
And come to this screen
And see
Entry of 16000 payment is happening somewhere
Yes it is happening
Entry of 16000 payment is happening
Okay Entry of 16000 payment is happening here
This is very much alright
Okay sir
Okay After that
Entry of 117400 receipt
Sir it is not there
Entry of 117400 receipt is not there
So what we have to do
Come out
Press V for voucher
And pass this entry in receipt voucher
In F6 receipt voucher
Receive from debtor named Ranveer 117400 rupees 117400
rupees
Call see
Ranveer under sundry debtors
Write Ranveer Singh
Ranveer Singh under sundry debtors
Write Ranveer Singh under sundry debtors
Write Ranveer only
If you save Ranveer under sundry debtors
Then what will happen after that
After saving
My dear friends
This amount will come here
You have to put
How much amount you have to put 117400 And debit to HDFC
bank 117400 So this entry is also done
This entry is also done
Entry of 117400
This entry is also passed
Okay sir
After that
Check if there is entry of 580
Go out again in teleprime
DAC And reach inside
Now see
Entry of 580 is there
It is not there sir
Entry of 580 is not there
So go to payment voucher
And make payment of bank charges of 580
V4 voucher
F5 payment voucher
And create bank charges
In indirect expense 580 And credit HDFC bank account 500
Control it
Okay sir
After that
Sir entry of 20,000 rupees receipt
Entry of 20,000 rupees receipt
Come Entry of 20,000 rupees receipt
See if it is there or not
D4 display
D4 debug
Sir entry of 20,000 rupees receipt is also not there
Okay sir
Now friends listen what happened
What we write now
Like we have entered entry of 117400
A little while ago
We had entered entry of 117400
Okay sir
Because it was coming in our passbook
Here is our passbook 117400 So we entered
We came to know
Who made this cash deposit
Ranveer made it
That's why we entered 117400 in the name of Ranveer
We will see this cash in our bank statement
Where is the payment coming from
Or who made the cash deposit
You will see in the bank statement
Okay sir
Whoever will transfer the bank
Will pay you
Will send money to your account
You will know
But you know what happened
This 20,000 rupees
This bank has written
Check and cash
And we are saying
Here is the entry
And we put it in our teleprime
But my dear friends
We had not deposited a cheque of 20,000
And do you know what name is coming here
The name is written here
That
Henry Henry's name is written here
For example
We said
We don't have a customer named Henry
We have never made a sale to a person named Henry
So why did he deposit the cheque
He will put money in our account
Where is this 20,000 rupees coming from
We called the bank
And found out
Where is this Henry
So the bank informed us
This is a wrong entry
Actually Actually I had to put money in someone else's
account
By mistake
I put 20,000 rupees in your account
We found out
See what is written in your question
Be ready for such a situation
See what is written in your question
Bank credited 20,000 to X in error
The bank accidentally put 20,000 rupees in X's account
So will you do the same mistake in your cashbook
First tell me
Will you do the same mistake in your cashbook
No sir
We will not do the same mistake in our cashbook
That's why
Now the steps we have written
In those steps
It's time to add one more thing
Come in those steps and add one more thing
Come on
I am taking you very beautifully
First write the steps
Then what spices can be added in those steps
I am showing the spices first
I am proving
Then I am getting it written
Match entries in cashbook and passbook
And look for the entries to be passed in the cashbook
So what did we do
First matching in cashbook and passbook
And we saw
These entries are not in the passbook
Look for the entries means
Write on a paper
Which entries are in the passbook
Which entries are not in the cashbook
Like 16,000 payment 17,400 received 580 bank charges
And received 20,000
Then when you come to the fourth step
You will try to pass these four entries
You will try to pass in your cashbook
By coming in teleprime
So keep one thing in mind
Keep one thing in mind
If there is any unknown source
Then leave it
Pass the entries selected in step 3
To fully update your cashbook
Full stop
Write further
Accept
Those entries
Erroneously made by bank in the passbook
However, this will not happen.
This can happen in a very rare case.
But still we have to cover the case.
We have to go with full understanding.
If this happens, what will happen?
What do you know if you get such a case?
So we have taken extensive coverage in our course.
We will teach you everything.
Smallest case and biggest case.
So when you are passing the entry in the cashbook.
Which you have selected in step 3.
Sir, where did you go?
He has not gone anywhere.
He has changed the battery.
Okay. Okay. Okay.
So keep this in mind.
Okay sir. Okay.
We will take care of this.
Okay.
What is our next step?
Next step.
Go for reconciliation in teleprime.
Now come to teleprime and start reconciling.
Press N or B.
And reconcile those entries which are in the cashbook and
passbook.
Escape. Escape. Escape.
N, B.
Rs. 13,14,000.
13,14,000
Was it in the passbook?
It wasn't in the passbook
Leave it now.
16,000 rupees 16,000 rupees
So press N or B and come here
After pressing N or B, we have come here
Enter the date of the entry in both the places
The one in the cash book and the one in the passbook and
finish the work 13,14,000.
Is it in the passbook?
Check if it is not in the passbook.
I will show you the passbook.
13,14,000 is not in the passbook
See this.
13,14,000 is not anywhere
Okay sir.
After that
After that, it is 16,000
Enter the date of 16,000.
1st April 2022
After that, it is not even 13,26,000.
Leave it and move ahead
If it is in the passbook, then enter the date
If it is in the passbook, then enter the date.
We will take 1st April 2022 14,000 is not there
And 16,000 is not even there 16,000 is not even there
Come here and see the passbook
Here it is not 1,40,000 and 16,000 is not even there 16,000
is not even there
My dear friends
So these items are left with us.
Pending Reconciliation
These items are pending reconciliation
Control A
And if you enter again, see the balance is 758
How much is in your passbook? 20,758.
Because we did not put the entry of 20,000
The bank has put it.
The bank will fix it
The bank will fix it.
Okay. So listen now
Now listen my dear friends
What is our next step?
Sir, our next step is
After step 6, only those items will remain pending
reconciliation
Which are pending on the bank's behalf
Which are pending on the bank's behalf.
But see
But see if this thing is fully applicable
In the last question, it was a small question.
But there are all points in it.
Pay attention 13, 14.
This is the item which is pending on the bank's behalf
Okay. We received the cheque, deposited it
Entered in cash. It has not been cleared in the bank yet.
Because there is no cash, the bank has not entered. This is
pending on the bank's behalf.
Okay. 13, 26. We issued the cheque.
Entered the creator in cash. It has not been entered in the
passbook yet.
Because it has not been cleared. This is also pending on
the bank's behalf. Okay.
But this 140,000
Now we made this sheet for the bank. Okay.
We made this sheet for the bank that this item remains
pending on your behalf
Listen very carefully.
We gave this sheet to the bank
Now the bank has an answer.
The bank has an answer.
The bank says 13, 14
It is understood that the cheque has been deposited. Okay.
It has not been encashed yet. 13, 26 also understands that
you have issued the cheque.
It is in clearing. The money has not been deducted from us
yet.
But the bank is saying that listen to this 140,000
You have put the entry of the bank bill receivable.
This 140,000 has been dishonored.
The cheque could not be cleared.
I show you the entry of this 140,000
I show you what is 140 in teleprime. Press escape and come
out.
Press escape and come out.
The bank is raising questions on your 140,000.
So what will you do? You will come to D4 display, D4
daybook and open the entry of 140,000.
On which the bank is raising questions and see what this
entry is.
Open that 140,000.
You are getting here
There is a clearance in exchange for a bill receivable.
There is a clearance in exchange for a bill receivable of
140,000.
Means a person had given you a cheque.
You deposited it in the bank. You let that person go.
Now the bank is saying that it has been dishonored.
The bank is saying that it has been dishonored.
They told you on the phone that it has been dishonored.
You have to pass its reverse entry on your own.
You either delete this entry or pass the reverse entry.
You have two ways.
Delete the entry or pass the reverse entry.
How will it be deleted? Alt D and Y
Press Alt D and Y
Now go back to the bank reconciliation.
N for banking, B for this.
You would find that 140,000 has also disappeared from here.
When you have removed it from the cash book, then what to
do with its reconciliation? The entry that was not in the
cash book and is not in the passbook, then how is its
reconciliation? 140,000 was in the cash book and was not in
the passbook.
You have removed it from the cash book.
Now what kind of reconciliation?
There is only one check in the name of 140,000 Deepika.
You have entered it twice.
We had entered it once a while ago.
We have entered it twice by mistake.
Now we are getting to know.
Delete this entry too.
D for display, D for Debook
Alt D and Y
Now go back to the bank and for banking, B for
reconciliation.
You would find that 140,000 has disappeared from here.
We have deleted the entry once.
Wait
Why is it not updating?
This is the old one.
Take April 1, 22 and finish it.
Now save it first.
Now the same entry is left, 13, 14, 13, 26 which is pending
on behalf of the bank.
The bank has told you what happened to 140,000.
The 16,000 that we have deleted in the back has been
deleted.
Which we had reconciled.
That's why it was coming again for reconciliation.
If you do it again, it will go away.
So 13, 14, 13, 26
Now the bank is saying that these two items are pending
here.
And now the balance is 758.
Now listen, now you tell the bank that two items
While living in our reconciliation, you should have a
balance of 758
In your passbook.
The balance of 758 should come in your passbook.
The bank is saying that it is still coming 20,758.
Now the bank is saying that our cashbook is completely
updated.
And we have also done all the reconciliation.
And our reconciliation sheet is saying that if two items
are pending 13, 14, 13, 26, then 758 should come. Now how
is 20,758 coming to you?
Now the bank will know that they have entered 20,000 by
mistake.
Now the bank will delete this 20,000 from there.
And finally how much will your balance look like? 758 Rupees
Now you can see that your balance is 758.
The bank will reverse it.
758 Now you can see that there is also 758 credit here.
And your reconciliation sheet is also showing a debit
balance of 758.
Means these two items are left, nothing else.
So now we have to improve our steps.
Now we have to improve our steps.
So after steps, only those items will be pending for
reconciliation.
Which are pending on the bank's behalf.
And errors in cashbook.
And errors in passbook.
Those items will be pending on the bank's behalf.
Like 13, 14 and 13, 26
And those items will also be pending which were mistakes in
the cashbook.
Like we had put 16,000 Rupees twice.
And those items will be pending which were mistakes in the
passbook.
Like 20,000 Rupees
After steps 6, which items will be pending for
reconciliation.
Which are pending on the bank's behalf.
Like 13, 14 and 13, 26
For which we have to wait.
And errors in cashbook.
Like we had put 16,000 Rupees twice.
Which are pending on the bank's behalf.
And errors in cashbook.
After that, one more step will come on the 8th step.
One more step will come on the 8th step.
Write it as 8th and make it 8th A.
One more step will come on the 8th step.
Send the reconciliation sheet to bank.
And Bank will inform
Bank will inform
About Bank will inform
About Queries in
Queries in
Reconciliation sheet
Example dishonor
Example dishonor You are not understanding 140. This is
dishonor.
Then bank will inform you that its dishonor.
Disappear yourself.
Bank will inform about queries in rico sheet.
Example dishonor 140.
And bank will ask you about something.
Bank will say, if you have done any repetition.
Like you have done 16000 twice.
Then bank will say, there was only one check.
Why you have done entry twice.
So after dishonor and repetition, bank will send you rico
sheet.
Bank will tell you about the queries.
Then what you have to do is
END Correct Queries in Cashbook
Then you have to correct those queries in your cashbook
Correct Queries in Cashbook
Then correct those queries in your cashbook
My Dear Friends
Then delete entry of 1040 and 16
Then delete entry of 140 and 16
Later after this work
After this work
After step 8
What will happen after step 8? Your cash book will be
updated completely.
Your cash book will be updated completely.
What will happen after that?
After that, my dear friends,
Now this is your reconciliation sheet.
The same item will be seen in this, which is pending on
behalf of the bank.
Then what will happen?
Then when these will also pass in the passbook after a few
days,
Then we will come back to teleprime and do their
reconciliation.
And both the books would have reached their final balance.
That is, what is after step 8?
After step 8, we corrected the queries in the cash book.
Now what will happen?
Now those items that are left, 13, 14 and 13, 26.
Those items will also be reflected in the passbook after a
while.
Let's reflect them in the passbook.
13, 14 and 13, 26.
What will happen after 758 credit?
What was my deposit of 13, 14,000?
Check and cash.
So this will come in the deposit, 13, 14,000.
And the check issued for 13, 26,000 will be cleared and the
money will be withdrawn from my account.
13, 26,000.
So finally, how much will my balance look like?
Pick up the calculator.
Finally, how much will my balance look like?
758 minus 13, 14,000, 26,000.
Plus 13, 14,000.
11,242 negative is coming.
That is the debit balance.
11,242 debit negative.
Now you have to come back.
When this item is reflected in your passbook.
We have reflected it ourselves.
You don't have to do anything.
If you download the passbook of the bank after a while, you
will see the reflect here.
Now you have to come back to teleprime.
And you have to do the reconciliation of these two items as
well.
Which are left.
You have to do their reconciliation as well.
Put their date as well.
And then your reconciliation will end completely.
And if you come to the balance sheet and see.
Then it will show the same balance in your bank account.
Negative 11,242 which is coming in your passbook.
Both the balance are final.
Both the books are final, updated and have reached the
right balance.
11,242 11,242
Okay.
So practice it.
See you in the next lecture.
Thank you.
Bye Bye.
Take care.