gift voucher tracking

G

Guest

HI :)

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

TIA

Shea.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top