Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #3  
Old 02-02-2006, 02:17 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Previous Balance Incorrect

In microsoft.public.money, Skip B wrote:

- quote -

> Well - thanks for the note, but it really doesn't help much. A couple of
> specific questions:
> 1) I had already changed the starting balance adn re-balanced July when I
> got this. Is there a way to "remove" or "unbalance" an account?


Delete the account? File-> Restore?

If you have compensating transactions in the register that are
messing things up, you could delete them.



- quote -

> 2) I had balanced this all the way to December 2005 when this happened.
> Suddenly it says I am back at June? What can cause this?


I don't even know what it would mean to be " back at June".



- quote -

> Skip
> "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
> news:m63ft1tls97rv7gkepre9shja5jav5akci[at]4ax.com...
> > In microsoft.public.money, Skip B wrote:
> > > > I spend a god deal of time last weekend updating and balancing accounts
> > > (ok,
> > > so I was lazy for a few months). So my statement for January came in for
> > > my
> > > main checking account and to my surprise, it says the last time I balanced
> > > was July. When I decided to do it all again, it brought up the wrong
> > > starting balance. Thinking I could correct by putting the correct balances
> > > in, it let me re-balance the July statement, but the starting balance once
> > > more is incorrect for the next statement.
> > > Do not change "Total amount you owed last month". That should be

> > the algebraic sum of all Reconciled statements, which would be the
> > balance you left off with the last time you balanced. Into "Total
> > amount you owe this month", enter balance from web statement. See
> > How Money Calculates the Starting Balance
> > http://support.microsoft.com/default...B;EN-US;138960
> > > If that balance is off, then it would seem that something was marked

> > Reconciled that should not have been, or something that was marked
> > Reconciled got changed to not reconciled.
> > > > > > I'm afraid to go any further. None
> > > of the other accounts is experiencing this issue. Has anyone ever
> > > experienced this? If so, how does one fix this?
> > > ===================Bonnie Synhorst said=======================

> > |Balancing can be frustrating. .. My rule of thumb is to avoid
> > |changing the starting statement balance that it asks for. If you
> > |do this, it will try to make an adjustment that you may not have
> > |needed to make (if you were balancing months out of order, for
> > |instance). I recommend balancing month by month starting from the
> > |earliest date after you are sure that nothing is marked with an R.
> > |
> > |Just remember, the opening balance it asks for is a calculation of
> > |the opening account balance plus or minus any reconciled
> > |transactions.
> > ==========================================
> > > If you have such transactions, you will want to get rid of them if

> > you have the real transaction data.
> > > If the transactions are there, and you know the balance is correct

> > now, you could declare an account balanced by marking all entries
> > balanced. Select to show only unreconciled transactions. Sort by
> > date, and go to the oldest transaction. Hold down Cntl+Shift+M and
> > let auto-repeat work thru the transactions until none are left
> > showing. Then balance making the starting and ending balance match
> > the known balance. Choose the balance date to be the day after your
> > last transaction.
> > > Thereafter, follow the normal procedure.

>
  #2  
Old 02-02-2006, 02:04 AM
Skip B
Guest
 
Posts: n/a
Default Re: Previous Balance Incorrect

Well - thanks for the note, but it really doesn't help much. A couple of
specific questions:

1) I had already changed the starting balance adn re-balanced July when I
got this. Is there a way to "remove" or "unbalance" an account?
2) I had balanced this all the way to December 2005 when this happened.
Suddenly it says I am back at June? What can cause this?

Skip

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:m63ft1tls97rv7gkepre9shja5jav5akci[at]4ax.com...
- quote -

> In microsoft.public.money, Skip B wrote:
> > I spend a god deal of time last weekend updating and balancing accounts
> > (ok,
> > so I was lazy for a few months). So my statement for January came in for
> > my
> > main checking account and to my surprise, it says the last time I balanced
> > was July. When I decided to do it all again, it brought up the wrong
> > starting balance. Thinking I could correct by putting the correct balances
> > in, it let me re-balance the July statement, but the starting balance once
> > more is incorrect for the next statement.

> Do not change "Total amount you owed last month". That should be
> the algebraic sum of all Reconciled statements, which would be the
> balance you left off with the last time you balanced. Into "Total
> amount you owe this month", enter balance from web statement. See
> How Money Calculates the Starting Balance
> http://support.microsoft.com/default...B;EN-US;138960
> If that balance is off, then it would seem that something was marked
> Reconciled that should not have been, or something that was marked
> Reconciled got changed to not reconciled.
> > I'm afraid to go any further. None
> > of the other accounts is experiencing this issue. Has anyone ever
> > experienced this? If so, how does one fix this?

