User Productivity Report to Excel

With the User Productivity Report to Excel function, you can print a report to Excel that includes a variety of productivity results for each User Code for a specified date or date range that users performed the activities. Every column on the report is based on the Activity Date, which is the date the user actually did the work.



Data Field Information
Prompt Response Req Len
Begin with User Code Type the code you want to begin with, click the magnifying glass to search the table or leave the field blank to start with the first code in the table.   8
End with User Code Type the code you want to end with, click the magnifying glass to search the table or leave the field blank to end with the last code in the table.   8
Begin with Activity Date Type the date you want the report to start with or click the calendar icon to select a date. Every column on the report is based on the Activity Date, which is the date the user performed the activity.   10
End with Activity Date Type the date you want the report to end with or click the calendar icon to select a date. Every column on the report is based on the Activity Date, which is the date the user performed the activity.   10

The report prints to Microsoft Excel via MyReports, so you can perform additional sorting as needed within Microsoft Excel. You can retrieve the report from MyReports. For additional information about Microsoft Excel via MyReports, see Printing in CGM webPRACTICE.

Sample Excel Report

Columns A through N



Columns O through AA



Columns AB through AN



Columns AO through AV



Definition of Report Columns
The encounter and charge columns are grouped into three sets that add up:

Column Name Column Definition
Date Date of Activity
User Code User Code of the employee that performed the actions
Pts Registered Count of patient accounts registered by this user
Pt Accts Edited/Inactivated Count of patient accounts Edited or Inactivated by this user. Note: if you edit a single patient account on three separate occasions on a date, it will only count as a single patient account that was edited.
Pt Appts Scheduled Count of patient appointments scheduled by this user
Pt Appts Rescheduled Count of patient appointments rescheduled by this user
Pt Appts Deleted Count of patient appointments deleted by this user
# of Superbills Posted Count of individual superbills posted by user. If you post all of the encounter charges using superbills, this column should match the Total # of Encounters Posted column because each superbill should be a complete encounter.
Total Trans Posted Count of all transactions posted by user. Sum of Total # of Chgs Posted, # of Pmts Posted, # of Credit Adjs Posted & # of Debit Adjs Posted.
Total # of Encounters Posted Count of individual encounters posted by user. Note: Each encounter can contain multiple charges and this column will most likely not match the Total # of Chgs Posted.
Total # of Chgs Posted Count of individual charges posted by user.
Total Chgs Posted $ Total amount of charges posted by user.
Proc Entry-# of Encounters Posted Count of individual encounters posted by user entered directly through Procedure Entry.
Proc Entry-# of Chgs Posted Count of individual charges posted by user entered directly through Procedure Entry.
Proc Entry-Total Chgs Posted $ Total amount of charges posted by user entered directly through Procedure Entry.
Unposted Proc-# of Encounters Stored Number of encounters that were 'Stored' as unposted procedures by the user, on the date stored. Encounters loaded and stored automatically by an interface are not counted.
Unposted Proc-# of Encounters Posted Number of 'Encounters' that were 'Stored' as unposted procedures and then 'Posted'.
Unposted Proc-# of Chgs Stored Number of individual procedures that were 'Stored' in unposted procedures by the user, on the date stored. Interface auto-stores are not counted.
Unposted Proc-# of Chgs Posted Number of individual charges that were 'Stored' as unposted procedures and then 'Posted'.
Unposted Proc-Total Chgs Posted $ Total amount of charges stored into Unposted Procedures by a user, on the date stored, credited to the user who stored them. Interface auto-stores are not counted.
# of Trans Edited Count of individual transactions edited by user.
# of Trans Reversed Count of individual transactions reversed by user.
Total Trans Reversed $ Total amount of individual transactions reversed by user, credited to the user who performed the reversal on the date they performed it - not the user or date of the original transaction.
# of Chgs Negated Count of individual charges negated by user.
Total Chgs Negated $ Total amount of individual transactions negated by user, credited to the user who performed the negate on the date they performed it - not the user or date of the original transaction.
Total # of Chgs Pended The number of charges the user pended, holding them on the insurance aging reports. Every pend is counted on the date it was performed, whether or not the charge is still pended today. A charge that is pended, unpended and pended again counts twice.
# of Chgs Unpended The number of charges the user unpended, reversing an earlier pend. Unpends are reported in their own column and are not subtracted from the pended count, so neither column hides the other's work.
# of Denials Pended The number of charges the user pended immediately after that same charge was denied by the same insurance carrier. This is a subset of Total # of Chgs Pended and can never be larger than it.
# of Pmts Posted Count of individual payments posted by user. Sum of # of Ins Pmts Posted, # of Co-Pay Pmts Posted & # of Other Pmts Posted.
Total Pmts Posted $ Total amount of all payments posted by user. Sum of Total Ins Pmts Posted $, Total Co-Pay Pmts Posted $ & Total Other Pmts Posted $.
Pmts-Total # Manually Posted Number of payments posted manually. This column excludes payments posted automatically from an ERA, so it and the Pmts-Total # ERA Auto-Posted column add up to the # of Pmts Posted.
Pmts-Total # ERA Auto-Posted Number of payments automatically posted from ERA files.
# of Ins Pmts Posted Count of individual insurance payments posted by user.
Total Ins Pmts Posted $ Total amount of insurance payments posted by user.
# of Co-Pay Pmts Posted Count of individual co-pay payments posted by user.
Total Co-Pay Pmts Posted $ Total amount of co-pay payments posted by user.
# of Other Pmts Posted Count of individual payments posted by user that do not fall into the insurance or co-payment categories.
Total Other Pmts Posted $ Total amount of other payments posted by user that do not fall into the insurance or co-payment categories.
# of Credit Adjs Posted Count of individual credit adjustments posted by user.
Total of Credit Adjs Posted $ Total amount of credit adjustments posted by user.
# of Debit Adjs Posted Count of individual debit adjustments posted by user.
Total of Debit Adjs Posted $ Total amount of debit adjustments posted by user.
NOTES-# Entered Number of DMS Notes entered.
INOTES-# Entered Number of DMS Insurance Notes entered.
Refiles-# of Claims Number of claims refiled. A claim is counted on the day it was actually sent or printed.
Refiles-# of Charges Number of individual procedure codes refiled. A charge is counted on the day its claim was actually sent or printed.
Claims Submitted-# of Electronic Number of claims submitted electronically. A claim is counted on the day it was actually sent, not when it was created.
Claims Printed-# of Paper Number of paper claims printed. A claim is counted on the day it was actually printed, not when it was created.

Notes