Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #5  
Old 01-04-2006, 03:30 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: categorizing a tax refund

Curiously enough, this only plays for the Expense Category Taxes:Federal
Income Tax and plays whether the amount being recorded is income or expense.
Contrast this with the treatment of Other Income:Federal Tax Refund where
there is no question and the presence of Taxes:Federal Income Tax and
Taxes:Federal Income Tax-Previous year. At least I think these were,
somewhere along the way, standard categories supplied by Money. The standard
list shrank radically in M05 so they may no longer be there.


  #4  
Old 01-04-2006, 03:23 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: categorizing a tax refund

Wow. Another little known "feature" surfaces in the newsgroup. It's even in
M04.

This is so oddball--it's a relatively unique place where Money does
something absolutely category specific on entry of data and it's another
place where Money collects some metadata that gets absolutely lost in the
application. (Presumably Tax Estimator and maybe the tax reports now about
this. But why isn't it something exposed to the user for any transaction
regardless of category? Sure, it only makes sense for some transactions. But
the hallmark of most other MS apps is that they generalize and abstract
solutions rather than add all of these narrow and closed obscure hacks.) So
there's some code looking at every transaction entered to see if this
question applies? No wonder the thing is such a pig. I wonder how many other
places this kind of crap is done?

"Dave" <p_sellars[at]hotmail.com> wrote in message
news:uk26O2NEGHA.2424[at]TK2MSFTNGP10.phx.gbl...
- quote -

> I've tried something a little different first:
> After backing up, I went back over the last few years federal tax refund
> deposits and re-categorized them as suggested, but maintained them as
> checking account deposits rather than in a new account. As expected Money
> asked if I wished to categorize the deposit as an expense (yes). Money
> also asked which tax year they should be assigned to, taking care of that
> concern. But when I did the same for state tax refund deposits Money
> didn't prompt for a tax year association. I don't know how to check this,
> and I have to assume Money didn't properly handle this untill I know
> otherwise. I suppose I can just change the state tax refund deposit
> transaction dates to Dec 31 of the proper years as previously suggested.
> These are small items and shouldn't skew any reports or statistics much at
> all. Happy New Year, ..............Dave



  #3  
Old 01-04-2006, 02:34 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: categorizing a tax refund

"Dave" <p_sellars[at]hotmail.com> wrote in message
news:uk26O2NEGHA.2424[at]TK2MSFTNGP10.phx.gbl...
- quote -

> Money also asked which tax year they should be assigned to, taking care of
> that concern. But when I did the same for state tax refund deposits Money
> didn't prompt for a tax year association.


That appears to be a new function, or maybe I just never used it. If you go
to the category and right-click a transaction, there's an option to
associate it with a tax year manually. There does not appear to be a
corresponding function for state taxes. You'll have to backdate the
transaction to the proper tax year if you want it to report correctly.

--
Chris Cowles
Gainesville, FL



  #2  
Old 01-04-2006, 02:18 AM
Dave
Guest
 
Posts: n/a
Default Re: categorizing a tax refund


I've tried something a little different first:
After backing up, I went back over the last few years federal tax refund
deposits and re-categorized them as suggested, but maintained them as
checking account deposits rather than in a new account. As expected Money
asked if I wished to categorize the deposit as an expense (yes). Money also
asked which tax year they should be assigned to, taking care of that
concern. But when I did the same for state tax refund deposits Money didn't
prompt for a tax year association. I don't know how to check this, and I
have to assume Money didn't properly handle this untill I know otherwise. I
suppose I can just change the state tax refund deposit transaction dates to
Dec 31 of the proper years as previously suggested. These are small items
and shouldn't skew any reports or statistics much at all. Happy New Year,
...............Dave


  #1  
Old 01-04-2006, 12:25 AM
Dave
Guest
 
Posts: n/a
Default Re: categorizing a tax refund


"Chris Cowles" <NoSpam[at]For.me> wrote
- quote -

> My method: create an account called FIT payment/refund. Create a
> transaction dated 12/31/05 increasing the balance of the account by the
> amount of the refund. Categorize it as income tax expense. It will be a
> negative expense and Money will complain, but say OK. When you get your
> refund, record the deposit as a transfer from FIT payment/refund.
> This method keeps the net tax correct relative to the tax year, and avoids
> recording the refund as income, which it is not.
> Others will have different approaches.
> --
> Chris Cowles
> Gainesville, FL

Thanks, I'll try it that way ..................Dave


 
Old 01-03-2006, 02:56 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: categorizing a tax refund

"Dave" <p_sellars[at]hotmail.com> wrote in message
news:OAaeBhBEGHA.2704[at]TK2MSFTNGP15.phx.gbl...
- quote -

> Hi Everyone,
> I'm running Microsoft Money 2004 Deluxe Version 12.0 Update 1.
> I'd like to know how to properly categorize my annual payroll tax refund.
> I'm guessing it should be entered as I would any regular payment deducted
> from my wages, but as a negative number. However I'm not sure how this
> would affect Money's tracking of amounts within the tax year, or if this
> really matters. I'll appreciate any light shed on this subject.


My method: create an account called FIT payment/refund. Create a transaction
dated 12/31/05 increasing the balance of the account by the amount of the
refund. Categorize it as income tax expense. It will be a negative expense
and Money will complain, but say OK. When you get your refund, record the
deposit as a transfer from FIT payment/refund.

This method keeps the net tax correct relative to the tax year, and avoids
recording the refund as income, which it is not.

Others will have different approaches.
--
Chris Cowles
Gainesville, FL



  #-1  
Old 01-03-2006, 02:46 AM
Dave
Guest
 
Posts: n/a
Default categorizing a tax refund

Hi Everyone,

I'm running Microsoft Money 2004 Deluxe Version 12.0 Update 1.

I'd like to know how to properly categorize my annual payroll tax refund.
I'm guessing it should be entered as I would any regular payment deducted
from my wages, but as a negative number. However I'm not sure how this would
affect Money's tracking of amounts within the tax year, or if this really
matters. I'll appreciate any light shed on this subject. Thanks,
........................Dave


 

Tags
categorizing, refund, tax
Similar Threads
Thread Forum Replies Last Post
2006 refund
greg.kandra@sbcglobal.net: How does one go about getting a refund for a downloaded copy of MS Money 2006 Premium? I purchased and downloaded from Microsoft. Please advise,...
Microsoft Money 1 08-10-2005 06:02 AM
tax escrow refund
Tom L: What's the most accurate way to record a tax escrow refund? When I make my mortgage payments, I split the transaction with a portion going to...
Microsoft Money 2 02-02-2005 05:51 PM
Refund received!
Shorty: I received a check today from MS for the downloaded version of Money 05 Premium . zztook about 3-4 weeks.
Microsoft Money 3 10-25-2004 12:36 AM
Fed Tax refund
Rich: What category should I assign a Federal Tax refund? State and Local has one set up in income but I'm not sure where to apply the federal one. ...
Microsoft Money 1 02-14-2004 10:55 PM



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 03:05 PM.