Daily Payments Report

Run the Daily Payments Report to see a breakdown of payments in a date range.

In Standard Reports, in the Daily section, click Payments.

The Daily Payments report is a list of all Patient Payments and Claim Payments.

To control user access to this report, see Report Setup: Security Permissions.

Filters

Set the report criteria and filters before running the report.

Calendar: In the first calendar select the start date. In the second calendar select the end date.

Providers: Select providers with attached payments to include. Ctrl + click to select multiple providers, or check All to include all providers, including those marked Hidden on Reports.

Clinics: Select clinics with attached payments to include in the report. Ctrl + click to select multiple clinics or check All (Includes hidden) to include all clinics, including those marked hidden.

Group By: Select how payments are grouped. Payments are always split by clinic if paysplits exist for multiple clinics.

Include hidden treatment planned prepayments: Determines whether treatment planned prepayments (i.e., hidden splits) are included on the report. The default for this setting can be set in Report Setup: Misc Settings.

Show online patient payments separately: Determines if Online Payments are grouped separately from other Patient Payments.

Show CareCredit fees: Check to display a column or additional row and totals for CareCredit merchant fees.

Show PayConnect fees: Check to display a column or additional row and totals for PayConnect merchant fees.

All insurance payment types: Uncheck to only select certain insurance payment types. Ctrl + click to select multiple items. When checked, includes all Insurance Payment Types.

All patient payment types: Uncheck to select only specific Patient Payment Types to include. When checked, hidden payment types and income transfers are included in the report.

Note: Income transfers list as a patient payment type. When running the report for specific providers, it is possible not all splits for an income transfer show. To see the full income transfer, all providers associated with the transaction must be selected.

All Claim Payment Groups: Applies to insurance payments only. Uncheck to select only specific Claim Payment Groups. When checked, includes all Claim Payment Groups, including those marked hidden. See Finalizing Insurance Payments to assign claim payment groups.

Report Preview

Click OK to generate the report. Below is an example of the report and explanation of the report columns. For a description of toolbar buttons, see Complex Report System

The Daily Payments report groups insurance payments and patient payments separately. Within those groups, payments are further grouped by Payment Type (e.g., check, credit card, etc).

Note: CareCredit Fees and PayConnect Fees are displayed on their own row, separate from the payment details.

Payment amounts are totaled at the end of the report and separately for insurance payments and patient payments. Each payment type includes subtotals below the grid. Below is additional information on how some totals are calculated.