1. Home
  2. Quicken Personal Finance
  3. Transactioons not downloading, but do appear in bank statement

Transactioons not downloading, but do appear in bank statement

We have as a second account a checking and savings account at our local credit union. I generally do not watch these with an eagle eye, as the responsibility for them is my wife's. I do enter checks if she gives me the duplcate to enter. I do download and reconcile the two accounts at the beginning of each month, but generally don't compare the statement with Quicken, only if there is a discrepancy. (My time is spent on our investments and our primary bank account). If no noise comes from the bank or my wife, I do ot tamper, and that's been the cxase until we were updating our financila profile for our advisor. At that time the savings accountwaS way off when she checked Quicken against the statement. This became noise at a high volume and I asked her to see if she could resolve it.

It is clear that the credit union uses Intuit to do their automated processes and on-line business. Their transaction descriptions are laughable as the Payee field is not a payee - it might read "Withdrawal Devit Chip" in the Payee field and in order to see who is being paid, yopu need to chjeck the MEMO field. You cannot produce any useable reports when a majority of the payees are Withdrawal Debit Chip".

The real problem we have discovered id that when downloading transactions for the Savings account, not all trans are downloaded, but the ones that are not do appear in the monthly ststement.

These missing transactions are all auto deduction payment s for an auto loan. And the real mystery is that of the 48 paymrnts, 33 are missing in Quicken (ie not downloaded bhut on the statements). There is no pattern to the missing transactions. When the loan started, a few were downloaded, followed by over 2 years missing, then some resumed, then they quit.

The download is done monthly and Quicken of course gets transaction for both accounts at in the Direct Connect session. The transactions for the checking accoutn are all downloaded and match the atatements - but the savings do not.

I am goiung to contact the credit union, but first would like to know if anything similar to this has happened to others and what caused it - bank, communication or cockpit error?

I need to find this problem and fix it before I tear out what little hair I have left.

Thanks for listening.

Reply to
John Carter
Loading thread data ...

There is useful information missing in your post. It's important to get that information before trying to troubleshoot your problem.

First: every Quicken question should include the Quicken Edition, year and release being used (found at Help > About Quicken). Example: Q2020 Home, Business & Rental Property R32.12.

Second: the exact Quicken name of the financial institution (see the General tab of the Edit Account Details dialog for the Quicken account).

Third: the account download "Connection Method" (see the Online Services tab of the Edit Account Details dialog for the Quicken account). Most credit unions use "Express Web Connect".

Just curious: are the printed statement ending dates the same for your checking account and your savings account?

Also please confirm that, " ... for the Savings account, not all trans are downloaded, but the ones that are not do appear in the monthly ststement [sic]." You are saying that you get transactions downloaded that do NOT appear in a statement. Is that true? So you have no idea who those transactions belong to or what those transactions represent?

So your downloads are sending transactions that don't appear in statements, and not sending transactions that do appear in statements?

You also say, "These missing transactions are all auto deduction payments for an auto loan. And the real mystery is that of the 48 paymrnts [sic], 33 are missing in Quicken (ie not downloaded bhut [sic] on the statements)." So are you paying the lender from your credit card "savings" account? And is the credit union also the lender for the auto loan?

Do you have the auto loan account setup in Quicken? If yes, is it setup for downloading, or is it a "manual" loan account?

Even before getting into the details of your problem, I suggest you plan to change your approach to your financial affairs. Waiting until you need a Quicken report of your financial situation to find out that your Quicken data does not match the data at the financial institution is waiting too long. I suggest you plan to "reconcile" your Quicken accounts each time you get access to the latest financial institution statement for the account.

You might also consider downloading more frequently than once a month. It's better to discover, and fix, problems as soon as possible. Sometimes you can visually notice problems even before you formally reconcile an account.

Reply to
John Pollard

I do apologize for the info that I normally provide. I will intersperse it withthe issues you bring up.

John Pollard snipped-for-privacy@gmail.com wrote in news: snipped-for-privacy@googlegroups.com:

Quicken 2020 Dekuxe Home R32.12 runniong on Wndows 10 Pro all updates

Financial institute name Wright-Patt Credit Union

Connection method is Direct connect

The printed statements received from the CU have both Accounts Checking and Savings on the same stataement. Their statements are dated from the first of a month to the end of a month - never cover any other period of time.

No - just the opposite. The statements have transactions that are NOT downl;oaded into Quicken. IE the statements have ALL the savings transactions, but the Quicken downloads do not. The missing transactions are in fact the monthly loan payment.

There are NO transactions missing from the statements, but are missing from the Quicken download. As a note, we have never had mysterious transactions appear on our statements that we could not identify as NOT OURS.

