Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #2  
Old 11-29-2007, 12:33 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: How to handle gift cards in MoneyPlus Deluxe

Here's what I'd do. YMMV.

I use Classification1 as Class. I already have an expense category
Miscellaneouseposit/Credit.

When I buy, say, a $1,000 Piggly Wiggly gift card, I'd create an expense
Miscellaneouseposit/Credit, class: Gift Cards as Money:Piggly Wiggly in
the account where the money came from for the card. When I buy $125 worth of
food groceries deducted from the Piggly Wiggly gift card, I'd enter a
***$0*** transaction in my pocket change cash account ***split*** into a
$125 Food:Groceries expense and a ($125) Miscellaneouseposit/Credit
negative expense, class: Gift Cards as Money:Piggly Wiggly. Then I'd report
transactions for class: Gift Cards as Money and for category
Miscellaneouseposit/Credit, subtotaled by subclass, and make sure the
running balance(s) for each subclass--i.e., each "brand of gift
card--converge back to $0. I.e., they'll go negative at purchase of the
cards and climb back up as the credit is converted to some other real
expense.

Classifications are pretty cheap, so if it takes a dozen of them or more I
think this is much lighter weight of a solution than, say, a dozen cash
accounts.

<semi_political_social_commentaryIt's bizarre that the best ways we can come up with to fund schools in this
country is through such incredibly inefficient--for us and the schools--and
profitable--for the gift card issuer--schemes. Go figure.
</semi_political_social_commentary
"KenDev" <KenDev[at]discussions.microsoft.com> wrote in message
news:B1E7FB95-F7DD-4FA6-842D-E23A3A025FAA[at]microsoft.com...
- quote -

> My school offers gift cards for various retailers as a funding source. I
> am
> trying to determine the best way to handle these gift cards using Money.
> I
> have thought of two options:
> 1. Treat all the purchases of gift cards as transfers into a cash account
> and then track each card as spent. (I think this would require some
> additonal diligent tracking on my part as each card is used and assigning
> the
> cash spent to the right category)
> 2. Create a separate account for each gift card vendor (I think this would
> add too many accounts as I use at least 12-15 different gift card
> vendors).
> I am leaning towards method 1, but I would like to here if anyone has any
> better suggestions as I am sure there are quite a few people out there who
> have to deal with this. (I don't even want to think about the issue that
> purchasing the gift cards also generates some credits towards school
> tuition.)



  #1  
Old 11-28-2007, 04:20 PM
KenDev
Guest
 
Posts: n/a
Default Re: How to handle gift cards in MoneyPlus Deluxe

The amounts can be rather large, I typically purchase $250-$750 at a time and
sometimes over 1000. The time span when the the cards actually get used
range from 1 month to a year or more. For these reasons, I don't like to
mark them as purchases until they are actually used because it makes it hard
to budget.

Additionally, not all cards are consumer spending. Sometimes I use the
smaller denominations for gifts.

Your suggestions have given me the idea that I could combine the two methods
and create fewer accounts that are easier to track. Like one for dining out,
one for home improvement, etc...

Thanks for your help.

Ken

"Chris Cowles" wrote:

- quote -

> "KenDev" <KenDev[at]discussions.microsoft.com> wrote in message
> news:B1E7FB95-F7DD-4FA6-842D-E23A3A025FAA[at]microsoft.com...
> > My school offers gift cards for various retailers as a funding
> > source. I am
> > trying to determine the best way to handle these gift cards using
> > Money. I
> > have thought of two options:
> > > 1. Treat all the purchases of gift cards as transfers into a cash

> > account
> > and then track each card as spent. (I think this would require some
> > additonal diligent tracking on my part as each card is used and
> > assigning the
> > cash spent to the right category)
> > > 2. Create a separate account for each gift card vendor (I think this

> > would
> > add too many accounts as I use at least 12-15 different gift card
> > vendors).

> Treat the entire card as a single purchase categorized as you would
> any other transaction with the same vendor. If you want
> subcategorization that won't work but, for example, I categorize all
> department stores as "department stores". That's all the detail I care
> to track. It's simply consumer spending. I pay closer attention to big
> ticket items but for the most part, it really doesn't matter.
> The amounts in question can't be so great that it matters which month
> you exhaust the gift card in, can it?

 
Old 11-28-2007, 03:49 PM
Chris Cowles
Guest
 
Posts: n/a
Default Re: How to handle gift cards in MoneyPlus Deluxe

"KenDev" <KenDev[at]discussions.microsoft.com> wrote in message
news:B1E7FB95-F7DD-4FA6-842D-E23A3A025FAA[at]microsoft.com...
- quote -

> My school offers gift cards for various retailers as a funding
> source. I am
> trying to determine the best way to handle these gift cards using
> Money. I
> have thought of two options:
> 1. Treat all the purchases of gift cards as transfers into a cash
> account
> and then track each card as spent. (I think this would require some
> additonal diligent tracking on my part as each card is used and
> assigning the
> cash spent to the right category)
> 2. Create a separate account for each gift card vendor (I think this
> would
> add too many accounts as I use at least 12-15 different gift card
> vendors).


Treat the entire card as a single purchase categorized as you would
any other transaction with the same vendor. If you want
subcategorization that won't work but, for example, I categorize all
department stores as "department stores". That's all the detail I care
to track. It's simply consumer spending. I pay closer attention to big
ticket items but for the most part, it really doesn't matter.

The amounts in question can't be so great that it matters which month
you exhaust the gift card in, can it?


  #-1  
Old 11-28-2007, 01:34 PM
KenDev
Guest
 
Posts: n/a
Default How to handle gift cards in MoneyPlus Deluxe

My school offers gift cards for various retailers as a funding source. I am
trying to determine the best way to handle these gift cards using Money. I
have thought of two options:

1. Treat all the purchases of gift cards as transfers into a cash account
and then track each card as spent. (I think this would require some
additonal diligent tracking on my part as each card is used and assigning the
cash spent to the right category)

2. Create a separate account for each gift card vendor (I think this would
add too many accounts as I use at least 12-15 different gift card vendors).

I am leaning towards method 1, but I would like to here if anyone has any
better suggestions as I am sure there are quite a few people out there who
have to deal with this. (I don't even want to think about the issue that
purchasing the gift cards also generates some credits towards school tuition.)

So, I welcome any great insights someone might have.

Thanks,

Ken
 

Tags
cards, deluxe, gift, handle, moneyplus
Similar Threads
Thread Forum Replies Last Post
Desperate - MoneyPlus Crashed!!!
John Gallagher: I am desperate. This morning I booted up my system. When Vista came up, a message box came up stating that Insights had stopped working. There...
Microsoft Money 1 10-26-2007 11:58 AM
moneyplus -- why can't you just leave cashflow alone?
beachhouse: I post here about once a year whenever the newest version of Money comes out... I'm still running Money 2001. The virtual checkbook register in...
Microsoft Money 3 08-17-2007 06:41 PM
Refunds put onto Gift Cards
Kathleen: I utilize my credit card statement as well as a bank account statement to organize most of my purchases. However, when I come to receiving an...
Microsoft Money 2 12-06-2003 03:02 AM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 11:23 PM.