Reports/Report Customer Payments By Product/Service Category

Thank you! 

I'd like to run a custom monthly report that shows product/service & the payment received in the month (not sales) for that specific product/service. In my case, I sell a service that is often paid for over a few months. I'd like a summary of payments received by months. 

Example. customer signs up and an invoice is created for $1000 (i.e. a sale of Item A). In month 1 they pay 600 and in month 2 they pay 400. I'd a report that shows 

Month 1:

"Item A"   

Payment: $600

Balance: $400

Month 2 

"Item A"   

Payment: $400

Balance: $0

Also, I can a commission based on payment received (i.e. in month 1 it would be $600 multiplied by a commission percentage). Is there a way to create a custom field that multiplies the payment received by a set %? 

There are similar questions but the solution provided is sales by product service not payments. 

Thanks

Yes, in QuickBooks Online (QBO), we can run custom reports for products and services, as well as for payments received, @dsfsdfds. However, there isn’t a built-in feature that allows users to create a custom field that automatically multiplies the payment received by a set percentage directly within transaction forms. I’ll guide you through the steps to customize a specific report.

To generate a monthly report in QBO that displays products/services and the payments received in a specified month, here's how:

1. Log in to QuickBooks Online:
2. Go to Reports:
3. In the Reports page, use the search bar to search for Transaction Detail by Account. Then click the report to open it.
4. Click Customize the report.
5. Under the General section, set the Report period to the specific month you want to analyze.
6. Under the Filters section, select Transaction type then choose Payment.
7. In the Rows/Columns section, check the Date, Product/Service/Amount.
8. Then click Run Report.

For modern view:

For classic view:

Also, custom reports allow you to focus on the particular metrics and data points that are most relevant to your business or your client’s business. Refer to this article: Customize reports and create custom summary reports in QuickBooks Online Accountant.

Additionally, by memorizing reports, you and your team ensure that you and your team use the same report format and settings every time. This consistency helps maintain uniformity in data analysis and reporting across the organization.

Moreover, enhance your financial trajectory by working with our QuickBooks Live Expert Assisted team. These financial maestros streamline your processes and provide bespoke advice to meet your business's unique needs. Click now to embark on a new era of financial clarity and success.

Mastering report customization in QuickBooks Online is essential for effective financial management and can enhance decision-making, communication, and adaptability in your business, @dsfsdfds. If you have further questions or need assistance with customizing reports, please click the reply button. I'm always here to help.

Thank you for this. Ive been able to set it up but I have another question. 

I would like the payment column to be net of tax. They currently show as the full payment amount. I would like to know how I can add a column that shows the payment net of tax. In the attached screen shot that would be "Amount" less "Tax Amount"

Thanks

please disregard my second question re. tax. Thanks

Is there a way to show this report with prior months payments, also shown by month? I would like to generate a report as a summary of payments received by service/product, by month (i.e not just show current month). 

Thanks

1. Go to the Reports menu, then type Sales by Customer Type Detail in the Search tab.
   
    
   
2. Click the Columns icon, then check the Category/Product/Service Tax amount box.
   
3. Click on Save.
4. Select the More action dropdown button at the upper right corner.
   
5. Choose the Export to Excel option.

1. Go to the Reports menu, then search for Sales by Product/Services Summary report.
   
2. Click on the Customize button, then set the accurate report period.
   
3. Hit the Row/Columns dropdown button.
   
4. In the Columns tab, choose Months.
5. Select the Run report option.

Customizing reports is beneficial as it allows businesses to tailor the data presentation to their unique needs and preferences. I've attached this article that offers detailed instructions on how to customize reports in QuickBooks Online: Customize Report in Modern View.

You can also print reports by check number in QuickBooks Online, which may be useful for you in the future.

I was able to create the report net of tax and it is working great. I do want to add one more layer of complexity. 

I would like my report, which shows customer payments for a series of months. Ideally something like this (see attached). I want to see payments for every month within a certain range. Ive seen similar reports for Income Statement by month. 

I was able to create the report net of tax and it is working great. I do want to add one more layer of complexity. 

I would like my report, which shows customer payments for a series of months. Ideally something like this (see attached). I want to see payments for every month within a certain range. Ive seen similar reports for Income Statement by month. 

looking for a solution on this. See attached screen shot. Payments by month for a customer/service. How do i generate this report?

Thank you for returning to the thread, @dsfsdfds. In QuickBooks Online we can generate Sales by Product/Service Detail report and group them by month. Let me provide detailed information to achieve this report.

This report provides comprehensive insights into sales activities broken down by each product or service. To pull up this report please follow the steps below:

1. Navigate to Reports menu.
2. On the search option, type in Sales by Product/Service detail.
3. On the Group by drop down, select Month.
4. Once done, Click on Run report.
   
   

To match the layout from your provided screenshots, you can export the file to Excel, and you can customize them with the information you need.
 

Moreover, you can save and share customized reports in a group to enhance data sharing and teamwork efficiency.

I value your dedication to obtaining this report, @dsfsdfds. Providing us with screenshots is highly appreciated as it helps us provide targeted solutions. If you need further assistance, please leave a comment below. Have a great day ahead!

Thanks for the update, however, I do not wish to export to excel to complete this task. Also, I do not see the balance receivable. In your rightmost column, the math doesn't appear to add up. 

I see that you can export an income statement by month and have each month horizontally across the screen. 

Can you please let me know how to accomplish the attached screenshot inside QBO? Again, exporting to Excel is not an option. I would like the months horizontally, and the vertical column grouped by product/service. I'm sure through some custom reporting tweaks this can be done and that is what I'm hoping you can help with. I need a QBO solution, not Excel. 

Thank you 

I appreciate your dedication to streamlining your reporting process within QuickBooks Online (QBO), dsfsdfds. However, displaying months horizontally and grouping columns by product/service is not supported. I can assist you in requesting this feature from our developers to enhance future data presentation.

I understand the convenience of organizing the balance receivable, invoices, and products/services in a report within the program. While QBO offers various reporting options, the specific format of displaying months horizontally with a vertical column grouped by product/service is unavailable. In this case, I recommend submitting a request for more configuration choices to customize the rows, columns, and data accordingly.

Follow the steps below:

1. Go to the Gear icon at the top.
2. Under the Profile column, select Feedback.
3. Share your suggestion, then click Next.

Alternatively, you can select the Give Feedback button at the top-right corner of the report page on Modern View.

Keep an eye on your suggestions on this website and visit our blog for recent developments.

Additionally, check out this article for more personalization instructions to get the most out of your financial report: Customize reports in QuickBooks Online.

Furthermore, you can scan this reference to memorize your customization settings: Save a customized report in QuickBooks Online.

If there is anything else I can assist you with or if you need help exploring other available reporting options, please don’t hesitate to let me know. We're here to make your experience with QuickBooks as productive and seamless as possible. Keep safe.