Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
February 7, 2019
Solved

User Reports

  • February 7, 2019
  • 2 replies
  • 0 views

Can I print a separate report for each user?  I have a report that I customized to print showing transactions for each user by showing the last modified by column but all users are on the same report.  We need to have each user (in our case, doctors) on separate reports so we have totals for each.  If only there were the option to filter by last modified by but that is the one thing that isn't in the list.  

Best answer by qbteachmt

This is Class Tracking, not user names: "Yes, we are wanting the transaction total for each user."

 

User names is how you control Access and limited rights, such as, some people have a log in that does not allow them to Print Checks. It's not a Financial option; it is a Usage and Audit Control provision.

 

"We had previously used software for a veterinary clinic and that is type of reports that we had printed off for each of our doctors that showed totals."

 

Yes, that is Class Tracking.

 

"The report that I customized is exactly what we want except for the fact that all users (doctors) are on the same report instead of having a report for each separately."

 

Because "user" is not financial, but a Clerical Control, aspect.

 

You want to Enable Class in the accounting preferences. You want to set up three classes: one for each of the two doctors, and one "Admin" class, typically.

 

Class = Divisional or Departmental reporting of allocated amounts.

 

Please see my attachment.

2 replies

qbteachmt
Level 11
February 7, 2019

"Last Modified By" is more of a data entry analysis for who did the work, and for the audit trail, to figure out who changed something and when and what.

 

Are you sure you didn't want Class Tracking? That is how you manage Divisional or Department reporting. P&L by Class, Balance Sheet by Class, Sales by Customer Summary, filter on one Class.

 

User Reports is more of a quality control aspect, not a financial aspect. You are not supposed to need "total by each user" because that isn't a financial perspective.

WOVCAuthor
February 7, 2019

Thanks for replying.  Yes, we are wanting the transaction total for each user.  We had previously used software for a veterinary clinic and that is type of reports that we had printed off for each of our doctors that showed totals.  The report that I customized is exactly what we want except for the fact that all users (doctors) are on the same report instead of having a report for each separately. 

qbteachmt
qbteachmtAnswer
Level 11
February 7, 2019

This is Class Tracking, not user names: "Yes, we are wanting the transaction total for each user."

 

User names is how you control Access and limited rights, such as, some people have a log in that does not allow them to Print Checks. It's not a Financial option; it is a Usage and Audit Control provision.

 

"We had previously used software for a veterinary clinic and that is type of reports that we had printed off for each of our doctors that showed totals."

 

Yes, that is Class Tracking.

 

"The report that I customized is exactly what we want except for the fact that all users (doctors) are on the same report instead of having a report for each separately."

 

Because "user" is not financial, but a Clerical Control, aspect.

 

You want to Enable Class in the accounting preferences. You want to set up three classes: one for each of the two doctors, and one "Admin" class, typically.

 

Class = Divisional or Departmental reporting of allocated amounts.

 

Please see my attachment.

February 23, 2022

I am looking for the same thing as well. I want to make user specific reports where they can only see their own data. It's strange that I can add "last modified by" but then can't filter by that.

Moderator
February 23, 2022

Hi there, @daraatdykehouse.


I’ve seen that you’ve posted twice on the Community page. My colleague JasroV already addressed this concern for you. You can visit this link to view his recommendation: https://quickbooks.intuit.com/learn-support/en-us/account-management/re-menu-reports-accountant-taxes-audit-trail/01/1042138#M57957.


If you need resources, video tutorials, and tips to manage your company, feel free to visit our Support page.


Please don’t hesitate to reach out again if you have any other concerns or questions about reports. We’ll be here to help. Keep safe!