Can I have one register from two accounts in M03 and in import question

#7 10-18-2003, 05:13 AM

Your post advises to check "the sample data file...", where can I find the
sample data file?

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:#uPx2YNlDHA.2328[at]TK2MSFTNGP10.phx.gbl...
- quote -

> Answers inline.
> "les" <elias[at]dc.net> wrote in message
> news:enr1VFNlDHA.2012[at]TK2MSFTNGP12.phx.gbl...
> > I have just begun trying-out Money 2003 and am having trouble doing what
I
> > want to do. I have two accounts, one is a Merrill Lynch money market
> > account which contains my portfolio and my VISA account and I also write
> > checks in that account. The second account is a Credit Union account in
> > which deposits are made and from which I pay bills. I would like to
have
> > one register that will contain all deposits and expenditures, including
> the
> > VISA charges, from both accounts. Can I do this and how?
> A register typically matches a single account. A Money data file can have
> multiple accounts, hence multiple registers. If you had "one register
> [containing all transactions] from both accounts" how would you balance
it?
> Your scenario sounds best to me as one Money data file with four accounts:
a
> VISA credit card account, a Credit Union Draft account, an Investment cash
> account (matches the ML money market account but probably has no end of
> complications if you want to download transaction data) and an associated
> Investment account for the portfolio save the cash component. This is
quite
> a normal setup in Money.
> I read your term "register" as synonymous with Money data file. I think
one
> data file with all of the accounts in your life is the best answer, and
this
> is imminently do-able. Money supports reporting and cash flow managment,
> among other things, across multiple accounts. You might want to look at
the
> sample data file to see how all of this was designed to work.
> > Also, ML only keeps 90 days worth of transactions. I would like to load
> the
> > entire year into Money. I have all of the data stored in a homemade
> Foxpro
> > application. I can output the data into any format that Money would
like.
> > Where can I find what the format is and can I they import that file into
> > Money to contain the entire year?
> Can FoxPro output QIF (Quicken Interchange Format)? I didn't think so.
> That's what Money knows how to import.
> See http://www.bollar.org/msmoney/#Q8 for info about generating QIF.
> <PREACHING> My final piece of advice I offer to every new user who might listen: Just
> Say No to messing with downloaded transaction data for now. Get things
> working and learn how to enter your own transactions by hand. Once you get
> all of this understood and working, then read about all of the issues that
> downloaded transaction data creates for various people in the newsgroup.
You
> may decide that downloading transaction data is more hassle than it's
worth
> or, at the least, because you have done it by hand you'll be better
prepared
> to understand and deal with these issues.
> </PREACHING

#6 10-18-2003, 04:11 AM

It's in the installation directory for Money, typically c:\program
file\Microsoft Money\

"les" <elias[at]dc.net> wrote in message
news:%233$c5zRlDHA.3612[at]TK2MSFTNGP11.phx.gbl...
- quote -

> Your post advises to check "the sample data file...", where can I find the
> sample data file?

#5 10-18-2003, 01:54 AM

Thanks for the response. I guess I don't know the difference between a
file, a register and an account. I am not interested in "balancing" the
accounts. I was attracted to the budget feature to track income and
expenses since both income and expenses come from the ML account and the CU
account. So seeing them in one (account, register, file) is what I would
like to do. I'll take your advice to gain a better understanding of what
the terms and the activities of Money are by entering data directly, but I
was impressed with the way Money downloaded data and categorized the
downloaded data. However, there is one problem with the CU download and
that is - Money uses the data in the description field to determine the
category for the expense. Unfortunately, the CU uses about the first 30
characters for CU identification before it gets around to describe the
transaction. This makes Money assign categories incorrectly.

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:#uPx2YNlDHA.2328[at]TK2MSFTNGP10.phx.gbl...
- quote -

