Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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.
To add the Open Balance column:
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!
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.
To add the Open Balance column:
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!
Thanks I had figured out the same. Open Balance would have been the correct field for this canned report.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here