Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #9  
Old 12-26-2006, 12:31 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Balances Problem in MS Money

In microsoft.public.money, Sandac wrote:

- quote -

> I have the same problem with 2 brokers: TDAmeritrade and Merrill Lynch.
> Do you have specific solutions for them?


While I don't, I remember people discussing how to handle TDA. Not
much ML discussions.

The TDA case has been going thru a transition where the sweep for
most accounts is into a bank money marked. They are not sending the
MM buys and sells out, so it is best to let the cash balance
represent the MM balance +/- unsettled trades.

If you have old MMF positions to begin with, it is probably best to
generate a Sell in Money so that your in Money holding of the money
market is zero. It's a little awkward sounding to me, but I expect
somebody will describe a good way to balance the cash in Money after
they are moved away from the older easy way.
  #8  
Old 12-26-2006, 05:01 AM
Sandac
Guest
 
Posts: n/a
Default Re: Balances Problem in MS Money

Cal Learner,
I have the same problem with 2 brokers: TDAmeritrade and Merrill Lynch.
Do you have specific solutions for them?
Thank you.
--
Sam.


"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Sandac wrote:
> > One more question:
> > 1. My problem with balance dveloped because I write a check from my Money
> > Market account. This transaction showed in Cash Transactions but didn't show
> > any where else. It shoud show up as number of share on my Money Market
> > account reduced and credit as cash on my account, before Cash Transaction.
> > How can I do it - recorded? Because Reduce Shares doesn't show up as
> > Deposit or credit to account.

> It depends on how the broker does it. Best IMO is to enter a Sell to
> raise the cash. However if the broker does not send the Buys and
> Sells of the sweep fund, then things are a lot trickier. Let the
> cash balance represent the sum of your sweep MMF and the effect of
> uncleared transactions.
> I am not going to go thru the process now. I notice you did not name
> the broker, so possible specific experience with your broker cannot
> be offered.

  #7  
Old 12-26-2006, 04:01 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Balances Problem in MS Money

In microsoft.public.money, Sandac wrote:

- quote -

> One more question:
> 1. My problem with balance dveloped because I write a check from my Money
> Market account. This transaction showed in Cash Transactions but didn't show
> any where else. It shoud show up as number of share on my Money Market
> account reduced and credit as cash on my account, before Cash Transaction.
> How can I do it - recorded? Because Reduce Shares doesn't show up as
> Deposit or credit to account.


It depends on how the broker does it. Best IMO is to enter a Sell to
raise the cash. However if the broker does not send the Buys and
Sells of the sweep fund, then things are a lot trickier. Let the
cash balance represent the sum of your sweep MMF and the effect of
uncleared transactions.

I am not going to go thru the process now. I notice you did not name
the broker, so possible specific experience with your broker cannot
be offered.
  #6  
Old 12-26-2006, 01:52 AM
Sandac
Guest
 
Posts: n/a
Default Re: Balances Problem in MS Money

One more question:
1. My problem with balance dveloped because I write a check from my Money
Market account. This transaction showed in Cash Transactions but didn't show
any where else. It shoud show up as number of share on my Money Market
account reduced and credit as cash on my account, before Cash Transaction.
How can I do it - recorded? Because Reduce Shares doesn't show up as
Deposit or credit to account.

Thank you.
--
Sam.


"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Sandac wrote:
> > I also prefer to keep on “Track cash transactions” .
> > My undestanding is I need to add a compensating transactions of "Adjustment".
> > My questions:
> > 1. On what date I should record "Adjustment" - on a date I start my account
> > or it can be any date?

> It can be any date. I would prefer to have it be the earliest date
> where I feel fairly confident that I have no missing transactions
> that follow that date.
> After entering the adjustment, you could later change the date if
> you like.
> > 2. Will "Adjustment" transactions affect calculation of my Tax liabilities?

> Not if you don't make it a taxable category. You can specify that
> when you make the category. Alternatively, you could have *no*
> category, and just indicate in the memo that it is an adjustment.
> > 3. If I add "Adjustment" transactions once, will I have to do it again and
> > again in a future to keep my balance correct or it's only once per account
> > life thing?

> It's a one-time thing if you can add all of the subsequent
> transactions. If you were trying to track the cash in your pocket,
> then it would be a fairly frequent thing. But for an investment or
> checking account, you should be able to make it a one-time thing.
> Now suppose you made the adjustment, but later found an old
> transaction that you had not yet entered. In that case, you might
> enter that old transaction, and then modify the adjustment that you
> made.

  #5  
