Excel Accounting Templates India: Free Downloadable Templates for Small Business

Why Excel Remains Relevant for Indian Small Business Accounting

Despite the proliferation of cloud accounting software, Microsoft Excel continues to serve as the primary accounting tool for millions of Indian micro and small enterprises. India has approximately 63 million MSMEs, and estimates suggest that fewer than 15 percent use dedicated accounting software. The remaining businesses rely on manual registers, Excel spreadsheets, or basic bookkeeping apps. For these businesses, well-designed Excel templates represent a significant step up from manual bookkeeping without the learning curve or subscription cost of specialized software.

Excel's strengths for small business accounting include universal familiarity -- most commerce graduates and business owners have basic spreadsheet skills, zero subscription cost for businesses already using Microsoft Office or Google Sheets, complete flexibility to customize templates for specific business needs, powerful formula capabilities that can automate calculations when properly configured, and the ability to serve as a stepping stone before migrating to dedicated software. The key limitation is that Excel does not enforce double-entry accounting rules automatically, requires discipline to maintain accuracy, lacks built-in audit trails, and becomes unwieldy when transaction volumes exceed a few hundred per month.

This guide provides templates designed specifically for Indian business requirements, incorporating GST compliance fields, Indian accounting conventions, and formulas that automate common calculations. Each template includes data validation to reduce entry errors, conditional formatting for visual quality checks, and protection on formula cells to prevent accidental overwrites.

Template Design Principles

Cash Book and Bank Book Template

The cash book is the foundation of small business bookkeeping. It records every cash receipt and payment in chronological order, providing a real-time view of cash position. For Indian businesses, the cash book serves dual purposes -- operational cash management and compliance with Section 44AA of the Income Tax Act, which requires maintenance of books of accounts for certain categories of taxpayers.

Cash Book Template Structure

The template consists of a receipts side (debit) and payments side (credit), following the traditional double-column cash book format. Each entry includes the date, voucher reference number, description of the transaction, account head classification (using a dropdown list for consistency), receipt or payment amount, and a running balance calculated automatically. A separate section at the bottom of each monthly sheet provides automatic totals for each account head using SUMIF formulas, which feed into the general ledger.

Key Formulas in the Cash Book

Running Balance: The running balance formula for each row is straightforward -- previous balance plus current receipt minus current payment. The formula in cell G3 would be =G2+E3-F3, where G is the balance column, E is receipts, and F is payments. Conditional formatting highlights the balance in red if it goes below zero, immediately flagging potential errors since cash balance cannot be negative.

Monthly Account-wise Summary: At the bottom of each month's sheet, SUMIF formulas aggregate transactions by account head. The formula =SUMIFS(E:E,D:D,"Sales Revenue",A:A,">="&DATE(2026,4,1),A:A,"<"&DATE(2026,5,1)) totals all sales receipts for April 2026. These summaries automatically post to the general ledger sheet, eliminating manual posting.

Bank Book Variation

The bank book template mirrors the cash book structure but adds columns for check number, bank reference number, and a reconciliation status flag. The reconciliation column uses a dropdown (Cleared/Pending/Void) that enables quick bank reconciliation at month-end. A separate reconciliation sheet pulls pending transactions to compute the reconciled bank balance, comparing it against the bank statement balance.

General Ledger Template

The general ledger maintains individual account records showing all transactions posted to each account during the period. While accounting software handles ledger posting automatically, an Excel-based ledger requires either manual posting or formula-driven automation from the cash book and bank book templates.

Ledger Template Structure

Each account occupies a dedicated sheet or section within the ledger workbook. The structure includes columns for date, journal reference (voucher number linking back to the cash book entry), description, debit amount, credit amount, and running balance. The account header shows the account code, name, opening balance, and account type (asset, liability, income, or expense). At the bottom, the closing balance is calculated as opening balance plus total debits minus total credits (for asset and expense accounts) or opening balance plus total credits minus total debits (for liability, equity, and income accounts).

Automated Posting Using SUMIFS

For a semi-automated approach, create a transaction journal sheet where all entries are recorded centrally with debit and credit account columns. Then use SUMIFS formulas on each ledger account sheet to pull relevant transactions. For the Sales Revenue ledger, the formula =SUMIFS(Journal!F:F,Journal!E:E,"Sales Revenue") pulls all credit entries posted to Sales Revenue. This approach maintains the single entry point advantage of a journal while automatically distributing entries to individual ledgers.

Trial Balance Template