> ===================Bonnie Synhorst said=======================
> |Balancing can be frustrating. .. My rule of thumb is to avoid
> |changing the starting statement balance that it asks for. If you
> |do this, it will try to make an adjustment that you may not have
> |needed to make (if you were balancing months out of order, for
> |instance). I recommend balancing month by month starting from the
> |earliest date after you are sure that nothing is marked with an R.
> |
> |Just remember, the opening balance it asks for is a calculation of
> |the opening account balance plus or minus any reconciled
> |transactions.
> ==========================================
> If you have such transactions, you will want to get rid of them if
> you have the real transaction data.
> If the transactions are there, and you know the balance is correct
> now, you could declare an account balanced by marking all entries
> balanced. Select to show only unreconciled transactions. Sort by
> date, and go to the oldest transaction. Hold down Cntl+Shift+M and
> let auto-repeat work thru the transactions until none are left
> showing. Then balance making the starting and ending balance match
> the known balance. Choose the balance date to be the day after your
> last transaction.
> Thereafter, follow the normal procedure.



  #1  
Old 01-26-2006, 06:36 PM
Jim
Guest
 
Posts: n/a
Default Re: Previous Balance Incorrect

On Wed, 25 Jan 2006 06:10:22 -0800, "Skip B" <skip[at]theborlands.comwrote:

- quote -

> I spend a god deal of time last weekend updating and balancing accounts (ok,
> so I was lazy for a few months). So my statement for January came in for my
> main checking account and to my surprise, it says the last time I balanced
> was July. When I decided to do it all again, it brought up the wrong
> starting balance. Thinking I could correct by putting the correct balances
> in, it let me re-balance the July statement, but the starting balance once
> more is incorrect for the next statement. I'm afraid to go any further. None
> of the other accounts is experiencing this issue. Has anyone ever
> experienced this? If so, how does one fix this?
> Thanks...Skip


I had the same problem a few years ago when I missed a month or two.
As I recall I simply made the adjustment proffered by Money. Then it
was off in the opposite direction the next month, and I accepted that
adjustment. And from there on it has been correct.

Jim
 
Old 01-25-2006, 01:44 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Previous Balance Incorrect

In microsoft.public.money, Skip B wrote:

- quote -

> I spend a god deal of time last weekend updating and balancing accounts (ok,
> so I was lazy for a few months). So my statement for January came in for my
> main checking account and to my surprise, it says the last time I balanced
> was July. When I decided to do it all again, it brought up the wrong
> starting balance. Thinking I could correct by putting the correct balances
> in, it let me re-balance the July statement, but the starting balance once
> more is incorrect for the next statement.


Do not change "Total amount you owed last month". That should be
the algebraic sum of all Reconciled statements, which would be the
balance you left off with the last time you balanced. Into "Total
amount you owe this month", enter balance from web statement. See
How Money Calculates the Starting Balance
http://support.microsoft.com/default...B;EN-US;138960

If that balance is off, then it would seem that something was marked
Reconciled that should not have been, or something that was marked
Reconciled got changed to not reconciled.



- quote -

> I'm afraid to go any further. None
> of the other accounts is experiencing this issue. Has anyone ever
> experienced this? If so, how does one fix this?


===================Bonnie Synhorst said=======================
|Balancing can be frustrating. .. My rule of thumb is to avoid
|changing the starting statement balance that it asks for. If you
|do this, it will try to make an adjustment that you may not have
|needed to make (if you were balancing months out of order, for
|instance). I recommend balancing month by month starting from the
|earliest date after you are sure that nothing is marked with an R.
|
|Just remember, the opening balance it asks for is a calculation of
|the opening account balance plus or minus any reconciled
|transactions.
==========================================

If you have such transactions, you will want to get rid of them if
you have the real transaction data.

If the transactions are there, and you know the balance is correct
now, you could declare an account balanced by marking all entries
balanced. Select to show only unreconciled transactions. Sort by
date, and go to the oldest transaction. Hold down Cntl+Shift+M and
let auto-repeat work thru the transactions until none are left
showing. Then balance making the starting and ending balance match
the known balance. Choose the balance date to be the day after your
last transaction.

Thereafter, follow the normal procedure.

  #-1  
Old 01-25-2006, 01:10 PM
Skip B
Guest
 
Posts: n/a
Default Previous Balance Incorrect

I spend a god deal of time last weekend updating and balancing accounts (ok,
so I was lazy for a few months). So my statement for January came in for my
main checking account and to my surprise, it says the last time I balanced
was July. When I decided to do it all again, it brought up the wrong
starting balance. Thinking I could correct by putting the correct balances
in, it let me re-balance the July statement, but the starting balance once
more is incorrect for the next statement. I'm afraid to go any further. None
of the other accounts is experiencing this issue. Has anyone ever
experienced this? If so, how does one fix this?

Thanks...Skip


 

Tags
balance, incorrect, previous
Similar Threads
Thread Forum Replies Last Post
account balance is incorrect
Bill: account balace isn't adding in my "Investments to watch" account. "Investments to watch" group is greyed out. How can I get it to add these...
Microsoft Money 1 02-03-2004 01:05 AM
Incorrect balance
Sandra Bonny: I used to automatically download statements from my bank. How come that the balance in my account, and the one in Money are not the same (there is...
Microsoft Money 4 10-05-2003 09:40 PM
Finding Previous Reconciled Balance
Rebecca: How do you find the previous reconciled balance amount if the amount has inadvertently been changed?
Microsoft Money 3 09-07-2003 11:17 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 04:19 PM.