TemplateHub is not a dump of generic .xlsx files. Arshad Ansari designs each workbook for one compliance or bookkeeping job, then publishes the method next to the download so you can judge the file before you trust it with a GSTIN.

Why this page exists

AdSense and search reviewers (and you) should be able to see that the site is a maintained library with a named editor, not an auto-generated download mill. The steps below are the same ones used for the GST invoice and RCM self invoice files that are already live.

The publishing checklist

1. Pick one job for the workbook

A file is either a GST tax invoice, an RCM self invoice, a cash book, or a P&L — not all four. Mixed-purpose sheets hide the wrong fields and fail the first audit question: what is this document?

2. List the mandatory fields first

For GST invoices that list is CGST Rule 46. For RCM self invoices it is Section 31(3)(f) plus a Reverse Charge flag. For salary slips it is earnings, statutory deductions, and net pay. Labels go on the sheet before any formatting.

3. Write formulas a Sheets user can keep

Quantity × rate, tax = taxable × rate / 2 for CGST/SGST, SUM for totals. No VBA, no XLOOKUP-only logic, no macros. If LibreOffice drops the formula, the sheet is redesigned.

4. Leave a completed sample

Reviewers and first-time users need to see a filled invoice, not a grid of zeros. Sample GSTIN-style placeholders sit in [square brackets] so you know what to overwrite.

5. Print to A4 and export PDF

Indian invoices still travel as printouts and WhatsApp PDFs. Print titles, margins, and amount-in-words are checked so a 6-line invoice does not spill onto a second blank page.

6. Write the page that explains the file

The download is not the article. Each template page states when the file applies, when it does not (for example: do not use a tax invoice for unregistered RCM), and a numeric example.

What we test in three apps

Microsoft Excel (Microsoft 365) is the source file. The same .xlsx is uploaded to Google Sheets and opened in LibreOffice Calc. Failures we have already caught and redesigned for: currency formats that become USD in Sheets, named ranges that LibreOffice ignores, and merged header cells that break SUM when you insert a line item.

Dropdowns use plain data-validation lists, not Excel Tables that refuse to open elsewhere. Dates are real date values, not text, so a cash book running balance still sorts.

Worked numbers, not empty theory

Guides include at least one arithmetic example — an 18% intra-state line that splits 9% + 9%, or a GTA freight self invoice at 5%. If the article cannot show the rupee amounts, it is not published. That is also why we refuse to clone the same invoice ten times with different H1 tags.

Corrections

Law and Excel both change. If a field is missing or a formula rounds CGST incorrectly, use the contact page. The template page is updated in place; the URL stays the same so existing downloads and search listings do not break.

How we build Excel templates