WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Accounting Tutorials » Bookkeeping Tutorials » Balance Sheet Reconciliation

Balance Sheet Reconciliation

Balance Sheet Reconciliation is the reconciliation of the closing balances of all the accounts of the company that forms part of the company’s balance sheet in order to ensure that the entries passed to derive the closing balances are recorded and classified properly so that balances in the balance sheet are appropriate.

What is a Balance Sheet Reconciliation?

Reconciliation of balance sheet simply means the reconciliation of closing balances of all transactional and ledger entries and accounts. It forms part of the balance sheet items for a respective financial year and whether it is being recorded and properly classified, making up to the balances appropriately in the balance sheet. It is a final and crucial activity that the company performs to ensure the accuracy of its financial statements before the closing of its books at the end of the financial cycle.

Balance Sheet Reconciliation

Types/Components of Balance Sheet Reconciliation

There are two types of formats in which a balance sheet can be prepared. One is the horizontal format or called the T-format, and the other format is the Vertical Format. The contents in both the format are, however, the same. It is only the way it gets presented is different. Presently the vertical format is widely being in use.

The components of the balance sheet comprise data, which would either increase or decrease revenue. Hence many of these would have already been computed. In contrast, the preparation on income and expense / Profit and Loss statements, and a few would be carried forward from the previous year’s balances shall merely have the final balances available in these accounts.

Ideally, a balance sheet would have the following components:- “Assets, Liabilities, and Owner’s Equity.”

  • Assets are items that would likely increase or generate revenue for the company—examples: cash, receivables, inventory, prepaid expenses, and fixed assets, etc.
  • Liabilities are items which would likely decrease the revenue for the company. Examples: Debts, accounts payable, payroll and taxes payable, notes payable, deferred revenue, and customer deposits, etc.
  • There is no such formula to calculate the balance sheet as it is a statement to match the total liabilities with total assets. However, this can be represented in the following form:- Assets + Owners Equity = Liabilities.

Balance Sheet Reconciliation Template

Given Below is the Template of the Balance sheet reconciliation.

Popular Course in this category
Sale
Bookkeeping Course
4.5 (241 ratings)
1 Online Courses | 3+ Hours | Verifiable Certificate of Completion | Lifetime Access
View Course
Company Name
Balance Sheet as at MM/DD/YYYY
 
Fixed assets
Intangible assets xxx It is the total value of development costs incurred by the business plus the cost of the license it holds for selling its goods.
Tangible assets xxx It is the cost of the business premises, furniture
and equipment, less depreciation charged since first using the assets
Investments xxx It is the value of shares owned in DEF Utilities PLC
xxx
Current assets 
Stock xxx It is the total value of goods bought from suppliers that have not yet been sold plus raw materials held for production plus the value of work in progress.
Debtors
Trade debtors xxx It is the total of the amounts customers owe, less bad debts and amounts considered uncollectable
Prepayments and accrued income xxx It is the maintenance fee payable annually in advance to the computer software company.
xxx
Cash at bank and in hand xxx It is the total of cash kept on site and the balance on the business’ current account with the bank.
xxx
Creditors: amounts falling due within One Year Also known as current liabilities – liabilities are shown as negatives because they are amounts owed by the business.
Bank loans and overdrafts xxx It is the portion of the business’ bank loan, which is due to be repaid in the next twelve months.
Trade creditors xxx It is the total of the amounts owed by the business to its suppliers for goods it bought to sell to its customers.
Other creditors including tax and social security xxx It is the value of tax and national insurance contributions deducted from employee salaries that have not yet been paid over to the Inland Revenue.
Accruals and deferred income xxx It includes interest due to the bank loan since the last repayment.
xxx
Net current assets  xxx Also known as working capital – this shows the business’ ability to meet current obligations.
Total assets less current liabilities xxx
Creditors: amounts falling due after more than one year
Bank loan xxx It is the portion of the business’ bank loan, which is due to be repaid in over one year.
Net assets xxx
Capital and reserves
Called up share capital xxx These are the funds invested by the owners in the business, e.g., to finance its assets.
Profit and loss account xxx These are the profits made since the start of the business, fewer expenses, and amounts paid to the owners as dividends.
Shareholders’ funds xxx

Examples of Balance Sheet Reconciliation

Now, let’s see some examples of the Balance sheet reconciliation.

Balance Sheet Reconciliation Example #1

Following is the trial balance of M/S ABC at the end of the year. Prepare a balance sheet for the same.

balance sheet reconcilation example 1.1

Solution:

Below is the reconciliation of the Balance Sheet.

balance sheet reconcilation example 1

We note here that the total net assets are equal to total net liabilities (740,000)

Balance Sheet Reconciliation Example #2

At the end of March, 20X6 the balances in the various accounts of ABC & Company are as follows:

example 2.1 - ABC & Company

Prepare the balance sheet of ABC & Company as per the format.

Solution:

Below is the balance sheet reconciliation.

example 2 - ABC & Company

Again, we see that the total assets are equal to total liabilities.

Advantages

Reconciling of balance sheet shall provide many and multiple benefits. However, a few of the key and main benefits are:

  • Eliminates accounting errors
  • To better understand and evaluate the financial strength of the company

Disadvantages

Manual reconciliation of balance sheets or any accounts is prone to have errors due to the manual intervention involved. Hence it involves a risk of data manipulation, missing the recording of data, etc.

Recommended Articles

It has been a guide Balance Sheet Reconciliation. Here we discuss how to reconcile the Balance sheet using closing balances, ledger entries, and accounting transactions along with practical examples. You can learn more about accounting from the following articles –

  • Balance Sheet Ratios
  • How to Read a Balance Sheet?
  • Examples of Balance Sheet
  • Equation of Balance Sheet
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* 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
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

Login

Forgot Password?

WallStreetMojo

Free Accounting Course

You will Learn Basics of Accounting in Just 1 Hour, Guaranteed!

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

New Year Offer - Bookkeeping Course View More