The Credit Union is the lender of the auto loan. The payments were set up to be an automatic deduction from the savings account each month on the same day. There are no credit cards involved. We use a debit card from the checking account, but no other means of accessing the money in the savings account except thru a withdrawal or an authorized deduction as in the loan patment.

They do not create an additinal account that is Quicken accessible so there is still only 2 accounts for the CU - checking and savings. I asked the loan officer why not, as it would enable me to track progress and keep an eye on the accounts. He had no explanation. So I creeated a manual loan account with the typical asset, liability properties and an amortization sschedule. For the first few months, the ;loan payment was being downloaded and the way I set it up was working properly, so I dodn't watch it with an eagle eye. Obviously when the transactions for the loan paym,ent wern't being downloaded, the accounts for the auto loan fell behind.

I have 3 banknig accounts and 4 brokerqe IRA accounts, and 3 brokerage IRA accounts for my wife that are very much larger in magnitude that the Credit Union accounts. My wife has asked me to handle her accounts exceot fore the Credit Union. The CU has never been much more rthan noise level compared th the account that I ride herd on very closely. It is my wife's account and I have it in Quicken only to (for my purposes) show up in a net worth and other Qucken reports I might add that we had no problems with any aspect of the credit union for 12 years - every download completed and the accounts reconcled with the statemments, had no reason to doubt the system until she took out a car loan...

That's something I will nave to start doing. I considered having her use my computer to do the download for the CU, but she was not a willing student, so dropped that idea shortly there after. We have been married nine months less than 50 years, so should have known better that she was more intersted in spending than managing. Such is a great life I live.

I have an appointment with the credit union "Quicken people" and if I find anything I'll post. In th e meantime, thanks for your interest.

John Carter

>
Reply to
John Carter

First, let me correct a mistake I made in my previous post.

When I said, "So are you paying the lender from your credit card 'savings' account?", I intended to say, "So are you paying the lender from your credit UNION 'savings' account?" Sorry about any confusion that caused.

I believe you have now confirmed that the credit union is the lender, and that they are taking the loan payment from your savings account. So that loan payment transaction should be in the downloaded data from the credit union ... along with any other savings account transactions.

Since you are downloading using the "Direct Connect" connection method, the financial institution (or the software company they hire for the purpose) is 100% responsible for the contents of the download. That means that if there are transactions that are truly missing from the download, only the financial institution can correct that.

But it is possible - though I think unlikely - that the transactions are being download, but do not appear as New transactions in Quicken.

The most reliable way to determine that is to examine the Quicken "OFX Log", which should contain every transaction downloaded - regardless of whether it was ever entered into a Quicken account register. That means that the OFX Log will contain downloaded transactions from every account downloaded to, and usually transactions from multiple different downloads to the same account.

To see the Quicken Log Files, go to Quicken Help > Log Files. Then click on "OFX Log". You will be able to view your current OFX Log file in the resulting display, but you have no additional features to help you locate data from within the Quicken display (you have to scroll and visually scan the data). What you do have there is the option to save the OFX Log as a .TXT file - see the button at the bottom of the display.

Once you have saved the OFX Log to a .TXT file, you can open that .TXT file in something like Notepad, which does have some features to help you locate data.

I presume you know the exact amount of the missing loan transactions, so you could use that amount as the text (yes, "text") to search for in the OFX Log. If your loan payment amount is, for example, $456.78; you can use the Notepad "Find" feature to look for "456.78".

Here is an example of the Quicken OFX data for one of my savings account interest transactions, for $0.07:

<STMTTRN> <TRNTYPE>CREDIT <DTPOSTED>20210129190000 <TRNAMT>0.07 <FITID>000000000000.0702101299107.63 <NAME>Interest Earned </STMTTRN>

I used "Find" text of "0.07" (no quotes) to locate the above transaction in the .TXT file I created from my OFX Log.

[NOTE: I used M.S. Word to insert a manual line break preceding each less-than sign (<) to produce the above example, to make the example easier to read. The actual downloaded data was (legitimately) strung together, so it looked like this: <STMTTRN><TRNTYPE>CREDIT<DTPOSTED>20210129190000<TRNAMT>0.07<FITID>000000000000.0702101299107.63<NAME>Interest Earned</STMTTRN>

Some financial institutions start each downloaded OFX "field" on a new line ... some don't.]

If you do not find any of the missing transactions in your OFX Log, I think you can be reasonably certain that Quicken is not involved, and concentrate your efforts on the credit union.

If you do find any of the missing transactions in the OFX Log, there might be some additional steps that would shed more light on what may have happened to them. You can post back here, if you want to dig deeper.

Reply to
John Pollard

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.