cancel
Showing results for 
Search instead for 
Did you mean: 
cgregorovic
Level 2

Reports--what do the rpts include

Hi all... I know someone can help me. In layman's terms, can someone describe what the following reports include because I get a different totals when I run each report--all on accrual basis and all for the same year (2023).

  • P&L
  • Sales by Customer Summary
  • Income by Customer

 

All 3 of these reports give me a different total for earned income. I do use journal entries for things like if we invoice, but we don't want to recognize that revenue yet because we didn't deliver yet...we recognize only when we deliver...or we deliver and not invoice yet because they want us to finish the entire project first, etc.

 

I just don't understand why there are different amounts, and it drives us crazy!

 

Thank you in advance for your help!

3 Comments 3
BigRedConsulting
Community Champion

Reports--what do the rpts include

RE: P&L

For each income/expense accounts type account, displays the sum of the transaction detail rows that use the account for the report period.

 

RE: Sales by Customer Summary

Shows the total by customer for select items, "all sales items", recorded on sales forms (invoices, credit memos, sales receipt, ...) for the report period that use a customer.

  • Income not associated with a customer is excluded (sales receipts don't have to have a customer).
  • Income not on sales forms are excluded.
  • Sales that are not income/expenses are included (for example, you could sell an asset like a car, which is not income).

 

RE: Income by Customer

Shows the total by customer for all income/expense accounts for the report period.

  • So, is really Net Income by customer.
  • Income/expenses not associated with a customer are excluded. 

 

Re: All 3 of these reports give me a different total for earned income.

I don't think any them try to give you anything like earned income, at least not if some of your data that uses income accounts is not earned income.

cgregorovic
Level 2

Reports--what do the rpts include

Thank you so much for taking the time to reply with details. It definitely helps, but still doesn't answer why my totals would be off. I do think it's the way QBs runs reports, or at least that's what I'm concluding.

BigRedConsulting
Community Champion

Reports--what do the rpts include

I think it does. As noted, the reports report on three conceptually different things. They are not designed to be the same.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us