Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #13  
Old 03-05-2007, 11:19 AM
Jim Johnson
Guest
 
Posts: n/a
Default Re: Bill recording

On Sat, 3 Mar 2007 08:58:30 -0500, Mark Horn <mark[at]hornclan.comwrote:

- quote -

> 2) If I've got a scheduled bill that I know is coming up, I make sure
> to enter it into the register before I download it. This has
> the greatest chance for getting Money to match that transaction.
> If it doesn't match, or matches the wrong transaction, click the
> "Change" button on the downloaded transaction. This will bring
> up a dialog that allows you to unmatch the current transaction and
> select the correct transaction to match.


I do this also, you can set the bill to enter automatically into the
register a day or so ahead of time (you choose the number of days). I
set mine to enter 1 day ahead of time. This way I don't have to do it
manually. Money always matches when I download form the bank. In a
case where I haven't done the above - money will give me the dialog
box asking if it's a scheduled bill when I download. I believe the OP
wasn't getting this.

Jim
  #12  
Old 03-05-2007, 02:01 AM
Mark Horn
Guest
 
Posts: n/a
Default Re: Bill recording

On 2007-03-04, LeGauche <LeGauche[at]discussions.microsoft.com> wrote:
- quote -

> My next question is if you are able to elaborate on matching transactions
> between two accounts. So for instance I have my checking account, my credit
> card and my credit card payment in the Bills section. Since I am able to
> download transactions from both my bank and credit card, I need them to match
> up and also I need to have the monthly credit card payment in my scheduled
> bills and that to match up to recognize the payment from my bank account.


There's not really much to elaborate on. About the only thing
that you have to worry about is when you pay your credit card from
the checking account. What I do is have a scheduled bill from
my checking account that uses the special "Credit Card Payment"
category. When I actually pay the credit card, I enter this bill
into the register. That will result in a transfer of money from
the checking account to the credit card account.

The transactions will eventually be recorded by the bank and the
credit card company. It's usually the credit card company that sees
the transaction first. That will result in a transaction download
that will match the transfer in the credit card account in money.
A day or two later, the bank holding the checking account will see
the transaction. That will result in a transaction download that
will match the transfer in the checking account.

This will result in something weird, but not a big deal.
Whichever account sees the transaction last (in my above example
the checking account) will get to set the date of the transaction
in both accounts. This is because the transaction is a transfer.

- quote -

> The other issue with this is that I have a gas card that I need matched, but
> additionally I don't always use it. Often I pay it off and it isn't another
> month or two before I carry a balance on it again. Will the scheduled bill
> portion of the transaction recognize that my balance is currently zero and
> then suspend that bill until I have a balance again?


No. In the month that happens go into the scheduled bill and click
on "Skip This Occurance".
  #11  
Old 03-04-2007, 02:46 PM
LeGauche
Guest
 
Posts: n/a
Default Re: Bill recording

Thank you! I sense that reply contains all that I need to be successful with
this aspect of Money.

My next question is if you are able to elaborate on matching transactions
between two accounts. So for instance I have my checking account, my credit
card and my credit card payment in the Bills section. Since I am able to
download transactions from both my bank and credit card, I need them to match
up and also I need to have the monthly credit card payment in my scheduled
bills and that to match up to recognize the payment from my bank account.

The other issue with this is that I have a gas card that I need matched, but
additionally I don't always use it. Often I pay it off and it isn't another
month or two before I carry a balance on it again. Will the scheduled bill
portion of the transaction recognize that my balance is currently zero and
then suspend that bill until I have a balance again?

Thanks in advance!

"Mark Horn" wrote:

- quote -

