Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #6  
Old 04-25-2008, 07:12 PM
Tom
Guest
 
Posts: n/a
Default Re: Account balance is right, but there's a missing transaction in MM+



"Steve" <respond[at]online.newsgroup> wrote in message
news:Xns9A8B823E75023184365720018436572[at]207.46.248.16...
- quote -

> As far as I know, Money doesn't try to edit your transactions. I make
> multiple $40 deposits because that's a common bill to some of my
> clients. Money has never tried to combine them. It sometimes _does_ get
> confused about which downloaded transaction goes with which manually
> entered transaction, but there's only so much it can do. I don't want
> Money making assumptions.


Neither do I!

- quote -

> Don't forget about the nut that holds the wheel. That's the case for my
> problems about half the time.


For me, if/when it gets out of whack it's because of some behind-the-scenes
process over which I have no control. Something's nutty, for sure...




- quote -

> --
> Steve B.
> New Life Home Improvement


  #5  
Old 04-25-2008, 06:48 PM
Steve
Guest
 
Posts: n/a
Default Re: Account balance is right, but there's a missing transaction in MM+

"Tom" <tomh5480[at]live.com> wrote on 25 Apr 2008 in group
microsoft.public.money:

- quote -

> "Steve" <respond[at]online.newsgroup> wrote in message
> news:Xns9A8B582709663184365720018436572[at]207.46.248.16...
> > "Tom" <tomh5480[at]live.com> wrote on 25 Apr 2008 in group
> > microsoft.public.money:
> > > > "Steve" <respond[at]online.newsgroup> wrote in message
> > > news:Xns9A8B4F58C8C6184365720018436572[at]207.46.248.16...
> > > > > > > Check your view settings. Maybe you're hiding reconciled
> > > > transactions, and that one is accidentally reconciled.
> > > > > View settings: Sort by date, All dates, All transactions, Top Line
> > > Only.
> > > > > > Look at the opening balance. Has it been adjusted by $100?
> > > > > It looks like it has been, if I factor in .02 (2 cent) transaction,
> > > which is also missing. What can I do about that?
> > > 1. From Windows Explorer, make a copy of your data file. Give it an

> > obvious name like "Copy of my money file to figure out bad
> > balance.mny" so you won't confuse it with the real thing later. Put
> > it on your desktop so you can find it easily.
> > 2. Double-click the copy you made to open it.
> > 3. Adjust the starting balance of your problem account by $100.02.
> > 4. Add the missing transactions.
> > 5. Check the current balance on the account.
> > 6. Go back and adjust the starting balance the other direction,
> > because everyone always does it backwards the first time.
> > > Once you prove to yourself that it's working, open your _real_ Money

> > file and repeat the process on live data.

> Thanks, Steve. Adjusting the beginning balance and manually adding
> the missing entries did it.
> Still, I wonder why the two entries failed to show in MM+. Two
> possibilities come to mind:
> 1. MM+ figured they were duplicates and just dropped them; if so,
> that's kind of wrong - I should be given the option of deleting the
> duplicates. I don't know if this is the case, because I have other
> identical transactions which are reflected in register line items.
> For example, Dollar Tree double-billed me on 2 separate transactions,
> and both billings showed up for both transactions.
> 2. Whatever method MM+ is using to retrieve transactions from
> Woodforest National Bank is wonky; maybe Woodforest is deciding those
> entries are duplicates and not supplying them to MM+ (whether in a
> file, HTML/XML stream, whatever). I don't know if this is the case
> since all transactions are displayed on the website (but that may be
> a wholly separate process from the transaction retrieval that MM+
> uses).
> In any case, thanks again Steve.


As far as I know, Money doesn't try to edit your transactions. I make
multiple $40 deposits because that's a common bill to some of my
clients. Money has never tried to combine them. It sometimes _does_ get
confused about which downloaded transaction goes with which manually
entered transaction, but there's only so much it can do. I don't want
Money making assumptions.

Don't forget about the nut that holds the wheel. That's the case for my
problems about half the time.
--
Steve B.
New Life Home Improvement
  #4  
Old 04-25-2008, 03:24 PM
Tom
Guest
 
Posts: n/a
Default Re: Account balance is right, but there's a missing transaction in MM+

Thanks, Steve. Adjusting the beginning balance and manually adding the
missing entries did it.

Still, I wonder why the two entries failed to show in MM+. Two possibilities
come to mind:

1. MM+ figured they were duplicates and just dropped them; if so, that's
kind of wrong - I should be given the option of deleting the duplicates. I
don't know if this is the case, because I have other identical transactions
which are reflected in register line items. For example, Dollar Tree
double-billed me on 2 separate transactions, and both billings showed up for
both transactions.

2. Whatever method MM+ is using to retrieve transactions from Woodforest
National Bank is wonky; maybe Woodforest is deciding those entries are
duplicates and not supplying them to MM+ (whether in a file, HTML/XML
stream, whatever). I don't know if this is the case since all transactions
are displayed on the website (but that may be a wholly separate process from
the transaction retrieval that MM+ uses).

In any case, thanks again Steve.


"Steve" <respond[at]online.newsgroup> wrote in message
news:Xns9A8B582709663184365720018436572[at]207.46.248.16...
- quote -

> "Tom" <tomh5480[at]live.com> wrote on 25 Apr 2008 in group
> microsoft.public.money:
> > "Steve" <respond[at]online.newsgroup> wrote in message
> > news:Xns9A8B4F58C8C6184365720018436572[at]207.46.248.16...
> > > > > Check your view settings. Maybe you're hiding reconciled
> > > transactions, and that one is accidentally reconciled.
> > > View settings: Sort by date, All dates, All transactions, Top Line

> > Only.
> > > > Look at the opening balance. Has it been adjusted by $100?
> > > It looks like it has been, if I factor in .02 (2 cent) transaction,

> > which is also missing. What can I do about that?

> 1. From Windows Explorer, make a copy of your data file. Give it an
> obvious name like "Copy of my money file to figure out bad balance.mny"
> so you won't confuse it with the real thing later. Put it on your
> desktop so you can find it easily.
> 2. Double-click the copy you made to open it.
> 3. Adjust the starting balance of your problem account by $100.02.
> 4. Add the missing transactions.
> 5. Check the current balance on the account.
> 6. Go back and adjust the starting balance the other direction, because
> everyone always does it backwards the first time.
> Once you prove to yourself that it's working, open your _real_ Money
> file and repeat the process on live data.
> --
> Steve B.
> New Life Home Improvement


  #3  
Old 04-25-2008, 03:22 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Account balance is right, but there's a missing transaction in MM+

In microsoft.public.money, Tom wrote:

- quote -

> I pulled an update from Woodforest, and it updated ok. When I compare the
> MM+ register listing to the online one for the bank, there's a $100
> transaction on the bank's website which does not show in MM+ - but the
> balances are in agreement, to the penny.
> How can that be?


Make sure you are in Advanced Register as indicated to the upper
right in the register.

Note that right below where it says Advanced Register is the
BankBalance. That is the balance number last downloaded from the
bank. At the lower right is the EndingBalance. That is the sum of
your transactions plus the initial balance. It will match the latest
running balance when you sort by date. I brought those up in case
you were looking at BankBalance, which is not affected by what
transactions are in your register.

Now if that does not explain it, change the View to AllTransactions.
Does the EndingBalance change? Try the same for Unreconciled and
UnAccepted transactions views. The EndingBalance should not change
by changing the view. If it does, check back.

  #2  
Old 04-25-2008, 02:39 PM
Steve
Guest
 
Posts: n/a
Default Re: Account balance is right, but there's a missing transaction in MM+

"Tom" <tomh5480[at]live.com> wrote on 25 Apr 2008 in group
microsoft.public.money:

- quote -

> "Steve" <respond[at]online.newsgroup> wrote in message
> news:Xns9A8B4F58C8C6184365720018436572[at]207.46.248.16...
> > > Check your view settings. Maybe you're hiding reconciled

> > transactions, and that one is accidentally reconciled.

> View settings: Sort by date, All dates, All transactions, Top Line
> Only.
> > Look at the opening balance. Has it been adjusted by $100?

> It looks like it has been, if I factor in .02 (2 cent) transaction,
> which is also missing. What can I do about that?


1. From Windows Explorer, make a copy of your data file. Give it an
obvious name like "Copy of my money file to figure out bad balance.mny"
so you won't confuse it with the real thing later. Put it on your
desktop so you can find it easily.
2. Double-click the copy you made to open it.
3. Adjust the starting balance of your problem account by $100.02.
4. Add the missing transactions.
5. Check the current balance on the account.
6. Go back and adjust the starting balance the other direction, because
everyone always does it backwards the first time.

