Payment received does not appear in Sales by Customer report

Mar 17, 2005 3 Replies

Hi,



In getting my records together to do my 2004 taxes, I just discovered that a $900 payment I received from a client does not appear in a Sales by Customer Detail report in Quickbooks 2000. However, the payment does appear If I Search (Ctrl-F) for payments received from the client or Search by the amount. The payment also appears in my checking account register, and in the Payment History pop-upof the Invoice. It just doesn't apear in the Sales by Customer report.



This "hide and seek" payment is very disconcerting , because I discovered it when I was trying to match my QB record of payments received from this client and the 1099-MISC the client sent me. The 1099 appears to be more than $2000 over the total in the Sales Report, so now I'm wondering if QB is acting flaky, or if the client has made an error unrelated to this problem.



The only thing notably different about this payment is that the invoice is dated in December, 2003, but the payment was received in January 2004. Could this be confusing Quickbooks?



So far, this is the only client whose payments show a discrepancy, and I have never had a problem recording payments from this client over the years.



Can anyone suggest why this is happening, and what I can do to be sure I'm not missing other payments?



Thank you.



Orrie


Modify the report so it uses cash basis and not accrual basis. On the accrual basis this was 2003 income on the cash basis it is 2004 income.

I have always used Cash basis for my sole proprietorship, so it didn't occur to me that I would have to select Cash for a report. How can I make that the default for reports? At least now I know enough to check whether the setup is for Accrual or Cash. Thanks again.

Orrie

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required