Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesRetail & E-commerceStore OperationsGift Card & Store Credit Log

SpreadsheetStore OperationsFree

Gift Card & Store Credit Log

Every card and credit issued, what has been redeemed, the balance outstanding and what is about to expire.

Shown with sample data

Colour

Gift Card & Store Credit Log

Every card and credit issued, what has been redeemed, the balance outstanding and what is about to expire.

Outstanding liability
$232.49
Issued
$412.99
Share redeemed
41%
Expiring within 30 days
1
Value issued by type
  • Gift card$300
  • Store credit$102.99
  • Promotional voucher$10
Share of value issued by type
  • Gift card$30073%
  • Store credit$102.9925%
  • Promotional voucher$102%

How to use it

  1. 1Give every card a unique number.
  2. 2Record the sale on the day it is issued.
  3. 3Update “Redeemed” each time the card is used.
  4. 4Check unclaimed-property and expiry rules where you trade.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

A gift card is money you owe. Record each card or credit note with its number, value and expiry and update what has been redeemed; the sheet shows the balance on each, the total liability on your books and which cards expire soon.

Who it’s for

  • Shops selling paper or handwritten vouchers
  • Tracking store credit from returns
  • Year-end liability for your accountant

What’s included

  • Cards sheet: One row per card, credit note or voucher.
  • Summary by Type sheet: Value issued and Redeemed and the number of entries for each type, calculated from the Cards sheet.

How to use it

  1. 1Give every card a unique number.
  2. 2Record the sale on the day it is issued.
  3. 3Update “Redeemed” each time the card is used.
  4. 4Check unclaimed-property and expiry rules where you trade.
Related searchesgift card trackerstore credit loggift voucher registergift certificate logvoucher liability

Details

Format
Spreadsheet
Category
Store Operations
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetStore OperationsFree

Gift Card & Store Credit Log

Every card and credit issued, what has been redeemed, the balance outstanding and what is about to expire.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Store Operations
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More store operations templates

View all
Retail Sales Tracker2 sheets

Net sales

$20,210

Avg transaction

$48

Conversion

24%

Net sales by day
SpreadsheetStore Operations

Retail Sales Tracker

Daily sales by channel with transactions, average basket and target progress.

10 min setupPreview
Retail Store KPI Scorecard2 sheets

Sales

$308,840

Conversion rate

14%

Average transaction value

$33

Sales by store
$148k
$130k
$31k
Riverside MallHigh StreetStation Kiosk
SpreadsheetStore Operations

Retail Store KPI Scorecard

Weekly footfall, transactions, units and sales by store, turned into conversion, basket value and units per sale.

10 min setupPreview
Store Staff Rota2 sheets

Total hours

150

Labour cost

$2,622

Labour % of sales

18%

ABCD
1StaffRoleContracted hrsMon
2HannahManager408
3OmarSupervisor320
4PriyaSales associate246
5TomSales associate160
Rota
SpreadsheetStore Operations

Store Staff Rota

Next week's hours by person and day, with contract and overtime checks, staff on and labour cost each day, minimum cover alerts and labour as a share of forecast sales.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