Originally Posted by
KYBOSH
I read on another forum where some people found 10K in GCs they didn't know they had/lost.
Personally I can't afford an oversight like that.
Yeah, most of the answers don't discuss how an oversight like that would be detected.
I have a spreadsheet that records events (=records in a database). A GC purchase would be two events: the 500 and the ~4.95. I code the 500 with the last 4 digits of the GC and I code the fee with "-1". A BB "debit" load would code the last 4 digits of the GC. With that system, it's trivial to use a pivot table to detect a code with only one record (which would mean a GC was bought but not drained).