Free for readers

Excel templates for
GST and Accounts Made Simple

The eight ready-to-use templates from the book by Samrat Das. Fill in the yellow cells; everything else calculates automatically.

Download all 8 templates (ZIP)

Or download one at a time

Chapter 1

Leak Check

Estimate what each profit leak costs you in a year, and see which one to fix first.

Download
Chapter 2

Five Books Starter

Sales, purchases, cash, bank and expense registers with automatic GST and monthly totals.

Download
Chapter 3

One-Page P&L

Monthly profit and loss with gross margin, net margin and profit kept after drawings.

Download
Chapter 5

GSTR-2B Match

Paste your purchase register and GSTR-2B; see matched, differing and missing bills instantly.

Download
Chapter 8

Debtors Ageing and DSO

Age every unpaid bill into 0–30, 31–60, 61–90 and 90+ days, with your DSO calculated.

Download
Chapter 9

13-Week Cash Plan

Weekly cash in and out for 13 weeks, with shortfalls flagged in red before they happen.

Download
Chapter 10

ABC Analysis and True Margin

Group items by sales, spot slow movers, and find the true margin after freight, breakage and credit.

Download
Chapter 11

One-Page MIS

Ten key numbers each month that turn green, yellow or red automatically against your targets.

Download
How to use
  1. Open the file in Excel, Google Sheets or WPS Office (free on mobile).
  2. Type only in the light-yellow cells with blue text. White cells are formulas; leave them alone.
  3. The first row shows an example from the book. Overwrite it with your own figures.
  4. Save a fresh copy each month, for example MIS_Nov_2026.xlsx.