> Answers inline.
> "les" <elias[at]dc.net> wrote in message
> news:enr1VFNlDHA.2012[at]TK2MSFTNGP12.phx.gbl...
> > I have just begun trying-out Money 2003 and am having trouble doing what
I
> > want to do. I have two accounts, one is a Merrill Lynch money market
> > account which contains my portfolio and my VISA account and I also write
> > checks in that account. The second account is a Credit Union account in
> > which deposits are made and from which I pay bills. I would like to
have
> > one register that will contain all deposits and expenditures, including
> the
> > VISA charges, from both accounts. Can I do this and how?
> A register typically matches a single account. A Money data file can have
> multiple accounts, hence multiple registers. If you had "one register
> [containing all transactions] from both accounts" how would you balance
it?
> Your scenario sounds best to me as one Money data file with four accounts:
a
> VISA credit card account, a Credit Union Draft account, an Investment cash
> account (matches the ML money market account but probably has no end of
> complications if you want to download transaction data) and an associated
> Investment account for the portfolio save the cash component. This is
quite
> a normal setup in Money.
> I read your term "register" as synonymous with Money data file. I think
one
> data file with all of the accounts in your life is the best answer, and
this
> is imminently do-able. Money supports reporting and cash flow managment,
> among other things, across multiple accounts. You might want to look at
the
> sample data file to see how all of this was designed to work.
> > Also, ML only keeps 90 days worth of transactions. I would like to load
> the
> > entire year into Money. I have all of the data stored in a homemade
> Foxpro
> > application. I can output the data into any format that Money would
like.
> > Where can I find what the format is and can I they import that file into
> > Money to contain the entire year?
> Can FoxPro output QIF (Quicken Interchange Format)? I didn't think so.
> That's what Money knows how to import.
> See http://www.bollar.org/msmoney/#Q8 for info about generating QIF.
> <PREACHING> My final piece of advice I offer to every new user who might listen: Just
> Say No to messing with downloaded transaction data for now. Get things
> working and learn how to enter your own transactions by hand. Once you get
> all of this understood and working, then read about all of the issues that
> downloaded transaction data creates for various people in the newsgroup.
You
> may decide that downloading transaction data is more hassle than it's
worth
> or, at the least, because you have done it by hand you'll be better
prepared
> to understand and deal with these issues.
> </PREACHING

#4 10-18-2003, 01:19 AM

Thanks for the tip. I exported data from Money and looked at the format and
I can easily parse the data in my Foxpro dbf to look exactly like the Money
QIF export. So it appears as though I will be able to load all of the old
data.
"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:soc0pv0s21jcqndp2ubcqfnrd1du3subti[at]4ax.com...
- quote -

> In microsoft.public.money, les wrote:
> > I have just begun trying-out Money 2003 and am having trouble doing what
I
> > want to do. I have two accounts, one is a Merrill Lynch money market
> > account which contains my portfolio and my VISA account and I also write
> > checks in that account. The second account is a Credit Union account in
> > which deposits are made and from which I pay bills. I would like to have
> > one register that will contain all deposits and expenditures, including
the
> > VISA charges, from both accounts. Can I do this and how?
> > I would not want to even think about that if you mean you want to go
> to one account rather than one file.
> Instead I would suggest different accounts and use Reports to
> display the combined transactions.
> > > > Also, ML only keeps 90 days worth of transactions. I would like to load
the
> > entire year into Money. I have all of the data stored in a homemade
Foxpro
> > application. I can output the data into any format that Money would
like.
> > Where can I find what the format is and can I they import that file into
> > Money to contain the entire year?
> You have downloaded some data. File-> Export that data from both the
> Cash Transactions and the Investment Transaction to see a format
> that Money will like.
> Create a corresponding pair of .qif files with the so far
> un-recorded transactions. Name the investment transactions
> alphabetically before the cash transactions. Starting the name of
> the investment transactions file with an underscore would do it.
> File-> Import both files ALL AT ONCE with Ctrl+<click> .

#3 10-17-2003, 11:30 PM

The tip of the iceberg of the kinds of issues I was preaching about.

Good luck and come on back with questions as you progress.

"les" <elias[at]dc.net> wrote in message
news:e9V%23jEQlDHA.1004[at]TK2MSFTNGP09.phx.gbl...
- quote -

