Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #5  
Old 08-18-2006, 03:41 AM
bobbyk
Guest
 
Posts: n/a
Default RE: Best way to balance an OLD account?

off the topic but i am not able to get my bank account statement to go from
an e to a r after going in to balance my account, then reconcile any advise
would help

"BobG" wrote:

- quote -

> I have a couple accounts that have little activity (e.g. Savings)...so I tend
> to not pay close attention to 'balancing' them on a monthly basis (since they
> don't change that much).
> This has lead to my now forgetting to balance them at all when activity does
> occur. Net-net - I'm WAY out of balance - due primarily to TRANSFERs between
> accounts (and how I didn't know how to reconcile these in the past - which
> created duplicate entries - I've since figured this out - I think).
> So now, I'm trying to get these accounts current, but my statements don't go
> back far enough (this account is almost 10 years old) to allow me to sort
> through the erroneous entries. I want to just start over, but the account is
> tied to my bank.
> I've tried CLOSING the account and creating a new one, but with the old one
> is apparently connected to my bank, and therefore won't create/update.
> Any tips on the best way to START OVER with an online account?

  #4  
Old 08-02-2006, 02:04 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Best way to balance an OLD account?

In microsoft.public.money, BobG wrote:

- quote -

> Tried it and assuming I did it correctly it DID balance the account (per the
> BALANCE THIS ACCOUNT procedure)...BUT my balance that shows in the ACCOUNT
> LISTings is still incorrect.


Are you saying that the balance in the Account List differs from
that in the Balance column of the register?

Try File-> RepairMoneyFile-> QuickFileRepair

If you still have a problem, what version are you running?

- quote -

> I may have misspoke in that....what I'm trying to accomplish is twofold:
> 1) Balance the account (which your procedure did)
> 2) Have the ACCOUNT BALANCE accurately reflect what is in the account (i.e.
> the bank statement).- this is the area where I am still off.
> I've tried making an 'adjustment' (in past attempts) but this only serves to
> BALANCE the account, not correct/reflect the true balance in the account.
> Also - when I make an adjustment - the adjustments start showing up in
> reports and get calculated into all sorts of cash-flow, spending, etc
> projections....which totally distorts the picture..


That procedure marks the transactions as balanced. It does not cause
them to be correct.

  #3  
Old 08-02-2006, 01:53 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: Best way to balance an OLD account?

Which balance in the account listings are you referring to? Are you aware
that the 'Adjusted' balance is the result of ALL transactions, including
those which have not cleared?

Are you synching with your bank? If so, the 'bank' balance may be that
reported by the bank on the most recent update, not the balance on a
statement with which you're reconciling the account.
--
Chris Cowles
Gainesville, FL



"BobG" <BobG[at]discussions.microsoft.com> wrote in message
news:4D314E43-A23F-461E-9B59-CD81D7DF34DE[at]microsoft.com...
- quote -

> Cal,
> Tried it and assuming I did it correctly it DID balance the account (per
> the
> BALANCE THIS ACCOUNT procedure)...BUT my balance that shows in the
> ACCOUNT
> LISTings is still incorrect.
> I may have misspoke in that....what I'm trying to accomplish is twofold:
> 1) Balance the account (which your procedure did)
> 2) Have the ACCOUNT BALANCE accurately reflect what is in the account
> (i.e.
> the bank statement).- this is the area where I am still off.
> I've tried making an 'adjustment' (in past attempts) but this only serves
> to
> BALANCE the account, not correct/reflect the true balance in the
> account.
> Also - when I make an adjustment - the adjustments start showing up in
> reports and get calculated into all sorts of cash-flow, spending, etc
> projections....which totally distorts the picture.



  #2  
Old 08-01-2006, 11:54 AM
BobG
Guest
 
Posts: n/a
Default Re: Best way to balance an OLD account?

Cal,

Tried it and assuming I did it correctly it DID balance the account (per the
BALANCE THIS ACCOUNT procedure)...BUT my balance that shows in the ACCOUNT
LISTings is still incorrect.

I may have misspoke in that....what I'm trying to accomplish is twofold:
1) Balance the account (which your procedure did)
2) Have the ACCOUNT BALANCE accurately reflect what is in the account (i.e.
the bank statement).- this is the area where I am still off.

I've tried making an 'adjustment' (in past attempts) but this only serves to
BALANCE the account, not correct/reflect the true balance in the account.

Also - when I make an adjustment - the adjustments start showing up in
reports and get calculated into all sorts of cash-flow, spending, etc
projections....which totally distorts the picture..

Any additional guidance would be welcomed.
"BobG" wrote:

- quote -

