Small Business Accounting in Excel: A Practical System

Last updated: 27 June 2026

Indian SMBs can run a legally compliant, auditor-ready accounting system entirely in Excel — no paid software required. The five-step framework (chart of accounts → cash book → ledger → trial balance → financial statements) covers every record an Indian business owner must maintain under the Income Tax Act and Companies Act 2013.

Key takeaways

• Section 44AA of the Income Tax Act requires most businesses and professionals to maintain books of accounts; failure attracts penalties under Section 271A.
• The tax-audit threshold is ₹1 crore turnover for businesses (raised to ₹10 crore if at least 95% of receipts and payments are digital).
• For professionals (doctors, lawyers, architects, etc.), the audit threshold is ₹50 lakh gross receipts.
• Companies must prepare financial statements per Schedule III of the Companies Act 2013, including a classified balance sheet.
• A well-structured Excel workbook with separate sheets for each accounting record replicates most of what SMB accounting software does.
• GST filing depends on accurate sales and purchase ledgers — Excel built right feeds into your GSTR returns.
• Free Ankeshan templates are pre-formatted to Indian standards and require no sign-up to download.

Fact box — Who must keep books of accounts under Section 44AA? A person carrying on a non-specified business or profession must maintain books if income from it exceeds ₹1.2 lakh, or total turnover/gross receipts exceed ₹10 lakh, in any of the three preceding years (a new business is covered if income or turnover is likely to exceed these limits in the first year). For specified professionals (medical, legal, engineering, accountancy, architectural, interior decoration, film, authorised representative, company secretary), Rule 6F requires prescribed books once gross receipts exceed ₹1.5 lakh in any of the three preceding years. Source: Income Tax Act 1961, Section 44AA(2) read with Rule 6F.

Fact box — Tax-audit thresholds (Assessment Year 2026-27)

Category	Threshold
Business (cash-heavy)	₹1 crore turnover
Business (≥95% digital receipts & payments)	₹10 crore turnover
Profession	₹50 lakh gross receipts
Presumptive (Sec 44AD opted-out)	Audit if income declared below 6%/8% and total income exceeds the basic exemption
Source: Sections 44AB and 44AD, Income Tax Act 1961 (Assessment Year 2026-27). Confirm the audit trigger for your fact pattern with your CA.

Why Excel still makes sense for Indian SMBs

Many small business owners start with spreadsheets before graduating to accounting software. For a micro or small enterprise — under ₹2.5 crore investment and ₹10 crore turnover for Micro; under ₹25 crore investment and ₹100 crore turnover for Small (as per the revised MSME classification effective 1 April 2025) — a well-designed Excel system is often sufficient for years.

The advantages are real: no subscription cost, no internet dependency, full data ownership, and a system your accountant can open without installing anything. The disadvantage is discipline — Excel will not stop you from making errors the way double-entry software does. That is why structure matters.

What accounting records does an Indian SMB actually need?

Regardless of your legal structure, you will need:

1. Cash book — primary record of every cash and bank transaction, in order of date.
2. Sales register — all outward supplies, with GST details per invoice.
3. Purchase register — all inward supplies, with ITC eligibility.
4. General ledger — all accounts classified (assets, liabilities, income, expenses, equity).
5. Trial balance — periodic proof that debits equal credits.
6. Profit and loss statement — income less expenses for the financial year.
7. Balance sheet — snapshot of assets, liabilities, and net worth.

Companies additionally need:

• Schedule III compliant balance sheet (vertical format with sub-classifications)
• Statement of changes in equity (for companies reporting under Ind AS)
• Notes to accounts

Sole proprietorships and partnerships have more flexibility in format but must still be able to support an audit if triggered.

The 5-step Excel accounting system

Step 1 — Chart of accounts

The chart of accounts (COA) is the master list of every account you will use. Think of it as the index of your accounting system. A typical Indian SMB COA groups accounts into five categories:

The COA drives every other sheet. Each account gets a unique code (e.g., 1001 = Cash, 2001 = Trade creditors). A consistent code structure lets you use SUMIF to pull balances automatically.

