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:
- 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?
- 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
