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 is being done.
Credit will be done.
ICICI bank.
Press control A.
Okay Sir.
Press control A.
After that come.
Take this.
Cheque is paid into bank.
Cheque deposit.
22,17 lakhs.
As soon as the deposit is done.
We enter in the cashbook.
Yes.
As soon as the deposit is done.
Enter in the cashbook.
Next point will be.
No, no, no, that is the entry of the bank, we did not
complete it yet.
Interest on investment 12 lakhs, We will do it during the
time of reconciliation, now reaching 6340 means that out of
these 5 points, whatever work would have been done in the
cash book, you enter it into your teleprime.
That is why the balance of 6340 must be coming in
teleprime, otherwise how it would be coming.
Entries that have already happened, do them.
Those remaining, do not do that.
Okay sir, so let's do a receipt, F6 22,17,000 from Debtor
Ranveer
Debtor Ranveer will always be there
Debtor Ranveer will always be there 22,17,000 22,17,000
Debit ICICI Bank Control
Now press escape and reach balance sheet
Come out and press Alt F1
See this
The balance of bank should come here
It is coming here on left side 6340 means
Negative bank balance has come
I have not changed the screen
You can enter in teleprime
I have entered in teleprime
I will show you
I have entered in received voucher
I have created Ranveer from 22,17,000 and debited ICICI
bank from 22,17,000
So this is our balance sheet
Finally see this
The balance of bank should come here
It is coming here on left side 6340 means
Negative balance is coming
This is what we wanted to get
Now listen to me
Come to writing pad
Now listen to me again
See this
We had
Opening balance
How much?
Minus 10,55,340
We issued more cheques 11,68,000 We entered in cash book
In teleprime
10,55,340 11,68,000 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
The third point is that it has entered in the passbook
And not in the cashbook.
That's why this reason for the difference has been made
Tthe fourth and fifth point have been entered in the
cashbook
And not in the passbook.
That's why this is the reason for the difference
And the interest on investment has entered in the passbook
And not in the cashbook.
That's why there is a reason for difference
These are the five reasons because of them
Difference is coming we have seen that if we do this entry
in the cash book then we will reach 6340 and if we do the
entries in the passbook then we will reach 144100 now there
is no right balance in this, remember neither the negative
balance of 6340 is final in the cash book this is also not
final or correct balance because now there are shortcomings
in the cash book which shortcomings are there in the cash
book 2nd, 3rd and 6th are not included in the cash book and
neither the balance in the
of 144100 is final this is also not final, why? because
this entry is not included in the passbook which one? 4th
and 5th 4th and 5th that's why no balance is practical no
balance is final what I have shown you
I have shown you how this situation is prepared in which
situation you are
I have shown you in teleprime the question that is
presented in front
I have shown you in teleprime
I have shown you this much how you reached the negative
balance of 6340 in the cash book how did you reach? you
started with 1055340 and you put these entries in the cash
book 4th and 5th so you reach here in the negative balance
of 6340 now it is not final 6340 because some entries are
left in it which ones? 2nd, 3rd and 6th how did the balance
of 144100 come in the passbook? you started with 1055340
and you put 2nd, 3rd and 6th points in the passbook not 4th
and 5th 2nd, 3rd and 6th points
4th and 5th that's why the balance in your passbook is
different there is no final because it is less in the
passbook 4th and 5th points are not included in the
passbook so what will happen now? now friends, I have
presented this situation in teleprime how did you reach
6340 in teleprime? and I have shown you the passbook how
did the passbook reach 14400? yes, I have shown you the
passbook however, you will never have to make the passbook
the print will come out of the bank still I am showing
I am making you analyze so we have made this situation now
what we have to do? now what we have to do? sir, from these
points which are pending on behalf of the cash book which
are pending on behalf of the cash book let's enter them in
our cash book and then the points which will be left then
the points which will be left which are pending on behalf
of the bank we will catch the bank and the bank will deal
it at their end yes sir so come and tell me come and tell
me friends which are the things
are pending on behalf of us which are the things which are
pending on behalf of us sir, tell us practically what do
you have to do practically? you don't have to do anything
practically practically, get the printout of the passbook
ok sir and in the cash book this cash book if you are
starting a new bank reconciliation then you have to do this
you have to check the opening balance from the passbook and
all the transactions that have happened ask the owner in
that whatever you have entered in
cash book he will do it and whatever is pending from the
passbook do it at the time of reconciliation that's it,
nothing else ok, ok, ok let's move ahead let's do it ahead
now listen to me which are the pending things whose entry
we want to do in the cash book 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 to teleprime
come to teleprime
v for voucher let's do the entry first interest on
overdraft take payment voucher F5 debit, alt c, account
whose name is interest on overdraft this will be your
indirect expense that's why take it in indirect expenses
ctrl a, give 160 rupees 160 rupees yes credit ICICI bank
160 rupees very good do the entry of bank charges debit,
alt c, bank charges account under the heading of indirect
expenses ctrl a, 400 and credit
ICICI bank 400 very good and, and, and interest on
investment you have to do this in received voucher credit
interest on investments
under the heading of indirect income ctrl a 12 lakhs debit
ICICI bank
yes and save it by ctrl a save it by ctrl a so what
happened now my cash book is complete my cash book is
complete what happened some item was pending in my cash
book now it is complete come again and listen
I I saw transactions in my cash book
the pending in my cash book so finally cash book has
reached its final balance ask how because all the entries
are in the cash book this was already in 4th and 5th 2nd,
3rd and 6th so my cash book has reached its final balance
now see the balance in my cash book is final the balance in
my cash book is final it is correct all the postings are
done there is no pending reconciliation nothing is left see
in b4 balance sheet 11,93,100 is the negative balance
11,93,100 is the negative balance all the
are in it 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 does it mean
Means download the passbook and mix with your cashbook
The third step says
Match 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 it in your cashbook
You did not do it in your cashbook
What are the entries
Which have been done in the passbook
You did not do it in your cashbook
Then you pass those entries on the fourth step you have to
select those entries on 3rd step select that entry in
passbook which exist in passbook not in cashbook and on 4th
step you have to pass those entries this will update your
cashbook pass the entriy selected in step 3 2
Fully update your cashbook this will 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 go for
bank reconciliation, then
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 will show you some steps
I will do some preparation
Till then you can look at the question
Okay sir
I have to change the screen
I will do preparation
Wait a minute
Just a minute
Now let's read the question
On 30th September 2019
Bank account of X
According to the bank column of cashbook
Was overdrawn to the extent of 4062
My cashbook has a negative balance of 4062
Shall I show you
How will it look
Some entries must have already been done in my cashbook
That's why it must have reached some balance
Whether negative or positive
You have to start from there
Assume that you have reached a company
There is already accounting
And there is 4062
What is coming
There is already a negative balance in the cashbook
Sir, if it is not already
If the accounting starts from zero
Download the passbook
And start the opening balance from 10, 55, 340
Okay Now I will show you the cashbook
Let's come to teleprime
There is a negative balance in it
Here it is
Left side
There is a negative balance in the bank account 4062 4062
Yes sir
Let's move on
And On the same date
There is a credit balance of 20,758 in the bank statement
I will show you the bank statement
I will also show you the passbook
There is a credit balance of 20,758
I downloaded it from the bank
Client ID, Password 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
Checked the balance 20758 Credit balance
The third step
Match the entries in the passbook and cashbook
Look Which entries are not happening in the cashbook
Which you can do in the cashbook
Okay Okay Now we will try to match our cashbook and passbook
Now we will try to match our cashbook and passbook
So watch
You have to see
In the third step
Which entries are in the passbook
Pending to be passed in the cashbook
Not happening in the cashbook
So what you have to do basically check in passbook
basically check in passbook my dear friends check in
passbook sir entry in passbook is 16000 117400 580 and
20000 16000 117400 580 and 20000 16000 117400 580 and 20000
write on paper write on paper withdrawal means payment
withdrawal means payment screen will not change again and
again entry in passbook is 16000 entry in passbook is 16000
deposit is 117000 deposit is 117000 entry is 580 entry is
580 entry is 580 payment and receipt is from
payment and receipt is from creditor bank charges is 580
bank charges is 580 entry is not in cashbook which one is
not in cashbook come to teleprime and check cashbook how to
check cashbook come to gateway of tele press DAC and press
enter and reach to this screen after pressing DAC press
enter and see entry of payment is 16000 entry of payment is
16000 entry of payment is 16000 this is very much alright
this is very much alright ok after that entry of receipt is
117400 entry of receipt is
entry of receipt is 117400 entry of receipt is 117400 what
to do come out and enter in receipt voucher receipt voucher
receipt from debtor receipt is 117400 receipt is 117400
receipt is 117400 and see
Ranveer under sundry debtors write all name
Ranveer Singh under sundry debtors under sundry debtors
under sundry debtors write Ranveer write Ranveer save this
After that, after saving, my dear friends, you have to
enter this amount here.
How much amount do you have to put? 1,17,400.
And debit it to HDFC bank.
1,17,400.
So this entry is also done.
This entry is also done.
1,17,400.
This entry is also passed.
Okay sir.
After that, check if there is an entry of 580 or not.
Now go out again in teleprime.
DAC.
And reach inside.
Now check if there is an entry of 580 or not.
There is no entry of 580 here.
So go to payment voucher and make payment of bank charges
of 580.
V4 voucher.
F5 payment voucher.
And create bank charges at indirect expense.
500 C.
And credit HDFC bank account 500 C.
Control it.
Okay sir.
After that, sir, entry of Rs. 20,000 receipt.
Entry of Rs. 20,000 receipt.
Come here.
Entry of Rs. 20,000 receipt.
See if it is there or not.
D4 display, D4 debug.
Sir, there is no entry of Rs. 20,000 receipt.
Okay sir.
Now friends, listen what happened.
What we write now, like we have entered Rs. 1,17,400
receipt.
A little while ago, we had entered Rs. 1,17,400 receipt.
Okay sir.
Because it was coming in our passbook.
Here is our passbook, Rs. 1,17,400.
So we entered.
We came to know who made this cash deposit.
Ranveer did it.
That's why we entered Rs. 1,17,400 in the name of Ranveer.
We will see this cash in our bank statement.
That from where payment is coming.
Or who has deposited cash, you will see in the bank
statement.
Okay sir.
Whoever will transfer the bank or will pay you.
Will send money to your account.
You will know.
But do you know what happened?
This Rs. 20,000 which is visible, this Rs. 20,000.
This bank has written check and cash.
And we are saying that entry is coming here.
And we put it in our teleprime too.
But my dear friends.
We had not deposited a cheque of Rs. 20,000.
And do you know what name is coming here?
Here the name is written something like this.
Henry.
Here a Henry name is written.
For example.
We said that we don't have a customer named Henry.
We have never made a sale to a person named Henry.
So why will he deposit a cheque to us?
He will deposit money in our account.
Where is this Rs.
20,000 coming from?
We called the bank and found out where Henry is coming from.
So the bank informed us that this is a wrong entry.
Actually, we had to deposit money in someone else's account.
By mistake, we have put Rs. 20,000 in your account.
We found out this.
See what is written in your question.
Be ready for such a situation.
See what is written in your question.
Bank credited Rs. 20,000 to X in error.
The bank put Rs. 20,000 in X's account by mistake.
Will you make the same mistake in your cashbook?
First tell me this.
Will you make the same mistake in your cashbook?
No sir, we will not make the same mistake in our cashbook.
That's why,
Now the steps we have written,
It's time to add one more thing in those steps.
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 that spice first, proving it, then writing it.
Match entries in cashbook and passbook.
And look for the entries to be passed in the cashbook.
So what did we do?
First we matched the entries in the cashbook and passbook.
And we saw that these entries are not there in the passbook.
Look for the entries means,
Write on a paper,
Which entries are there in the passbook and not in the
cashbook.
Like Rs.
16,000 payment,
Rs. 17,400 received,
Rs. 580 bank charges and Rs. 20,000 received.
Then when you come to the fourth step,
You will try to pass these four entries.
You will pass it in your cashbook by coming to 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 ahead of this.
Accept
Those entries
Erroneously
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 understand everything.
What if this happens?
What if you get such a case?
So we have taken extensive coverage in our course.
We will teach you everything in the course.
Small case and big case
So when you are passing the entry in the cashbook,
These four
Which you have selected in step 3
Sir, where did you go?
He has not gone anywhere.
He has changed the battery.
Okay So keep this in mind.
Okay sir
We will keep this in mind.
Okay What is our next step?
What is our next step?
Next step
Go for reconciliation in teleprime
Now come to teleprime and start reconciling.
Press N and B
And reconcile those entries that are in the cashbook and
passbook.
Escape Escape N, B
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.
N 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 it on time?
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 and improve our steps.
Rather than improving, we should say improving.
So after steps only those items will be pending for
reconciliation which are pending on bank's behalf.
And errors in cash book and errors in pass book.
Those items will be pending on bank's behalf like 13-14 and
13-26.
And those items will also be pending which were errors in
cash book like we had put Rs.16000 twice.
And those items will be pending which were errors in pass
book like Rs.20,000.
This will not be seen in that, sorry.
Remove error in pass book first.
Write only this much.
After applying step 6, which items will be pending for
reconciliation which are pending on bank's behalf like
13-14 and 13-26.
For which we have to wait.
And errors in cash book which you have put errors in cash
book like Rs.16000 twice.
Rs.16000 twice.
So write only this much which are pending on bank's behalf
and errors in cash book.
After that what we will do?
On 8th step, one more step will come.
On 8th step, one more step will come my dear friends.
Write it as 8th and make it 8th A.
On 8th step, one more step will come.
Send the reconciliation sheet to bank.
Send the RICO sheet to bank.
Now you will send that reconciliation sheet to bank.
And
bank will inform
bank will inform about
queries in
reconciliation sheet.
Example Dishonor
Will you send this reconciliation sheet to bank?
Okay sir.
Will you send this reconciliation sheet to bank?
Yes sir.
Bank will see that we can understand 13-14 and 13-26 but
can't understand 1-40.
bank will inform you that this is 140 dishonor bank will
inform you that this is 140 dishonor bank will inform about
queries in rico sheet example dishonor 140 and bank will
ask you if you have done any repetition like you have done
16000 twice bank will ask you that this is only one check
so after dishonor and repetition step 8
after step 8 your cash book will be updated your cash book
will be updated after that my dear friends you will see the
same item in your rico sheet what will happen if you pass
in passbook then we will come back to teleprime and do
reconciliation and both books will reach their final
balance after step 8 we have corrected queries in cash book
now what will happen now those items which are left 13,14
and 13,26 those items will be reflected in passbook let's
reflect them in passbook let's reflect
in passbook 13,14 and 13,26
after 758 credit my deposit was 13,14,000 check in cash
so 13,14,000 will come in deposit
and check issued 13,26,000 so finally my balance will be
758 minus 13,14,000 plus 13,14,000 minus 13,14,000 plus
13,14,000 11,242 negative means debit balance now you have
to come back when these items will be reflected in your
passbook we have reflected them if you will download bank
passbook after sometime then you will see reflect now you
have to come back to teleprime and do reconciliation of
these two items put their date and then your reconciliation
will end and if you come in balance
then your bank account will show same balance negative
11,242 both books are final both books are final both books
are final both books are final so practice it so practice
it so practice it