> I think Dick would count me as one of the "true believers".
> Here's the pattern that I use:
> 1) First things first: if you've got the setting where you
> automatically accept all downloaded transactions, don't.
> Turn that off. Pain and suffering are all that will result from
> that setting.
> 2) If I've got a scheduled bill that I know is coming up, I make sure
> to enter it into the register before I download it. This has
> the greatest chance for getting Money to match that transaction.
> If it doesn't match, or matches the wrong transaction, click the
> "Change" button on the downloaded transaction. This will bring
> up a dialog that allows you to unmatch the current transaction and
> select the correct transaction to match.
> 3) If I download a transaction, but I haven't pre-entered the bill
> so that it matches, I don't accept the downloaded transaction.
> I go straight to the scheduled bill and enter it into the
> register. Then I go back to the account register, and click the
> "Change" button to get it to match the correct transaction.
> 4) If I've accidentally clicked "accept". At this point there is
> no way to actually get the transaction to match. What I do is go
> into the scheduled bill and enter it into the register. Then I
> go back to the register and delete the entry I just entered.
> I do this for two reasons: First, I want to make sure that the
> scheduled bill's next payment date is correct. Second, I want
> to make sure that the budget reflects the correct amount for
> this month. By entering it, it will be counted in the budgeted
> portion. By deleting the transaction, the actual portion won't
> be counted twice (once for the downloaded transaction and once
> for my manually entered transaction).
> I hope this makes sense. It's a lot simpler than the amount of
> words that I used to describe it.
> On 2007-02-27, LeGauche <LeGauche[at]discussions.microsoft.com> wrote:
> > That is simply ridiculous.
> > > So you mean to tell me that you have to enter the bill into your register

> > and then delete the duplicate entry because the software can't figure out
> > that, even though you have downloaded an EPAY from your bank that matches the
> > preferred payee name via the payee details in the bill manager, you already
> > paid the bill? What is the point of having the Bill section then if it is
> > just going to duplicate my efforts?
> > > "Bob Peel, MVP" wrote:
> > > > No you have to go to Bills Summary, highlight the bill concerned and click
> > > on Enter in Register.
> > > > > Then when you download and match against your checking account the bills are
> > > in there.
> > > > > --
> > > Regards
> > > Bob Peel,
> > > Microsoft MVP - Money
> > > > > For UK tips & fixes see
> > > http://support.microsoft.com/default...d=fh;EN-GB;mny.
> > > > > > > I do not respond to any emails that I have not specifically asked for.
> > > > > "Belle Gin" <""no$pam\"[at]no$pam.net"> wrote in message
> > > news:d9477$457767b6$42a1c46d$13951[at]FUSE.NET...
> > > > Joaneee wrote:
> > > > > The downloaded transactions get matched to entries in your checking
> > > > > account, not in the bills list. You would have to "pay" the bills so
> > > > > that entries appear in your Money checking account in order to have them
> > > > > match with downloaded transactions. If I understand you right.
> > > > > > > How do I "pay" the bills? Is there something I can enter when I'm going
> > > > through and accepting the downloaded transactions?
> > > >
  #10  
Old 03-03-2007, 12:58 PM
Mark Horn
Guest
 
Posts: n/a
Default Re: Bill recording

I think Dick would count me as one of the "true believers".
Here's the pattern that I use:

1) First things first: if you've got the setting where you
automatically accept all downloaded transactions, don't.
Turn that off. Pain and suffering are all that will result from
that setting.

2) If I've got a scheduled bill that I know is coming up, I make sure
to enter it into the register before I download it. This has
the greatest chance for getting Money to match that transaction.
If it doesn't match, or matches the wrong transaction, click the
"Change" button on the downloaded transaction. This will bring
up a dialog that allows you to unmatch the current transaction and
select the correct transaction to match.

3) If I download a transaction, but I haven't pre-entered the bill
so that it matches, I don't accept the downloaded transaction.
I go straight to the scheduled bill and enter it into the
register. Then I go back to the account register, and click the
"Change" button to get it to match the correct transaction.

4) If I've accidentally clicked "accept". At this point there is
no way to actually get the transaction to match. What I do is go
into the scheduled bill and enter it into the register. Then I
go back to the register and delete the entry I just entered.
I do this for two reasons: First, I want to make sure that the
scheduled bill's next payment date is correct. Second, I want
to make sure that the budget reflects the correct amount for
this month. By entering it, it will be counted in the budgeted
portion. By deleting the transaction, the actual portion won't
be counted twice (once for the downloaded transaction and once
for my manually entered transaction).

I hope this makes sense. It's a lot simpler than the amount of
words that I used to describe it.

On 2007-02-27, LeGauche <LeGauche[at]discussions.microsoft.com> wrote:
- quote -