See the full guide: Chart of accounts for Indian business — Excel template

Step 2 — Cash book / day book

Every cash and bank transaction enters the cash book first. This is the primary book of entry — the raw daily log. A double-column cash book tracks cash and bank side by side. A well-designed Excel cash book maintains a running balance automatically using an IF formula.

See: Cash book format in Excel — free template

Step 3 — General ledger

Transactions from the cash book (and sales/purchase registers) post to the general ledger — one sheet or table per account. The ledger classifies and accumulates totals. At any point you can extract the closing balance for any account.

See: Build a general ledger in Excel

Step 4 — Trial balance

The trial balance is the list of all account closing balances at a point in time — debit balances in one column, credit balances in the other. If they agree, the arithmetic is correct. If not, something has been entered only once or with the wrong sign.

See: Trial balance in Excel — how to prepare and check

Step 5 — Financial statements

The trial balance feeds two primary statements:

• Profit and loss (income statement) — shows whether you made money in the period.
• Balance sheet — shows what you own and what you owe at year-end.

Companies use the Schedule III vertical format. Sole proprietors can use a simpler format, though many accountants prefer the vertical style for clarity.

See: Profit and loss template in Excel | Balance sheet format in Excel

Fact box — Companies Act 2013: Schedule III balance sheet Every company registered under the Companies Act 2013 must present its balance sheet in the Schedule III format — a vertical layout with separate sub-heads for non-current assets, current assets, non-current liabilities, current liabilities, shareholders' funds, and reserves and surplus. The format was last revised by MCA in 2021 to add additional disclosure requirements. Source: Companies Act 2013, Schedule III; MCA notification dated 24 March 2021.

Fact box — Double-entry vs single-entry: which is required? Section 44AA does not mandate double-entry bookkeeping by name, but the "books of accounts" specified (cash book, journal, ledger) imply a double-entry system. For tax audits, the auditor will expect to reconcile the books. Companies Act 2013 companies are implicitly required to follow double-entry. Single-entry (a simple receipts and payments record) is only defensible for very small businesses below the threshold limits.

The full double-entry cycle in Excel

If you want a single Excel workbook that handles the entire cycle, structure it with these sheets:

1. COA — chart of accounts (account code, name, type, normal balance)
2. Journal — every transaction as a dated journal entry (Date | Ref | Account | Debit | Credit | Narration)
3. CashBook — auto-populated from Journal filtered by Cash and Bank accounts, plus a running balance
4. Ledger_[Account] — one sheet per major account, pulling from Journal with SUMIF
5. TrialBalance — SUMIF across all ledger sheets, comparing debit vs credit totals
6. P&L — links from ledger account totals for income and expense accounts
7. BalanceSheet — links from ledger account totals for asset, liability, and equity accounts

This is the architecture explained in detail in our complete guide: How to build an accounting system in Excel from scratch

GST and Excel accounting

GST compliance adds a layer to your books. Each sale must record:

• Base amount
• GST rate and amount (CGST/SGST for intra-state; IGST for inter-state)
• Customer GSTIN (for B2B)
• Invoice number and date

Your sales ledger feeds GSTR-1. Your purchase ledger feeds your ITC claim in GSTR-3B. The GST slabs as of 27 June 2026 are: Nil / 5% / 18% / 40% (the 12% and 28% slabs were abolished on 22 September 2025).

A well-structured Excel accounting system separates GST into its own liability accounts so your GST payable figure is always visible. Learn more in our GST hub.

Financial year-end closing

The Indian financial year runs from 1 April to 31 March. Closing the books involves:

1. Reconciling the bank statement against your cash book
2. Posting depreciation on all fixed assets
3. Verifying debtors and creditors balances
4. Accruing outstanding expenses and prepaid income
5. Closing nominal accounts (income and expenses) to retained earnings
6. Producing the final trial balance, P&L, and balance sheet

See the step-by-step: Financial year-end closing checklist — Excel

