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

Sales by item detail report shows wrong balance

The sales by item detail report does not provide accurate balance.  The balance is just the original amount even when drilling into the invoice clearly shows the balance on that invoice is 0.  I have run for entire year to ensure both invoice and cash applied were included in the same reporting period.

 

I need a cash receipt by item and this should have been proper approach, but clearly Intuit report does not appear to work.   Any suggestions or is this just broken?

Solved
Best answer October 21, 2020

Best Answers
JessT
Moderator

Sales by item detail report shows wrong balance

Hi heshapiro!

 

I can shed light on the report you mentioned.

 

The Balance (column) is the total sales per item per transaction. Hence, this is called sales by item detail report. If you wish to see the unpaid portion of the total sales, you can add the Open Balance column.

  • A zero open balance means you don't have any collectible amounts for the item
  • A non-zero open balance means you still have open invoices.

To add the Open Balance column:

  1. On the same report, click on Customize Report.
  2. In the COLUMNS section, search for Open Balance and select it.
  3. Click OK.

 

If you'll keep on using the said report, I would suggest adding it to your list of memorized reports. That way, you won't have to customize it again.

 

Feel free to reach back out if you have other in mind. Have a good day!

View solution in original post

2 Comments 2
JessT
Moderator

Sales by item detail report shows wrong balance

Hi heshapiro!

 

I can shed light on the report you mentioned.

 

The Balance (column) is the total sales per item per transaction. Hence, this is called sales by item detail report. If you wish to see the unpaid portion of the total sales, you can add the Open Balance column.

  • A zero open balance means you don't have any collectible amounts for the item
  • A non-zero open balance means you still have open invoices.

To add the Open Balance column:

  1. On the same report, click on Customize Report.
  2. In the COLUMNS section, search for Open Balance and select it.
  3. Click OK.

 

If you'll keep on using the said report, I would suggest adding it to your list of memorized reports. That way, you won't have to customize it again.

 

Feel free to reach back out if you have other in mind. Have a good day!

heshapiro
Level 2

Sales by item detail report shows wrong balance

Thanks I had figured out the same.  Open Balance would have been the correct field for this canned report.

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

Need to get in touch?

Contact us