Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
 
Old 10-12-2004, 10:00 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Money 2003. Prior posting date

In microsoft.public.money, Kemmie777 wrote:

- quote -

> I download my banking statement using my Banks Online service. When I
> import the file, Money is changing the posting dates of ATM/Debit Card
> transactions to a prior posting date. EX.. An atm withdrawl done and posted
> on 09/30/04 on my online banking statement is showing in Money with the date
> 09/29/04. How do I correct this so it does not keep happening.



One way this happens is if the bank sets the time field in the OFX
download dates to zeros, or omits the code-- which strangely
defaults to zero=midnight. That corresponds to midnight. Now if the
broker makes the timezone be set to eastern time, that transaction
dated november 1 (implicitly midnight) EST, your computer set for
PST will see that as 9 PST on October 23. I wish Money would not
work that way, but it does. And the potential for this is defined in
the OFX spec.

The cure for this is for your broker to timestamp the transactions
at 5 AM (or later). 7 AM EST corresponds to noon GMT. That would fix
the problem for *any* timezone. But for you, any time after 3am
would be sufficient. Not for the Hawaiians tho. You get the idea.

The workaround is to set your computer timezone to GMT or the
timezone of your bank while doing the download and processing. I
would suggest you think of that as more of a diagnostic to prove the
concept. Then see if you can get your bank to behave. If you would
like to cite the OFX spec, that is easy enough.

  #-1  
Old 10-12-2004, 09:25 PM
Kemmie777
Guest
 
Posts: n/a
Default Money 2003. Prior posting date

Hi,
I download my banking statement using my Banks Online service. When I
import the file, Money is changing the posting dates of ATM/Debit Card
transactions to a prior posting date. EX.. An atm withdrawl done and posted
on 09/30/04 on my online banking statement is showing in Money with the date
09/29/04. How do I correct this so it does not keep happening.

I just recently switched from Quicken.

Thanks
 

Tags
2003, date, money, posting, prior
Similar Threads
Thread Forum Replies Last Post
Check issue date vs. Posting Date Problem
Steve: I have just noticed that when importing my check transactions from my bank that it changes my Draft Date to the date the check was posted/cashed. ...
Microsoft Money 1 06-22-2004 04:24 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 12:12 AM.