Petpooja Payroll is now Attendo
Book a Demo

Gift Register Format in Excel for ITC Records (2026-27)

Nothing is billed for a Diwali gift, so nothing gets written down. That is the problem. The GST rules ask for a record of every gift and free sample that leaves your stock, and the input tax credit on those goods is blocked. Updated October 2026.

  • A 100-row register: what was given, what it cost, who received it, and what has happened to the input tax credit on it
  • A staff gift tracker that totals each employee's gifts for the financial year against the fifty thousand rupee limit in Schedule I
  • A summary with the one figure your accountant needs before the return, and checks that point at rows left incomplete
No spam. Instant download link to your email.
Petpooja presents
Gift Register Format
For Indian businesses
6
Sheets · Excel
FY 2026-27
What's Inside

Six sheets that put a giveaway on record

01

The Instructions Sheet

Four lines for anyone who only reads one thing, then why the record matters, how to fill it, who goes in the recipient column and what the workbook does not do. It says plainly that this is a working record kept with your stock accounts, not a replacement for them.

02

The Gift Register

One hundred rows, one for each time goods go out for nothing. Date, item, quantity, where the goods came from, the purchase bill, cost, the GST rate on purchase, the recipient and the credit status. The value given and the input GST on it calculate themselves.

03

The Staff Gift Tracker

Type each employee's name or code once. The sheet totals their gifts from the register for the financial year, sets the total against the fifty thousand rupee limit, and says who is inside it. A check line tells you when a staff gift on the register matches no name.

04

The Summary

Totals by type of recipient and by credit status, with the figure still to reverse picked out. Checks count the rows with no date, no credit status, no input GST figure, a date outside the year or a staff gift with nobody named, so a total is never trusted blind.

05

A Worked Example

A sweet shop's Diwali in eight rows: gift boxes for clients, candle sets and calendars for customers, mithai made in-house for dealers, tasting pieces and three staff gifts. One employee crosses the limit, and the example shows what the register does about it.

06

The Rule Reference

Section 17(5)(h), Rule 56(2) and Rule 56(8), sections 35(1), 35(6) and 36, section 7(1)(a), entries 1 and 2 of Schedule I, paragraph A of Circular 92/11/2019 and paragraph 5 of Circular 172/04/2022. Quoted with the practical effect beside each, so you can check this against the source rather than take our word for it.

Keep billing and stock on one record with Petpooja Invoice

Petpooja Invoice raises GST-compliant invoices with the tax calculated automatically and tracks stock in real time as you bill, with billing and inventory kept in one place.

Explore Petpooja Invoice
Why This Matters

The gift is free of tax. It is not free of paperwork

A sale leaves a bill behind it. A gift leaves nothing. Two hundred diya sets go out with festive purchases, forty boxes of dry fruit go to clients, every member of staff takes home a hamper, and by the middle of November the only evidence is a gap in the stock.

The GST rules do not treat that gap as nothing. Rule 56(2) of the CGST Rules says the accounts of stock a registered person maintains shall contain particulars of goods "lost, stolen, destroyed, written off or disposed of by way of gift or free sample". Gifts and free samples are named. A giveaway is a stock movement, and it has to be written down like any other.

And if it is not written down? Section 35(6) says that where a registered person fails to account for goods, the proper officer shall determine the tax payable on the goods not accounted for "as if such goods or services or both had been supplied by such person". Read plainly, stock that has left and appears in no record can be treated as stock you sold. How that applies to your books is a question for your accountant, and the register is what they will ask to see.

The record also has to answer for the credit. Section 17(5)(h) of the CGST Act says input tax credit is not available on goods disposed of by way of gift or free samples. So the GST you paid when you bought those diya sets is a blocked credit, and the register is where you record whether you claimed it, and what was done about it if you had.

Staff gifts carry one more line. The proviso to entry 2 of Schedule I says gifts not exceeding fifty thousand rupees in value in a financial year by an employer to an employee shall not be treated as supply. The year is the trap: a Diwali hamper is counted with whatever that employee was given in April. The Staff Gift Tracker adds it up for each person.

This page is about the record, not the offer. A discount, a slab offer and a buy one get one free are not gifts and do not belong in this register. They go on the invoice, and our Diwali Sale GST Invoice Format covers how each one is billed. For choosing the offer itself, see our guides to Diwali offers that increase sales and festive season retail sales.

Sample Preview

What each sheet gives you

Here's a preview of what you'll get inside, sheet by sheet, in the order they open. The figures in the Example row are illustrative.

