Accounts Receivable out of Balance-Search for problem records

Jon_sacks

My Accounts Receivable balance is off. I found that 3 payees although every transactions is "c" cleared have a balance. I can't find the transaction (invoice) that does not appear to have a payment properly applied to it. If I go into "Receive Customer Payment" it displays no open invoices. There is no way to do a reconciling transaction since it can't be applied in "Receive Customer Payments" and remains as uncleared (you can't manually clear an A/R transaction).

Super Validation does not find any bad or orphan transactions. How do I find an A/R entry (Invoice) that although cleared does not balance to 0. Note: I have tried looking at the detail of "Payment History" in the invoices but this is very time consuming.

I did find one transaction that has an issue, but see no way of correcting it. The Payment history does not match the invoice "Balance Due". Balance Due on the Invoice screen shows 0, but the balance on the Payment History in the Invoice shows an balance due of $213.00.

Note: A/R shows this transaction as Cleared.

The two questions are:

1. How can I find the other transactions that are out of balance (i.e. Balance due according to the payment history) without going into each of the 4102 transactions I have?
2. How do I fix a transaction that is cleared to correct my A/R balance?

Quicken Classic B&P for Windows ver: R59.10/27.1.59.10

NotACPA

I'm a bit confused by your 1st graphic. The Invoice in the background shows one number … but the Payment history is showing a different invoice number.

How are they associated?

Jon_sacks

I'm confused by your response NotACPA, they are the same it's invoice 2265, the display in the front is when you click on "Payment History" in the invoice, I would not know any way to display that screen other than within the invoice. If you are talking about the "Invoice Number Column" in the detail portion of the payment details, that is the check number from payment, not an invoice number.