Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #11  
Old 04-17-2004, 03:25 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Hidden or invisible record in account register - M2004

In microsoft.public.money, Ed Hansberry, MS-MVP/Mobile Devices
wrote:

- quote -

> That did it! I had to mark it unvoid from the bank vendor window. Then
> when I imported it the system tried to match it up with my manual $2
> entry. I clicked "Choose another" and the downloaded entry was there.
> Checked it and it was accepted and now visible and fully editable. :-)


Glad to hear it.

  #10  
Old 04-17-2004, 02:34 PM
Ed Hansberry, MS-MVP/Mobile Devices
Guest
 
Posts: n/a
Default Re: Hidden or invisible record in account register - M2004

via_newsgroup[at]please.tnx(Cal Learner-- MVP) wrote:

- quote -

> What I would try is this: prepare a QIF file that matches the hidden
> transaction. You could do this by exporting a QIF with your
> manually-entered transaction, and deleting all of the records except
> for the one. Then delete the manually-entered transaction in the
> register. File-> Import the small QIF file as a statement from your
> bank. The hope is that it will match the hidden transaction, and
> make it visible.


That did it! I had to mark it unvoid from the bank vendor window. Then
when I imported it the system tried to match it up with my manual $2
entry. I clicked "Choose another" and the downloaded entry was there.
Checked it and it was accepted and now visible and fully editable. :-)

Thanks!
--
_______________________
Ed H.
  #9  
Old 04-13-2004, 01:24 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Hidden or invisible record in account register - M2004

In microsoft.public.money, Ed Hansberry, MS-MVP/Mobile Devices
wrote:

- quote -

> "Ed Hansberry, MS-MVP/Mobile Devices"
> <spamfree-silvernino[at]hotmail.spambegone.com> wrote:
> > via_newsgroup[at]please.tnx(Cal Learner-- MVP) wrote:
> > > > What I would try is this: prepare a QIF file that matches the hidden
> > > transaction. You could do this by exporting a QIF with your
> > > manually-entered transaction, and deleting all of the records except
> > > for the one. Then delete the manually-entered transaction in the
> > > register. File-> Import the small QIF file as a statement from your
> > > bank. The hope is that it will match the hidden transaction, and
> > > make it visible.
> > > Hrm... I'll give that a shot. Thanks.

> Ok, never really fooled with a QIF file before. Here is what I have so
> far:
> !Type:Bank
> D3/15'2004
> CX
> MATM Fee waived
> T2.00
> PBankname
> LBank Charges:ATM Fees
> ^


Yes. Nicely done.

- quote -

> What is the "CX" line? I notice that later unmatched transactions
> don't have that. Should I remove that before trying to import?


Cleared Status. In other words, it is cleared.
http://www.ntlug.org/~cbbrowne/financeformats.html

I don't think it is going to matter, but you could try it both ways.
Interesting point.

  #8  
Old 04-13-2004, 11:27 AM
Ed Hansberry, MS-MVP/Mobile Devices
Guest
 
Posts: n/a
Default Re: Hidden or invisible record in account register - M2004

"Ed Hansberry, MS-MVP/Mobile Devices"
<spamfree-silvernino[at]hotmail.spambegone.com> wrote:

- quote -

> via_newsgroup[at]please.tnx(Cal Learner-- MVP) wrote:
> > What I would try is this: prepare a QIF file that matches the hidden
> > transaction. You could do this by exporting a QIF with your
> > manually-entered transaction, and deleting all of the records except
> > for the one. Then delete the manually-entered transaction in the
> > register. File-> Import the small QIF file as a statement from your
> > bank. The hope is that it will match the hidden transaction, and
> > make it visible.

> Hrm... I'll give that a shot. Thanks.


Ok, never really fooled with a QIF file before. Here is what I have so
far:

!Type:Bank
D3/15'2004
CX
MATM Fee waived
T2.00
PBankname
LBank Charges:ATM Fees
^

What is the "CX" line? I notice that later unmatched transactions
don't have that. Should I remove that before trying to import?
--
_______________________
Ed H.
  #7  
Old 04-13-2004, 02:47 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Hidden or invisible record in account register - M2004

In microsoft.public.money, Retired Coal Miner wrote:

- quote -

> That is an interesting trick, great to save for future reference.
> I'm curious if you've ever actually done this, and did it match up? I
> suppose one could create a dummy/test money file and play around with it...