> However, there is one problem with the CU download and
> that is - Money uses the data in the description field to determine the
> category for the expense. Unfortunately, the CU uses about the first 30
> characters for CU identification before it gets around to describe the
> transaction. This makes Money assign categories incorrectly.

#2 10-17-2003, 09:23 PM

To add to Dick's PREACHING ;-) think long and hard about a backup strategy.
Do not rely on a single floppy or even a series of floppies. Think about
backing up to hard disk and then burning a CD from the hard disk or copying
to some other removable media. Test the backups regularly as it will always
be the most critical backup that you cant read when you need it most!

--
Regards
Bob Peel,
Microsoft MVP - Money

Hints/Tips
http://support.microsoft.com/default...d=fh;EN-GB;mny
UK Wishes/Suggestions
mnyukwsh[at]microsoft.com

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:%23uPx2YNlDHA.2328[at]TK2MSFTNGP10.phx.gbl...
- quote -

> Answers inline.
> "les" <elias[at]dc.net> wrote in message
> news:enr1VFNlDHA.2012[at]TK2MSFTNGP12.phx.gbl...
> > I have just begun trying-out Money 2003 and am having trouble doing what
I
> > want to do. I have two accounts, one is a Merrill Lynch money market
> > account which contains my portfolio and my VISA account and I also write
> > checks in that account. The second account is a Credit Union account in
> > which deposits are made and from which I pay bills. I would like to
have
> > one register that will contain all deposits and expenditures, including
> the
> > VISA charges, from both accounts. Can I do this and how?
> A register typically matches a single account. A Money data file can have
> multiple accounts, hence multiple registers. If you had "one register
> [containing all transactions] from both accounts" how would you balance
it?
> Your scenario sounds best to me as one Money data file with four accounts:
a
> VISA credit card account, a Credit Union Draft account, an Investment cash
> account (matches the ML money market account but probably has no end of
> complications if you want to download transaction data) and an associated
> Investment account for the portfolio save the cash component. This is
quite
> a normal setup in Money.
> I read your term "register" as synonymous with Money data file. I think
one
> data file with all of the accounts in your life is the best answer, and
this
> is imminently do-able. Money supports reporting and cash flow managment,
> among other things, across multiple accounts. You might want to look at
the
> sample data file to see how all of this was designed to work.
> > Also, ML only keeps 90 days worth of transactions. I would like to load
> the
> > entire year into Money. I have all of the data stored in a homemade
> Foxpro
> > application. I can output the data into any format that Money would
like.
> > Where can I find what the format is and can I they import that file into
> > Money to contain the entire year?
> Can FoxPro output QIF (Quicken Interchange Format)? I didn't think so.
> That's what Money knows how to import.
> See http://www.bollar.org/msmoney/#Q8 for info about generating QIF.
> <PREACHING> My final piece of advice I offer to every new user who might listen: Just
> Say No to messing with downloaded transaction data for now. Get things
> working and learn how to enter your own transactions by hand. Once you get
> all of this understood and working, then read about all of the issues that
> downloaded transaction data creates for various people in the newsgroup.
You
> may decide that downloading transaction data is more hassle than it's
worth
> or, at the least, because you have done it by hand you'll be better
prepared
> to understand and deal with these issues.
> </PREACHING

#1 10-17-2003, 08:11 PM

I have just begun trying-out Money 2003 and am having trouble doing what I
want to do. I have two accounts, one is a Merrill Lynch money market
account which contains my portfolio and my VISA account and I also write
checks in that account. The second account is a Credit Union account in
which deposits are made and from which I pay bills. I would like to have
one register that will contain all deposits and expenditures, including the
VISA charges, from both accounts. Can I do this and how?

Also, ML only keeps 90 days worth of transactions. I would like to load the
entire year into Money. I have all of the data stored in a homemade Foxpro
application. I can output the data into any format that Money would like.
Where can I find what the format is and can I they import that file into
Money to contain the entire year?

10-17-2003, 06:30 PM

In microsoft.public.money, les wrote:

