Connect with us

Bank/Checking Account

Bank Reconciliation Made Easy

Published

on

Bank Reconciliation Made EasyBank reconciliations are prepared by bank depositors when they receive their monthly bank statements.  The reconciliation is made to determine any required adjustments to the cash balance.  Two types of reconciling items are possible: (1) Reconciling items not requiring adjustment on the books (type A) (b) Reconciling items requiring adjustment on the books (type B). And, two format of bank reconciliations is demonstrated in this post. Read on… 

 

Advertisement

Types of Reconciling Items in Bank Reconciliation

Type A: Reconciling Items do not require adjusting Journal entries

(1) Outstanding checks
(2)  Deposits in transit
(3) Bank errors

Type B: Reconciling items require adjusting journal entries

(1)  Unrecorded returned nonsufficient funds (NSF) checks
(2)  Unrecorded bank charges
(3)  Errors in the cash account
(4)  Unrecorded bank collections of notes receivable

 

Reconciling items must be analyzed to determine whether they are included in:

  • the balance per bank; and/or
  • the balance per books.

 

If they are included in one, but not the other, an adjustment is requiredFor instant: the $1,800 deposit in transit in the following example is included in the balance per books but not in the balance per bank.  Thus, it must be added to the balance per bank to reconcile to the correct cash balance.  Deposits in transit do not require an adjusting journal entry.  Analyze all reconciling items in this manner, but remember, only journalize type B reconciling items

Note: Type A and B adjustments can be either added or subtracted depending upon the type of format and the nature of the item.

 

Formats and Examples of Bank Reconciliation

Two types of formats are used in bank reconciliations:
 
Format 1

Balance   per        bank 
+/–        A adjustments 
Correct  cash  balance 

Balance    per     books 
+/–        B adjustments 
Correct  cash  balance

 

 Example of Bank Reconciliation Format 1 is shown below:

Sample of Bank Reconciliation Format 1

 

Note: he balance per bank and balance per books each are reconciled directly to the corrected balance.

Adjusting journal entries: All of the items in the per books section of a bank reconciliation (type B) require adjusting entries.  The entries for the above example appear below:

[Debit]. Miscellaneous expense = $5 
[Credit]. Cash = $5

[Debit]. AR = $170
[Credit]. Cash = $170

[Debit]. Cash = $150
[Credit]. Notes receivable = $150

[Debit]. Cash = $45
[Credit]. AR (or sales) = $45

 

Format 2 [Four Column Cash Reconciliation, referred to as “Proof of Cash”]

Basically, format 2 is as follows:

Balance per bank
+(–) A     adjustments
+(–) B     adjustments
Balance per books
+(–) B     adjustments
Correct cash balance

 

Example of Bank Reconciliation Format 2 [Four Column] is shown below:

Example of Bank Reconciliation 4 Column

 

Unlike the bank reconciliation format 1 above which is as of a specific date, a four-column cash reconciliation, also known as a “proof of cash,” reconciles bank and book cash balances over a specified time period

A proof of cash consists of four columns:  beginning of the period bank reconciliation, receipts, disbursements, and end-of-the-period bank reconciliation.  Thus, the proof of cash cross-foots as well as foots.

Note that there are no type B reconciling items in the beginning reconciliation column.  This is because the $4,562 has been adjusted when the June bank statement was reconciled.  Notice that figures appearing in the center columns have unlike signs if they are adjacent and like signs if they are not adjacent to amounts in the side columns.

The purpose of the proof of cash is to disclose any cash misstatements, such as unrecorded disbursements and receipts within a month, which would not be detected by a bank reconciliation. For example, if the center two columns each required a negative $1,000 to make the top line reconcile with the bottom line, there may be unrecorded receipts and deposits of $1,000.

9 Comments

9 Comments

  1. Pinky

    Jan 20, 2010 at 5:36 am

    Hellow
    I m MBA student and your method of reconciliatoin is much better. i want a some easy level of this method.

  2. Jane

    Apr 28, 2010 at 8:02 am

    Please explain the items included in the reconciliation formats, to ease non accountant’s work

  3. pineapple.

    Jun 21, 2010 at 1:10 am

    very practical and easy to understand.

  4. Ronnie

    Jul 23, 2010 at 2:16 am

    i like how you explained this topic so please discuss a more complicated error in either bank or book…

  5. yongky nelson

    Oct 10, 2010 at 9:39 am

    I’ve got a task, and dunno how to answer it. there’s no receipts and disbursements.

  6. Lal Mohd

    Mar 18, 2011 at 5:14 am

    hi i like how i give praise you dear i want formats of made financial reports

  7. Lulu

    Mar 21, 2011 at 12:50 pm

    Could you please give formats reconciliations for easy grasp to leaners

  8. Mister B

    Jun 14, 2011 at 1:34 pm

    How sould voided check be handled ? Should we reconcile the original cash disbursment then the void transaction or sould it be ignored ?

  9. mj

    Apr 9, 2015 at 7:40 am

    The deposit in july 10 was understated. $49 must be added to the receipts

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.




Are you looking for easy accounting tutorial? Established since 2007, Accounting-Financial-Tax.com hosts more than 1300 articles (still growing), and has helped millions accounting student, teacher, junior accountants and small business owners, worldwide.

Trending