Gross Receipts Report

The Gross Receipts report gives you information regarding all payments entered for a selected time period, whether they are applied or unapplied.

This documentation contains the following sections:

Filter Options

Since this is a relatively simple report, there are only a few filters available:

 

Select Providers/Offices: Allows you to filter the report by provider and/or office references. For applied payments, this will filter based on the provider/office selected in the charge screen, as shown below:

For unapplied payments and refunds, the provider and office are filtered based on the provider listed in the payment window:

Screen_Shot_2017-05-01_at_11.57.00_AM.png

If you run the Gross Receipts report with all providers included, it should match the deposits listed on the Posted/Procedure Date Day sheet or Procedure/Posted Date by Month assuming both reports use the same date range. If the report is filtered to show only selected providers, there will be discrepancies because the deposit information is based solely on the provider/office listed for the payment.

Screen_Shot_2017-05-01_at_11.59.35_AM.png

Start/End Date: You can filter the report to show only payments associated with a given date range.

Posted/Procedure Date: The Posted/Procedure Date radio buttons determine which date the start and end date fields will use to filter the report. The procedure date is entered in the Payment window and can be edited. The posted date is the date the payment was entered into the computer and cannot be edited. You can choose which filter to use by selecting the appropriate button.

After choosing your filters, click the Apply button to see your results.

Results Columns

The Gross Receipts report's results are broken down into two sections: Receipts by Payment Type, and Receipts by Provider.

Receipts by Payment Type

Unexpanded

The first section of the Gross Receipts report breaks down the payments by payment type. This section allows you to expand individual Payment Types to parse more detailed information.

  • Type: This column simply lists the payment type, as entered in References > Payment Type. This area will only list types that were associated to a payment during the selected date range.

  • Unapplied: This lists the amount of payments received during the time period that are not applied to charges.

  • Applied: The Applied column lists the amount of payments received during the selected period that have been applied to charges.

  • Refund: This column lists the amount of payments received during the selected date range that have been refunded. This column is based on the payment date, not the refund date. If a payment was received in January and refunded in March, it would show in the Refund column of the Gross Receipts report in January. This report also shows all refunds issued, including reversals and refunds of insurance payments to provider or patient. If you wish to view refunds by the refund date, use the Refunds report.

  • Total: The Total column lists the total money received of that payment type during the date range, regardless of applied/unapplied status. This number should equal the sum of the Unapplied, Applied and Refund columns.

  • % Total Receipts: This column shows the percentage of total receipts that are associated to the payment type, and also displays the information in bar graph form. This can be very helpful for determining where the majority of your office's payments come from, at a glance.

You can click the triangle next to any of the payment types to see a list of specific payments included on the report.

Expanded

You can use the expanded view of the Gross Receipts report to view which accounts made payments during the selected time period. This can also be helpful in auditing the report.

  • Primary Name: The first column lists the name listed in the Primary tab of the patient's account.

  • Reference: The Reference column lists the reference number entered in the payment screen, if applicable.

  • Posted Date: This lists the date the payment was entered into the computer. If you selected the Procedure Date radio button for the start and end date, this date may fall outside your specified range.

  • Total: This column lists the total amount of the payment.

  • Applied: This lists the amount of the payment that has been applied to charges.

  • Unapplied: The Unapplied column lists the amount of the payment that has not yet been put towards charges.

  • Refund: The final column lists the amount of the payment that has been refunded, if any. This report also shows all refunds issued, including reversals and refunds of insurance payments to provider or patient.

Below the breakdown by payment type, you will see the Gross Receipts by Provider section.

Receipts by Provider

At the bottom of the Gross Receipts report, you will see your receipts broken down by provider.

  • Provider: This column lists the providers' first and last names, as listed in References > Users.

  • Unapplied: This lists the amount of payments received during the time period that are not applied to charges.

  • Applied: The Applied column lists the amount of payments received during the selected period that have been applied to charges.

  • Refund: This column lists the amount of payments received during the selected date range that have been refunded. This column is based on the payment date, not the refund date. If a payment was received in January and refunded in March, it would show in the Refund column of the Gross Receipts report in January. This report also shows all refunds issued, including reversals and refunds of insurance payments to provider or patient. If you wish to view refunds by the refund date, use the Refunds report.

  • Total: The Total column lists total money received of that payment type during the date range, regardless of applied/unapplied status. This number should equal the sum of the Unapplied, Applied and Refund columns.

  • % Total Receipts: This column shows the percentage of total receipts that are associated to the payment type, and also displays the information in bar graph form.

Â