Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #12  
Old 04-02-2008, 03:01 AM
Dave924
Guest
 
Posts: n/a
Default Re: Tracking bills auto-deducted from paycheck



"Dick Watson" wrote:

- quote -

> The workaround is to use some intermediate account--like if you have a
> "pocket change" account for the cash in your pocket, you Transfer the Loan
> Payment amount tot hat account and then you enter the Loan Payment in that
> account. Since it's +$x, -$x, =$0, it make no difference, really, what
> account you use.
> "Dave924" <Dave924[at]discussions.microsoft.com> wrote in message
> news:E95DF309-76FE-441A-B717-C249A0B68B55[at]microsoft.com...
> > Anyway, you had indicated that there was a work around for not being able
> > to
> > use a loan payment category for a paycheck transaction and I would be most
> > appreciative if you could tell me how you go about doing that.
> > > I have a loan where the payments are automatically deducted from my

> > paycheck
> > and I would like to record that paycheck deduction in my Money 2003 file.

Of course that's a great idea.........Thank you very much!

Dave
  #11  
Old 04-02-2008, 02:00 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Tracking bills auto-deducted from paycheck

The workaround is to use some intermediate account--like if you have a
"pocket change" account for the cash in your pocket, you Transfer the Loan
Payment amount tot hat account and then you enter the Loan Payment in that
account. Since it's +$x, -$x, =$0, it make no difference, really, what
account you use.

"Dave924" <Dave924[at]discussions.microsoft.com> wrote in message
news:E95DF309-76FE-441A-B717-C249A0B68B55[at]microsoft.com...
- quote -

> Anyway, you had indicated that there was a work around for not being able
> to
> use a loan payment category for a paycheck transaction and I would be most
> appreciative if you could tell me how you go about doing that.
> I have a loan where the payments are automatically deducted from my
> paycheck
> and I would like to record that paycheck deduction in my Money 2003 file.



  #10  
Old 04-02-2008, 01:12 AM
Dave924
Guest
 
Posts: n/a
Default Re: Tracking bills auto-deducted from paycheck



"Dick Watson" wrote:

- quote -

> Assuming you are using Advanced Register and not the Essentials edition of
> Money, you can use the "Paycheck" split transaction type to track everything
> from your paycheck. Gross income, deductions before taxes, tax withholding,
> deductions after tax like these. Depending on whether these transfers from
> your paycheck go to accounts you have in Money, you can just use Transfer
> (e.g., Transfer : Credit Union Savings) or some expense category (e.g.,
> Insurance : Automobile) directly. These entries are just separate
> transaction lines in the Paycheck transaction. The one thing that's not
> possible is a Loan Payment of an amortizing Loan Account. There are ways
> around this if it is what you want to do. Post back.
> If you are using Essential Register or Money Essentials (MEss) edition, none
> of this answer applies. Likewise if you are wondering things like this, you
> are probably ready to outgrow Essential Register or MEss anyway.
> "Tim Trachimowicz" <trackspace[at]gmail.com> wrote in message
> news:15280e52-bdab-4ec0-97c7-be50c15a70c8[at]d4g2000prg.googlegroups.com...
> > On Mar 23, 3:04 pm, Tim Trachimowicz <tracksp...[at]gmail.com> wrote:
> > > I get home/auto insurance through my employer and the fees are
> > > deducted from my paycheck every two weeks. From a tracking/budget
> > > perspective, how should I be capturing this?
> > > > > Thanks!
> > > I forgot to mention, my net paycheck it direct deposited into my

> > account which is automatically captured by Money. I don't see the
> > gross to itemize this and other deductions except on my pay stub.

Sorry about the last 3 blank replies. I am new to this discussion group and
I was having difficulty finding out where I should type my reply.

Anyway, you had indicated that there was a work around for not being able to
use a loan payment category for a paycheck transaction and I would be most
appreciative if you could tell me how you go about doing that.

I have a loan where the payments are automatically deducted from my paycheck
and I would like to record that paycheck deduction in my Money 2003 file.