> That is simply ridiculous.
> So you mean to tell me that you have to enter the bill into your register
> and then delete the duplicate entry because the software can't figure out
> that, even though you have downloaded an EPAY from your bank that matches the
> preferred payee name via the payee details in the bill manager, you already
> paid the bill? What is the point of having the Bill section then if it is
> just going to duplicate my efforts?
> "Bob Peel, MVP" wrote:
> > No you have to go to Bills Summary, highlight the bill concerned and click
> > on Enter in Register.
> > > Then when you download and match against your checking account the bills are

> > in there.
> > > --

> > Regards
> > Bob Peel,
> > Microsoft MVP - Money
> > > For UK tips & fixes see

> > http://support.microsoft.com/default...d=fh;EN-GB;mny.
> > > > I do not respond to any emails that I have not specifically asked for.
> > > "Belle Gin" <""no$pam\"[at]no$pam.net"> wrote in message

> > news:d9477$457767b6$42a1c46d$13951[at]FUSE.NET...
> > > Joaneee wrote:
> > > > The downloaded transactions get matched to entries in your checking
> > > > account, not in the bills list. You would have to "pay" the bills so
> > > > that entries appear in your Money checking account in order to have them
> > > > match with downloaded transactions. If I understand you right.
> > > > > How do I "pay" the bills? Is there something I can enter when I'm going
> > > through and accepting the downloaded transactions?

> >
  #9  
Old 03-01-2007, 02:02 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Bill recording

Try these:

http://groups.google.com/group/micro...e217185376d839

http://groups.google.com/group/micro...e082c87e19dfbd

http://groups.google.com/group/micro...b45e47903c375b

http://groups.google.com/group/micro...b9955a627e14f1

You might also want to do your own advanced search of group
microsoft.public.money at http://groups.google.com.

"LeGauche" <LeGauche[at]discussions.microsoft.com> wrote in message
news:6754BAAD-4F6B-4835-9D80-5773243485F3[at]microsoft.com...
- quote -

> I can't say that I am surprised, but I appreciate your attempt to assist
> me.
> Microsoft should really cover this topic in their tutorials and manuals.
> Unfortunately that post in the link doesn't go into matching downloaded
> transactions in a bank account to due/overdue Bills at all.



  #8  
Old 03-01-2007, 12:08 PM
LeGauche
Guest
 
Posts: n/a
Default Re: Bill recording

I can't say that I am surprised, but I appreciate your attempt to assist me.
Microsoft should really cover this topic in their tutorials and manuals.
Unfortunately that post in the link doesn't go into matching downloaded
transactions in a bank account to due/overdue Bills at all.

Regards,

"Dick Watson" wrote:

- quote -

> I was hoping one of the True Believers in downloaded transaction data would
> jump in here. They haven't. Try this as a starting point:
> http://groups.google.com/group/micro...247d6dc37fd6ed
> "LeGauche" <LeGauche[at]discussions.microsoft.com> wrote in message
> news:13DC8E4D-E0D4-4079-B1B7-87ECCAF00398[at]microsoft.com...
> > Yes. I am using Advanced Register and Advanced Bills. Any information on
> > how to manipulate the software into doing what I want/need/should've done
> > is
> > appreciated.

  #7  
Old 02-28-2007, 09:11 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Bill recording

I was hoping one of the True Believers in downloaded transaction data would
jump in here. They haven't. Try this as a starting point:
http://groups.google.com/group/micro...247d6dc37fd6ed

"LeGauche" <LeGauche[at]discussions.microsoft.com> wrote in message
news:13DC8E4D-E0D4-4079-B1B7-87ECCAF00398[at]microsoft.com...
- quote -

> Yes. I am using Advanced Register and Advanced Bills. Any information on
> how to manipulate the software into doing what I want/need/should've done
> is
> appreciated.



  #6  
Old 02-28-2007, 12:56 AM
LeGauche
Guest
 
Posts: n/a
Default Re: Bill recording

Yes. I am using Advanced Register and Advanced Bills. Any information on
how to manipulate the software into doing what I want/need/should've done is
appreciated.

Thanks!

"Dick Watson" wrote:

- quote -

> Others will have to step in on the exact steps and these steps will only
> apply to future downloaded transactions. The ones in the register already
> are what they are. First let's clarify. Are you using Advanced Register and
> Advanced Bills? They'll need to know to give you a good answer.
> "LeGauche" <LeGauche[at]discussions.microsoft.com> wrote in message
> news:76808F1F-2748-417B-AD3C-A71F59C358A7[at]microsoft.com...
> > I am using Money Deluxe 2007 and I have yet to be asked by Money to Match
> > anything to anything. Would you please elaborate on how to manually match
> > a
> > transaction in a bank account to a bill? Past, present and future
> > transactions if possible.

  #5  
