Skip to content

Finance Operations

A chart of accounts for Indian SMEs that makes reporting easy

How to structure ledgers in Tally or Zoho Books so margins, GST and TDS fall out of the books — with a sample structure and the mistakes that clutter it.

Soham T. Savdavkar 9 min read
On this page
  1. 01 Why the chart of accounts matters
  2. 02 Five principles
  3. 03 A sample structure
  4. 04 GST and TDS ledgers
  5. 05 Segments without ledger sprawl
  6. 06 Mistakes that clutter the books
  7. 07 Fixing a chart that has grown messy

Nobody starts a business thinking about their chart of accounts. It grows by accident: a ledger created for each new expense as it arrives, named by whoever was entering it that day. Five years later there are three ledgers for travel, a large “miscellaneous expenses”, and a monthly report that can’t answer the simplest question about margin. The chart of accounts is the least glamorous part of accounting and the one that decides what every report can tell you.

Why the chart of accounts matters

A report can only show a distinction the books record. If freight on purchases is posted to the same ledger as courier charges for marketing, no MIS will ever show you your true cost of goods. If sales from your website and from marketplaces go to one ledger with no tag, you cannot see which channel makes money. The structure you choose now is the ceiling on the questions you can answer later.

Five principles

  1. Separate direct costs from overheads. Materials, direct labour, freight inward and job work sit above gross profit; rent, admin salaries and marketing sit below it. This single split is what makes gross margin analysis possible.
  2. Name ledgers for what the money was for, not who received it. “Software subscriptions”, not the vendor’s name; the vendor belongs in the supplier ledger.
  3. One meaning per ledger. If two people would post the same bill to different ledgers, the chart is ambiguous. Merge or rename until they wouldn’t.
  4. Keep balance sheet ledgers reconcilable. Every asset and liability ledger should be checkable against something outside the books: a bank statement, a loan statement, a supplier statement, the GST portal.
  5. Plan for reporting, not just recording. Group ledgers the way your MIS reads, so the monthly pack comes straight out of the groups.

A sample structure

Tally organises ledgers under predefined groups; Zoho Books uses account types. Either way, the same logical structure works for most trading, manufacturing and services businesses:

GroupExample ledgers
RevenueSales — by broad stream only (goods, services, exports); other operating income
Direct costsPurchases, freight inward, direct labour, job work charges, packing materials
Employee costsSalaries and wages (non-production), employer PF and ESI, staff welfare
Operating expensesRent, power, software subscriptions, professional fees, travel, marketing, repairs
Finance and non-cashInterest on loans, bank charges, depreciation
Fixed assetsOne ledger per asset class, matching your depreciation classes
Current assetsCustomers (sundry debtors), inventory, advances to suppliers, GST input ledgers, TDS receivable
Current liabilitiesSuppliers (sundry creditors), GST output ledgers, TDS payable, salaries payable, provisions
Loans and capitalEach loan separately; capital; drawings or dividends

Every customer and supplier gets their own party ledger, with GSTIN and PAN captured in the master. Every bank account, overdraft and card gets its own ledger, so each can be reconciled on its own.

GST and TDS ledgers

Set these up so your returns can be prepared from the books without a spreadsheet in between:

  • GST by head and direction: Input CGST, Input SGST, Input IGST; Output CGST, Output SGST, Output IGST. Separate ledgers for tax payable under reverse charge, and for credit that is blocked or has to be reversed.
  • Electronic cash ledger as its own ledger, so tax deposited but not yet used is visible.
  • TDS payable by nature of payment — contractors, professional fees, rent, commission, interest — so each quarterly statement comes straight from its ledger.
  • TDS receivable for tax your customers deduct from you, reconciled each quarter against your annual tax credit statement (Form 168, formerly 26AS).

Segments without ledger sprawl

The instinct, when you want margin by product or profit by branch, is to create “Sales — Pune”, “Sales — Nashik” and so on for every income and cost ledger. Within a year the chart has tripled and nobody trusts the totals.

Use the tools built for this instead: cost centres (and cost categories) in Tally, reporting tags in Zoho Books. Each entry carries a tag for its branch, product or channel, and any report can be cut by it, while the chart of accounts stays short. Tagging has to happen as entries are posted; reconstructing a year of untagged entries later is slow and never quite right.

Mistakes that clutter the books

  • A large “miscellaneous” ledger. If it is more than a small fraction of expenses, it is hiding things you should see.
  • A ledger per vendor in the expense groups. Vendors belong in supplier ledgers; expense ledgers describe what was bought.
  • Suspense accounts that never clear. Suspense is for days, not quarters. Review it at every month-end close.
  • Personal and business spending mixed. Owner expenses belong in drawings, not in travel or staff welfare.
  • Duplicate ledgers created because nobody could find the existing one: “Conveyance”, “Local conveyance”, “Travel — local”.

Fixing a chart that has grown messy

  1. Export the trial balance and list every ledger with its balance and how often it is used.
  2. Draft the target structure, and map each existing ledger to where it belongs.
  3. Merge duplicates and reclassify misplaced ledgers, ideally at the start of a financial year.
  4. Write a one-page posting guide: which ledger each common kind of bill goes to.
  5. Lock ledger creation to one or two people, so the chart doesn’t drift back.

A clean chart of accounts is one of the first things to settle when your accounting changes hands, because every monthly report afterwards depends on it. If you are moving software at the same time, our Tally to Zoho Books migration guide covers doing both at once.

Written by

Soham T. Savdavkar, Director at Outsourced Finance Solutions — an outsourced finance company providing accounting, MIS reporting, GST and TDS compliance and virtual CFO (VCFO) support to growing businesses across India, from an office in Kanjurmarg, Mumbai.

OFS is not a firm of chartered accountants and performs no CA-reserved work. This article is general information, not advice for your specific situation.

Serving businesses across India

Let’s look at your numbers together.

A 30-minute call, no cost and no obligation. Bring your last set of accounts and we’ll tell you plainly what we’d do, what it would cost, and whether you even need us.

Delivered within 24 working hours, or next month is on us. 24 working hours from the moment we have your complete data. The clock runs Monday to Saturday and pauses on Sundays and public holidays. Terms

Call now WhatsApp