|
#6
| |||
| |||
| 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
| |||
| |||
| 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
| |||
| |||
| 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
| |||
| |||
| In microsoft.public.money, Dick Watson wrote: - quote - > Are you saying you don't have old transactions entered and you want to enter
I think if Joshua were to replace the account Starting Balance with> 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. 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
| |||
| |||
| 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
| |||
| |||
| 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. |
| | |||
| |||
| 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
| |||
| |||
| 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 | |
| |