I have used a variation. However you are not going to be able to
intentionally produce the hidden transaction to attempt the un-hide.

  #6  
Old 04-13-2004, 02:41 AM
Retired Coal Miner
Guest
 
Posts: n/a
Default Re: Hidden or invisible record in account register - M2004

That is an interesting trick, great to save for future reference.

I'm curious if you've ever actually done this, and did it match up? I
suppose one could create a dummy/test money file and play around with it...


Cal Learner-- MVP wrote:


- quote -

> What I would try is this: prepare a QIF file that matches the hidden
> transaction. You could do this by exporting a QIF with your
> manually-entered transaction, and deleting all of the records except
> for the one. Then delete the manually-entered transaction in the
> register. File-> Import the small QIF file as a statement from your
> bank. The hope is that it will match the hidden transaction, and
> make it visible.


  #5  
Old 04-13-2004, 02:26 AM
Ed Hansberry, MS-MVP/Mobile Devices
Guest
 
Posts: n/a
Default Re: Hidden or invisible record in account register - M2004

via_newsgroup[at]please.tnx(Cal Learner-- MVP) wrote:

- quote -

> What I would try is this: prepare a QIF file that matches the hidden
> transaction. You could do this by exporting a QIF with your
> manually-entered transaction, and deleting all of the records except
> for the one. Then delete the manually-entered transaction in the
> register. File-> Import the small QIF file as a statement from your
> bank. The hope is that it will match the hidden transaction, and
> make it visible.


Hrm... I'll give that a shot. Thanks.
--
_______________________
Ed H.
  #4  
Old 04-12-2004, 08:35 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Hidden or invisible record in account register - M2004

In microsoft.public.money, Ed Hansberry, MS-MVP/Mobile Devices
wrote:

- quote -

> (Cal Learner-- MVP) wrote:
> > Does the balance at the bottom of the register change based as the
> > register view is changed to show only unreconciled transactions or
> > in some other way?

> No. Marking the hidden transaction as VOID or unvoided has *no* effect
> in the transaction window's account balance line. I had marked the
> manual one void and left the hidden one active. Because that seems to
> make my transaction register off by the $2, I have now marked the
> hidden one void and used my manual entry as the valid one.
> Marking the hidden transaction VOID does effect the "Balance this
> account" screen, so some items are being calculated off of it. Marking
> as VOID also impacts reports.
> It seems just the transaction screen and the FIND utility are stumped
> by this transaction. Well, and me!


What I would try is this: prepare a QIF file that matches the hidden
transaction. You could do this by exporting a QIF with your
manually-entered transaction, and deleting all of the records except
for the one. Then delete the manually-entered transaction in the
register. File-> Import the small QIF file as a statement from your
bank. The hope is that it will match the hidden transaction, and
make it visible.

  #3  
Old 04-12-2004, 08:24 PM
Ed Hansberry, MS-MVP/Mobile Devices
Guest
 
Posts: n/a
Default Re: Hidden or invisible record in account register - M2004

"Ed Hansberry, MS-MVP/Mobile Devices"
<spamfree-silvernino[at]hotmail.spambegone.com> wrote:

- quote -

> > *The MoneyLink.XLA can pull it into Excel.

This is incorrect. I was looking at the wrong line. The $2 deposit is
not being shown. I mistakenly looked at the original $2 withdrawal.

So, Find, the transaction window and the moneylink.XLA cannot see
this.
--
_______________________
Ed H.
  #2  
Old 04-12-2004, 08:22 PM
Ed Hansberry, MS-MVP/Mobile Devices
Guest
 
Posts: n/a
Default Re: Hidden or invisible record in account register - M2004

via_newsgroup[at]please.tnx(Cal Learner-- MVP) wrote:

- quote -

> Does the balance at the bottom of the register change based as the
> register view is changed to show only unreconciled transactions or
> in some other way?


No. Marking the hidden transaction as VOID or unvoided has *no* effect
in the transaction window's account balance line. I had marked the
manual one void and left the hidden one active. Because that seems to
make my transaction register off by the $2, I have now marked the
hidden one void and used my manual entry as the valid one.

Marking the hidden transaction VOID does effect the "Balance this
account" screen, so some items are being calculated off of it. Marking
as VOID also impacts reports.

