TemplateHub Blog
Written guides that sit next to the downloads: Rule 46 field checklists, a GTA freight self-invoice with rupee amounts, Excel vs Google Sheets test notes, and the three-file bookkeeping stack for a new Indian firm. Each article is by Arshad Ansari and is updated in place when a rule or formula changes.
An unregistered purchase bill charges no GST. Worked sample: copier paper ₹3,600, pens ₹500, stapler ₹700, total ₹4,800, and Section 32 is why the tax stays at zero.
An invoice for free samples under GST is a Rule 55 delivery challan, not a tax invoice. Worked sample: shampoo ₹2,550, cream ₹2,400, soap ₹840, total ₹5,790, and the consignee pays nothing.
RCM tax invoice format under GST: the registered supplier's invoice, not a self invoice. A firm of advocates bills ₹40,000 at 18%, which splits into CGST ₹3,600 and SGST ₹3,600, and that GST is not added to the fee.
RCM bill format under GST: the registered supplier's bill, not a self invoice. GTA freight of ₹18,500 at 5% splits into CGST ₹462.50 and SGST ₹462.50, and that GST is not added to the freight.
GST payment voucher for Reverse Charge: what Rule 52 requires, vs a self invoice, what you pay the supplier vs the government, and a free Excel download.
Build a month's attendance grid for a small shop: P/A/L/H codes, COUNTIF payable days, late remarks, and how that number reaches the salary slip.
The publishing checklist behind every TemplateHub download: one job per file, Rule 46 or RCM fields, three-app formula tests, sample rows, and a written explainer.
Invoice, cash book, and P&L — what each file is for, a sample month with rupee figures, and when to add GST, salary slips, or accounting software.
First-hand notes from opening TemplateHub GST workbooks in Excel 365, Google Sheets, and LibreOffice — what survives, what breaks, and how we design around it.
A full Reverse Charge self-invoice example for Goods Transport Agency freight — 5% GST, cash payment to government, GSTR-3B tables, and the Excel cells to fill.
What CGST Rule 46 actually requires on a tax invoice, which cells buyers and CAs check first, and how that maps to a working Excel GST invoice — with an 18% intra-state example.
Complete step-by-step guide to making a wedding budget in Excel — total budget, 11 wedding categories, percentage allocations, per-head cost logic, deposit tracking, common mistakes, and a free wedding budget planner template.
Complete beginner-friendly guide to making a monthly budget in Excel — the 50/30/20 rule, the 5 sections every budget needs, step-by-step instructions, common mistakes to avoid, and a free monthly budget template to download.
Step-by-step guide to creating a rent receipt in Excel for HRA claims in India — required fields, landlord PAN rule, revenue stamp rule, HRA calculation, common mistakes, and a free rent receipt template with a 12-month log to download.
Self invoice format under GST for RCM in Excel: when it is mandatory, vs a regular tax invoice, payment voucher rules, GSTR-3B, and a free Excel download.
Learn how to use VLOOKUP in Excel with syntax, examples, exact match, IFERROR, common mistakes, and a free practice template.
Learn how to make a salary slip in Excel with employee details, earnings, deductions, gross pay, net salary, and a free salary slip template.
Learn how to track business expenses in Excel — what to record, how to set up a category summary, tips to stay consistent, and a free expense tracker template.
Learn how to build a profit and loss statement in Excel step by step — revenue, COGS, gross profit, expenses, net profit, plus a free template to download.
A step-by-step guide to creating a GST-compliant invoice in Excel — the required fields, CGST/SGST vs IGST, common mistakes, and a free template to download.