EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All in One Bundle
  • Login

Bank Reconciliation Example

By Diksha KeniDiksha Keni

Home » Finance » Blog » Accounting Fundamentals » Bank Reconciliation Example

Bank-Reconciliation-Example

Introduction to Bank Reconciliation Examples

Bank Reconciliation is a process that gives the reasons for differences between the bank statement and Cash Book maintained by a business. Not only is the process used to find out the differences, but also to bring about changes in relevant accounting records to keep the records up to date. Bank reconciliations examples are carried out at regular intervals.

Examples of Bank Reconciliation (With Excel Template)

Let’s take an example to understand the calculation of Bank Reconciliation in a better manner.

Start Your Free Investment Banking Course

Download Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

You can download this Bank Reconciliation Example Excel Template here – Bank Reconciliation Example Excel Template
Examples of Bank Reconciliation are as follows:

Bank Reconciliation Example – 1

Markson’s & Co. has a balance as per pass book of $1,000 as on 31st March 2019. It has a balance as per Cash Book as on 31st March 2019 of $1050. Further details are as follows:

  1. A cheque of $300 was deposited, but not collected by the bank.
  2. Bank charges of $50 were recorded in Passbook, but not in Cash Book.
  3. Cheques worth $200 were issued, but not presented for payment.
  4. Bank interest of $100 was recorded in Passbook, but not in Cash Book.

Solution: 

Bank Reconciliation Statement of Markson’s & Co. as on 31st March 2019

Popular Course in this category
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)250+ Online Courses | 1000+ Hours | Verifiable Certificates | Lifetime Access
4.9 (3,296 ratings)
Course Price

View Course

Related Courses
Finance for Non Finance Managers Course (7 Courses)Cost Accounting Course (5 Courses)US GAAP Course (29 Courses with 2020 Updated)

Bank Reconciliation Example -1.1

Bank Reconciliation Example – 2

Wright Inc. has a balance in a Passbook of $10,000 as on 31st December 2018. These are the other details:

  1. Three cheques of $2,000, $1,500 and $2,500 were deposited in the bank on 30th December 2018 but were recorded in the bank statement in January 2019.
  2. Cheque of $500 issued on 31st December 2018 was not presented for payment.
  3. A dividend of $1,000 on stocks was credited in Bank Account, but not recorded in Cash Book.
  4. A direct deposit of $400 was made in Bank Account by a customer, which was not recorded in Cash Book.
  5. Bank charges of $100 were entered only in Bank Passbook
  6. Balance as per Cash Book on 31st December 2018 was $14,200.

Solution: 

Bank Reconciliation Statement of Wright Inc. as on 31st December 2018Example -2.1

Bank Reconciliation Example – 3

Rutherford Inc. has a difference in the balance as per Cash Book and bank statement as on 31st March 2019. You are advised to prepare a Bank Reconciliation Statement as on that date with the following information:

  1. Balance as per Bank Statement as on 31st March 2019 is $4,000. Balance as per Cash Book is $1,400.
  2. Cheque of $1,000 and $500 issued as on 30th March 2019, but not yet cleared
  3. An insurance premium paid by bank $200. It is not yet recorded in Cash Book.
  4. An outgoing cheque of $2,000 recorded twice in the Cash Book. It is properly recorded in the bank statement.
  5. Payment of a cheque of $400 recorded twice in PassBook.
  6. Dividends received $500 recorded only in the bank statements and not Cash Book.
  7. Cheque of $700 deposited on 29th March 2019. But, it is not yet collected.
  8. Bank charges of $100 debited only in Bank PassBook.

Solution: 

Bank Reconciliation Statement of Rutherford Inc. as on 31st March 2019

Bank Reconciliation Example -3.1

Bank Reconciliation Example – 4

You are an Accountant in Jeffries Inc. You have prepared a Cash Book for March 2019. There is a difference in the balance as on 31st March 2019 between the bank statement and Cash Book. You are required to prepare a Bank Reconciliation Statement as on 31st March 2019. Below is the extract for the Cash Book and Bank statement for the month of March 2019.

Cash Book (March 2019) for Jeffries Inc

Cash Book -4.1

Bank statement (March 2019) for Jeffries Inc

Bank statement -4.1

Solution:

We first find the common items in the Cash Book and the Bank statement. The common items are:

