|
#4
| |||
| |||
| In microsoft.public.money, Geekster wrote: - quote - > Exactly what I needed! Thanks Cal!!
Here is a better version of that process:1.Open a new Notepad file, and paste the following six lines between the delimiter lines below into the file. Save the file as ClearBalance.QIF . ============begin ClearBalance.QIF========================== !Type:Bank D10/18/2007 T-1.00 PRemove Balance MUsed to remove the balance ^ ============end ClearBalance.QIF========================== 2. Change the date on the line that starts with 'D' to a date later than the reported last download in the register. Today's date should work. The date format depends on your Windows regional settings. 3. Save the File-> SaveAs the file "ClearBalance.QIF" in the same folder as your *.mny file. 4. Open Money, and File-> Import-> Downloaded Statement. Select ClearBalance.QIF and click Import. Money will ask which account (or to make a new account). Select the account you wish to clear the Downloaded Date from, and click Next, then OK. 5.Do not process the statement as you would a regular statement. Instead go to the Account List and right-click where it says "Transactions to read:1" for the account that you imported into. Choose DeleteStatement. You can re-use the ClearBalance.QIF file on all the accounts you wish to clear. - quote - > "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message > news:t70eh316025jd64cd5rlf6gorijh3327d0[at]4ax.com... > > In microsoft.public.money, Geekster wrote: > > > > Thanks for the reply Cal. Since I rarely use (e.g. or download data to) > > > the > > > accounts, is there a way to clear the Bank Balance to 0? Balancing the > > > account 0/0 doesn't work. > > > Michael Gordon posted a process to clear the downloaded balance > > from the Bank Balance column of the Account List. > > > 1.Open a new Notepad file, and paste the following six lines between > > the delimiter lines below into the file. > > > ============begin ClearBalance.QIF========================== > > !Type:Bank > > D10/18/2007 > > T-1.00 > > PRemove Balance > > MUsed to remove the balance > > ^ > > ============end ClearBalance.QIF========================== > > > 2. Change the date on the line that starts with 'D' to a date > > later than the reported last download in the register. Today's > > date should work. The date format depends on your Windows regional > > settings. > > > 3. Save the File-> SaveAs the file "ClearBalance.QIF" in the same > > folder as your *.mny file. > > > 4. Open Money, and File-> Import-> Downloaded Statement. Select > > ClearBalance.QIF and click Import. Money will ask which account > > (or to make a new account). Select the account you wish to clear > > the Downloaded Date from, and click Next, then OK. > > > 5. Process the statement as you would a regular statement, > > and then accept the transaction. > > > 6. Note that the Bank Balance column of the Account List has > > been cleared. I did not get the downloaded balance in the register > > itself to disappear, but it did go away in the Account List. > > > 7. Return to the account register and Delete the fake $1 > > transaction. > > > You can re-use the ClearBalance.QIF file on all the accounts you > > wish to clear. > > > I don't know which versions this works with, but it > > should work with Money Plus. > > > > > > > > > > > > > > > > Thanks again. > > > > > "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message > > > news:46jdh39qp10l9mk8f20lhenc5g3r90b3g0[at]4ax.com... > > > > In microsoft.public.money, Geekster wrote: > > > > > > > > Searched the group and checked the FAQ but didn't see a question or > > > > > answer. > > > > > > > > > Using Money '08 on the Account List page I have several accounts that > > > > > have > > > > > been balanced to zero for months and since the conversion a few months > > > > > ago > > > > > these accounts are now showing a negative Bank Balance but a Zero Adj > > > > > Balance. The accts in question are at 0, nothing is owed. However the > > > > > amount shown are either the last (or next to last) payment made in the > > > > > acct. > > > > > In one instance it's not a payment but a transfer of $$ from an > > > > > overpayment > > > > > back to checking. > > > > > > > > > Any idea why Money would show an amount on the Bank Balance column and > > > > > yet > > > > > have -0- Adj Balance. > > > > > > > Bank balance is the balance that downloaded last time. The adjusted > > > > balance is the balance based on the transactions in the register, > > > > including even future-dated transactions. > > |
|
#3
| |||
| |||
| Exactly what I needed! Thanks Cal!! "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message news:t70eh316025jd64cd5rlf6gorijh3327d0[at]4ax.com... - quote - > In microsoft.public.money, Geekster wrote: > > Thanks for the reply Cal. Since I rarely use (e.g. or download data to) > > the > > accounts, is there a way to clear the Bank Balance to 0? Balancing the > > account 0/0 doesn't work. > Michael Gordon posted a process to clear the downloaded balance > from the Bank Balance column of the Account List. > 1.Open a new Notepad file, and paste the following six lines between > the delimiter lines below into the file. > ============begin ClearBalance.QIF========================== > !Type:Bank > D10/18/2007 > T-1.00 > PRemove Balance > MUsed to remove the balance > ^ > ============end ClearBalance.QIF========================== > 2. Change the date on the line that starts with 'D' to a date > later than the reported last download in the register. Today's > date should work. The date format depends on your Windows regional > settings. > 3. Save the File-> SaveAs the file "ClearBalance.QIF" in the same > folder as your *.mny file. > 4. Open Money, and File-> Import-> Downloaded Statement. Select > ClearBalance.QIF and click Import. Money will ask which account > (or to make a new account). Select the account you wish to clear > the Downloaded Date from, and click Next, then OK. > 5. Process the statement as you would a regular statement, > and then accept the transaction. > 6. Note that the Bank Balance column of the Account List has > been cleared. I did not get the downloaded balance in the register > itself to disappear, but it did go away in the Account List. > 7. Return to the account register and Delete the fake $1 > transaction. > You can re-use the ClearBalance.QIF file on all the accounts you > wish to clear. > I don't know which versions this works with, but it > should work with Money Plus. > > > Thanks again. > > > "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message > > news:46jdh39qp10l9mk8f20lhenc5g3r90b3g0[at]4ax.com... > > > In microsoft.public.money, Geekster wrote: > > > > > > Searched the group and checked the FAQ but didn't see a question or > > > > answer. > > > > > > > Using Money '08 on the Account List page I have several accounts that > > > > have > > > > been balanced to zero for months and since the conversion a few months > > > > ago > > > > these accounts are now showing a negative Bank Balance but a Zero Adj > > > > Balance. The accts in question are at 0, nothing is owed. However the > > > > amount shown are either the last (or next to last) payment made in the > > > > acct. > > > > In one instance it's not a payment but a transfer of $$ from an > > > > overpayment > > > > back to checking. > > > > > > > Any idea why Money would show an amount on the Bank Balance column and > > > > yet > > > > have -0- Adj Balance. > > > > > Bank balance is the balance that downloaded last time. The adjusted > > > balance is the balance based on the transactions in the register, > > > including even future-dated transactions. > |
|
#2
| |||
| |||
| In microsoft.public.money, Geekster wrote: - quote - > Thanks for the reply Cal. Since I rarely use (e.g. or download data to) the
Michael Gordon posted a process to clear the downloaded balance> accounts, is there a way to clear the Bank Balance to 0? Balancing the > account 0/0 doesn't work. from the Bank Balance column of the Account List. 1.Open a new Notepad file, and paste the following six lines between the delimiter lines below into the file. ============begin ClearBalance.QIF========================== !Type:Bank D10/18/2007 T-1.00 PRemove Balance MUsed to remove the balance ^ ============end ClearBalance.QIF========================== 2. Change the date on the line that starts with 'D' to a date later than the reported last download in the register. Today's date should work. The date format depends on your Windows regional settings. 3. Save the File-> SaveAs the file "ClearBalance.QIF" in the same folder as your *.mny file. 4. Open Money, and File-> Import-> Downloaded Statement. Select ClearBalance.QIF and click Import. Money will ask which account (or to make a new account). Select the account you wish to clear the Downloaded Date from, and click Next, then OK. 5. Process the statement as you would a regular statement, and then accept the transaction. 6. Note that the Bank Balance column of the Account List has been cleared. I did not get the downloaded balance in the register itself to disappear, but it did go away in the Account List. 7. Return to the account register and Delete the fake $1 transaction. You can re-use the ClearBalance.QIF file on all the accounts you wish to clear. I don't know which versions this works with, but it should work with Money Plus. - quote - > Thanks again. > "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message > news:46jdh39qp10l9mk8f20lhenc5g3r90b3g0[at]4ax.com... > > In microsoft.public.money, Geekster wrote: > > > > Searched the group and checked the FAQ but didn't see a question or > > > answer. > > > > > Using Money '08 on the Account List page I have several accounts that have > > > been balanced to zero for months and since the conversion a few months ago > > > these accounts are now showing a negative Bank Balance but a Zero Adj > > > Balance. The accts in question are at 0, nothing is owed. However the > > > amount shown are either the last (or next to last) payment made in the > > > acct. > > > In one instance it's not a payment but a transfer of $$ from an > > > overpayment > > > back to checking. > > > > > Any idea why Money would show an amount on the Bank Balance column and yet > > > have -0- Adj Balance. > > > Bank balance is the balance that downloaded last time. The adjusted > > balance is the balance based on the transactions in the register, > > including even future-dated transactions. |
|
#1
| |||
| |||
| Thanks for the reply Cal. Since I rarely use (e.g. or download data to) the accounts, is there a way to clear the Bank Balance to 0? Balancing the account 0/0 doesn't work. Thanks again. "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message news:46jdh39qp10l9mk8f20lhenc5g3r90b3g0[at]4ax.com... - quote - > In microsoft.public.money, Geekster wrote: > > Searched the group and checked the FAQ but didn't see a question or > > answer. > > > Using Money '08 on the Account List page I have several accounts that have > > been balanced to zero for months and since the conversion a few months ago > > these accounts are now showing a negative Bank Balance but a Zero Adj > > Balance. The accts in question are at 0, nothing is owed. However the > > amount shown are either the last (or next to last) payment made in the > > acct. > > In one instance it's not a payment but a transfer of $$ from an > > overpayment > > back to checking. > > > Any idea why Money would show an amount on the Bank Balance column and yet > > have -0- Adj Balance. > Bank balance is the balance that downloaded last time. The adjusted > balance is the balance based on the transactions in the register, > including even future-dated transactions. |
| | |||
| |||
| In microsoft.public.money, Geekster wrote: - quote - > Searched the group and checked the FAQ but didn't see a question or answer.
Bank balance is the balance that downloaded last time. The adjusted> Using Money '08 on the Account List page I have several accounts that have > been balanced to zero for months and since the conversion a few months ago > these accounts are now showing a negative Bank Balance but a Zero Adj > Balance. The accts in question are at 0, nothing is owed. However the > amount shown are either the last (or next to last) payment made in the acct. > In one instance it's not a payment but a transfer of $$ from an overpayment > back to checking. > Any idea why Money would show an amount on the Bank Balance column and yet > have -0- Adj Balance. balance is the balance based on the transactions in the register, including even future-dated transactions. |
|
#-1
| |||
| |||
| Searched the group and checked the FAQ but didn't see a question or answer. Using Money '08 on the Account List page I have several accounts that have been balanced to zero for months and since the conversion a few months ago these accounts are now showing a negative Bank Balance but a Zero Adj Balance. The accts in question are at 0, nothing is owed. However the amount shown are either the last (or next to last) payment made in the acct. In one instance it's not a payment but a transfer of $$ from an overpayment back to checking. Any idea why Money would show an amount on the Bank Balance column and yet have -0- Adj Balance. Thanks. |
| Tags |
| account, appears, balance, balanced, bank |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Bank balance issue on Account List page Geekster: Just noticed after converting to '08 that two accounts are showing Zero (0) Adj Balance but the Bank Balance column show a negative entry. I viewed... | Microsoft Money | 1 | 09-24-2007 08:09 AM | |
| showing last time account was balanced in account list Mark Fields: In Money '03 (last version I used before '07) while loking at my list of open accounts there was a command that would show the last time each... | Microsoft Money | 4 | 09-10-2007 11:47 PM | |
| Thread Tools | |
| Display Modes | |
| |