Q: How do I make a report showing how much was collected for each procedure code by provider regardless of charge date of service?  For instance, I need to know how much Dr A received during March for procedure code 99213.  I know I need to subtotal by provider and procedure code but I can't seem to find the right fields to get the desired results.  Most of your reports are based on the charge date of service.

A: The report needs to be based on the payment transactions in the transaction table with a link through the MWPAX table back to the charge transaction (to get the procedure code and the attending provider). The way to do this is outlined in the Focus Reports Developer Training CD included with Focus Reports Professional. Grouping the report by provider and procedure and filtering by date of payment is also covered in the training material. Focus Reports Technical Support is also available by calling (800) 752-3565.