Old 02-28-2007, 12:28 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Bill recording

Others will have to step in on the exact steps and these steps will only
apply to future downloaded transactions. The ones in the register already
are what they are. First let's clarify. Are you using Advanced Register and
Advanced Bills? They'll need to know to give you a good answer.

"LeGauche" <LeGauche[at]discussions.microsoft.com> wrote in message
news:76808F1F-2748-417B-AD3C-A71F59C358A7[at]microsoft.com...
- quote -

> I am using Money Deluxe 2007 and I have yet to be asked by Money to Match
> anything to anything. Would you please elaborate on how to manually match
> a
> transaction in a bank account to a bill? Past, present and future
> transactions if possible.



  #4  
Old 02-27-2007, 11:12 PM
LeGauche
Guest
 
Posts: n/a
Default Re: Bill recording

I am using Money Deluxe 2007 and I have yet to be asked by Money to Match
anything to anything. Would you please elaborate on how to manually match a
transaction in a bank account to a bill? Past, present and future
transactions if possible.

Thanks,

"Dick Watson" wrote:

- quote -

> In most cases, Money is supposed to figure it out. In some cases, it
> doesn't. In these cases, Money would typically expects you to Match it to a
> Bill when it asks if it needs to match it up with anything. Basically you
> get to do manually what it failed to do automagically.
> Beyond matching up with downloaded transactions, the point of having it in
> the Bills is for things like Forecast Cash Flow, Budget Planner, and Tax
> Estimator. FWIW, most of the features that are reasons to have the bill in
> Scheduled Bill pre-date the matching up with downloaded transaction features
> and are usable for many more personal finance management tasks than just
> data capture. By all accounts, most users do get the downloaded transactions
> to work with Scheduled Bills reasonably well.
> I can't say any of how it is supposed to work from experience. I enter my
> transactions by hand and skip all of this nonsense AND get it right, my way,
> the first time. What you call "simply ridiculous" Microsoft and the FIs call
> a feature despite the fact that there are about 1,000 ways for it to fail
> for every 1 there is for it to succeed.
> "LeGauche" <LeGauche[at]discussions.microsoft.com> wrote in message
> news:33AF5307-2546-4405-93F6-32B480806965[at]microsoft.com...
> > That is simply ridiculous.
> > > So you mean to tell me that you have to enter the bill into your register

> > and then delete the duplicate entry because the software can't figure out
> > that, even though you have downloaded an EPAY from your bank that matches
> > the
> > preferred payee name via the payee details in the bill manager, you
> > already
> > paid the bill? What is the point of having the Bill section then if it is
> > just going to duplicate my efforts?

  #3  
Old 02-27-2007, 06:43 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Bill recording

In most cases, Money is supposed to figure it out. In some cases, it
doesn't. In these cases, Money would typically expects you to Match it to a
Bill when it asks if it needs to match it up with anything. Basically you
get to do manually what it failed to do automagically.

Beyond matching up with downloaded transactions, the point of having it in
the Bills is for things like Forecast Cash Flow, Budget Planner, and Tax
Estimator. FWIW, most of the features that are reasons to have the bill in
Scheduled Bill pre-date the matching up with downloaded transaction features
and are usable for many more personal finance management tasks than just
data capture. By all accounts, most users do get the downloaded transactions
to work with Scheduled Bills reasonably well.

I can't say any of how it is supposed to work from experience. I enter my
transactions by hand and skip all of this nonsense AND get it right, my way,
the first time. What you call "simply ridiculous" Microsoft and the FIs call
a feature despite the fact that there are about 1,000 ways for it to fail
for every 1 there is for it to succeed.

"LeGauche" <LeGauche[at]discussions.microsoft.com> wrote in message
news:33AF5307-2546-4405-93F6-32B480806965[at]microsoft.com...
- quote -

> That is simply ridiculous.
> So you mean to tell me that you have to enter the bill into your register
> and then delete the duplicate entry because the software can't figure out
> that, even though you have downloaded an EPAY from your bank that matches
> the
> preferred payee name via the payee details in the bill manager, you
> already
> paid the bill? What is the point of having the Bill section then if it is
> just going to duplicate my efforts?



  #2  