Old 12-25-2006, 07:39 PM
Sandac
Guest
 
Posts: n/a
Default Re: Balances Problem in MS Money

Thanks.
--
Sam.


"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Sandac wrote:
> > I also prefer to keep on “Track cash transactions” .
> > My undestanding is I need to add a compensating transactions of "Adjustment".
> > My questions:
> > 1. On what date I should record "Adjustment" - on a date I start my account
> > or it can be any date?

> It can be any date. I would prefer to have it be the earliest date
> where I feel fairly confident that I have no missing transactions
> that follow that date.
> After entering the adjustment, you could later change the date if
> you like.
> > 2. Will "Adjustment" transactions affect calculation of my Tax liabilities?

> Not if you don't make it a taxable category. You can specify that
> when you make the category. Alternatively, you could have *no*
> category, and just indicate in the memo that it is an adjustment.
> > 3. If I add "Adjustment" transactions once, will I have to do it again and
> > again in a future to keep my balance correct or it's only once per account
> > life thing?

> It's a one-time thing if you can add all of the subsequent
> transactions. If you were trying to track the cash in your pocket,
> then it would be a fairly frequent thing. But for an investment or
> checking account, you should be able to make it a one-time thing.
> Now suppose you made the adjustment, but later found an old
> transaction that you had not yet entered. In that case, you might
> enter that old transaction, and then modify the adjustment that you
> made.

  #4  
Old 12-25-2006, 07:25 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Balances Problem in MS Money

In microsoft.public.money, Sandac wrote:

- quote -

> I also prefer to keep on Track cash transactions .
> My undestanding is I need to add a compensating transactions of "Adjustment".
> My questions:
> 1. On what date I should record "Adjustment" - on a date I start my account
> or it can be any date?


It can be any date. I would prefer to have it be the earliest date
where I feel fairly confident that I have no missing transactions
that follow that date.

After entering the adjustment, you could later change the date if
you like.


- quote -

> 2. Will "Adjustment" transactions affect calculation of my Tax liabilities?

Not if you don't make it a taxable category. You can specify that
when you make the category. Alternatively, you could have *no*
category, and just indicate in the memo that it is an adjustment.

- quote -

> 3. If I add "Adjustment" transactions once, will I have to do it again and
> again in a future to keep my balance correct or it's only once per account
> life thing?


It's a one-time thing if you can add all of the subsequent
transactions. If you were trying to track the cash in your pocket,
then it would be a fairly frequent thing. But for an investment or
checking account, you should be able to make it a one-time thing.

Now suppose you made the adjustment, but later found an old
transaction that you had not yet entered. In that case, you might
enter that old transaction, and then modify the adjustment that you
made.
  #3  
Old 12-25-2006, 07:15 PM
Sandac
Guest
 
Posts: n/a
Default Re: Balances Problem in MS Money

Hi again Cal Learner,
I also prefer to keep on “Track cash transactions” .
My undestanding is I need to add a compensating transactions of "Adjustment".
My questions:
1. On what date I should record "Adjustment" - on a date I start my account
or it can be any date?
2. Will "Adjustment" transactions affect calculation of my Tax liabilities?
3. If I add "Adjustment" transactions once, will I have to do it again and
again in a future to keep my balance correct or it's only once per account
life thing?
--
Sam.


"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Sandac wrote:
> > > "Cal Learner-- MVP" wrote:
> > > > In microsoft.public.money, Sandac wrote:
> > > > > > I am using Money 2006 Premium.
> > > > I am downloading my investment transactions and updating them online.
> > > > I have regular and Retirement accounts.
> > > > I am getting my balances completely wrong, but if I turn off (uncheck)
> > > > “Track cash transactions” the getting almost correct and its fix problem for
> > > > Not Retirement accounts. If I uncheck it for Retirement account Money
> > > > automatically turn off “Retirement account” selection (in Account Settings)
> > > > and make this account not Retirement.
> > > > My questions:
> > > > 1. How can I have my “Track cash transactions” on (selected) and have my
> > > > balances correct?
> > > > > Either enter all of your transactions, or enter some, and enter
> > > something(s) that compensate for the missing transactions.
> > > From Sam: Who and why missed transactions if I have all of them downloaded

> > from my broker and my Initial balances was always $0.0 ?