Thanks for your help.
  #9  
Old 04-02-2008, 12:54 AM
Dave924
Guest
 
Posts: n/a
Default Re: Tracking bills auto-deducted from paycheck



"Dick Watson" wrote:

- quote -

> Assuming you are using Advanced Register and not the Essentials edition of
> Money, you can use the "Paycheck" split transaction type to track everything
> from your paycheck. Gross income, deductions before taxes, tax withholding,
> deductions after tax like these. Depending on whether these transfers from
> your paycheck go to accounts you have in Money, you can just use Transfer
> (e.g., Transfer : Credit Union Savings) or some expense category (e.g.,
> Insurance : Automobile) directly. These entries are just separate
> transaction lines in the Paycheck transaction. The one thing that's not
> possible is a Loan Payment of an amortizing Loan Account. There are ways
> around this if it is what you want to do. Post back.
> If you are using Essential Register or Money Essentials (MEss) edition, none
> of this answer applies. Likewise if you are wondering things like this, you
> are probably ready to outgrow Essential Register or MEss anyway.
> "Tim Trachimowicz" <trackspace[at]gmail.com> wrote in message
> news:15280e52-bdab-4ec0-97c7-be50c15a70c8[at]d4g2000prg.googlegroups.com...
> > On Mar 23, 3:04 pm, Tim Trachimowicz <tracksp...[at]gmail.com> wrote:
> > > I get home/auto insurance through my employer and the fees are
> > > deducted from my paycheck every two weeks. From a tracking/budget
> > > perspective, how should I be capturing this?
> > > > > Thanks!
> > > I forgot to mention, my net paycheck it direct deposited into my

> > account which is automatically captured by Money. I don't see the
> > gross to itemize this and other deductions except on my pay stub.

  #8  
Old 04-02-2008, 12:51 AM
Dave924
Guest
 
Posts: n/a
Default Re: Tracking bills auto-deducted from paycheck



"Dick Watson" wrote:

- quote -

> Assuming you are using Advanced Register and not the Essentials edition of
> Money, you can use the "Paycheck" split transaction type to track everything
> from your paycheck. Gross income, deductions before taxes, tax withholding,
> deductions after tax like these. Depending on whether these transfers from
> your paycheck go to accounts you have in Money, you can just use Transfer
> (e.g., Transfer : Credit Union Savings) or some expense category (e.g.,
> Insurance : Automobile) directly. These entries are just separate
> transaction lines in the Paycheck transaction. The one thing that's not
> possible is a Loan Payment of an amortizing Loan Account. There are ways
> around this if it is what you want to do. Post back.
> If you are using Essential Register or Money Essentials (MEss) edition, none
> of this answer applies. Likewise if you are wondering things like this, you
> are probably ready to outgrow Essential Register or MEss anyway.
> "Tim Trachimowicz" <trackspace[at]gmail.com> wrote in message
> news:15280e52-bdab-4ec0-97c7-be50c15a70c8[at]d4g2000prg.googlegroups.com...
> > On Mar 23, 3:04 pm, Tim Trachimowicz <tracksp...[at]gmail.com> wrote:
> > > I get home/auto insurance through my employer and the fees are
> > > deducted from my paycheck every two weeks. From a tracking/budget
> > > perspective, how should I be capturing this?
> > > > > Thanks!
> > > I forgot to mention, my net paycheck it direct deposited into my

> > account which is automatically captured by Money. I don't see the
> > gross to itemize this and other deductions except on my pay stub.

  #7  
Old 04-02-2008, 12:49 AM
Dave924
Guest
 
Posts: n/a
Default Re: Tracking bills auto-deducted from paycheck



"Dick Watson" wrote:

- quote -

