Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #1  
Old 02-19-2004, 08:39 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Using Money 2004 and auto categorizing downloaded transactions???

In microsoft.public.money, wj wrote:

- quote -

> The problem may get even worse that different transactions being assigned to
> a same category or to a same payee.
> For example, I wrote 10 checks to various payees, somehow some payees have
> electronic capability with my bank, so my bank shows those checks cleared
> all as payee "electronic check". When I edit the downloaded transactions and
> assigned a correct payee to the first such "electronic check", all the rest
> "electronic check" become the same payee.


I suggest you add "electronic check" to Excluded Payee Names.

Accounts&Bills-> Categories&Payees-> Payees-> GoToPayeeRulesManager

Excluded Payee Names identifies words and phrases that should be
ignored from the payee
field (e.g., check, deposit).

- quote -

> What a headache.

 
Old 02-19-2004, 08:08 PM
wj
Guest
 
Posts: n/a
Default Re: Using Money 2004 and auto categorizing downloaded transactions???

The problem may get even worse that different transactions being assigned to
a same category or to a same payee.

For example, I wrote 10 checks to various payees, somehow some payees have
electronic capability with my bank, so my bank shows those checks cleared
all as payee "electronic check". When I edit the downloaded transactions and
assigned a correct payee to the first such "electronic check", all the rest
"electronic check" become the same payee.

What a headache.


"Billyba" <none[at]none.com> wrote in message
news:ihp930d31atqo0csde12qp20bm2rimkg6a[at]4ax.com...
- quote -

> I received Money 2004 on a new laptop that I bought.
> All I want to do with it is download all my account transactions from Bank

of
> America, pull them into Money, and have everything autocategorize based on

the
> name so I can easily see 'where the money goes' , ie mortgage, bills,
> entertainment, etc.
> I can't see any easy way to do this.
> I can download and import data fine from BOA. The problem is that each
> transaction has a date encoded in the payee such as LOWES 0212 or LOWES

0215 so
> that EVERY TRANSACTION to the same payee is treated as a different payee.
> I found some rudimentary filtering in the payee rules dialog, but it is

very
> weak in that it cannot filter numeric data, only specific strings. If it

had
> regular expression exclusions, for example, I could easily create a regexp

to
> remove any sequence of 4 digits surrounded by space...
> So here are the problems:
> 1) Money doesn't seem to have a facility to autocategorize based on payee

name.
> I should be able to set a default category for each payee in the payee

details
> screen (for example, DIRECTTV is assigned Bills:Cable/Satellite ), and

apply
> that to ALL transactions to the payee.
> 2) Why the heck can't I select more than one transaction to assign a

category?
> for example, if I could CTRL-click to select ALL of the transactions to
> DIRECTTV, I could assign the Bills:Cable/Satellite category to all of them

in
> one shot, but NO I can't do this.
> 3) I can't see all of the transactions to the same payee anyway because of

the
> date string problem! Double clicking on DIRECTV 0210 just shows that one
> payment, and not all DIRECTTV payments.
> If I am totally missing the boat here then please let me know. But I

could not
> figure out a way to solve any of the above problems.
> Can anyone recommend a different product that actually has some decent

filtering
> capability, and works the way it should with online account data?



  #-1  
Old 02-19-2004, 03:55 PM
Billyba
Guest
 
Posts: n/a
Default Using Money 2004 and auto categorizing downloaded transactions???

I received Money 2004 on a new laptop that I bought.

All I want to do with it is download all my account transactions from Bank of
America, pull them into Money, and have everything autocategorize based on the
name so I can easily see 'where the money goes' , ie mortgage, bills,
entertainment, etc.

I can't see any easy way to do this.

I can download and import data fine from BOA. The problem is that each
transaction has a date encoded in the payee such as LOWES 0212 or LOWES 0215 so
that EVERY TRANSACTION to the same payee is treated as a different payee.

I found some rudimentary filtering in the payee rules dialog, but it is very
weak in that it cannot filter numeric data, only specific strings. If it had
regular expression exclusions, for example, I could easily create a regexp to
remove any sequence of 4 digits surrounded by space...

So here are the problems:

1) Money doesn't seem to have a facility to autocategorize based on payee name.
I should be able to set a default category for each payee in the payee details
screen (for example, DIRECTTV is assigned Bills:Cable/Satellite ), and apply
that to ALL transactions to the payee.

2) Why the heck can't I select more than one transaction to assign a category?
for example, if I could CTRL-click to select ALL of the transactions to
DIRECTTV, I could assign the Bills:Cable/Satellite category to all of them in
one shot, but NO I can't do this.

3) I can't see all of the transactions to the same payee anyway because of the
date string problem! Double clicking on DIRECTV 0210 just shows that one
payment, and not all DIRECTTV payments.


If I am totally missing the boat here then please let me know. But I could not
figure out a way to solve any of the above problems.

Can anyone recommend a different product that actually has some decent filtering
capability, and works the way it should with online account data?

 

Tags
2004, auto, categorizing, downloaded, money, transactions
Similar Threads
Thread Forum Replies Last Post
Auto category transactions??
Robert Gary: I have a lot of automatic transactions that appear on my statements (ATM withdrawl, POS, etc). Is there a way to assign an expression to a category...
Microsoft Money 1 02-15-2004 07:10 AM
Downloaded transactions incorrectly merged-Money 2004
Joel: Maybe this is just an option setting, but I download transactions from my bank on a regular basis. On a regular basis some of the transactions are...
Microsoft Money 5 01-20-2004 04:03 AM
2004 - Cannot view downloaded transactions
Tim: Money 2004 Standard - All of a sudden I cannot view downloaded transactions in my register. The link shown in MoneyCentral at:...
Microsoft Money 6 12-19-2003 01:10 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 06:54 AM.