Instructions: Four lines to read first, why the record matters, what is in the workbook, how to use it, who goes in the recipient column, and what the workbook does not do.
Gift Register: One row for each giveaway: date, item, quantity, where the goods came from, purchase bill, cost, GST rate on purchase, recipient type, recipient and credit status. Value given and input GST calculate themselves.
Staff Gift Tracker: For each name: gifts recorded, value in the year, the limit, room left and a result. The result reads within the limit, above the limit, ask your accountant, or no gift found on the register.
Summary: Rows, value given and input GST by type of recipient and by credit status, with "Claimed, still to reverse" picked out as the figure to hand over before the return.
Example: Eight rows from a sweet shop's Diwali. Value given ₹1,22,930, input GST on it ₹14,242.50, of which ₹978.50 is still to reverse. Employee E‑07 stands at ₹53,450 against the ₹50,000 limit.
Rule Reference: Rule 56(2): the accounts of stock shall contain particulars of goods disposed of by way of gift or free sample. Section 17(5)(h): input tax credit shall not be available on them.
... all 6 sheets in one Excel file, with the formulas locked and the input cells open.
Key Stats

Three provisions that decide what you record

Rule 56(2)

Where gifts are named. The accounts of stock a registered person maintains shall contain particulars of goods lost, stolen, destroyed, written off or disposed of by way of gift or free sample. The rule excludes a person paying tax under section 10.

Source: CGST Rules 2017, Rule 56(2), read 12-Oct-2026
₹50,000 a year

The staff gift limit. Gifts not exceeding fifty thousand rupees in value in a financial year by an employer to an employee shall not be treated as supply. It is counted for each employee across the whole year, not for each festival.

Source: CGST Act 2017, Schedule I, entry 2, proviso, read 12-Oct-2026
72 months

How long the record is kept. Books of account and other records are retained until seventy-two months from the due date of furnishing the annual return for the year they relate to, and longer where a proceeding is pending.

Source: CGST Act 2017, section 36, read 12-Oct-2026
Common Mistakes

7 Gift Record Mistakes That Cost You Later

01

Writing nothing down because nothing was billed

The commonest one. No invoice is raised for a gift, so no record is made at all. Rule 56(2) asks for it all the same. Record the gift on the day it goes out, while somebody still remembers the quantity.

02

Keeping the input tax credit on gift stock

Gift stock is easy to claim along with everything else that month, because nobody knew yet it would be given away. If that happened, mark the row as claimed and still to reverse, and give the total to your accountant before the return.

03

Counting staff gifts one festival at a time

The fifty thousand rupee limit in Schedule I is for each employee in a financial year. A Diwali gift is added to a birthday gift in June and an award in January. Looking at Diwali alone tells you nothing about who is close to the limit.

04

Recording a discount or a buy one get one free as a gift

Neither is a gift. A discount shown on the invoice reduces the taxable value, and a buy one get one free is two items for one price. Both go on the bill, and putting them in this register would mark credit as blocked when it is not. Our Diwali Sale GST Invoice Format covers them.

05

Leaving out goods you made yourself

A sweet shop that gives away its own mithai bought no finished goods, so there is no purchase bill to point at. The CBIC circular applies the block to the inputs used in relation to gifts and free samples. Record the row, pick "Made in-house", and ask your accountant for the input GST figure.

06

Listing customers by name

The register has to show where the stock went. It does not need a list of the people who walked in. For gifts handed over with a purchase, write "Walk-in customers" and the quantity for the day. Keep names for staff, where the limit is counted for each person, and business names for clients and dealers.

07

Typing over a wrong entry

Rule 56(8) says entries shall not be erased, effaced or overwritten, and that where records are kept electronically a log of every entry edited or deleted shall be maintained. A spreadsheet keeps no such log by itself. Explain the correction in the Remarks column, and ask your accountant how they want corrections kept.

Comparison

Giving Gifts From Memory vs With This Register

Aspect From memory With this register
A gift going out Handed over, nothing written One row on the day, with quantity and cost
The credit on gift stock Claimed with the rest of the month's purchases A status on every row, and one total still to reverse
Staff gifts Looked at festival by festival Totalled for each employee across the financial year
Goods made in-house Left out, because there is no purchase bill Recorded, with the accountant's input GST figure
At the return The accountant asks, and nobody is sure The Summary sheet, with its checks read first

Swipe the table sideways to see the full comparison.

Put the giveaway on record

