Trouble matching downloaded transactions

Q reports the deposits as they are received by the bank.

If a deposit is multiple items then the bank reports one deposit amount and you use split to record the details.

If you want to record each item separately then you must make each item a separate deposit at the bank and they will be reported separately in Q.

Exactly. Just like what you would have done if you were using a paper register book like in the good old days. Each line in the little register had a 'cleared' column that you'd check off against each line on your bank statement. The mantra is to always try to use Quicken to reflect reality, not what you'd like it to do via brute force i possible.

Hi, David.

Enter each DEPOSIT, not each item deposited, as a separate line in the Register. When you have multiple items in a single deposit, use a split transaction to list the items. Then the downloaded deposit will match the manually entered deposit total.

Don't let the download be the INITIAL recording of the deposit. Record it manually first, so that there will be something for the downloaded entry to match.

That's the correct treatment if you actually deposit each check separately. But not if you combine them into a single deposit.

RC

-- R. C. White, CPA San Marcos, TX (Retired. No longer licensed to practice public accounting.) snipped-for-privacy@grandecom.net Microsoft Windows MVP (2002-2010) (Using Quicken Deluxe 2011 R 8 and Windows Live Mail in Win7 x64)

Quicken 2011.

Often I enter multiple checks to deposit on separate lines in the register. The bank records one deposit consisting of the sum of the multiple items I have entered in the register. When I download from the bank I can not figure out how to reliably get the single bank deposit to associate with the corresponding multiple register entries. I am a previous MS Money user and there was a nice dialog box to chose the entries to match. I have tried everything including right clicking the downloaded transaction and manually match, but somehow it just does not seem to work for me. I usually end up with a new split transaction with my original entries deleted. This is not what I want to happen. The 'help' section does not say much about matching downloaded bank deposits. I generally resort to accepting the bank deposit, manually reconciling the proper entries and deleting the bank transaction entry afterward. Is there a better way?

David

Q reports the deposits as they are received by the bank.

If a deposit is multiple items then the bank reports one deposit amount and you use split to record the details.

If you want to record each item separately then you must make each item a separate deposit at the bank and they will be reported separately in Q.

"David" wrote

There's "another" way.

Create a dummy Quicken account; call it "Undeposited Funds", for example.

As you receive checks you will want to deposit, record them as individual transactions in the "Undeposited Funds" account.

When you make the actual deposit in your checking account, categorize that as a transfer from the "Undeposited Funds" account.

John, I'm with you, but why call this a dummy account? Checks I have in hand are an asset, and I have an asset account titled "Uncashed Checks". I list each as received, then do the transfer you describe when I finally getting around to depositing them.

Another solution to OP's problem is to delete the one downloaded, redundant, transaction once he has verified that the 3 checks totaling $95 he deposited match the bank's records. He's then left with his individual entries for, say, $25, $25, and $45. Doug

Drawbacks to this approach are that the separate existing Quicken deposit transactions will not be marked as "cleared", will not have their "posting date" updated, and they will not be designated as having been "downloaded" (meaning they will remain as candidates to be "matched" to future downloaded transactions).