Once you prove to yourself that it's working, open your _real_ Money
file and repeat the process on live data.
--
Steve B.
New Life Home Improvement
  #1  
Old 04-25-2008, 02:07 PM
Tom
Guest
 
Posts: n/a
Default Re: Account balance is right, but there's a missing transaction in MM+

(comments inline)

"Steve" <respond[at]online.newsgroup> wrote in message
news:Xns9A8B4F58C8C6184365720018436572[at]207.46.248.16...
- quote -

> "Tom" <tomh5480[at]live.com> wrote on 25 Apr 2008 in group
> microsoft.public.money:
> > I pulled an update from Woodforest, and it updated ok. When I
> > compare the MM+ register listing to the online one for the bank,
> > there's a $100 transaction on the bank's website which does not show
> > in MM+ - but the balances are in agreement, to the penny.
> > > How can that be?

> Check your view settings. Maybe you're hiding reconciled transactions, and
> that one is accidentally reconciled.


View settings: Sort by date, All dates, All transactions, Top Line Only.

- quote -

> Look at the opening balance. Has it been adjusted by $100?

It looks like it has been, if I factor in .02 (2 cent) transaction, which is
also missing. What can I do about that?

- quote -

> Maybe the transaction has a very old date that doesn't show up on your
> screen. Check your view settings for this, too.


I sorted by amount, but still I don't see the missing $100 transaction. I
see 4 other $100 transactions, but not that one.


- quote -

> Type <Ctrl> +F to bring up the "Find" dialog box; click the "Advanced..."
> button; choose the "Advanced search:" radio button; click the "Next> "
> button; click "Reset Criteria"; choose the "Amount" tab; fill in the
> amount to search on; click "Next> ". Search through here for your
> transaction. Check it carefully to see what might be odd about it.


I still only see the other 4. There is still one missing.


- quote -

> --
> Steve B.
> New Life Home Improvement


Thanks, Steve.



 
Old 04-25-2008, 01:48 PM
Steve
Guest
 
Posts: n/a
Default Re: Account balance is right, but there's a missing transaction in MM+

"Tom" <tomh5480[at]live.com> wrote on 25 Apr 2008 in group
microsoft.public.money:

- quote -

> I pulled an update from Woodforest, and it updated ok. When I
> compare the MM+ register listing to the online one for the bank,
> there's a $100 transaction on the bank's website which does not show
> in MM+ - but the balances are in agreement, to the penny.
> How can that be?


Check your view settings. Maybe you're hiding reconciled transactions, and
that one is accidentally reconciled.

Look at the opening balance. Has it been adjusted by $100?

Maybe the transaction has a very old date that doesn't show up on your
screen. Check your view settings for this, too.

Type <Ctrl> +F to bring up the "Find" dialog box; click the "Advanced..."
button; choose the "Advanced search:" radio button; click the "Next> "
button; click "Reset Criteria"; choose the "Amount" tab; fill in the
amount to search on; click "Next> ". Search through here for your
transaction. Check it carefully to see what might be odd about it.
--
Steve B.
New Life Home Improvement
  #-1  
Old 04-25-2008, 01:33 PM
Tom
Guest
 
Posts: n/a
Default Account balance is right, but there's a missing transaction in MM+

I pulled an update from Woodforest, and it updated ok. When I compare the
MM+ register listing to the online one for the bank, there's a $100
transaction on the bank's website which does not show in MM+ - but the
balances are in agreement, to the penny.

How can that be?


 

Tags
account, balance, missing, transaction
Similar Threads
Thread Forum Replies Last Post
Negative Cash Transaction Account Balance in 401k account
MikeyFrat: Hi, I have a 401k investment account from a former employer,setup in Money 2006 DLX as a retirement account, tracking cash transactions. Though I...
Microsoft Money 3 01-29-2007 05:59 AM
Missing loan accounts in 'Account Balance History' report
Kezarnet: Good evening. I’m trying to create an Account Balance History report that shows the balance of my student loans over time. When I go to...
Microsoft Money 2 09-25-2006 11:54 AM
How to balance account when missing a statement?
BoDEAN: I never got my August statement, and just got my september statement? How can I balance my account effectively? I just did it, and it asked if I...
Microsoft Money 1 10-10-2003 05:05 AM
Correct Balance but missing transaction
Frank: I have just converted to Money 2004 from Quicken and have the following problem: I update a Money Credit Card account. The balance on the left...
Microsoft Money 2 08-03-2003 04:51 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 02:13 PM.