Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I am trying to generate a report containing all transections and net balance of customers (transection by customer). Report is generated showing correct balance and transection (invoice/Payment) amount. But it does not show the item of any invoice (what is sold to the customer). How can i solve this issue.
Good morning, @Mwaqar.
Thanks for taking the time to reach out to the QuickBooks Community for support. I hope you're enjoying the day so far.
Since you'd like to see the item included on your report, I recommend we use the Custom Transaction Detail report. I've included some steps to run and customize the report below.
Then your report should show everything you need. I've included an example report below to reference.
That should do it. For additional details about customizing reports, check out Customize reports in QuickBooks Desktop.
Please let me know if you have any further questions or concerns. I'm always here to lend a hand. Take care!
I tried by generating custom report but it mess up the transections and customer balance and increased transections which i dont understand. I run manufacturing industry and use build assembly feature. Image is attached for understanding. First is custom generated report have items and second image is customer balance details with actual transections, but it does not show items even selected.
Hi @Mwaqar,
Thank you for getting back and sharing screenshots about the result. Allow me to provide additional information about running reports in QuickBooks Desktop.
When you run a transaction report, the line items on a specific invoice will show separately. That's why it looks like invoices are increasing when viewing the data.
The balance appearing in the transaction report will base on the debit and credit columns. Since these two have different targets for the data, the Customer Balance Detail will show the correct balance based on your invoices and payments.
Items will not show in the customer balance report because of the sources and targets. The source is the Report set. That's why only summary information of the transaction show and not the detailed info like the item and item description.
I want to share a link that helps you know more about how the reports work. It'll help with customizing and choosing the right report based on what you need: Understand reports.
Additionally, I've attached an article for your reference on how to configure reports in the Desktop version: Customize reports in QuickBooks Desktop.
Drop me a comment if you have questions about the reports or gathering data. I'll be around to help. Have a great day ahead.
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