Finxora Logo
Sign In
Balance Sheet Format in Excel for Small Business: Example
Back to Blog

Balance Sheet Format in Excel for Small Business: Example

FINXORA
6 min read
balance sheet
excel
accounting
small business
finance

Build a small business balance sheet in Excel with a rupee example, exact cell formulas, capital reconciliation and checks before sharing it with your bank.

Build the format around your books and business type

A balance sheet shows a business's assets, liabilities and owner's funds on a particular date. For a small Indian business, an Excel workbook can provide a clear working format for management review and discussions with a bank. The basic equation is Assets = Liabilities + Owner's Funds. Each amount should come from reconciled records rather than an estimate entered to make the statement balance.

The example below is a simplified proprietorship statement. It uses proprietor's capital rather than company share capital. A partnership needs partner-wise capital details, while a company's financial statements require the applicable Schedule III presentation and disclosures. A short spreadsheet example is not a substitute for the financial statements required for a particular entity or purpose.

Gather the records before entering figures

Start with an adjusted trial balance at the reporting date. Reconcile bank accounts, cash, receivables, payables, stock and loans. Confirm that year-end purchases, sales, expenses and other adjustments have been posted. The profit transferred into capital must come from the same accounting period as the balance sheet.

  • Obtain the trial balance and the previous closing balance sheet.
  • Prepare customer and supplier schedules, including disputed or overdue amounts.
  • Confirm closing stock quantity and valuation from supporting records.
  • Reconcile fixed assets, additions, disposals and depreciation.
  • Separate loan principal, interest and repayments using lender statements.
  • Prepare the proprietor's opening capital, additions, profit and drawings schedule.

Keep unresolved differences in a separate review list. Do not place them in cash, capital or miscellaneous assets merely to produce equal totals. The cause may be an omitted balance, a duplicate entry or an adjustment that belongs in the profit and loss account.

Set up a practical Excel workbook

Use separate sheets for source balances, adjustments, supporting schedules and the final balance sheet. On the final sheet, put the business name in A1, the title in A2, the reporting date in A3 and the unit in A4. For this example, enter Particulars in A5 and Amount in Rs in B5. All amounts below are whole rupees.

Use numeric cells for amounts; apply number formatting instead of typing a currency symbol into the cell. Keep input cells visually distinguishable from formulas. Add a previous-year column when needed, but use the same classification and unit for both years. Record the workbook's preparation date and version so a bank submission can be traced back to the reviewed file.

Worked balance sheet example in rupees

Assume a proprietor has closing capital of Rs 6,00,000, a term loan split between long-term and current portions, trade creditors and outstanding expenses. Assets include equipment after depreciation, closing stock, receivables, cash and prepaid expenses. Enter the following rows exactly to use the formulas in the next section.

Excel rowParticulars in column AAmount in column B
6Proprietor's closing capital6,00,000
7Term loan: non-current portion3,00,000
8Term loan: current portion1,00,000
9Trade payables2,00,000
10Outstanding expenses50,000
11Total capital and liabilities12,50,000
12Equipment: net carrying amount5,00,000
13Closing inventory3,00,000
14Trade receivables2,50,000
15Cash and bank balances1,50,000
16Prepaid expenses50,000
17Total assets12,50,000
18Difference: assets less capital and liabilities0

The illustration has liabilities of Rs 6,50,000 and capital of Rs 6,00,000. Together they finance assets of Rs 12,50,000. The current portion of the term loan is shown separately so the reader can distinguish near-term obligations from the remaining borrowing. Check classification against the reporting framework and loan terms in an actual file.

Enter formulas that match the layout

In B11, enter =SUM(B6:B10). In B17, enter =SUM(B12:B16). In B18, enter =B17-B11. The difference should be zero. Keep subtotal rows outside the ranges for other totals so a later change does not count the same amount twice.

For a visible status message, A19 can say Balance check and B19 can contain =IF(ROUND(B18,2)=0,"Balanced","Review difference"). This tests agreement at two decimal places. Retain full precision in the underlying figures and review rounding separately; do not use a large tolerance to conceal an unexplained difference.

For review purposes, B20 can calculate current assets with =SUM(B13:B16), giving Rs 7,50,000. B21 can calculate current liabilities with =SUM(B8:B10), giving Rs 3,50,000. B22 can calculate the current ratio with =IF(B21=0,"Not applicable",B20/B21). The result is approximately 2.14. This is an illustration, not a universal bank acceptance threshold.

Reconcile the capital figure separately

Suppose opening capital is Rs 4,00,000, additional capital introduced is Rs 1,00,000, profit for the year is Rs 1,80,000 and drawings are Rs 80,000. Closing capital is Rs 4,00,000 + Rs 1,00,000 + Rs 1,80,000 - Rs 80,000 = Rs 6,00,000. This supports B6 in the example.

In a separate capital schedule, enter these four inputs in B2 to B5 respectively and calculate closing capital in B6 using =B2+B3+B4-B5. Link the final statement to that total. A partner's capital account or company reserves schedule needs its own treatment; the proprietor's drawings model should not be copied into every entity format.

Review common accounting and spreadsheet errors

Equipment should be supported by a fixed asset schedule showing cost, additions, disposals and depreciation. A purchase of equipment should not remain entirely within routine expenses if it requires capitalisation under the applicable accounting policy. Avoid deducting depreciation twice when the imported trial balance already contains net asset balances.

Reconcile bank balances after timing items and unposted transactions. Assess customer balances and stock valuation using the relevant accounting policies and supporting evidence. A term loan statement may include charges or interest that do not form part of principal. Personal payments and proprietor's drawings require review rather than automatic classification as business expenditure.

In Excel, inspect broken links, hidden rows, overwritten formulas and totals excluding newly inserted accounts. Equal totals demonstrate arithmetic agreement, not completeness or correct classification. Compare the profit and loss account, capital schedule and prior-year opening balances before signing off.

For the related preparation guidance, see automatic balance sheet generator.

Prepare a version suitable for sharing

Set a readable print area, repeat headings across pages and state whether the figures are provisional, projected or based on final accounts. Attach schedules that explain material balances. Keep source detail in the working file and review the exported version so columns, negative signs and units remain readable.

When you need linked statements and entity-specific layouts, Finxora's balance sheet software provides balance sheets with supporting statements and PDF, Word and Excel exports. It also supports trial balance import through Tally XML, with mapping reviewed before import. Check the sample reports for presentation and the balance sheet plans for current options. Source reconciliation and professional review remain essential whichever preparation method you choose.

Frequently Asked Questions

Published on March 17, 2026

Updated on November 18, 2026

Back to Blog

Need bank-ready financials? Create a CMA report or a project report with Finxora in minutes.