Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #6  
Old 02-24-2005, 02:09 PM
Joshua Frank
Guest
 
Posts: n/a
Default Re: Balancing in Reverse

Thanks for all the tips. I'll give it a try and see what works best.
A J Gladson wrote:
- quote -

> Thats what I did - once I was certain that most of the transactions
> were entered. I started at the oldest date and reconciled forward. I
> did have to adjust an opening balance in many cases. Depending on how
> good you data is, you could reconcile quarterly or some other time
> period where you have a good balance from the Bank.

  #5  
Old 02-23-2005, 06:59 PM
A J Gladson
Guest
 
Posts: n/a
Default Re: Balancing in Reverse

Thats what I did - once I was certain that most of the transactions
were entered. I started at the oldest date and reconciled forward. I
did have to adjust an opening balance in many cases. Depending on how
good you data is, you could reconcile quarterly or some other time
period where you have a good balance from the Bank.

  #4  
Old 02-23-2005, 06:23 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Balancing in Reverse

That's probably a great technique: set the Account beginning balance to $0
and start with a transaction that deposits (or withdraws if overdrawn) the
statement beginning balance for the statement you want to begin with.

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

> In microsoft.public.money, Dick Watson wrote:
> > Are you saying you don't have old transactions entered and you want to

enter
> > them into a balanced account? (Balanced means that from the beginning
> > account balance in Money through all of the reconciled transactions

agrees
> > with the bank.)
> > > It can be done: Take an old statement balance. Subtract the ending

balance
> > from the beginning balance. Add/subtract that amount into the Money

account
> > beginning balance. Enter the transactions. The last balance in the

register
> > should be back to what it was before the cycle.

> I think if Joshua were to replace the account Starting Balance with
> an initial transaction in the register, it would be easier for him
> to make the changes. Each time he wants to add a month, he would
> void that initial transaction, and add a Reconciled pre-dated
> transaction to match the starting balance from the statement to be
> added. Then he would add the transactions for a month and balance.
> > > OTOH, are you asking if you can "balance" the account for just the

> > activities on the December statement, regardless of prior activities to

that
> > one? That's a LOT harder. You have no basis for the beginning balance.

Money
> > also won't readily support it since Money defines balancing as

reconciling
> > EVERY cleared but unreconciled transaction to get to an ending balance.
> > > "Joshua Frank" <jfrank[at]archimetrics.remove-tinned-meat.com> wrote in

message
> > news:%23sybT4cGFHA.2748[at]tk2msftngp13.phx.gbl...
> > > That's a good start, thanks, but can I roll back in time. Let's say I
> > > start balancing now, but then I want to go back and enter January's
> > > statement, and then later go back and enter December's, and so on. I
> > > wouldn't want to wipe out the later balancing in order to do the
> > > earlier. Is this possible?


  #3  
Old 02-23-2005, 05:53 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Balancing in Reverse

In microsoft.public.money, Dick Watson wrote:

- quote -

> Are you saying you don't have old transactions entered and you want to enter
> them into a balanced account? (Balanced means that from the beginning
> account balance in Money through all of the reconciled transactions agrees
> with the bank.)
> It can be done: Take an old statement balance. Subtract the ending balance
> from the beginning balance. Add/subtract that amount into the Money account
> beginning balance. Enter the transactions. The last balance in the register
> should be back to what it was before the cycle.


I think if Joshua were to replace the account Starting Balance with
an initial transaction in the register, it would be easier for him
to make the changes. Each time he wants to add a month, he would
void that initial transaction, and add a Reconciled pre-dated
transaction to match the starting balance from the statement to be
added. Then he would add the transactions for a month and balance.


- quote -

> OTOH, are you asking if you can "balance" the account for just the
> activities on the December statement, regardless of prior activities to that
> one? That's a LOT harder. You have no basis for the beginning balance. Money
> also won't readily support it since Money defines balancing as reconciling
> EVERY cleared but unreconciled transaction to get to an ending balance.
> "Joshua Frank" <jfrank[at]archimetrics.remove-tinned-meat.com> wrote in message
> news:%23sybT4cGFHA.2748[at]tk2msftngp13.phx.gbl...
> > That's a good start, thanks, but can I roll back in time. Let's say I
> > start balancing now, but then I want to go back and enter January's
> > statement, and then later go back and enter December's, and so on. I
> > wouldn't want to wipe out the later balancing in order to do the
> > earlier. Is this possible?


  #2  
Old 02-23-2005, 05:29 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Balancing in Reverse

Are you saying you don't have old transactions entered and you want to enter
them into a balanced account? (Balanced means that from the beginning
account balance in Money through all of the reconciled transactions agrees
with the bank.)