Download the free Gift Register Format and write down this festive season's gifts and free samples on the day they go out.

FAQ

Frequently asked questions

Is a gift register mandatory under GST?
Rule 56 sets out what your accounts must contain. It does not prescribe a form called a gift register. What is required is the record itself. Rule 56(2) of the CGST Rules says the accounts of stock a registered person maintains shall contain particulars of goods lost, stolen, destroyed, written off or disposed of by way of gift or free sample. A register is one practical way of keeping those particulars for gifts, to be held with your stock accounts. The rule excludes a person paying tax under section 10, the composition scheme. If your stock itself is not yet on record, our Stock and Inventory Management template is the place to start. This page is general guidance, not tax advice, and your accountant should confirm which accounts your business has to keep.
Can I claim input tax credit on Diwali gifts?
Not on goods you give away for nothing. Section 17(5)(h) of the CGST Act says input tax credit shall not be available in respect of goods disposed of by way of gift or free samples, and Circular 92/11/2019-GST applies that to the inputs, input services and capital goods used in relation to gifts distributed without consideration. That is different from a discount or a buy one get one free, where the credit is not blocked. The difference is whether anything was charged, which our Diwali Sale GST Invoice Format sets out offer by offer. Our guide to GST on sweets and festive food covers the rates on what you are buying.
Is GST payable on Diwali gifts to employees?
It depends on the value across the year. The proviso to entry 2 of Schedule I says gifts not exceeding fifty thousand rupees in value in a financial year by an employer to an employee shall not be treated as supply. Above that, the proviso no longer applies. An employer and an employee are related persons under the Explanation to section 15, which is why Schedule I reaches staff gifts at all. Circular 92/11/2019-GST adds that where a gift is a supply because of Schedule I, the supplier would be eligible for the credit on it. The tracker tells you who has passed the limit. It does not work out what is due. A gift is also different from something an employee is owed under their contract: Circular 172/04/2022-GST says perquisites provided in terms of the employment contract will not be subjected to GST. Take both points to your accountant before the return.
What if I already claimed the credit on goods I later gave away?
Then the register is where you flag it. Pick "Claimed, still to reverse" on the row. The Summary sheet totals every such row into one figure, and tells you if any of them has no input GST amount yet. What happens next is for your accountant or GST practitioner to decide: usually a reversal, though the circular notes that where Schedule I treats a giveaway as a supply the credit is available, and the register has a status for that too. Once it is settled, update the status and note the return period in the next column. The free GST calculator is handy for checking the GST on a single purchase.
How long should I keep the gift register?
As long as your other GST records. Section 36 of the CGST Act says books of account and other records shall be retained until the expiry of seventy-two months from the due date of furnishing the annual return for the year they relate to. If an appeal, revision, proceeding or investigation is pending, they are kept for one year after it is finally disposed of, or for the seventy-two months, whichever is later. Keep one file for each financial year, which is how the workbook is built, and store it with that year's stock records. A stock count at year end is a good time to close the file, and our Inventory Audit Checklist covers the count.
Do free samples and tasting portions go in the register too?
Yes. Rule 56(2) and section 17(5)(h) both name free samples alongside gifts, so the register has a "Free sample" recipient type for them. A tasting counter does not need a row for every piece. One row for the day, with the total quantity and what it cost you, is a workable record. For food you made yourself, pick "Made in-house" and ask your accountant for the input GST figure, because there is no single purchase rate to apply. Our post on reasons to give free samples makes the case for sampling in the first place.

About Petpooja

Petpooja is India's leading SME business software suite, trusted by 1,50,000+ businesses across restaurants, retail, healthcare, manufacturing, and more. From billing and payroll to task management and procurement Petpooja helps Indian businesses run better, every day.

From a paper trail to one record

Petpooja Invoice raises GST-compliant invoices with the tax calculated automatically, tracks stock in real time as you bill, and keeps billing and inventory in one place. Ask for a walkthrough of Petpooja Invoice for your shop.

Book a Free Demo Call: +91-92279 80766
Petpooja Blog newsletter

Practical guides for your business, in your inbox.

New articles, free tools and templates for restaurants, retail and growing businesses. No spam, unsubscribe anytime.

By subscribing, you agree to receive updates from Petpooja. Read our Privacy Policy.

Reader settings
Theme
Text size
Free 20-minute demo

Book a Demo

Tell us about your business. Our team will call you within 24 hours.

Start typing to search for your city
Which product are you interested in?

By submitting, you agree to receive updates from Petpooja and accept our Privacy Policy.