Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
January 17, 2024
Question

Reports--what do the rpts include

  • January 17, 2024
  • 1 reply
  • 0 views

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!

1 reply

BigRedConsulting
Level 15
January 20, 2024

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.

February 6, 2024

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
Level 15
February 6, 2024

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