|
#1
| |||
| |||
| In microsoft.public.money, wj wrote: - quote - > The problem may get even worse that different transactions being assigned to
I suggest you add "electronic check" to Excluded Payee Names.> 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. 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. |
| | |||
| |||
| 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
| |||
| |||
| 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 | |
| |