The Earned Receipts report displays payments applied to procedures performed by the selected Provider(s). It is located in the Accounting/Financial Folder of the Reports Ability.

This report contains the following sections:

Filter Options

This report is based on the date the payment was applied to a charge. It does not take into account any unapplied amounts, and does not take into account the payment's Posted or Procedure Date.

You can view the date a payment was applied in the far right of the payment window:

This is the best report to show what the providers have earned. Like all MacPractice reports you have a variety of filters that can be selected. Uncheck the checkbox next to any set of filters to disable it.

Open

Open

• Select Providers/Select Offices: These filters, when enabled, show only payments applied to procedures associated with the selected providers or offices.

• Select Procedures: Use this filter to show only receipts applied to the selected procedures.

• Start/End Date: The start/end date filters can be used to show only payments applied during the selected date range.

• Additional Options: You can select a number of additional options to display in the Account view of the report.

You can run the report to detail receipts by account, provider, or both. When you are done selecting your filters, click Apply to see your results, which will differ depending on whether it’s by Account or by Provider.

Earned Receipts By Account Results

Unexpanded

Open

• Account: The first column displays the account number where the payment was applied.

• Primary Last, First: The second column shows the name in the Primary tab of the account.

• Earned: The final column reflects the total amount of applied payments.

First Expansion

Open

• Payment: The first column of the expanded view lists the payment type, such Check, Cash, Card, Insurance, and so on.

• Posted Date: The next column displays the date the payment was posted.

• Total Payment: The third column lists the total amount of the payment.

• Applied to Matching Charges: The final column shows the amount of the payment that was applied to charges that match your report criteria.

Second Expansion

Open

• Patient ID: Shows the specific patient ID number for the patient the charge was entered under.

• Procedure Code: Procedure code the payment was applied towards.

• Code Modifier: Modifier that was listed on the charge, if any.

• Procedure Date: The Procedure Date of the charge.

• Fee: The total fee for the charge.

• Tax: Lists the tax charged for the procedure, if applicable.

• Payment Applied: The amount of the selected payment that was applied towards the charge.

• WriteOff: The amount of any write-offs posted towards the procedure.

• Open Portion: The unpaid balance on the charge.

• Date Applied: The date the payment was applied to the charge.

• Provider: The User ID of the provider listed on the charge.

• Place Of Service Code: The place of service listed on the charge.

Earned Receipts By Provider Results

The Earned Receipts by Provider report is simpler than the Earned Receipts by Account. This report has only four columns.

Open

Open

• Provider: The first column displays the provider associated with the charge the payments are applied to. Any user that has the Is Providercheckbox set in References > Users will be shown in this list.

• Applied: The second column shows the amount of money that has been applied to procedures during the date range. This amount does not look at the posted or procedure date of the payment.

• Previously Applied Adjustment: This column displays the amount that this provider's applied payments have been adjusted prior to the date range of this report. The primary purpose is to indicate how a provider's Net Earned column has been impacted by changes outside of the date range.
  Previously Applied Adjustments can be shown if the charge has been assigned to a different provider after a payment has been applied. They can also be shown if the payment's applied amount has been unapplied then applied to a different provider's charge.

  Let's use an example to illustrate this: 
  A payment of 75.00 was applied to a charge that was assigned to Provider A. 
  Later, it is determined that the charge should have been assigned to Provider B, and you change  the provider assigned to Provider B.
  In this situation, the Previously Applied Adjustment would reflect -75.00 as that payment no longer is assigned to Provider A. 

  Here's a second example:
  Provider KS is assigned to a charge, and a payment of 75.00 was applied to this charge prior to April 2017.  
  Upon reviewing the ledger, it was determined that the payment should have only had 40.00 applied to this charge, and the remaining 35.00 was to be applied to a different charge, under a different provider. In this scenario, you adjust how the payment is applied on 04/25/2017.

  In this screenshot, we can see that the Previously Applied Adjustment column for Provider KS is -75.00, because we have unapplied the original payment prior to the date range of the report. In the expanded results, we can see two line items. The first line item is to unapply the old payment, and the second line indicates the corrected amount applied.

• Net Earned: The final column displays the total of the Applied and Previously Applied columns. If the Previously Applied Adjustment is negative, it will be subtracted from the Applied column for the Net Earned figure.

The 'Total' line will list all providers is listed in the report and a total of each column.