> Great feedback, I'll give it a try and see if this works (it sounds like what
> I was looking for).
> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, BobG wrote:
> > > > I have a couple accounts that have little activity (e.g. Savings)...so I tend
> > > to not pay close attention to 'balancing' them on a monthly basis (since they
> > > don't change that much).
> > > > > This has lead to my now forgetting to balance them at all when activity does
> > > occur. Net-net - I'm WAY out of balance - due primarily to TRANSFERs between
> > > accounts (and how I didn't know how to reconcile these in the past - which
> > > created duplicate entries - I've since figured this out - I think).
> > > > > So now, I'm trying to get these accounts current, but my statements don't go
> > > back far enough (this account is almost 10 years old) to allow me to sort
> > > through the erroneous entries. I want to just start over, but the account is
> > > tied to my bank.
> > > > > I've tried CLOSING the account and creating a new one, but with the old one
> > > is apparently connected to my bank, and therefore won't create/update.
> > > > > Any tips on the best way to START OVER with an online account?
> > > If you wish to start fresh and declare an account balanced, you can

> > mark 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. This is
> > not the normal procedure. It starts you with an amnesty for former
> > balancing.
> > > Thereafter, follow the normal procedure.
> > > When doing so, don't adjust the starting balance. How Money

> > Calculates the Starting Balance. To reach that balance, Money starts
> > with your opening balance and then adds all reconciled deposits and
> > subtracts all reconciled payments.
> > http://support.microsoft.com/default...B;EN-US;138960

>
  #1  
Old 07-31-2006, 04:32 PM
BobG
Guest
 
Posts: n/a
Default Re: Best way to balance an OLD account?

Great feedback, I'll give it a try and see if this works (it sounds like what
I was looking for).

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, BobG wrote:
> > I have a couple accounts that have little activity (e.g. Savings)...so I tend
> > to not pay close attention to 'balancing' them on a monthly basis (since they
> > don't change that much).
> > > This has lead to my now forgetting to balance them at all when activity does

> > occur. Net-net - I'm WAY out of balance - due primarily to TRANSFERs between
> > accounts (and how I didn't know how to reconcile these in the past - which
> > created duplicate entries - I've since figured this out - I think).
> > > So now, I'm trying to get these accounts current, but my statements don't go

> > back far enough (this account is almost 10 years old) to allow me to sort
> > through the erroneous entries. I want to just start over, but the account is
> > tied to my bank.
> > > I've tried CLOSING the account and creating a new one, but with the old one

> > is apparently connected to my bank, and therefore won't create/update.
> > > Any tips on the best way to START OVER with an online account?

> If you wish to start fresh and declare an account balanced, you can
> mark 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. This is
> not the normal procedure. It starts you with an amnesty for former
> balancing.
> Thereafter, follow the normal procedure.
> When doing so, don't adjust the starting balance. How Money
> Calculates the Starting Balance. To reach that balance, Money starts
> with your opening balance and then adds all reconciled deposits and
> subtracts all reconciled payments.
> http://support.microsoft.com/default...B;EN-US;138960

 
Old 07-29-2006, 04:01 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Best way to balance an OLD account?

In microsoft.public.money, BobG wrote:

- quote -

> I have a couple accounts that have little activity (e.g. Savings)...so I tend
> to not pay close attention to 'balancing' them on a monthly basis (since they
> don't change that much).
> This has lead to my now forgetting to balance them at all when activity does
> occur. Net-net - I'm WAY out of balance - due primarily to TRANSFERs between
> accounts (and how I didn't know how to reconcile these in the past - which
> created duplicate entries - I've since figured this out - I think).
> So now, I'm trying to get these accounts current, but my statements don't go
> back far enough (this account is almost 10 years old) to allow me to sort
> through the erroneous entries. I want to just start over, but the account is
> tied to my bank.
> I've tried CLOSING the account and creating a new one, but with the old one
> is apparently connected to my bank, and therefore won't create/update.
> Any tips on the best way to START OVER with an online account?


If you wish to start fresh and declare an account balanced, you can
mark 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. This is
not the normal procedure. It starts you with an amnesty for former
balancing.

Thereafter, follow the normal procedure.

When doing so, don't adjust the starting balance. How Money
Calculates the Starting Balance. To reach that balance, Money starts
with your opening balance and then adds all reconciled deposits and
subtracts all reconciled payments.
http://support.microsoft.com/default...B;EN-US;138960
  #-1  
Old 07-29-2006, 03:33 PM
BobG
Guest
 
Posts: n/a
Default Best way to balance an OLD account?

I have a couple accounts that have little activity (e.g. Savings)...so I tend
to not pay close attention to 'balancing' them on a monthly basis (since they
don't change that much).

This has lead to my now forgetting to balance them at all when activity does
occur. Net-net - I'm WAY out of balance - due primarily to TRANSFERs between
accounts (and how I didn't know how to reconcile these in the past - which
created duplicate entries - I've since figured this out - I think).

So now, I'm trying to get these accounts current, but my statements don't go
back far enough (this account is almost 10 years old) to allow me to sort
through the erroneous entries. I want to just start over, but the account is
tied to my bank.

I've tried CLOSING the account and creating a new one, but with the old one
is apparently connected to my bank, and therefore won't create/update.

Any tips on the best way to START OVER with an online account?
 

Tags
account, balance
Similar Threads
Thread Forum Replies Last Post
balance in Account List view does not match balance in actual regi
HB: The balance of two of my accounts as shown in the summary pages (home page and account list view) does not match that in the actual registers. All...
Microsoft Money 6 02-27-2005 04:45 AM
Balance in Checking Account disagrees with balance in account list
joni: I am using Money 2003 and noticed today that my balance in the register of my checking account is correct, but when I switch to the account list...
Microsoft Money 2 08-20-2004 10:50 PM
Account List Balance different from the Register End Balance of the account-Money 2003
Andrej: Help?
Microsoft Money 1 01-18-2004 07:23 AM



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 07:39 PM.