Posted by geemiz | Posted in Practical Accounting 1 | Posted on 17-11-2010
Tags: free review materials, free study materials, Theory of Accounts
One statement being made before computing the total amount of cash both on hand in bank is the statement of bank reconciliation. This statement is not one of the basic financial reports that every company must make annually but this statement is necessary to reach the true amount of cash. This article is not intended to discuss about Bank Reconciliation because this was discuss in a different page. This write up is consist of the lists of formulas being used in computing for adjusted cash on hand or in bank, the total amount of outstanding check and the total amount of deposits in transit.
Before going further let’s meet the three basic formats used in reconciling the book balance and the bank balance.
Adjusted balance Method
Both book and bank balance is brought to correct the cash balance that must appear in the statement of position under this method.
Book to Bank Method
This method allows the book balance to be reconciled with the bank balance. Meaning the book balance is adjusted to equal the bank balance.
Bank to Book Method
This is just similar with the book to bank method but in this method instead of the book being reconciled with the bank balance, the bank balance is being reconciled with the book or the bank balance is adjusted to equal the amount of the cash in the book balance.
Adjusted Balance Method
- Book balance
Add: Credit memos
———————
Total
Less: debit memos
———————
Adjusted book balance- Bank balance
Add: Deposit in transit
———————
Total
Less: Oustanding checks
———————
Adjusted bank balance
Book to Bank Method
- Book balance
Add: Credit memos
Outsatanding checks
———————-
Total
Less: Debit memos
Deposit in transit
———————-
Bank balance
Bank to Book Method
- Bank balance
Add: Deposit in transit
Debit memos
———————–
Total
Less: Credit memos
Outstanding checks
———————–
Book balance
Two-date Bank Reconciliation
As it is so called, two-date bank reconciliation involves two dates and the procedures followed in solving for the adjusted cash balance is just the same with one-date bank reconciliation.
Computation of Book balance
- Balance per book beginning of the month
Add: book debits during the month
——————————————
Total
Less: Book credits during the month
——————————————
Balance per Book end of the month
Computation of Bank balance
- Balance per book beginning of the month
Add: bank credits during the month
——————————————-
Total
Less: bank debits during the month
——————————————–
Balance per Bank end of the month
Other computations involved in bank reconciliation:
Computation of deposit in transit
- Deposit in transit beginning of the month
Add: Cash receipts deposited during the month
———————————————
Total deposit to be acknowledged by bank
Less: Deposits acknowledged by bank during the month
———————————————
Deposit in transit end of the month
Computation of outstanding checks
- Outstanding checks beginning of the month
Add: checks drawn by depositor during the month
———————————————
Total checks to be paid by bank
Less: Checks paid by bank during the month
———————————————
Outstanding checks end of the month
The proforma computations above are all used in solving the adjusted cash in bank reconciliation.
Hi
I thing this web is very important in future needs more upgrate.
Nuru
Thank you Nuru. I am a bit busy with work but will have an accounting update the soonest.
i m so impress of this farmulas any body can gives me any other website
thanks, i really undEstood how to do it.
Thank You Arar, I am glad it helped..
O it is the great web for the helping of some one who needs to understand the miscellaneous work of accounting. Thanks
really this is very effective site for help in accounting solution.
it is so good to sole the problem of bank
this is too good to have the bank recon…. formula
thx this site is good
What will be the compuation of deposit in transit if there are errors on the part of book and bank???
Can there be any other equation for doing bank recon apart from below steps if yes please advice.
Checkbook Bal. = Bank Bal. + deposit in transit – uncleared
checks – uncleared bank fee / cc fee + any
unrecorded chargebacks / Bank charges /
other expense
I like your blog- I would like to know whether this is is also correct:balance as per bank statement, add uncredited memos, less unpresented cheques to get the correct closing bank balance.
This anice formula.
NICE 🙂
is ok nic.
nice formula 🙂 it will help a lot 🙂
Hahaha. Mas madaling intindihin. Salamat sa link Dianne :* 🙂
thanks…
how about finding deposit in transit from ending to beginning.. can you give the formula for this? please….
formulas? understand and apply it. thanks. this is very helpful for us. 🙂
Mas madali pag nag T ACCOUNT ka. 🙂
lahat naman eh, pag mawala ka sa analysis mo, mag t account! haha
hOW about if the problem includes the balances of the previous month?
thanks a lot!
Easy Formula Its Help me to execute the Bank Recon effective;y
It’s really a great and useful piece of information. I am glad that you simply
shared this helpful information with us. Please stay us informed like
this. Thanks for sharing.
Asking questions are truly good thing if you are not understanding anything fully,
however this paragraph offers pleasant understanding yet.
Hello I want to ask the formula to use if the only given are total book credits, total bank debits, outstanding checks (end), debit memo previous and current month but it is asking for the deposit in transit beginning? Please help me to answer this problem. It will help me a lot. Thank you.
it is very helpful for me as a accounting student 😉
Helpful!!
Cheer!!
how do you account for checks written and checks paid?