Note:
This section will provide you guidelines on how to prepare balance sheet of your business.
The statement templates provided, serve as a guide towards bare minimum line items that may be included in the financial statements. Please note that complete set of financial statements includes: income statement, balance sheet and cash flows along with explanatory notes. Further, you may seek professional guidance for preparation of formal financial statements, if deemed necessary.
Entries in this template that are marked in black indicate use of formulae. Please avoid tempering with formulae based entries.
Balance Sheet (Amount in Rs.)
Assets
                                                     
Current Assets Assets of the business having a life of less than a year. Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
A Cash  Cash available with the business, at office or in the bank account.            
B Accounts Receivables Amount to be received on account of credit sales.            
C Inventories Stock of raw material, work in process, finished goods, store and spares.            
D Pre Paid Expenditures  Expenses paid in advance, egg, advance building rent, insurance premium, lease payment etc.            
E Total Current Assets (A+B+C+D) 0 0 0 0 0 0
Fixed Assets Assets having a life of more than one year and acquired for permanent use in the business. Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
F Land Cost of the land used for office or factory (no depreciation).            
G Building/
Infrastructure		 Cost of the building and infrastructure used for office or factory minus accumulated depreciation.            
H Machinery & Equipment Cost of machinery and equipment minus accumulated depreciation.            
I Furniture & Fixtures Cost of furniture and fixture (electricity fittings etc) minus accumulated depreciation.            
J Office Vehicles Cost of office vehicles (if any) minus accumulated depreciation.            
K Office Equipment Cost of office equipment (printers, computers, fax, telephone etc) minus accumulated depreciation.            
L Total Fixed Assets (F+G+H+I+J+K) 0 0 0 0 0 0
                                                     
Total Assets (E+L) 0 0 0 0 0 0
Liabilities
                                                     
Current Liabilities Liabilities which are payable with in a period of one year. Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
M Accounts Payable The amount payable to the creditors of the business for example the suppliers of raw material.            
N Short Term Debt Outstanding amount of the amount representing short term debt acquired for working capital.            
O Other Liabilities Other trade liabilities, if any.            
P Total Current Liabilities (M+N+O) 0 0 0 0 0 0
                                                     
Long Term Liabilities Liabilities which are payable after a period of one year or more. Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Q Long Term Loan Outstanding balance of the amount acquired from the bank as a long term loan, lease facilities, etc.            
R Total Long Term Liabilities (Q) 0 0 0 0 0 0
                                                     
Equity The investment of the owners / partners / shareholders. Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
S Capital Contribution of owners towards the business commonly referred as owners' equity.            
T Retained earnings Amount retained from the annual revenue.            
U Total Equity (S+T) 0 0 0 0 0 0
                                                     
Total Liabilities and Equity (P+R+U) 0 0 0 0 0 0
Total of Assets and Liabilities should be equal. 0 0 0 0 0 0