> Assuming you are using Advanced Register and not the Essentials edition of
> Money, you can use the "Paycheck" split transaction type to track everything
> from your paycheck. Gross income, deductions before taxes, tax withholding,
> deductions after tax like these. Depending on whether these transfers from
> your paycheck go to accounts you have in Money, you can just use Transfer
> (e.g., Transfer : Credit Union Savings) or some expense category (e.g.,
> Insurance : Automobile) directly. These entries are just separate
> transaction lines in the Paycheck transaction. The one thing that's not
> possible is a Loan Payment of an amortizing Loan Account. There are ways
> around this if it is what you want to do. Post back.
> If you are using Essential Register or Money Essentials (MEss) edition, none
> of this answer applies. Likewise if you are wondering things like this, you
> are probably ready to outgrow Essential Register or MEss anyway.
> "Tim Trachimowicz" <trackspace[at]gmail.com> wrote in message
> news:15280e52-bdab-4ec0-97c7-be50c15a70c8[at]d4g2000prg.googlegroups.com...
> > On Mar 23, 3:04 pm, Tim Trachimowicz <tracksp...[at]gmail.com> wrote:
> > > I get home/auto insurance through my employer and the fees are
> > > deducted from my paycheck every two weeks. From a tracking/budget
> > > perspective, how should I be capturing this?
> > > > > Thanks!
> > > I forgot to mention, my net paycheck it direct deposited into my

> > account which is automatically captured by Money. I don't see the
> > gross to itemize this and other deductions except on my pay stub.

  #6  
Old 03-26-2008, 08:26 PM
Retired Coal Miner
Guest
 
Posts: n/a
Default Re: Tracking bills auto-deducted from paycheck

I don't trust it either, always open and check the details. And always find
it to be correct. And I'm pleasantly surprised each time.

Dick Watson wrote:
- quote -

> I have noticed the same behavior. I think it looks at transaction
> history in the series and when it find one that "matches" (I don't know
> exactly what it looks for) it uses the same amounts.
> Somehow, though, I never trust and always finding myself cross-checking.
> Perhaps I'm paranoid in this. But I've also had cases before where
> something that is a KNOWN value like the SS income cap ends up off by a
> couple of pennies (the category totals over the capped time period
> compared to the cap amount) and had to--can't stop myself due to severe
> anal retention--go chase those down after the fact from forty eight or
> forty nine weekly pay stubs that I have to go online to look at, one at
> a time. It's always easiest to get the data right when you first capture
> it than it is to find/fix later.)

  #5  
Old 03-26-2008, 12:44 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Tracking bills auto-deducted from paycheck

I have noticed the same behavior. I think it looks at transaction history in
the series and when it find one that "matches" (I don't know exactly what it
looks for) it uses the same amounts.

Somehow, though, I never trust and always finding myself cross-checking.
Perhaps I'm paranoid in this. But I've also had cases before where something
that is a KNOWN value like the SS income cap ends up off by a couple of
pennies (the category totals over the capped time period compared to the cap
amount) and had to--can't stop myself due to severe anal retention--go chase
those down after the fact from forty eight or forty nine weekly pay stubs
that I have to go online to look at, one at a time. It's always easiest to
get the data right when you first capture it than it is to find/fix later.)

"Retired Coal Miner" <...[at]...> wrote in message
news:VsGdndSpZbIQB3TanZ2dnUVZ_qainZ2d[at]comcast.com...
- quote -

> However, I believe Money handles this effectively in a subtle way that is
> easy to miss.


  #4  
Old 03-25-2008, 11:36 PM
Retired Coal Miner
Guest
 
Posts: n/a
Default Re: Tracking bills auto-deducted from paycheck

Dick Watson wrote:
- quote -

> Mine unfortunately varies the taxes by penny rounding errors all of the time
> so I rarely get to enter one EXACTLY as I've scheduled it. But all I have to
> do is update a number or two. But since I get paid weekly, I have to do this
> cross check every week.

