gift voucher tracking

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


"Shea" wrote:

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