> I am not sure what you mean. With many brokers, all funds are
> "swept" into a Money Market Fund with Buy transactions. Thus the
> cash transactions register would usually contain zero.
> The "initial balance" would not ever change due to downloads from
> the broker.
> Your current balance is the (signed) sum of the transactions plus
> the initial balance.
> If I have not understood what you were asking, try again. You might
> also name the broker, in case somebody has experience to offer with
> downloading from that broker.
> > > > An initial balance that is non-zero would be to compensate for
> > > transactions that are not entered. I would tend to always put $0.00
> > > initial balance, and if I need to compensate, I would enter a
> > > compensating transactions. I made a category of "Adjustment". If
> > > things were ideal, no such adjustment would be necessary. However it
> > > might be difficult to have everything ideal.
> > > > > > 2. If I have to turn off “Track cash transactions” how can I keep On
> > > > (selected) Retirement account option?
> > > > > I am not in position to check that now. Sounds odd.
> > > From Sam: Can you please test it and let me know? Is it only on my system

> > or general Money bug?

> Probably not this year. Perhaps somebody has M06 handy and can try
> that.
> > > > > > 3. What I suppose to put in Opening balance in Account Settings when I
> > > > started my accounts or any new account?
> > > > > $0.00 if you did not have transactions that you will not enter.
> > > From Sam: If I turn off “Track cash transactions” how it will affect my

> > account? Will my divident, account maitenace fee and all cash transactions
> > disapear ot will not be truct any more?
> > > Those effects will take place. I would prefer to not take that step

> myself, but many people prefer that.

  #2  
Old 12-24-2006, 10:30 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Balances Problem in MS Money

In microsoft.public.money, Sandac wrote:

- quote -

> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, Sandac wrote:
> > > > I am using Money 2006 Premium.
> > > I am downloading my investment transactions and updating them online.
> > > I have regular and Retirement accounts.
> > > I am getting my balances completely wrong, but if I turn off (uncheck)
> > > Track cash transactions the getting almost correct and its fix problem for
> > > Not Retirement accounts. If I uncheck it for Retirement account Money
> > > automatically turn off Retirement account selection (in Account Settings)
> > > and make this account not Retirement.
> > > My questions:
> > > 1. How can I have my Track cash transactions on (selected) and have my
> > > balances correct?
> > > Either enter all of your transactions, or enter some, and enter

> > something(s) that compensate for the missing transactions.

> From Sam: Who and why missed transactions if I have all of them downloaded
> from my broker and my Initial balances was always $0.0 ?


I am not sure what you mean. With many brokers, all funds are
"swept" into a Money Market Fund with Buy transactions. Thus the
cash transactions register would usually contain zero.

The "initial balance" would not ever change due to downloads from
the broker.

Your current balance is the (signed) sum of the transactions plus
the initial balance.

If I have not understood what you were asking, try again. You might
also name the broker, in case somebody has experience to offer with
downloading from that broker.

- quote -

> > An initial balance that is non-zero would be to compensate for
> > transactions that are not entered. I would tend to always put $0.00
> > initial balance, and if I need to compensate, I would enter a
> > compensating transactions. I made a category of "Adjustment". If
> > things were ideal, no such adjustment would be necessary. However it
> > might be difficult to have everything ideal.
> > > 2. If I have to turn off Track cash transactions how can I keep On
> > > (selected) Retirement account option?
> > > I am not in position to check that now. Sounds odd.

> From Sam: Can you please test it and let me know? Is it only on my system
> or general Money bug?


Probably not this year. Perhaps somebody has M06 handy and can try
that.

- quote -

> > > > 3. What I suppose to put in Opening balance in Account Settings when I
> > > started my accounts or any new account?
> > > $0.00 if you did not have transactions that you will not enter.

> From Sam: If I turn off Track cash transactions how it will affect my
> account? Will my divident, account maitenace fee and all cash transactions
> disapear ot will not be truct any more?
>

Those effects will take place. I would prefer to not take that step
myself, but many people prefer that.
  #1  
Old 12-24-2006, 06:28 PM
Sandac
Guest
 
Posts: n/a
Default Re: Balances Problem in MS Money

Thanks for replay.
But I have some editional questions - see below.
--
Sam.


"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Sandac wrote:
> > I am using Money 2006 Premium.
> > I am downloading my investment transactions and updating them online.
> > I have regular and Retirement accounts.
> > I am getting my balances completely wrong, but if I turn off (uncheck)
> > “Track cash transactions” the getting almost correct and its fix problem for
> > Not Retirement accounts. If I uncheck it for Retirement account Money
> > automatically turn off “Retirement account” selection (in Account Settings)
> > and make this account not Retirement.
> > My questions:
> > 1. How can I have my “Track cash transactions” on (selected) and have my
> > balances correct?