Old 02-27-2007, 06:01 PM
LeGauche
Guest
 
Posts: n/a
Default Re: Bill recording

That is simply ridiculous.

So you mean to tell me that you have to enter the bill into your register
and then delete the duplicate entry because the software can't figure out
that, even though you have downloaded an EPAY from your bank that matches the
preferred payee name via the payee details in the bill manager, you already
paid the bill? What is the point of having the Bill section then if it is
just going to duplicate my efforts?

"Bob Peel, MVP" wrote:

- quote -

> No you have to go to Bills Summary, highlight the bill concerned and click
> on Enter in Register.
> Then when you download and match against your checking account the bills are
> in there.
> --
> Regards
> Bob Peel,
> Microsoft MVP - Money
> For UK tips & fixes see
> http://support.microsoft.com/default...d=fh;EN-GB;mny.
> I do not respond to any emails that I have not specifically asked for.
> "Belle Gin" <""no$pam\"[at]no$pam.net"> wrote in message
> news:d9477$457767b6$42a1c46d$13951[at]FUSE.NET...
> > Joaneee wrote:
> > > The downloaded transactions get matched to entries in your checking
> > > account, not in the bills list. You would have to "pay" the bills so
> > > that entries appear in your Money checking account in order to have them
> > > match with downloaded transactions. If I understand you right.
> > > How do I "pay" the bills? Is there something I can enter when I'm going

> > through and accepting the downloaded transactions?

  #1  
Old 12-07-2006, 03:22 PM
Bob Peel, MVP
Guest
 
Posts: n/a
Default Re: Bill recording

No you have to go to Bills Summary, highlight the bill concerned and click
on Enter in Register.

Then when you download and match against your checking account the bills are
in there.

--
Regards
Bob Peel,
Microsoft MVP - Money

For UK tips & fixes see
http://support.microsoft.com/default...d=fh;EN-GB;mny.


I do not respond to any emails that I have not specifically asked for.

"Belle Gin" <""no$pam\"[at]no$pam.net"> wrote in message
news:d9477$457767b6$42a1c46d$13951[at]FUSE.NET...
- quote -

> Joaneee wrote:
> > The downloaded transactions get matched to entries in your checking
> > account, not in the bills list. You would have to "pay" the bills so
> > that entries appear in your Money checking account in order to have them
> > match with downloaded transactions. If I understand you right.

> How do I "pay" the bills? Is there something I can enter when I'm going
> through and accepting the downloaded transactions?


 
Old 12-07-2006, 12:00 AM
Belle Gin
Guest
 
Posts: n/a
Default Re: Bill recording

Joaneee wrote:
- quote -

> The downloaded transactions get matched to entries in your checking account,
> not in the bills list. You would have to "pay" the bills so that entries
> appear in your Money checking account in order to have them match with
> downloaded transactions. If I understand you right.


How do I "pay" the bills? Is there something I can enter when I'm going
through and accepting the downloaded transactions?
  #-1  
Old 12-06-2006, 06:13 PM
Belle Gin
Guest
 
Posts: n/a
Default Bill recording

I have a number of monthly payments set up in the "bills" section of
Money 2007 Deluxe. I am wondering why, when I download my checking
account transactions, they don't match up with the bills. Money will
show those bills as overdue when in fact they have been debited from my
account on the date indicated in the bills section. Further, there
doesn't seem to be any way to go back and link it to the transaction I
downloaded. what am I doing wrong?
 

Tags
bill, recording
Similar Threads
Thread Forum Replies Last Post
T-Bill recording
songli: I'm using Money2006. I bought $50k worth of 13-week T-Bills. I defined 13wkTBill as a security. When I try to enter this transaction, I put in...
Microsoft Money 2 11-08-2005 02:58 AM
How will this work: Changing bill payer from MSN Bill Pay to mybank
Retired Coal Miner: My one year of MSN Bill Pay premium service, included in M03 dlx is close to expiring. So I am planning to use the service from my bank, (their...
Microsoft Money 1 02-24-2004 02:37 AM
Recording Expenses
Tribe: There does not seem to be a way to enter an expense so that it is recorded on the income statement. Anyone know how to do this?
Microsoft Money 1 02-16-2004 09:39 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 10:13 PM.