Skip to main content
Jan 8, 2018 8:01 PM UTC
Solved

The Income by Customer Summary Report isn't pulling a few payments received for a specified month

In order to pull the correct sales figures for each  month, I've been running the report Income By Customer Summary. The business sends invoices out, but often doesn't receive payment for weeks, or months, depending on the payment plan arranged with the customer. My issue is that the Income By Customer Summary isn't pulling a few payments received for a specified month. The invoice was created in a prior month, but the final payment is defintely entered/listed in the month specified in the report. So why isn't the report pulling those few payments? Is this a user error, or is there a better report to use? 

 

(Title has been edited by moderator for clarity)

    vpcontroller
    Jan 9, 2018 7:08 PM UTC

    @196578 

     

    • Sales by Customer Report = generated from sales forms (Invoice and Sales Receipt) only.
    • Income by Customer Report = sales forms + non-sales forms (income deposits without sales forms).

    14 replies

    Jan 9, 2018 6:00 AM UTC

    Hey @coaliron,

     

    Welcome to the QB Community! 

     

    Have you tried running a Sales by Customer Detail Report? Let me know if this reports the information you need!

    Dec 16, 2020 1:05 AM UTC

    I can print Profit and loss detail and my balance sheet reports but my income by customer reports both come up blank. Do you think i have put something wrong. Help if you can. I need to see how much each customer has made for the company.

    vpcontroller
    Jan 9, 2018 6:39 PM UTC

    The report you really want base the correct Sales figure is Company's Profit and Loss report. From this report, you can click revenue amount and will take to detailed sales reports.

    Jan 9, 2018 6:44 PM UTC

    @vpcontroller, great insight. Thank you.

     

    Is there an easy way to differentiate Income by Customer and Sales by Customer Reports? This might help clarify things for @coaliron.

    vpcontroller
    Jan 9, 2018 7:08 PM UTC

    @196578 

     

    • Sales by Customer Report = generated from sales forms (Invoice and Sales Receipt) only.
    • Income by Customer Report = sales forms + non-sales forms (income deposits without sales forms).
    sobolevalena21
    Jul 18, 2018 9:45 PM UTC

    Inside your Income by Customer Report, try switching the basis for the report look: Accrual vs. Cash. 

    Jul 19, 2018 10:31 PM UTC

    @sobolevalena21, thanks for adding to the conversation. It's such an eye-opener when you switch between cash and accrual views of reports.

    @coaliron, did you have any "in-progress payments" when you ran your report?