I see that difference of a few pennies on federal taxes almost every paycheck,
and it annoys me to no end why it varies all almost every time. I've gone so
far as to lookup how the IRS says it it should be calculated, (Publication 15
(2008), (Circular E), Employer's Tax Guide, found here
http://www.irs.gov/publications/index.html) and I still do not see how the
calculation varies each time.

However, I believe Money handles this effectively in a subtle way that is easy
to miss. I keep my bi-weekly paycheck setup as a scheduled deposit in B&D.
The net amount deposited into my checking account is set as the amount on the
front of the B&D entry, and the gross, and all the taxes and other deductions
(including transfers into other accounts) are behind the 'details' button in
the B&D entry. The few cents variation in federal taxes causes the net amount
to vary by a few pennies each paycheck. But Money seems to have a memory (or
is capable of searching through past deposits, or ...) of all the previous
entries for the net deposit entered. So given that the gross is always the
same amount, if I ever click the scheduled B&D entry, and change the net
deposit, and the net deposit is an amount that I've previously entered as the
net, Money knows the correct combination of all the deductions and sets them
accordingly so they all add up correctly to the net and gross.

I've seen it do this since the M04 version. The reason I'm impressed with this
is that it gets all the deductions correct, Federal, state and local tax,
health, life, and dental insurance, and other deductions. I have 12 different
deductions and it gets them correct all the time. I suspect it might use the
same algorithm that it uses when you balance a checking account, where when
you enter a balance for the stmt date, if there is one unique combination of
debits and credits that sum up to the difference between the last stmt balance
and this stmt balance, then those are the entries selected.

To add to the previous suggestions, I enter the scheduled B&D on a Thu or
Friday when I receive my biweekly direct deposit notification, (which has all
the deduction details listed). That makes any transfers into other accounts
appear in the other accounts, too. It's Saturday or Sunday until Money picks
up the deposit transaction from the bank, but by then I already know the
exact amount, and entered it when I entered the scheduled deposit on Thu or Fri.
  #3  
Old 03-24-2008, 09:43 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Tracking bills auto-deducted from paycheck

Glad we can help and thanks for the feedback. Post back if you run into issues.

To your earlier post, yes, one of the signature problems with downloaded
data is you only get what the bank knows. In this case, they only know net
pay. But knowing gross and all of the puts and takes is pretty key to things
like tax planning and cases like yours.

What you can do--and it will also help some of the budget models--is to
update one download to a slit Paycheck with all of your stub information
manually. Then r-click on this in the register and add it to the scheduled
bills in its Paycheck form. Assuming your pay doesn't change from check to
check, you should then only have to do a quick cross-check to stubs of the
sceduled transaction and not have to enter all of the split informaiton by
hand again.

Mine unfortunately varies the taxes by penny rounding errors all of the time
so I rarely get to enter one EXACTLY as I've scheduled it. But all I have to
do is update a number or two. But since I get paid weekly, I have to do this
cross check every week.

"Tim Trachimowicz" wrote:

- quote -

> Many thanks. I looked into it and it seems that it'd do the trick. I
> appreciate the help.

  #2  
Old 03-24-2008, 05:08 PM
Tim Trachimowicz
Guest
 
Posts: n/a
Default Re: Tracking bills auto-deducted from paycheck

Many thanks. I looked into it and it seems that it'd do the trick. I
appreciate the help.

--Tim

On Mar 23, 9:55 pm, "Dick Watson" <littlegreenge...[at]mind-enufalready-
spring.com> wrote:
- quote -

> Assuming you are using Advanced Register and not the Essentials edition of
> Money, you can use the "Paycheck" split transaction type to track everything
> from your paycheck. Gross income, deductions before taxes, tax withholding,
> deductions after tax like these. Depending on whether these transfers from
> your paycheck go to accounts you have in Money, you can just use Transfer
> (e.g., Transfer : Credit Union Savings) or some expense category (e.g.,
> Insurance : Automobile) directly. These entries are just separate
> transaction lines in the Paycheck transaction. The one thing that's not
> possible is a Loan Payment of an amortizing Loan Account. There are ways
> around this if it is what you want to do. Post back.
> If you are using Essential Register or Money Essentials (MEss) edition, none
> of this answer applies. Likewise if you are wondering things like this, you
> are probably ready to outgrow Essential Register or MEss anyway.
> "Tim Trachimowicz" <tracksp...[at]gmail.com> wrote in message
> news:15280e52-bdab-4ec0-97c7-be50c15a70c8[at]d4g2000prg.googlegroups.com...
> > On Mar 23, 3:04 pm, Tim Trachimowicz <tracksp...[at]gmail.com> wrote:
> > > I get home/auto insurance through my employer and the fees are
> > > deducted from my paycheck every two weeks. From a tracking/budget
> > > perspective, how should I be capturing this?
> > > Thanks!

> > I forgot to mention, my net paycheck it direct deposited into my
> > account which is automatically captured by Money. I don't see the
> > gross to itemize this and other deductions except on my pay stub.

  #1  
Old 03-24-2008, 12:55 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Tracking bills auto-deducted from paycheck

Assuming you are using Advanced Register and not the Essentials edition of
Money, you can use the "Paycheck" split transaction type to track everything
from your paycheck. Gross income, deductions before taxes, tax withholding,
deductions after tax like these. Depending on whether these transfers from
your paycheck go to accounts you have in Money, you can just use Transfer
(e.g., Transfer : Credit Union Savings) or some expense category (e.g.,
Insurance : Automobile) directly. These entries are just separate
transaction lines in the Paycheck transaction. The one thing that's not
possible is a Loan Payment of an amortizing Loan Account. There are ways
around this if it is what you want to do. Post back.

If you are using Essential Register or Money Essentials (MEss) edition, none
of this answer applies. Likewise if you are wondering things like this, you
are probably ready to outgrow Essential Register or MEss anyway.

"Tim Trachimowicz" <trackspace[at]gmail.com> wrote in message
news:15280e52-bdab-4ec0-97c7-be50c15a70c8[at]d4g2000prg.googlegroups.com...
- quote -

> On Mar 23, 3:04 pm, Tim Trachimowicz <tracksp...[at]gmail.com> wrote:
> > I get home/auto insurance through my employer and the fees are
> > deducted from my paycheck every two weeks. From a tracking/budget
> > perspective, how should I be capturing this?
> > > Thanks!

> I forgot to mention, my net paycheck it direct deposited into my
> account which is automatically captured by Money. I don't see the
> gross to itemize this and other deductions except on my pay stub.


 
Old 03-23-2008, 06:07 PM
Tim Trachimowicz
Guest
 
Posts: n/a
Default Re: Tracking bills auto-deducted from paycheck

On Mar 23, 3:04 pm, Tim Trachimowicz <tracksp...[at]gmail.com> wrote:
- quote -

> I get home/auto insurance through my employer and the fees are
> deducted from my paycheck every two weeks. From a tracking/budget
> perspective, how should I be capturing this?
> Thanks!


I forgot to mention, my net paycheck it direct deposited into my
account which is automatically captured by Money. I don't see the
gross to itemize this and other deductions except on my pay stub.
  #-1  
Old 03-23-2008, 06:04 PM
Tim Trachimowicz
Guest
 
Posts: n/a
Default Tracking bills auto-deducted from paycheck

I get home/auto insurance through my employer and the fees are
deducted from my paycheck every two weeks. From a tracking/budget
perspective, how should I be capturing this?

Thanks!
 

Tags
autodeducted, bills, paycheck, tracking
Similar Threads
Thread Forum Replies Last Post
Bills summery/show deducted amt/v2006
Bruce: In my previous versions of Money, in the bills summeray, at the bottom. It use to show how much was in that account, and what the balance would be...
Microsoft Money 11 07-20-2006 08:52 PM
tracking paycheck withholdings
Derick Beckwith: Where is the tool for tracking gross pay and all your payroll deductions? I would like to be able to track all my withholdings for investment and...
Microsoft Money 1 02-13-2004 02:48 AM
Money 98 reconciled item not deducted
Don: As near as I can tell from going back over the account and running the available reports, an amount that I reconciled in a previous month shows as...
Microsoft Money 1 10-21-2003 06:37 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 03:32 AM.