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.
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.