Bank Reconciliation Formula

32

Posted by geemiz | Posted in Practical Accounting 1 | Posted on 17-11-2010

Tags: , ,

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.

Meet geemiz


Geezelle Maningo - A Cebu based travel blogger and the other half of GeeMiz Travel blog. She has been traveling around the Philippines and Asia since 2010 with her husband. A casual trekker/hiker since 2017 and has been blogging since 2008. A digital marketer during workdays and a bookworm on lazy days - she co-founded Cebu Book Club.

Comments (32)

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?

Write a comment