The trial balance is a listing of all ledger account balances at a specific date, serving as the first check on arithmetic accuracy of the books. If the total of debit balances equals the total of credit balances, the books are arithmetically correct (though not necessarily free from errors like errors of omission or compensating errors).

Trial Balance Template Structure

The template pulls closing balances from each ledger account using cell references or VLOOKUP formulas. It organizes accounts into standard categories -- assets, liabilities, equity, income, and expenses -- with debit and credit columns. The totals row computes the sum of each column, and a variance cell highlights any difference between total debits and total credits. Conditional formatting turns the variance cell green when balanced (zero variance) and red when unbalanced, providing an immediate visual check.

Using the Trial Balance for Error Detection

When the trial balance does not balance, systematic error detection involves checking the difference amount. If the difference is divisible by 9, suspect a transposition error (digits reversed, like 54 entered as 45). If the difference is divisible by 2, suspect a posting to the wrong side (debit instead of credit). If the difference matches a specific transaction amount, suspect an omitted posting. These heuristics, combined with cell tracing in Excel (Formulas > Trace Precedents), help locate errors efficiently.

Profit and Loss Statement Template

The profit and loss statement (income statement) summarizes revenue and expenses for a specified period, showing the net profit or loss. For Indian small businesses, this statement also forms the basis for computing taxable income under the Income Tax Act.

P&L Template Structure for Indian Businesses

The template follows the Indian accounting format with the following structure: Revenue from Operations (domestic sales, export sales, service income), Other Income (interest, rental, miscellaneous), Total Revenue, Cost of Materials Consumed or Cost of Services, Employee Benefit Expenses (salaries, PF, ESI, gratuity), Depreciation, Other Expenses (broken into categories like rent, communication, travel, professional fees, insurance, repairs, bank charges), Total Expenses, and Profit Before Tax. Additional lines show tax provisions (current tax, deferred tax) and Profit After Tax.

Key Formulas and Features

Revenue and expense amounts pull automatically from the trial balance template using SUMIF or direct cell references. Percentage calculations show each expense as a proportion of total revenue, enabling quick identification of cost categories that are disproportionately high. A comparison section shows the previous period's figures alongside current period for trend analysis. Gross margin, operating margin, and net margin percentages are calculated automatically, providing the key profitability metrics that business owners and lenders look for.

Balance Sheet Template

The balance sheet presents the financial position of the business at a specific date, listing assets, liabilities, and equity. For Indian companies, the format follows Schedule III of the Companies Act 2013, while for sole proprietors and partnerships, a simplified format is acceptable.

Balance Sheet Template Structure

The balance sheet template includes an automatic balancing check -- Total Assets must equal Total Liabilities plus Equity. A prominent cell at the top displays "BALANCED" in green or "NOT BALANCED - Difference: Rs X" in red, providing immediate feedback on whether all entries have been correctly captured and classified.

GST Compliance Templates

GST compliance requires maintaining detailed records of all taxable transactions. Three Excel templates are essential for GST-registered Indian businesses: the GST Sales Register, GST Purchase Register, and GST Summary and Reconciliation template.

GST Sales Register

This template records all outward supplies with columns for invoice number, invoice date, customer name, customer GSTIN, place of supply (state code), HSN/SAC code, taxable value, CGST rate and amount, SGST rate and amount, IGST rate and amount, cess amount, total invoice value, and transaction type (B2B, B2C, Export, SEZ). SUMIFS formulas at the bottom categorize transactions exactly as required for GSTR-1 filing -- B2B invoices by state, B2C large invoices, B2C small invoices aggregated by rate, export invoices, and credit/debit notes.

GST Purchase Register

Mirror of the sales register but for inward supplies. Additional columns track whether ITC is eligible, whether reverse charge applies, and the ITC category (inputs, capital goods, input services). This register feeds into the GSTR-3B preparation by summarizing total inward supplies, ITC eligible amounts broken into CGST, SGST, and IGST components, and reverse charge liability.

GST Reconciliation Template

This critical template compares your purchase register data with GSTR-2A/2B data downloaded from the GST portal. Using VLOOKUP on supplier GSTIN and invoice number, the template identifies matched invoices, mismatched amounts, invoices in your books but not in GSTR-2A (potential ITC at risk), and invoices in GSTR-2A but not in your books (potential unrecorded purchases). This reconciliation is essential for maximizing legitimate ITC claims while avoiding claims on invoices not filed by suppliers.