| | |||
| |||
| 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
| |||
| |||
| 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 | |
| |