> Either enter all of your transactions, or enter some, and enter
> something(s) that compensate for the missing transactions.


From Sam: Who and why missed transactions if I have all of them downloaded
from my broker and my Initial balances was always $0.0 ?

- quote -

> An initial balance that is non-zero would be to compensate for
> transactions that are not entered. I would tend to always put $0.00
> initial balance, and if I need to compensate, I would enter a
> compensating transactions. I made a category of "Adjustment". If
> things were ideal, no such adjustment would be necessary. However it
> might be difficult to have everything ideal.



- quote -

> > 2. If I have to turn off “Track cash transactions” how can I keep On
> > (selected) Retirement account option?

> I am not in position to check that now. Sounds odd.


From Sam: Can you please test it and let me know? Is it only on my system
or general Money bug?
- quote -

> > 3. What I suppose to put in Opening balance in Account Settings when I
> > started my accounts or any new account?

> $0.00 if you did not have transactions that you will not enter.


From Sam: If I turn off “Track cash transactions” how it will affect my
account? Will my divident, account maitenace fee and all cash transactions
disapear ot will not be truct any more?
 
Old 12-24-2006, 01:08 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Balances Problem in MS Money

In microsoft.public.money, Sandac wrote:

- quote -

> I am using Money 2006 Premium.
> I am downloading my investment transactions and updating them online.
> I have regular and Retirement accounts.
> I am getting my balances completely wrong, but if I turn off (uncheck)
> Track cash transactions the getting almost correct and its fix problem for
> Not Retirement accounts. If I uncheck it for Retirement account Money
> automatically turn off Retirement account selection (in Account Settings)
> and make this account not Retirement.
> My questions:
> 1. How can I have my Track cash transactions on (selected) and have my
> balances correct?


Either enter all of your transactions, or enter some, and enter
something(s) that compensate for the missing transactions.

An initial balance that is non-zero would be to compensate for
transactions that are not entered. I would tend to always put $0.00
initial balance, and if I need to compensate, I would enter a
compensating transactions. I made a category of "Adjustment". If
things were ideal, no such adjustment would be necessary. However it
might be difficult to have everything ideal.


- quote -

> 2. If I have to turn off Track cash transactions how can I keep On
> (selected) Retirement account option?


I am not in position to check that now. Sounds odd.

- quote -

> 3. What I suppose to put in Opening balance in Account Settings when I
> started my accounts or any new account?


$0.00 if you did not have transactions that you will not enter.
  #-1  
Old 12-24-2006, 05:40 AM
Sandac
Guest
 
Posts: n/a
Default Balances Problem in MS Money

I am using Money 2006 Premium.
I am downloading my investment transactions and updating them online.
I have regular and Retirement accounts.
I am getting my balances completely wrong, but if I turn off (uncheck)
“Track cash transactions” the getting almost correct and its fix problem for
Not Retirement accounts. If I uncheck it for Retirement account Money
automatically turn off “Retirement account” selection (in Account Settings)
and make this account not Retirement.
My questions:
1. How can I have my “Track cash transactions” on (selected) and have my
balances correct?
2. If I have to turn off “Track cash transactions” how can I keep On
(selected) Retirement account option?
3. What I suppose to put in Opening balance in Account Settings when I
started my accounts or any new account?
Thanks in advance.

Sam.
 

Tags
balances, money, problem
Similar Threads
Thread Forum Replies Last Post
Money 2001 v9.0, balances will not zero
conleche@gmail.com: Older verison of Money has performed flawlessly up until now. Balancing my checking account, all entries I've cleared match the statement perfectly...
Microsoft Money 1 04-20-2006 09:36 PM
New to MS Money 05, having trouble w/ balances :(
rwetsel: My "Bank Balance" in MS Money (the one at the top right of the advanced register, and appearing in the left pane next to the last online update...
Microsoft Money 7 03-08-2005 11:51 PM
Problem with investment vs cash balances in Money 2004
Matt: I am having a terrible problem with balancing the cash side of an investment account. I have searched this newsgroup and have already tried the...
Microsoft Money 6 01-02-2004 10:45 PM
On Line Stmt Balances Different than Account List Balances
wldonnell: I just migrated my money files from an old pc to my new pc by backing up the files on a diskette and then opening the backup diskette on my new pc....
Microsoft Money 2 08-13-2003 01:52 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:24 PM.