Applying one combined payment to different customer invoices

degoertzen
degoertzen Quicken Windows Subscription Member ✭✭

Hello im using quicken business amd personal on windows. So i deposited 3 checks into my bank account from 3 different customers. The downloaded transaction shows 1 lump sum for the 3 of them in my checkong account. I read on the quicken forum about creating a cash account and then transferring the downloaded transaction to the cash account and marking the invoices as paid to that cash account.

I did that but it wouldn't let me clear the transactions in the cash account. It still had the red pencil by the payment transactions for the invoices and said it hadn't been matched to a downloaded transaction and there fore just showed double the amount in the cash account and then my actual banking account was obviously showing too low because of lacking the original deposit.

So I started over tried somwthing a little different. I created a cash account with a balance of zero, marked the 3 invoices paid into the cash account and then transferred the amount to my actual checking account. So now the invoices are paid and the amounts are correct but the transfer in my checking account has the red pencil beside it and is showing as not cleared. There is no downloaded transaction for me to match it to anymore. What should've I done differently? Is there anything I can do to clear it since the downloaded transaction is gone?

Answers

  • NotACPA
    NotACPA Quicken Windows Subscription SuperUser ✭✭✭✭✭

    Simply click in the CLR field of the deposit transaction to mark it as cleared.

    Q user since February, 1990. DOS Version 4
    Now running Quicken Windows Subscription, Business & Personal
    Retired "Certified Information Systems Auditor" & Bank Audit VP

  • UKR
    UKR Quicken Windows Subscription SuperUser ✭✭✭✭✭

    It's a matter of timing.

    • Before you download transactions into your checking account you need to have recorded a New Customer Payment transaction into the Customer Invoices account for each payment check that you received. Direct to the payment to the intermediate Cash Account.
    • when done recording payments, create a "Daily Deposits" transfer transaction in the Cash Account transferring the total amount received into the checking account. Think of this as your deposit slip.
    • take the checks to the bank
    • next day, when the bank has processed ("cleared") your deposit, download checking account transactions.
    • The downloaded deposit transaction can now be matched to the Daily Deposits transaction and will be properly marked as "c"(cleared)
This discussion has been closed.