Reallocated payments in QB2005

What you are describing does not sound quite right. I would suggest that you run a transaction report for this customer and verify that the dates of the invoices and payments are correct. A payment made last summer but showing up on the January P&L suggests an incorrect date on the payment. Also check for payments received without being applied to an invoice.

A negative A/R balance usually indicates a credit to the account. This can be caused by a payment w/o an invoice for example.

I would also verify the date range of the report.

I checked the dates and they are all correct but the application of payments may be key. The bill in question was paid by general journal debit for an expense paid directly by the customer with credit to A/R in his name. I bet that leaves the application of the payment floating and subject to reapplication later. I will check back for other instances where payment was split to see if they all involved general journal credits to A/R.

Thank you.

Al Levesque

What was the date on the Journal entry?

A better way to accomplish this would be to create a clearing account using a bank type. Code the payment to the customer using the clearing account as well as the receipt of payment with the clearing account. This eliminates the need for the journal entry.

The initial Journal entry was dated Aug 6, about a week after the invoice was generated. Another Journal entry was made Aug 29, and the final on Oct

1. On the other hand, a P&L generated today shows a small part of the payment as of Jan 30th, when the customer paid a bill dated Jan 1st.

We will experiment on the method you showed and hope that does it.

Thanks again,

Al Levesque

Run a P&L Detailed Report and double click on the Jan 30 transaction. Maybe this will give a clue as to the source of the problem.

The other thing that may be causing the problem is your use of Journal entries that impact A/R. Was your company set up as accrual but you are running reports on a cash basis? I seem to recall that depending on which line of the JE the A/R account was located could cause reporting problems. I