It can be done: Take an old statement balance. Subtract the ending balance
from the beginning balance. Add/subtract that amount into the Money account
beginning balance. Enter the transactions. The last balance in the register
should be back to what it was before the cycle.

OTOH, are you asking if you can "balance" the account for just the
activities on the December statement, regardless of prior activities to that
one? That's a LOT harder. You have no basis for the beginning balance. Money
also won't readily support it since Money defines balancing as reconciling
EVERY cleared but unreconciled transaction to get to an ending balance.

"Joshua Frank" <jfrank[at]archimetrics.remove-tinned-meat.com> wrote in message
news:%23sybT4cGFHA.2748[at]tk2msftngp13.phx.gbl...
- quote -

> That's a good start, thanks, but can I roll back in time. Let's say I
> start balancing now, but then I want to go back and enter January's
> statement, and then later go back and enter December's, and so on. I
> wouldn't want to wipe out the later balancing in order to do the
> earlier. Is this possible?



  #1  
Old 02-23-2005, 04:35 PM
Joshua Frank
Guest
 
Posts: n/a
Default Re: Balancing in Reverse

That's a good start, thanks, but can I roll back in time. Let's say I
start balancing now, but then I want to go back and enter January's
statement, and then later go back and enter December's, and so on. I
wouldn't want to wipe out the later balancing in order to do the
earlier. Is this possible?


Dick Watson wrote:
- quote -

> See http://umpmfaq.info/faqdb.php?q=107.
> "Joshua Frank" <jfrank[at]archimetrics.remove-tinned-meat.com> wrote in message
> news:%23mcHyQSGFHA.2824[at]tk2msftngp13.phx.gbl...
> > Is there any way to balance a credit card account starting now and going
> > backward in time. I have an account that goes back to 1997 that I never
> > balanced because I had the account before I ever used Money, and when I
> > started it was too painful to go back and do it retroactively. But now
> > it's getting frustrating not to be able to balance. I'd like to balance
> > starting now, and then go back a month at a time when I feel like it, but
> > I can't see any way to do this because balancing seems like a
> > forward-in-time process. Does anyone have any ideas on this? TIA.

 
Old 02-23-2005, 02:21 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Balancing in Reverse

See http://umpmfaq.info/faqdb.php?q=107.

"Joshua Frank" <jfrank[at]archimetrics.remove-tinned-meat.com> wrote in message
news:%23mcHyQSGFHA.2824[at]tk2msftngp13.phx.gbl...
- quote -

> Is there any way to balance a credit card account starting now and going
> backward in time. I have an account that goes back to 1997 that I never
> balanced because I had the account before I ever used Money, and when I
> started it was too painful to go back and do it retroactively. But now
> it's getting frustrating not to be able to balance. I'd like to balance
> starting now, and then go back a month at a time when I feel like it, but
> I can't see any way to do this because balancing seems like a
> forward-in-time process. Does anyone have any ideas on this? TIA.



  #-1  
Old 02-22-2005, 08:19 PM
Joshua Frank
Guest
 
Posts: n/a
Default Balancing in Reverse

Hi All,

Is there any way to balance a credit card account starting now and going
backward in time. I have an account that goes back to 1997 that I never
balanced because I had the account before I ever used Money, and when I
started it was too painful to go back and do it retroactively. But now
it's getting frustrating not to be able to balance. I'd like to balance
starting now, and then go back a month at a time when I feel like it,
but I can't see any way to do this because balancing seems like a
forward-in-time process. Does anyone have any ideas on this? TIA.

Cheers,
Josh
 

Tags
balancing, reverse
Similar Threads
Thread Forum Replies Last Post
reverse mortgage
quest: Has anyone modeled a reverse mortgage in the lifetime planner? TIA!!
Microsoft Money 4 02-15-2005 04:21 AM
Reverse a cleared e pay
Jim Parkes: Money appears to have made an assumption that a telephone transfer of funds for coincidentally the same amount as a scheduled e-pay was correct....
Microsoft Money 3 09-03-2004 02:33 AM
Reverse Stock Split
Larry: I'm using Money 2003 and want to enter a reverse stock split. There was a 1 for 5 split, meaning my shares should be divided by 5. (It's for AT&T...
Microsoft Money 4 07-10-2004 01:13 AM
Reverse Printing of Checks
William L. Oppenheim, M.D.: My checks feed into my 7550 printer in the correct order, but blank side of the page facing upward in the paper tray. The general settings on my...
Microsoft Money 1 06-16-2004 11:58 AM
How do i reverse a transfer?
Scott E: I mistakenly made an etransfer from my checking to my overdraft account in the same bank for $3500 instead of $350. Is there a way to cancel this?...
Microsoft Money 1 10-06-2003 11:30 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 07:39 AM.