- quote -

> I have just begun trying-out Money 2003 and am having trouble doing what I
> want to do. I have two accounts, one is a Merrill Lynch money market
> account which contains my portfolio and my VISA account and I also write
> checks in that account. The second account is a Credit Union account in
> which deposits are made and from which I pay bills. I would like to have
> one register that will contain all deposits and expenditures, including the
> VISA charges, from both accounts. Can I do this and how?

I would not want to even think about that if you mean you want to go
to one account rather than one file.

Instead I would suggest different accounts and use Reports to
display the combined transactions.

- quote -

> Also, ML only keeps 90 days worth of transactions. I would like to load the
> entire year into Money. I have all of the data stored in a homemade Foxpro
> application. I can output the data into any format that Money would like.
> Where can I find what the format is and can I they import that file into
> Money to contain the entire year?

You have downloaded some data. File-> Export that data from both the
Cash Transactions and the Investment Transaction to see a format
that Money will like.

Create a corresponding pair of .qif files with the so far
un-recorded transactions. Name the investment transactions
alphabetically before the cash transactions. Starting the name of
the investment transactions file with an underscore would do it.
File-> Import both files ALL AT ONCE with Ctrl+<click> .

#-1 10-17-2003, 05:43 PM

Answers inline.

"les" <elias[at]dc.net> wrote in message
news:enr1VFNlDHA.2012[at]TK2MSFTNGP12.phx.gbl...
- quote -

> I have just begun trying-out Money 2003 and am having trouble doing what I
> want to do. I have two accounts, one is a Merrill Lynch money market
> account which contains my portfolio and my VISA account and I also write
> checks in that account. The second account is a Credit Union account in
> which deposits are made and from which I pay bills. I would like to have
> one register that will contain all deposits and expenditures, including
the
> VISA charges, from both accounts. Can I do this and how?

A register typically matches a single account. A Money data file can have
multiple accounts, hence multiple registers. If you had "one register
[containing all transactions] from both accounts" how would you balance it?
Your scenario sounds best to me as one Money data file with four accounts: a
VISA credit card account, a Credit Union Draft account, an Investment cash
account (matches the ML money market account but probably has no end of
complications if you want to download transaction data) and an associated
Investment account for the portfolio save the cash component. This is quite
a normal setup in Money.

I read your term "register" as synonymous with Money data file. I think one
data file with all of the accounts in your life is the best answer, and this
is imminently do-able. Money supports reporting and cash flow managment,
among other things, across multiple accounts. You might want to look at the
sample data file to see how all of this was designed to work.

- quote -

> Also, ML only keeps 90 days worth of transactions. I would like to load
the
> entire year into Money. I have all of the data stored in a homemade
Foxpro
> application. I can output the data into any format that Money would like.
> Where can I find what the format is and can I they import that file into
> Money to contain the entire year?

Can FoxPro output QIF (Quicken Interchange Format)? I didn't think so.
That's what Money knows how to import.

See http://www.bollar.org/msmoney/#Q8 for info about generating QIF.

<PREACHINGMy final piece of advice I offer to every new user who might listen: Just
Say No to messing with downloaded transaction data for now. Get things
working and learn how to enter your own transactions by hand. Once you get
all of this understood and working, then read about all of the issues that
downloaded transaction data creates for various people in the newsgroup. You
may decide that downloading transaction data is more hassle than it's worth
or, at the least, because you have done it by hand you'll be better prepared
to understand and deal with these issues.
</PREACHING

Similar Threads
Thread	Forum	Replies	Last Post
register cathy: Does anyone know how to remove the family member and properties lines from my register, I accidently added them and want less confusion Thanks	Microsoft Money	1	10-10-2003 11:06 PM
Account Register Bob Brannon: Hello, I am using MS Money 2003. There is an envelope icon in the (!) exclamation field of one record in the account register for my checkbook...	Microsoft Money	2	10-09-2003 08:26 PM
Register Renee: Can someone tell me how to print ONLY the check register???	Microsoft Money	1	08-18-2003 02:04 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode