comments inline

"Thinker" <Thinker[at]discussions.microsoft.com> wrote in message
news:F5DFE12F-BAEC-4843-8A7F-6CA31D7953B6[at]microsoft.com...
- quote -

Sure.

- quote -

Yah, but as you noted in the original post, this is *very* easily remedied
in Excel.

- quote -

It might be a nice improvement but: a) I think they view reports exported to
Excel as an incredibly low priority use case and what they are doing now is
not *wrong* or hard to work around--unlike, say, the lack of classifications
when exporting via MoneyLink, b) of the top 100 things I'd like to see fixed
or improved in Money I wouldn't even get close to this issue.

I've written code and queries to take specially customized reports and get
ALL of the account transasaction data from all of my accounts out of Money
and re-normalized into a schema I developed in Access. That experience
emboldens me to say that if you think this is the worst sin of the way they
report/export data to Excel, you haven't played enough in this area.

Again, I'm not for a moment saying that the issue you raise isn't "correct".
It's just not a biggie by comparison.

- quote -

???

comments inline

"Thinker" <Thinker[at]discussions.microsoft.com> wrote in message
news:FA9226F5-6003-4ECE-BD24-45C0FE1B43F8[at]microsoft.com...
- quote -

Like at Money version 1? Seriously, I'm not sure what they've ever changed
in this regard that made it more possible to enter every transaction as a
debit or credit.

- quote -

Since Money presents everyting in "Accounts" if you think of an Account as
Asset or Liability, then every entry is a double entry.

- quote -

Maybe, but MOST users do not have the sophisticated understanding of
accounting principles and are aided by semantic assistance from place to
place and time to time.

So I also wonder what people who don't use subcategories see. Do they see

Transfer to : Checking Account
Some Expense Category

?

I am thinking that's what happens--which means that the Transfer to: is just
coincidentally like the Cat:Subcat -- because if I list all my transactions
and sort in Excel by the Auto : Gas category, I get all the positive and
negative transactions (correctly sorted), but if I list all my Checking
transactions and then sort, it (Excel) treats the negative and positive
transactions like two different "Accounts", with the positive listed as
Transfer to: and the negative ones as Transfer from" -- so I do think they
should fix this--it's not the same as the category, subcategory.

If I list

"Dick Watson" wrote:

- quote -

Yeah, so MoneyLink is an option I guess. I do double entry accounting in
Money, which was impossible up until they allowed me to have negative or
positive entries in every account--so I basically have to spoof things
(because Money won't force the debits and credits to be equal).

So I can credit or debit an expense account (i.e., what Money calls a
category) and it doesn't say whether it is debit or crediting, that's assumed
by the +/- sign of the amount. So it's odd that it has to say transfer in or
out.

"Dick Watson" wrote:

- quote -

You don't say HOW you are exporting to Excel. But when I do it from reports,
I get in one column:

Category

Computer : Service Access
Automobile : Gasoline
....
Transfer From : WF Checking

NOTE that the Transfer From : is no different than any other entries--it
needs to be parsed at the " : ". I agree this is somewhat tedious, but my
point is that the ENTIRE Category : Subcategory thing has the exact same
issue.

But when I use MoneyLink to extract, I get in separate columns:

Category Subcategory
Transfer WF Checking

If that's what you like, I'd suggest you investigate MoneyLink. Of course,
as these things go, it has its own set of issues like you can't get
classification out with it.

"Thinker" <Thinker[at]discussions.microsoft.com> wrote in message
news:EEF4929B-1D5C-4430-94A8-A641696B3CF8[at]microsoft.com...
- quote -

When I export to excel, the account names of transfers are listed as:

Transfer from: XYZ Checking
Transfer to: XYZ Checking

This screws up my ability to sort by account name in excel--and while I can
write a function to cut those off, I shouldn't have to do that. The account
name is not "Transfer to" or "Transfer from". Obviously, if the source
account is a bank account and the other account is another asset or liability
account, it is a transfer. Please take the words out of the exported data.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/communities...t.public.money