Provided by the International Finance Corporation
Some describe the balance sheet as a “snapshot” of the company’s financial position at a point (a moment or an instant) in time. For example, the amounts reported on a balance sheet dated December 31, 2012 reflect that instant when all the transactions through December 31 have been recorded. It summarizes the company’s assets, liabilities and shareholders’ equity at a specific point in time. The three balance sheet segments in the Excel file below give investors an idea as to what the company owns and owes, as well as the amount invested by the shareholders. This is intended to be a simple and practical tool to be adjusted and used by SMEs working in all sectors. You may adapt it to reflect your business needs, type of clientele, products and services you offer. It provides the minimum information required by financial institutions for assessing loan applications, tax authorities and potential investors.
Although the template is an example of a balance sheet for a sole proprietorship, you can quickly modify it for a corporation or partnership. You can add or delete account titles, revise the format, or otherwise modify it to suit your needs.
File Description: The file contains a Microsoft Excel spreadsheet template. Once you’ve downloaded the file, you must copy it to your EXCELXLSTART directory in order to use it.
- Download this balance sheet template just once, and be able to use it over and over again
- The spreadsheet contains the essential items that need to be considered when preparing a balance sheet
- The spreadsheet can be completely customized – you can quickly add or delete items or revise the format to meet your needs
- The spreadsheet is easy to use. Just plug in your numbers and it will automatically compute all the subtotals and totals and even tell you if your balance sheet doesn’t balance
Copyright © 2000 – 2017, International Finance Corporation. All Rights Reserved.
2121 Pennsylvania Avenue, N.W., Washington, D.C. 20433, www.ifc.org
The material in this work is copyrighted. Copying and/or transmitting portions or all of this work without permission may be a violation of applicable law. IFC does not guarantee the accuracy, reliability or completeness of the content included in this work, or for the conclusions or judgments described herein, and accepts no responsibility or liability for any omissions or errors (including, without limitation, typographical errors and technical errors) in the content whatsoever or for reliance thereon.