It seems just the transaction screen and the FIND utility are stumped
by this transaction. Well, and me!
--
_______________________
Ed H.
  #1  
Old 04-12-2004, 07:53 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Hidden or invisible record in account register - M2004

In microsoft.public.money, Ed Hansberry, MS-MVP/Mobile Devices
wrote:

- quote -

> "Ed Hansberry, MS-MVP/Mobile Devices"
> <spamfree-silvernino[at]hotmail.spambegone.com> wrote:
> > The downloaded transaction is not available for viewing in:
> > *The account register, no matter what filtering I have set.
> > *The Advanced Find menu
> > > It is visible in:

> > *The category section for ATM/Bank fees window in the lower right
> > *The Payee section for my bank in the lower window
> > *The Account Balance History report
> > *The MoneyLink.XLA can pull it into Excel.

> Another tidbit. If you right-click and edit the transaction in the
> Payee or category window, the Date, Amount and Account are uneditible
> - grayed out. All other transactions, even reconciled ones, are
> totally editable, though they will warn you if you edit them and are
> marked as reconciled.


Does the balance at the bottom of the register change based as the
register view is changed to show only unreconciled transactions or
in some other way?

 
Old 04-12-2004, 04:51 PM
Ed Hansberry, MS-MVP/Mobile Devices
Guest
 
Posts: n/a
Default Re: Hidden or invisible record in account register - M2004

"Ed Hansberry, MS-MVP/Mobile Devices"
<spamfree-silvernino[at]hotmail.spambegone.com> wrote:

- quote -

> The downloaded transaction is not available for viewing in:
> *The account register, no matter what filtering I have set.
> *The Advanced Find menu
> It is visible in:
> *The category section for ATM/Bank fees window in the lower right
> *The Payee section for my bank in the lower window
> *The Account Balance History report
> *The MoneyLink.XLA can pull it into Excel.


Another tidbit. If you right-click and edit the transaction in the
Payee or category window, the Date, Amount and Account are uneditible
- grayed out. All other transactions, even reconciled ones, are
totally editable, though they will warn you if you edit them and are
marked as reconciled.

Very strange.
--
_______________________
Ed H.
  #-1  
Old 04-12-2004, 04:29 PM
Ed Hansberry, MS-MVP/Mobile Devices
Guest
 
Posts: n/a
Default Hidden or invisible record in account register - M2004

I have a transaction that drove me nuts last weekend causing my
checking account to be out of balance. It is a downloaded deposit of
$2.00 (an ATM reimbursement fee) in my account. The amount is not
visible in the account register so I of course added it manually which
meant to Money, it is now in there twice, my manual entry plus it's
invisible one.

The downloaded transaction is not available for viewing in:
*The account register, no matter what filtering I have set.
*The Advanced Find menu

It is visible in:
*The category section for ATM/Bank fees window in the lower right
*The Payee section for my bank in the lower window
*The Account Balance History report
*The MoneyLink.XLA can pull it into Excel.

I've run the salv.exe program and it found no bad records. The amount
is correctly computing for the balance, but I don't know how the
amount is in the transaction register. If I start 3 transactions above
where it should be and manually add/subdtract amounts, the "Balance"
column is correct, so it is as if it is in the opening balance
calculation. It is properly dated 3/15/04 in all reports.

Suggestions?
--
_______________________
Ed H.
 

Tags
account, hidden, invisible, m2004, record, register
Similar Threads
Thread Forum Replies Last Post
Invisible transaction except if view by payee or category
JML: Using Money 04 Deluxe. Been using Money for *years*. I couldn't balance an account and if I unchecked one of the transactions, the statements...
Microsoft Money 3 03-06-2004 11:42 PM
Error between account list balances and actual account register
Tony: Hi - I've raised this as a support call but I'm running Money 2004 and my account balance on the account list view is differenct than that on the...
Microsoft Money 2 01-18-2004 02:18 PM
Budget Record for Dividends in Broker Account
Strongca: I am trying to set up my budget to include dividends from one of my Investment accounts. =the account has the "include in Budget Planner" box...
Microsoft Money 1 11-03-2003 12:29 AM
M2004 cash account on pocket money
Mike Vanecek: Under investments, Pocket M2004 Deluxe does not show the cash or contributions amounts, only the specific securities. Also, it groups all the...
Microsoft Money 1 08-22-2003 09:55 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:04 AM.