gift voucher tracking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI :)

Does anyone have a template, or info about setting up a spreadsheet to track
gift voucher redemptions/codes/etc?

TIA

Shea.
 
Hi Shea

So little info, so little detail, so little advise! :-)

You won't find such a specific template, but it can really not be difficult
to do. If you post more detail on what you intend to do, I am sure we can
help!

The way I see it, you need something like the following (Columns)

A: Voucher Number
B: Value
C: Expiry Date
D: Issued to
E: Address (?)
F: Telephone (?)
G: Date Issued
H: Date Tendered/Redeemed
I: Store Name(?)
J: Purchase value(?)
K: Amount Paid: (?)
L: Value less voucher say =if(J2="","",B2-J2)
M: Maybe a control column to see whether the correct amount was allowed?,
say =if(K2="","",if(K2=L2,"OK","WRONG"))

You tell me
 
Back
Top