How it works What it extracts Pricing Blog

Tools

Extract & create

GST Invoice to Excel Invoice Generator

Verify GSTIN

GSTIN Lookup Bulk GSTIN Verify GSTIN Validator GST Search by PAN

Calculate

GST Calculator Reverse GST Calculator Set-Off Calculator Late Fee Calculator Interest Calculator

Rules & reference

Return Due Dates E-Invoice Limit Registration Limit E-Way Bill Validity HSN Code Lookup

Downloads

Reference lists

GST Rate List TDS Rate Chart GST State Code List

Invoice & billing

Invoice Formats Delivery Challan Format

Business documents

Purchase Order Format Quotation Format Payment Receipt Format

Payroll & accounts

Salary Slip Format Balance Sheet Format

Returns & reconciliation

GSTR-3B Format GSTR-9 & 9C Format GSTR-2B Reconciliation All free downloads →
Sign in

Payment Receipt Format in Excel

Free Excel receipt that also works as a receipt voucher under Rule 50. Pick what the money was for and the sheet tells you whether GST is due right now.

Download Payment Receipt (Excel)

Excel 2016 and later, LibreOffice and Google Sheets. No macros. Fill the amber cells; the green ones calculate.

The Question Every Other Template Ignores

A receipt is easy. What is not easy is knowing whether the money you just received makes GST payable today — and the answer is different depending on what the payment was for.

What the money isGST payable now?Why
Advance for services Yes Receiving the advance is the time of supply under Section 13(2). Issue a receipt voucher, pay the tax in that month's return, adjust it against the invoice later.
Advance for goods No Notification 66/2017-Central Tax, 15 November 2017 relieved registered suppliers of goods from paying tax on advances. Still issue a receipt voucher; the tax is paid when you raise the invoice.
Payment against an invoice No The GST was already accounted for on the invoice. This is an ordinary receipt.

That middle row is where most free templates get it wrong — they charge tax on every advance regardless. Paying GST on an advance for goods means paying it twice: once on the advance, again on the invoice, and then working it back through an amendment.

The sheet has a dropdown for exactly this. Pick the payment type and it states the treatment and calculates accordingly.

Two Fallbacks Rule 50 Gives You

Advances often arrive before the details are settled. Rule 50 anticipates that:

  • Rate not determinable when the advance is received → charge 18%.
  • Nature of supply not determinable — you do not yet know where it will be supplied → treat it as an inter-state supply and charge IGST.

Both are built into the sheet, and both are noted next to the cells they apply to.

The Advance Is Treated as Tax-Inclusive

If a customer sends ₹1,18,000 as an advance for a service at 18%, the taxable value is ₹1,00,000 and the tax is ₹18,000 — the tax comes out of the amount received, not on top of it. The sheet backs it out for you rather than adding 18% to ₹1,18,000 and overstating the liability by ₹3,240.

What Rule 50 Requires on the Voucher

A receipt voucher must carry all of the following. Every one is on the sheet:

  • Your name, address and GSTIN
  • A consecutive serial number, unique within the financial year
  • Date of issue
  • The payer's name, address and GSTIN
  • Description of the goods or services
  • Amount of the advance
  • Rate and amount of tax — CGST, SGST, IGST, cess
  • Place of supply, with the state code
  • Whether tax is payable on reverse charge
  • Signature of the supplier or an authorised person

If the Deal Falls Through

Refunding the advance? Issue a refund voucher under Rule 51 — not a credit note. A credit note adjusts an invoice, and here no invoice was ever raised. The refund voucher references the original receipt voucher and is what lets you recover the tax you already paid.

Who Does Not Use This

Composition dealers. Section 10(4) bars them from collecting tax at all, so there is no tax to show on an advance. They issue a bill of supply instead of a tax invoice — see the composition scheme for the wider picture.

Raising the Invoice Next?

Rule 46 tax invoice, proforma and bill of supply — free working Excel sheets.

GST invoice formats

Frequently Asked Questions

Is GST payable on an advance received?

It depends on what the advance is for. For services, yes — receiving the advance is the time of supply under Section 13(2), so GST is payable in that month's return. For goods, no. Notification 66/2017-Central Tax dated 15 November 2017 relieved registered suppliers of goods from paying tax on advances; the tax is paid when the invoice is issued. A receipt voucher is issued in both cases.

What is a receipt voucher under GST?

A receipt voucher is the document you issue when you receive an advance, required by Section 31(3)(d) of the CGST Act and Rule 50 of the CGST Rules. It must carry your name, address and GSTIN, a consecutive serial number, the date, the recipient's details, a description of the goods or services, the amount of advance, the rate and amount of tax, the place of supply, whether tax is payable on reverse charge, and a signature.

What if I do not know the tax rate or the place of supply when the advance is received?

Rule 50 provides for both. If the rate is not determinable at that point, charge 18 per cent. If the nature of the supply is not determinable — you do not yet know where it will be supplied — treat it as an inter-state supply and charge IGST.

What happens if the advance is refunded and no supply takes place?

Issue a refund voucher under Rule 51, not a credit note. A credit note adjusts an invoice, and in this case no invoice was ever raised. The refund voucher references the original receipt voucher and lets you recover the tax you paid on the advance.