Bank Reconciliation Example -4.3

The balance items would appear in the Bank Reconciliation Statement

Bank Reconciliation Example -4.4

Conclusion

Bank Reconciliation Statement is a valuable tool to identify differences between the balance as per Cash Book and bank statement. Bank reconciliation also helps in detecting some frauds and manipulations. It is a good practice to carry out this exercise at regular intervals, which helps in maintaining controls in the organization. This also keeps the Cash Book up to date as those transactions which are rightly recorded in the bank statement can be recorded in the Cash Book.

Recommended Articles

This has been a guide to the Bank Reconciliation Example. Here we discuss the Definition and top 4 practical Bank Reconciliation examples along with a detailed explanation and downloadable excel template. You can also go through our other suggested articles to learn more –

  1. Real life examples of Globalization
  2. Monopolistic Competition Examples
  3. Risk Assessment Example with
  4. Top 7 Examples of Opportunity Cost
  5. Guide to Bank Reconciliation Formula

All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)

250+ Online Courses

1000+ Hours

Verifiable Certificates

Lifetime Access

Learn More

1 Shares
Share
Tweet
Share
Primary Sidebar
Finance Blog
  • Accounting fundamentals
    • Earned Income
    • Explicit Cost
    • External Audit
    • Accrued Expense
    • Allowance for Doubtful Accounts
    • Depreciation Tax Shield
    • Accounts Receivable Financing
    • Audit Report Qualified Opinion
    • Audit Report
    • Audit Report Examples
    • Marginal Tax Rate
    • Marginal Tax Rate
    • Direct vs Indirect Cash Flow Methods
    • Salvage Value
    • Balance Sheet Analysis
    • Current Liabilities Examples
    • Debtor
    • Other Comprehensive Income
    • Period Costs
    • Inventories List
    • Marketable Securities in Balance Sheet
    • Gross Sales
    • Tax Haven
    • Interim Reporting
    • Date of Record of Dividends
    • Short Term Assets
    • Revenue Streams
    • Tax Planning
    • Accounts Receivable Journal Entry
    • Book Profit
    • Capital Budgeting Importance
    • Accounts Payable Cycle
    • Inventory Audit
    • Estimated Tax
    • Dividend Declared
    • SG & A Expenses
    • Tax Lien
    • Excise Tax Examples
    • Accelerated Share Repurchase
    • Accounting Ethics
    • Accounts Payable Credit or Debit
    • Accounting for Fair Value Hedges
    • Long Term Debt in Balance Sheet
    • Assets Example
    • Audit Assertions
    • Accounts Receivable Process
    • List of Operating Expenses
    • Income Tax Accounting
    • Non-Operating Expenses
    • Unrealized Gains and Loses
    • Warranty Expense
    • What is Budgeting?
    • WIP Inventory
    • Current Liabilities
    • Zero Based Budgeting
    • Types of Liabilities on Balance Sheet
    • Marginal Costing vs Absorption Costing
    • Non-Current Liabilities Examples
    • Cash Equivalents
    • Types of Assets
    • Assets List
    • Deferred Income Tax
    • Working Capital Management Importance
    • Extraordinary Items
    • Deferred Tax
    • Long Term Liabilities
    • Perpetual Inventory System
    • Intangible Assets Examples
    • Goodwill
    • Working Capital Loan
    • Consolidated Financial Statement
    • Contingent Asset
    • Cash and Cash Equivalents
    • Fixed Assets
    • Current Asset
    • Financial Assets Types
    • Financial Assets
    • Wasting Asset
    • Write off
    • Objectives of Financial Statement Analysis
    • Earnout
    • Hire Purchase
    • Sublease
    • Off Balance Sheet
    • Liabilities Example
    • Leasehold
    • Off Balance Sheet Financing
    • Revolving Credit Facility
    • General Reserve
    • Accounting Information System
    • Accounting Transaction
    • Limitations of Financial Statement Analysis
    • 3 Types of Inventory
    • Cook the Books
    • Non Performing Assets
    • Revenue Reserve
    • Commitments and Contingencies
    • Conservatism Principle of Accounting
    • Money Measurement Concept
    • Materiality Concept
    • Types of Accounting
    • Types of Financial Statements
    • Balance Sheet Items
    • Components of Financial Statements
    • Cost Method
    • Related Party Transactions
    • Relevance in Accounting
    • Responsibility Accounting
    • Tragedy of the Commons
    • Accounts Receivable Aging
    • Accounting Scandals
    • Cost Benefit Principle
    • Accrual Accounting Examples
    • Fiscal Year
    • Financial Statement Limitations
    • Grey List
    • Objectives of Financial Statements
    • What are Accounting Principles?
    • Accounting Controls
    • Users of Financial Statements
    • Accounting Cycle
    • Accounting Estimates
    • Window Dressing in Accounting
    • What are Accounting Policies?
    • Fringe Benefits
    • Full Disclosure Principle
    • Financial Statement Examples
    • Sunk Cost
    • Accounts Receivable Turnover Ratio
    • Days in Inventory
    • Current Ratio vs Quick Ratio
    • Investment Banking vs Private Equity
    • Private Equity vs Hedge Fund
    • Accounting Ratios
    • Shell Corporation
    • Cost Accounting Career
    • Funds from Operations
    • Accounting Career
    • Actuaries Career
    • General Ledger Accounting
    • Forensic Accounting Career
    • Auditing Career
    • Budgeting Career
    • Gross Profit Ratio
    • Management Accounting Career
    • Cycle Counting
    • Going Concern Concept
    • Debit Note vs Credit Note
    • EBIT vs Net Income
    • EBIT vs Operating Income
    • EBITDA vs Net Income
    • EBITDA vs Operating Income
    • GAPP vs Non-GAAP
    • Finance vs Lease
    • Gross sales vs Net sales
    • Income Tax vs Payroll Tax
    • Mortgage Banker vs Broker
    • Revenue vs Net Income
    • Shareholder vs Stakeholder
    • Stock Option vs RSU
    • Full Form of FYI
    • Return on Invested Capital
    • Transaction Exposure
    • LLC vs Partnership
    • Replacement Cost
    • Unit Contribution Margin
    • Accounts Payable vs Notes Payable
    • CA vs CS
    • Capitalizing vs Expensing
    • CPA vs CA
    • Trial Balance vs Balance Sheet
    • CA vs MBA
    • Merger Accounting
    • Cash Management
    • Sole Proprietorship vs LLC
    • Manufacturing Overhead
    • Asset Retirement Obligation
    • Temporary Account
    • Leveraged Lease
    • Predetermined Overhead Rate
    • Drag-Along Rights
    • Special Journal
    • Interest vs Dividend
    • Direct Materials
    • Accounting Method
    • Return on Sales
    • Calendar Year vs Fiscal Year
    • Contribution Margin Income Statement
    • Activity Based Budgeting
    • Common Size Income Statement
    • Capital Lease vs Operating Lease
    • Insolvency vs Bankruptcy
    • Vertical Analysis of Income Statement
    • Debt vs Equity Financing
    • Adjusted EBITDA
    • LLC vs Inc
    • Return on Average Capital Employed
    • Stocks vs Real Estate
    • Return on Equity
    • Return on Capital Employed
    • Diluted Earnings Per Share
    • Limited Partner vs General Partner
    • Basic EPS
    • Cash Flow Return on Investment
    • Fixed vs Variable
    • Public Company vs Private Company
    • Market Order vs Limit Order
    • Return on Total Assets
    • Hard Cost vs Soft Cost
    • Return on Average Assets
    • Ethereum vs Ethereum Classic
    • Capital Employed
    • Gross Profit Percentage
    • OIBDA
    • Average Collection Period
    • Profit Margin
    • EBITDA Margin
    • Working Capital Turnover Ratio
    • Marginal vs Effective Tax Rate
    • CFO vs Controller
    • Accounting Interview Questions
    • EBITDA
    • Asymmetric Information
    • Days Payable Outstanding
    • Journal Examples
    • Debit vs Credit
    • Lease vs Rent
    • Buying vs Leasing
    • Finance Job From Engineering
    • Days Inventory Outstanding
    • Horizontal Integration Example
    • Revenue Expenditure
    • Accounts Payable Turnover Ratio
    • Statement of Cash Flows
    • Days Sales Uncollected
    • Days Sales Outstanding
    • Statement of Income Example
    • Unadjusted Trial Balance
    • Red Herring Example
    • Revenue vs Turnover
    • Functions of Financial Market
    • Cost of Goods Sold Example
    • Operating Ratio
    • Stock Turnover Ratio
    • Bill of Sale Examples
    • Break Even Analysis Example
    • Financial Analysis Example
    • Statement of Retained Earnings Example
    • Equity Ratio
    • Long Term Liabilities Example
    • Defensive Interval Ratio
    • Operating Expense Example
    • Solvency Ratio
    • Capital Adequacy Ratio
    • Cash Flow From Operations Ratio
    • Working Capital Example
    • Cash Reserve Ratio
    • Quick Ratio
    • Loan Sharks
    • Fixed Asset Examples
    • Partnership Example
    • Standard Deviation Examples
    • Accounting vs CPA
    • Period Cost vs Product Cost
    • Cash Ratio
    • Investment vs Speculation
    • Annuity vs Lump Sum
    • Bank Draft vs Certified Cheque
    • Bidding vs Auction
    • Better in Business and Finance
    • Direct Tax vs Indirect Tax
    • Financial Ratio Analysis Technique
    • EPS and Diluted EPS
    • Stocks vs Bonds
    • IFRS Vs US GAAP
    • Finance Degree Career Options
    • Tax Slabs & Rates
    • Lease vs Buy
    • Interest Rate vs Annual Percentage Rate
    • Long Term vs Short Term Capital Gains
    • Memorandum of Association vs Article of Association
    • Large Cap vs Small Cap
    • CPA vs CMA
    • Assets vs Liabilities
    • Revenue vs Income
    • Bookkeeping vs Accounting
    • Financial Lease vs Operating Lease
    • EBIT vs EBITDA
    • Revenue vs Sales
    • Common stock vs Preferred stock
    • US GAAP vs IFRS
    • Current Account vs Capital Account
    • IFRS in India
    • Finance vs Economics
    • ACCA vs CIMA
    • Current Assets vs Non Current Assets
    • Economic Examples
    • Investment vs savings
    • Active vs Passive Investing
    • Financial Accounting vs Management Accounting
    • Revenue vs Earnings
    • Trade Discount vs Cash Discount
    • Limited Liability Company
    • Finance for Non Finance Professionals
    • Costs vs Expenses
    • Chapter 11 vs Chapter 13
    • Why Financial Analytics
    • Accounting vs Financial Management
    • ACA vs ACCA
    • ACCA vs CPA
    • Budget vs Forecast
    • Positive Economics vs Normative Economics
    • CA vs ACCA
    • Stakeholders Example
    • Stock vs Options
    • Liquidity vs Solvency
    • Stock vs Equities
    • Franchising vs Licensing
    • GDP vs GNP
    • Inflation vs Deflation
    • Economic Growth vs Economic Development
    • Direct cost vs Indirect Cost
    • Accrual Accounting vs Cash Accounting
    • FCFF vs FCFE
    • Public vs Private Accounting
    • Capex vs Opex
    • BSE vs NSE
    • Loans vs Advances
    • Discount Rate vs Interest Rate
    • ROIC vs ROCE
    • Percentage Of Completion Method
    • 10K vs 10Q
    • Shares Outstanding vs Float
    • Contribution Margin vs Gross Margin
    • Short Term vs Long Term Capital Gains
    • General Journal vs General Ledger
    • Outsourcing vs Offshoring
    • Depreciation vs Amortization
    • Liability vs Debt
    • Asset Purchase vs Stock Purchase
    • Accrual vs Provision
    • Actuary vs Accountant
    • Stock vs Inventory
    • Liability vs Expense
    • Dividends EX-Date vs Record Date
    • Bid Price vs Ask Price
    • Dividend vs Growth
    • Time vs Money
    • IRA vs 401 (k)
    • Corporation vs LLC
    • CEO vs President
    • Margin vs Markup
    • Leasehold vs Freehold
    • Lending vs Borrowing
    • Non-Profit vs Not For Profit
    • Corporation vs Incorporation
    • CFO vs CEO
    • Purchase vs Procurement
    • Deficit vs Debt
    • Internal Audit Vs External Audit
    • C Corp vs S Corp
    • Absolute Advantage vs Comparative Advantage
    • Tangible vs Intangible
    • Executive Director vs Managing Director
    • Company vs Firm
    • Insurance vs Assurance
    • Expense vs Expenditure
    • Hard Money vs Soft Money
    • Entrepreneurship vs Management
    • Loan vs Mortgage
    • Fair Value vs Market Value
    • Chief Executive Officer vs Managing Director
    • Manufacturing vs Production
    • Random Error vs Systematic Error
    • 401(K) vs Roth IRA
    • 403(b) vs 457
    • Adjusting Entries
    • Equity vs Commodity
    • Turnover vs Profit
    • Effective Interest Rate
    • Working Capital Ratio
    • Margin vs Profit
    • Loan vs Lease
    • Shares vs Debentures
    • Equity vs Fixed Income
    • Market Equilibrium
    • Economics vs Business
    • Secured vs Unsecured Credit Card
    • Profitability vs Liquidity
    • Z score vs T score
    • Equity vs Asset
    • Geometric Mean vs Arithmetic Mean
    • Cost vs Price
    • Industry vs Sector
    • ShortSale vs Foreclosure
    • Revenue vs Profit
    • Real Interest Rate
    • Account Payable vs Accrued Expense
    • Day Trading vs Swing Trading
    • Indirect Costs
    • Graphs vs Charts
    • Issued Shares vs Outstanding Shares
    • Creditor vs Debtor
    • Annuity vs IRA
    • Pension vs Annuity
    • Debt Consolidation vs Bankruptcy
    • Equity vs Shares
    • Economic Utility
    • Average vs Weighted Average
    • Operating Profit vs Net Profit
    • Purpose of Income Statement
    • NASDAQ vs Dow Jones
    • Direct Method of Cash Flow Statement
    • Real GDP
    • Derivatives Example
    • Nominal GDP
    • Generally Accepted Accounting Principles
    • Cost of Sales vs Cost of Goods Sold
    • Historical Value vs Fair Value
    • General Ledger vs Trial Balance
    • Actual Cash Value vs Replacement Cost
    • Job Costing vs Process Costing
    • Standard Cost vs Actual Cost
    • 401k vs Annuity
    • FIFO vs LIFO
    • Bid Price vs Offer Price
    • Sole Proprietorship vs Partnership
    • Equity Shares vs Preference Shares
    • Debt vs Equity
    • Cost Accounting vs Financial Accounting
    • Coupon vs Yield
    • Career in Finance
    • Gross Salary vs Net Salary
    • Tax Credit vs Tax Deduction
    • Variance vs Standard Deviation
    • What is Disposable Income
    • Liabilities in Accounting
    • Chapter 7 vs Chapter 11
    • Budgeting Examples
    • Fixed Costs Example
    • Joint Venture Example
    • Quantitative Research Example
    • Bootstrapping Examples
    • Monopoly Examples
    • Monopolistic Competition Examples
    • Risk Assessment Example
    • Inflation Accounting
    • Defined Benefit Plan
    • Variable Costing Example
    • Acquisition Examples
    • Cognitive Dissonance Example
    • Opportunity Costs Examples
    • Globalization Example
    • Histogram Examples
    • Mean Example
    • Trial Balance Example
    • Command Economy Examples
    • Sunk Cost Examples
    • Compounding Example
    • Compound Interest Example
    • Profit vs Income
    • Joint Venture vs Partnership
    • Comparative Advantage Example
    • Bank Reconciliation Example
    • Competitive Advantage Example
    • Accrual vs Deferral
  • Asset Management Tutorial (117+)
  • Banking (43+)
  • Corporate Finance Basics (126+)
  • Credit Research Fundamentals (6+)
  • Economics (44+)
  • Finance Formula (372+)
  • Financial Modeling in Excel (13+)
  • Investment Banking Basics (60+)
  • Investment Banking Careers (26+)
  • Trading for dummies (66+)
  • valuation basics (25+)
Finance Blog Courses
  • Finance for Non Finance Managers Certification
  • Cost Accounting Course
  • US GAAP Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Investment Banking Jobs Offer
  • Finance Formula
  • All Tutorials
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course

© 2020 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA Login

Forgot Password?

EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

*Please provide your correct email id. Login details for this Free course will be emailed to you
Book Your One Instructor : One Learner Free Class

Let’s Get Started

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

EDUCBA

Download Bank Reconciliation Example Excel Template

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) Learn More