cancel
Showing results for 
Search instead for 
Did you mean: 
Active Member

How to remove client fees received from income for reporting

 
6 Comments
QuickBooks Team

Re: How to remove client fees received from income for reporting

It’s great to see you in the Community, davids2.


If you’re running the Sales by Product/Service Detail Report, let’s use the Filter feature to remove the client fees. With just a few clicks, you can easily customise the information.


Here’s how:

 

  1. Tap the Reports tab on the left panel and then enter Sales by Product/Service Detail in the search field.
  2. In the upper right-hand corner, hit the Customise tab to select the information you want to show on the statement.
  3. Select the date by clicking the Report period drop-down.
  4. Go to the Filter section to sort the information.
  5. Mark the box for Product/Service and make sure not to include the fees.
  6. Click Run report to reflect the changes.

For additional resources, I'm also adding a link to visually guide you about customising reports.

 

Reach out to me anytime if you have any questions. Please know I’m always ready to assist further. Have a great rest of your day.

 

Active Member

Re: How to remove client fees received from income for reporting

I did that. But report does not show. It states "This report does not contain any data."

Moderator

Re: How to remove client fees received from income for reporting

I appreciate you getting back in the thread, @davids2.

 

Let me help figure out why your report contains no data.

 

One possible scenario depends on how you record the client's fees. Did you use a service item when recording the fee? If so, you should be able to exclude the fees when generating a report for the income transactions of the product items. 

 

Or, it could be that the date range you selected have no transactions for the product items.

 

Once you identify the reason, you can customise the Sales by Product/Service Detail report again and exclude the fees.

 

Should you need to customise your other financial reports, you may check on this helpful article: Customise your financial reports.

 

Let me know how it goes. I want to help ensure you can run a report without showing your client's fees. 

Active Member

Re: How to remove client fees received from income for reporting

The date range is okay.

 

What is a "service item"?

In any event I don't want to see teh client fees, I want to see all other income only.

Highlighted
QuickBooks Team

Re: How to remove client fees received from income for reporting

Hi Davids2,

 

Let me continue to help you about your report. I just have a few questions though.

 

What report are you running, and how are these clients' fees recorded? By knowing the report and the way the fees were recorded, I would be able to replicate the scenario using my test account. 

 

Thanks in advance.

Established Community Backer ***

Re: How to remove client fees received from income for reporting

Client fees are income.  Easiest thing is to create a service type item in the products & services list called client fees and link it to a client fee income account you create.  Then use that item on the client invoice.  Items determine what account is posted to.

 

Then you can run a P&L and in customize select what income and expense account to report on