Depreciation in Excel

Fixed assets are not expensed immediately — they are depreciated over their useful life. The Income Tax Act prescribes the Written Down Value (WDV) method with fixed rates (e.g., computers: 40%, plant and machinery: 15%, buildings: 10%). Companies Act 2013 prescribes useful lives under Schedule II instead of fixed rates.

See: Depreciation calculator in Excel — WDV and SLM

Bank reconciliation

Your cash book and your bank statement will rarely match perfectly — outstanding cheques, bank charges, and timing differences cause gaps. A monthly bank reconciliation statement (BRS) identifies and explains every difference.

See: Bank reconciliation statement in Excel — format and template

Petty cash management

Most businesses maintain a petty cash fund for small daily expenses. A petty cash book records each payment against a float, and the float is replenished when it falls below a minimum. Section 40A(3) disallows expense deductions where cash payments exceed ₹10,000 to a single person in a single day — making accurate petty cash records important for tax.

See: Petty cash book in Excel — template and format

How Ankeshan helps Ankeshan provides free, pre-formatted Excel templates for every step in this system — cash book, ledger, trial balance, P&L, and balance sheet — all structured to Indian accounting standards. No sign-up required. The templates include built-in formulas for running balances, balance checks, and GST column separation.

All articles in this cluster

Frequently asked questions

Is Excel accounting legally acceptable for income tax purposes in India?

Yes. The Income Tax Act Section 44AA specifies that books of accounts must include a cash book, journal, and ledger but does not prescribe the medium. Excel-maintained books that are accurate, complete, and printable are accepted by the Income Tax Department. In a tax audit, the auditor examines the records in whatever format you maintain them.

What is the tax audit threshold for a small business in India?

The threshold is ₹1 crore of total turnover or gross receipts for the previous financial year. If your business receives and pays at least 95% of its transactions through digital/banking channels, the threshold rises to ₹10 crore. For professionals, the threshold is ₹50 lakh gross receipts.

Do I need accounting software, or will Excel suffice?

For businesses below the audit threshold with straightforward transactions (no inventory complexity, single GST registration, fewer than 200 transactions per month), Excel is genuinely adequate. As transaction volume grows or you need real-time multi-user access, purpose-built software becomes more practical. Many businesses use Excel throughout their life and only switch when external investors or bank covenants require audited accounts in a specific format.

How should I structure an Excel file for accounting?

Use one workbook per financial year. Create separate sheets for: chart of accounts, journal, cash book, one ledger sheet per major account (or a single multi-account ledger with filtering), trial balance, P&L, and balance sheet. Link sheets with formulas rather than re-entering data. Keep a README sheet with instructions for anyone who opens the file later.

What books of accounts are compulsory for a private limited company?

Under the Companies Act 2013 (Section 128), every company must keep books of accounts at its registered office covering all money received and spent, all sales and purchases, all assets and liabilities, and (if applicable) cost records. The books must be kept for at least 8 years. Financial statements must be in the Schedule III format. A statutory audit is compulsory for all companies regardless of turnover.

Can I use the same Excel file for GST and income tax?

Yes — and it is advisable to do so. Your sales register serves double duty: it supports GSTR-1 filing and provides the sales figure for income tax. Your purchase register provides the ITC figure for GST and the purchase/expense deduction for tax. Keeping both in one system reduces reconciliation work at year-end.

Sources and disclaimer

• Income Tax Act 1961, Sections 44AA, 44AB, 40A(3)
• Companies Act 2013, Sections 128–137, Schedule III
• MSMED Act 2006; revised MSME classification per Ministry of MSME notification effective 1 April 2025 (Union Budget 2025; PIB PRID 2098389)
• GST Council decisions on slab restructuring, September 2025
• MCA Schedule III notification, 24 March 2021

Disclaimer: General information, not professional advice. Verify on the official portal for your case. Reviewed by a Chartered Accountant; last updated 27 June 2026.

Related

• GST for small business
• Compliance calendar
• Payroll in Excel