|
#7
| |||
| |||
| In microsoft.public.money, Randy wrote: - quote - > OK. I'm thoroughly confused now.
Here is something that probably does not apply here, but could be of> First of all, I did go through my entire system and delete any trace > of a Temp Internet File. I also checked the qif files for duplicates. > Doesn't look like that's the culprit either. > So I followed your instructions below and imported the qif file -- and > it worked fine. All 100 transactions showed up in the register. This > made me think that there was something wrong with my downloaded files > (from CapitalOne). But I checked them out and they look fine. The > transactions are in there. > Now I'm very curious, so I delete your statement and went through the > following steps. interest at some point. When you delete an OFX statement, those transactions are remembered as having been already read. The transaction ID is remembered. A subsequent OFX download of the transaction with the same transaction ID is ignored. I don't think there would be any similar memory of deleted statements for QIF tho. - quote - > I have three files from my cc company, with 86, 55 and 64 transactions
That makes me think the next transaction could have been 06/13/2004> respectively. I import file #1 and get a message saying I have 86 > transactions to read, but when I look in the register there are only > 50. The last 16 transactions are missing, there's nothing there after > 6/12/2004. and your system was set to DD/MM/YYYY short dates. That does not seem likely, since I would expect a date error during the download had that been the case. Plus, you would have had a higher percentage of problem transactions. So we can reject that as the problem. Having fewer transactions than what was identified as transactions to read does not in itself seem strange. With QIF files from an account from different times, it does not seem strange that there would be overlap, unless there was a mechanism to limit each file to non-overlapping dates. But that "nothing after 6/12/2004" thing does not fit with anything normal to my thinking. A thing that comes to mind is to make a version of a file that has only the first line and the transactions that are dated after 6/12/2004. I can't think of what I would expect to occur tho. You can sort by order of entry or by date (normal). Is your view set to show all transactions? Just checking. - quote - > Next I import file #2 and am told I now have 141 transactions to read,
One thing that could be useful, at least as a troubleshooting> but when I look in the register there are still only 50, and nothing > after 6/12/2004. None of #2 are showing up. I do the same thing with > file #3 and am told I have 205 transactions to read, but still only > the original 50 show up in the register. > Now here is where it gets very strange. > I finally import your file. On my account list I'm told I have 305 > transactions to read. I open the register and now see 150 > transactions, but only 71 of them are from your test statement, and > there are 29 additional transactions from my import file #1. Still not > the full 86 transactions, and no sign of files #2 and #3, but there > are 9 more days worth, now through 6/21/2004. I have no idea what > happened to the other 29 transactions that are now missing from your > test file. > Just for grins I deleted everything and did it all again, with the > exact same results. Have you ever heard of anything like this? I'm > completely baffled. technique, is to import the QIF file as a new or recovered account (vs statement). That has the effect of turning off the duplicate elimination checking. I have not heard of anything like that. Perhaps somebody else has a theory given the data. The Microsoft people might be able to take another stab. |
|
#6
| |||
| |||
| OK. I'm thoroughly confused now. First of all, I did go through my entire system and delete any trace of a Temp Internet File. I also checked the qif files for duplicates. Doesn't look like that's the culprit either. So I followed your instructions below and imported the qif file -- and it worked fine. All 100 transactions showed up in the register. This made me think that there was something wrong with my downloade files (from CapitalOne). But I checked them out and they look fine. The transactions are in there. Now I'm very curious, so I delete your statement and went through the following steps. I have three files from my cc company, with 86, 55 and 64 transactions respectively. I import file #1 and get a message saying I have 86 transactions to read, but when I look in the register there are only 50. The last 16 transactions are missing, there's nothing there after 6/12/2004. Next I import file #2 and am told I now have 141 transactions to read, but when I look in the register there are still only 50, and nothing after 6/12/2004. None of #2 are showing up. I do the same thing with file #3 and am told I have 205 transactions to read, but still only the original 50 show up in the register. Now here is where it gets very strange. I finally import your file. On my account list I'm told I have 305 transactions to read. I open the register and now see 150 transactions, but only 71 of them are from your test statement, and there are 29 additional transactions from my import file #1. Still not the full 86 transactions, and no sign of files #2 and #3, but there are 9 more days worth, now through 6/21/2004. I have no idea what happened to the other 29 transactions that are now missing from your test file. Just for grins I deleted everything and did it all again, with the exact same results. Have you ever heard of anything like this? I'm completely baffled. via_newsgroup[at]please.tnx(Cal Learner-- MVP) wrote in message news:<k9v3k0dsun499ifitgo74fvd9p8gbsk1kn[at]4ax.com> ... - quote - > In microsoft.public.money, Randy wrote: > > I've spent the past few days trying (with no luck) to import my credit > > card statement into Money 2004. For some reason, even though Money > > says it imported 87 transactions, only 50 new transactions appear in > > the account. > I went back to think about other areas. > One possibility is that some records match items already in the > register. When you import a QIF file as a statement from your bank, > Money 2004 looks hard for duplicates and will ignore what it things > is a duplicate. That is based upon amount, payee and date data. If > you have identical charges, even in the same QIF file, it considers > them duplicates. :-( For QIF the matching is based on transaction > IDs that the FI puts into the file. That is very reliable within > Money. > > > I've tried deleting the statement and re-importing. I've tried > > importing both ofx and qif statements, and tried importing different > > months (I'm a couple months behind). I've repaired my Money file. I've > > even archived some older transactions to see if that helped. Nothing > > works. > I created a test file for a credit card account. (I did not test it > on a non-CC account. It should have 100 transaction records. 10 of > those are payments, and the rest are purchases. If you want to try > this file, I suggest you make a COPY of you Money file and try that. > you can File-> Import into a New or an existing account for testing > purposes. > You can create the file by copying from this posting the sections > between the ===begin=== and the ===end=== lines into a file named > something like MONTESTC.QIF. |
|
#5
| |||
| |||
| In microsoft.public.money, Randy wrote: - quote - > I've spent the past few days trying (with no luck) to import my credit
I went back to think about other areas.> card statement into Money 2004. For some reason, even though Money > says it imported 87 transactions, only 50 new transactions appear in > the account. One possibility is that some records match items already in the register. When you import a QIF file as a statement from your bank, Money 2004 looks hard for duplicates and will ignore what it things is a duplicate. That is based upon amount, payee and date data. If you have identical charges, even in the same QIF file, it considers them duplicates. :-( For QIF the matching is based on transaction IDs that the FI puts into the file. That is very reliable within Money. - quote - > I've tried deleting the statement and re-importing. I've tried
I created a test file for a credit card account. (I did not test it> importing both ofx and qif statements, and tried importing different > months (I'm a couple months behind). I've repaired my Money file. I've > even archived some older transactions to see if that helped. Nothing > works. on a non-CC account. It should have 100 transaction records. 10 of those are payments, and the rest are purchases. If you want to try this file, I suggest you make a COPY of you Money file and try that. you can File-> Import into a New or an existing account for testing purposes. You can create the file by copying from this posting the sections between the ===begin=== and the ===end=== lines into a file named something like MONTESTC.QIF. =================begin============================ ====== !Type:CCard D02/21/2004 T-350.18 PDELIGHTFUL TOOL MONGERS MMEMO TEST 428 ^ D05/27/2004 T-14.23 PSPEEDY LAWN MOWING SERVICES MMEMO TEST 857 ^ D01/04/2004 T-28.52 PFRIED FOOD EMPORIUM MMEMO TEST 714 ^ D02/08/2004 T-57.10 PMARATHON RUNNERS SHOE RETREADING MMEMO TEST 428 ^ D05/07/2004 T-14.00 PXYZ PEST PRODUCTS INC MMEMO TEST 076 ^ D09/12/2003 T183.11 PPAYMENT RECEIVED -- THANKS A BUNCH M ^ D12/17/2003 T-69.28 PPARTIAL FOODS COMPANYa HANOVER P MMEMO TEST 307 ^ D06/19/2004 T-23.03 PANUBIS DRY CLEANERS MMEMO TEST 769 ^ D02/13/2004 T-07.67 PEMPIRE DOG WASH MMEMO TEST 923 ^ D12/27/2003 T-752.38 PFRED'S SPELUNKING SUPPLY MMEMO TEST 978 ^ D09/25/2004 T-277.25 PSTAR MUSHROOM COMPANY MMEMO TEST 798 ^ D03/27/2004 T-055.48 PDELIGHTFUL TOOL MONGERS MMEMO TEST 406 ^ D01/29/2004 T-43.53 PSPEEDY LAWN MOWING SERVICES MMEMO TEST 779 ^ D06/05/2004 T-13.12 PFRIED FOOD EMPORIUM MMEMO TEST 415 ^ D09/02/2004 T-65.30 PMARATHON RUNNERS SHOE RETREADING MMEMO TEST 589 ^ D07/09/2004 T-32.30 PXYZ PEST PRODUCTS INC MMEMO TEST 846 ^ D02/16/2004 T884.11 PPAYMENT RECEIVED -- THANKS A BUNCH M ^ D03/13/2004 T-83.28 PPARTIAL FOODS COMPANYa HANOVER P MMEMO TEST 795 ^ D01/10/2004 T-47.13 PANUBIS DRY CLEANERS MMEMO TEST 975 ^ D05/11/2004 T-19.67 PEMPIRE DOG WASH MMEMO TEST 597 ^ D07/24/2004 T-651.58 PFRED'S SPELUNKING SUPPLY MMEMO TEST 421 ^ D04/24/2004 T-671.05 PSTAR MUSHROOM COMPANY MMEMO TEST 932 ^ D03/29/2004 T-150.58 PDELIGHTFUL TOOL MONGERS MMEMO TEST 931 ^ D02/29/2004 T-46.43 PSPEEDY LAWN MOWING SERVICES MMEMO TEST 625 ^ D09/07/2004 T-86.52 PFRIED FOOD EMPORIUM MMEMO TEST 776 ^ D01/09/2004 T-08.50 PMARATHON RUNNERS SHOE RETREADING MMEMO TEST 007 ^ D03/09/2004 T-10.50 PXYZ PEST PRODUCTS INC MMEMO TEST 931 ^ D02/19/2004 T1084.11 PPAYMENT RECEIVED -- THANKS A BUNCH M ^ D06/14/2004 T-62.58 PPARTIAL FOODS COMPANYa HANOVER P MMEMO TEST 978 ^ D06/15/2004 T-77.63 PANUBIS DRY CLEANERS MMEMO TEST 190 ^ D08/15/2004 T-00.77 PEMPIRE DOG WASH MMEMO TEST 391 ^ D12/25/2003 T-953.18 PFRED'S SPELUNKING SUPPLY MMEMO TEST 294 ^ D06/24/2004 T-672.55 PSTAR MUSHROOM COMPANY MMEMO TEST 978 ^ D06/25/2004 T-757.68 PDELIGHTFUL TOOL MONGERS MMEMO TEST 190 ^ D08/25/2004 T-00.73 PSPEEDY LAWN MOWING SERVICES MMEMO TEST 21 ^ D03/31/2004 T-14.22 PFRIED FOOD EMPORIUM MMEMO TEST 857 ^ D01/04/2004 T-21.20 PMARATHON RUNNERS SHOE RETREADING MMEMO TEST 285 ^ D04/09/2004 T-06.40 PXYZ PEST PRODUCTS INC MMEMO TEST 670 ^ D04/17/2004 T88.11 PPAYMENT RECEIVED -- THANKS A BUNCH M ^ D08/11/2004 T-84.08 PPARTIAL FOODS COMPANYa HANOVER P MMEMO TEST 808 ^ D06/14/2004 T-61.13 PANUBIS DRY CLEANERS MMEMO TEST 626 ^ D08/15/2004 T-71.47 PEMPIRE DOG WASH MMEMO TEST 285 ^ D07/21/2004 T-452.88 PFRED'S SPELUNKING SUPPLY MMEMO TEST 571 ^ D04/23/2004 T-875.95 PSTAR MUSHROOM COMPANY MMEMO TEST 600 ^ D07/21/2004 T-651.48 PDELIGHTFUL TOOL MONGERS MMEMO TEST 338 ^ D08/20/2004 T-53.33 PSPEEDY LAWN MOWING SERVICES MMEMO TEST 652 ^ D01/08/2004 T-78.32 PFRIED FOOD EMPORIUM MMEMO TEST 300 ^ D04/02/2004 T-85.70 PMARATHON RUNNERS SHOE RETREADING MMEMO TEST 140 ^ D12/07/2003 T-69.20 PXYZ PEST PRODUCTS INC MMEMO TEST 307 ^ D06/19/2004 T982.11 PPAYMENT RECEIVED -- THANKS A BUNCH M ^ D03/10/2004 T-76.98 PPARTIAL FOODS COMPANYa HANOVER P MMEMO TEST 230 ^ D07/16/2004 T-92.33 PANUBIS DRY CLEANERS MMEMO TEST 076 ^ D09/12/2003 T-30.77 PEMPIRE DOG WASH MMEMO TEST 723 ^ D09/27/2003 T-859.58 PFRED'S SPELUNKING SUPPLY MMEMO TEST 272 ^ D07/29/2004 T-873.75 PSTAR MUSHROOM COMPANY MMEMO TEST 054 ^ D04/20/2004 T-651.98 PDELIGHTFUL TOOL MONGERS MMEMO TEST 435 ^ D07/27/2004 T-96.53 PSPEEDY LAWN MOWING SERVICES MMEMO TEST 131 ^ D04/01/2004 T-59.22 PFRIED FOOD EMPORIUM MMEMO TEST 653 ^ D05/08/2004 T-97.90 PMARATHON RUNNERS SHOE RETREADING MMEMO TEST 323 ^ D08/04/2004 T-62.60 PXYZ PEST PRODUCTS INC MMEMO TEST 433 ^ D08/13/2004 T782.11 PPAYMENT RECEIVED -- THANKS A BUNCH M ^ D07/19/2004 T-51.08 PPARTIAL FOODS COMPANYa HANOVER P MMEMO TEST 471 ^ D09/17/2003 T-55.13 PANUBIS DRY CLEANERS MMEMO TEST 196 ^ D05/19/2004 T-77.47 PEMPIRE DOG WASH MMEMO TEST 615 ^ D04/22/2004 T-154.48 PFRED'S SPELUNKING SUPPLY MMEMO TEST 610 ^ D09/23/2003 T-273.95 PSTAR MUSHROOM COMPANY MMEMO TEST 105 ^ D09/23/2003 T-152.98 PDELIGHTFUL TOOL MONGERS MMEMO TEST 464 ^ D06/22/2004 T-59.73 PSPEEDY LAWN MOWING SERVICES MMEMO TEST 865 ^ D07/07/2004 T-61.92 PFRIED FOOD EMPORIUM MMEMO TEST 085 ^ D11/20/2003 T-73.90 PMARATHON RUNNERS SHOE RETREADING MMEMO TEST 105 ^ D09/03/2004 T-12.90 PXYZ PEST PRODUCTS INC MMEMO TEST 464 ^ D06/12/2004 T385.11 PPAYMENT RECEIVED -- THANKS A BUNCH M ^ D09/17/2003 T-86.58 PPARTIAL FOODS COMPANYa HANOVER P MMEMO TEST 776 ^ D01/19/2004 T-08.53 PANUBIS DRY CLEANERS MMEMO TEST 007 ^ D03/19/2004 T-10.57 PEMPIRE DOG WASH MMEMO TEST 931 ^ D02/29/2004 T-456.48 PFRED'S SPELUNKING SUPPLY MMEMO TEST 625 ^ D09/27/2003 T-876.55 PSTAR MUSHROOM COMPANY MMEMO TEST 776 ^ D01/29/2004 T-058.58 PDELIGHTFUL TOOL MONGERS MMEMO TEST 007 ^ D10/22/2003 T-13.03 PSPEEDY LAWN MOWING SERVICES MMEMO TEST 234 ^ D09/01/2004 T-42.82 PFRIED FOOD EMPORIUM MMEMO TEST 571 ^ D04/02/2004 T-12.20 PMARATHON RUNNERS SHOE RETREADING MMEMO TEST 854 ^ D09/22/2003 T-64.60 PXYZ PEST PRODUCTS INC MMEMO TEST 704 ^ D07/18/2004 T388.11 PPAYMENT RECEIVED -- THANKS A BUNCH M ^ D01/18/2004 T-40.88 PPARTIAL FOODS COMPANYa HANOVER P MMEMO TEST 086 ^ D04/16/2004 T-11.63 PANUBIS DRY CLEANERS MMEMO TEST 268 ^ D05/17/2004 T-14.27 PEMPIRE DOG WASH MMEMO TEST 857 ^ D01/24/2004 T-258.58 PFRED'S SPELUNKING SUPPLY MMEMO TEST 714 ^ D03/28/2004 T-579.65 PSTAR MUSHROOM COMPANY MMEMO TEST 007 ^ D01/26/2004 T-154.38 PDELIGHTFUL TOOL MONGERS MMEMO TEST 388 ^ D12/25/2003 T-33.63 PSPEEDY LAWN MOWING SERVICES MMEMO TEST 521 ^ D08/07/2004 T-83.32 PFRIED FOOD EMPORIUM MMEMO TEST 004 ^ D02/08/2004 T-57.10 PMARATHON RUNNERS SHOE RETREADING MMEMO TEST 400 ^ D07/06/2004 T-92.30 PXYZ PEST PRODUCTS INC MMEMO TEST 076 ^ D09/12/2003 T683.11 PPAYMENT RECEIVED -- THANKS A BUNCH M ^ D12/17/2003 T-69.28 PPARTIAL FOODS COMPANYa HANOVER P MMEMO TEST 307 ^ D06/19/2004 T-23.03 PANUBIS DRY CLEANERS MMEMO TEST 769 ^ D02/13/2004 T-07.77 PEMPIRE DOG WASH MMEMO TEST 239 ^ D07/28/2004 T-955.28 PFRED'S SPELUNKING SUPPLY MMEMO TEST 727 ^ D09/28/2003 T-377.05 PSTAR MUSHROOM COMPANY MMEMO TEST 544 ^ D09/10/2004 T11432.37 PPAYMENT RECEIVED -- THANKS A BUNCH MShould all balance out... ^ ===============end=================== |
|
#4
| |||
| |||
| In microsoft.public.money, Randy wrote: - quote - > I've already tried deleting my temporary files, and I did the
You might look at this thread:> QuickFileRepair with no luck. I even tried the Super Salvage utility > and it didn't help. > Would deleting cookies possibly help? I'd hate to delete them all, but > I could certainly go through and get rid of the junk. Are there > specific Money cookies I should delete? http://groups.google.com/groups?hl=e...22&btnG=Search Deleting that folder helped in at least one case, and the thing that I think remains after deleting temporary file is cookies. In IE6 there is File-> ImportAndExport-> Next-> ExportCookies. I tried exporting mine. I get a crlfcrlf-delimited (doublespaced) text file that should be editable with a text editor such as Notepad. I assume, but did not test that I could File-> ImportAndExport-> Next-> ImportCookies to get them back after deleting cookies. I assume could delete some and the process would still work. But I don't know absolutely. Perhaps first you might try reinstalling Money 2004 to a different folder/directory. That can cure some things, and it is simple and safe. Let us know. |
|
#3
| |||
| |||
| Well, it's just that 2003 was working pretty well for me. Ever since I upgraded to 2004 I've been having some nagging problems (this one, and another issue with Money creating online transactions that I didn't ask it to create). I made the 2004-to-2003 comment before searching the group to see what's involved. After doing that it doesn't really sound like an option (I have my .m11 backup file, but it's from months ago, and I really can't afford to lose that much info). I guess If I can't figure this out I may just completely uninstall/reinstall 2004 to see if it helps, or wait for Money 2005. "Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in message news:<#cWyWtulEHA.3536[at]TK2MSFTNGP12.phx.gbl> ... - quote - > What makes you think M03 would solve this? What's you strategy to roll your > M04 data file back to M03? > "Randy" <randych[at]hotmail.com> wrote in message > news:115126b0.0409092002.1b94e06e[at]posting.google.com... > > I've spent the past few days trying (with no luck) to import my credit > > card statement into Money 2004. For some reason, even though Money > > says it imported 87 transactions, only 50 new transactions appear in > > the account. > > > I've tried deleting the statement and re-importing. I've tried > > importing both ofx and qif statements, and tried importing different > > months (I'm a couple months behind). I've repaired my Money file. I've > > even archived some older transactions to see if that helped. Nothing > > works. > > > I'm just about ready to uninstall Money 2004 and go back to 2003. > > > Any suggestions?? |
|
#2
| |||
| |||
| I've already tried deleting my temporary files, and I did the QuickFileRepair with no luck. I even tried the Super Salvage utility and it didn't help. Would deleting cookies possibly help? I'd hate to delete them all, but I could certainly go through and get rid of the junk. Are there specific Money cookies I should delete? via_newsgroup[at]please.tnx(Cal Learner-- MVP) wrote in message news:<su92k05t95ss27i6a1mn9hjk04b2cllr7p[at]4ax.com> ... - quote - > In microsoft.public.money, Randy wrote: > > I've spent the past few days trying (with no luck) to import my credit > > card statement into Money 2004. For some reason, even though Money > > says it imported 87 transactions, only 50 new transactions appear in > > the account. > > > I've tried deleting the statement and re-importing. I've tried > > importing both ofx and qif statements, and tried importing different > > months (I'm a couple months behind). I've repaired my Money file. I've > > even archived some older transactions to see if that helped. Nothing > > works. > > > I'm just about ready to uninstall Money 2004 and go back to 2003. > > > Any suggestions?? > In Internet Explorer delete your browser temporary files with > Tools-> InternetOptions-> DeleteFiles. > Then in Money do File-> RepairMoneyFile-> QuickFileRepair for good > measure. > IE6 Tools-> InternetOptions-> DeleteCookies might be needed too, but > let's hope it doesn't get that far. |
|
#1
| |||
| |||
| In microsoft.public.money, Randy wrote: - quote - > I've spent the past few days trying (with no luck) to import my credit
In Internet Explorer delete your browser temporary files with> card statement into Money 2004. For some reason, even though Money > says it imported 87 transactions, only 50 new transactions appear in > the account. > I've tried deleting the statement and re-importing. I've tried > importing both ofx and qif statements, and tried importing different > months (I'm a couple months behind). I've repaired my Money file. I've > even archived some older transactions to see if that helped. Nothing > works. > I'm just about ready to uninstall Money 2004 and go back to 2003. > Any suggestions?? Tools-> InternetOptions-> DeleteFiles. Then in Money do File-> RepairMoneyFile-> QuickFileRepair for good measure. IE6 Tools-> InternetOptions-> DeleteCookies might be needed too, but let's hope it doesn't get that far. |
| | |||
| |||
| What makes you think M03 would solve this? What's you strategy to roll your M04 data file back to M03? "Randy" <randych[at]hotmail.com> wrote in message news:115126b0.0409092002.1b94e06e[at]posting.google.com... - quote - > I've spent the past few days trying (with no luck) to import my credit > card statement into Money 2004. For some reason, even though Money > says it imported 87 transactions, only 50 new transactions appear in > the account. > I've tried deleting the statement and re-importing. I've tried > importing both ofx and qif statements, and tried importing different > months (I'm a couple months behind). I've repaired my Money file. I've > even archived some older transactions to see if that helped. Nothing > works. > I'm just about ready to uninstall Money 2004 and go back to 2003. > Any suggestions?? |
|
#-1
| |||
| |||
| I've spent the past few days trying (with no luck) to import my credit card statement into Money 2004. For some reason, even though Money says it imported 87 transactions, only 50 new transactions appear in the account. I've tried deleting the statement and re-importing. I've tried importing both ofx and qif statements, and tried importing different months (I'm a couple months behind). I've repaired my Money file. I've even archived some older transactions to see if that helped. Nothing works. I'm just about ready to uninstall Money 2004 and go back to 2003. Any suggestions?? |
| Tags |
| import, records |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Money adding payee names to all records in a file untraceableremove_this@deathsdoor.com: When i review downloaded entries from my bank, I look up a check number and then enter the correct payee. Money is taking this payee name and... | Microsoft Money | 2 | 10-16-2003 08:15 PM | |
| Clear the existing records Dash: Hi, I have a problem. I wnated to know if there was any way that I could clear all of my current records and enter new information,including new... | Microsoft Money | 1 | 09-14-2003 05:24 AM | |
| Money did away with many months of records Leona V V: I had saved Micorsoft money to a floppy and a CD on Sept 3rd. The next day upon going to enter again my money had deleted everything back to May... | Microsoft Money | 4 | 09-10-2003 01:10 AM | |
| Thread Tools | |
| Display Modes | |
| |