The Daily Journal report is used to see the daily productions and collections. The report can be used to compare the codes that have been completed for the day and receipts that have been added for the day. The report gives the user a comprehensive idea of the daily transactions and diverts attention to potential areas that the practice loses money on.
This report shows real-time data and is available in two views: Summary and Detail View.
All dates are based on the transaction date.
Competitor Reports
- Day sheet (Dentrix)
- Day sheet (Eaglesoft)
- Daily Production, Income Report, Custom Daysheet Report (query example) (Open Dental)
Use Cases
- Review a summary of your practice’s daily operations.
- Reconcile production and collection.
Let's get started!
- Navigate to the System Menu > select Operational Reports under Insights.
- Click the + icon on the left or the Generate Report button on the right for the chosen report.
Explore below to learn more about the desired views, filter criteria, and results.
The summary view shows the consolidated total production and collection for the date range selected. It consists of the payment summary which shows the unapplied payments in the selected date range, the applied payments in the selected date range, and the applied payments in the selected date range from receipts that were added prior to the selected date range. The user can also see the total applied payments from the payment summary. The user also has the flexibility to see the daily collection and production grouped by either provider or location.
Let's explore the filters:
| No | Filters | Description |
|---|---|---|
| 1 | Group By* |
Choose whether to group your report results by Provider or Location. The location specified will be the treatment location for the completed codes and the receipt location for all the receipts that have been added to the system. *By default, Provider will be selected. |
| 2 | Date Range (Max 3 months)* |
The date range can be selected for a maximum of 3 months. *By default, Today is selected. |
| 3 | Provider | Select this option to focus your report based on the selected treatment provider(s). |
| 4 | Location* |
Select the location(s) to focus the report on the treatment location(s). *By default, the location will be the user’s default location. |
| 5 | Exclude Membership Discount Credits | Select this option to exclude Membership Discount Credits from this report. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 5 Treatment Locations and a date range exceeding 14 Days will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result - Summary View
Now, let's take a look at the results of the Daily Journal (Summary View).
The report provides information in column form grouped by either provider or location.
The first section of the summary view contains the consolidated total of all productions and collections of all the selected locations. The first section shows the UCR Fee, Pat. amount and Ins. Amount and Total Amount of the following.
- Completed Codes: The codes that have been completed in the selected date range in the selected location.
- Fee Updates: The fee updates that have been made for the completed codes. If the total fee for an update made in the selected date range is less than the total estimated fee then the amount will be displayed in red color inside closed brackets.
- Deleted Codes: The amount of balances removed when these procedure codes were deleted from the system. The amount will be displayed in red color inside closed brackets.
- Production Adjustments: The amount of production adjustments made against an outstanding balance, either to increase or decrease the amount of production generated. If the total Adjustment is a negative amount then the amount will be displayed in red color inside closed brackets.
- Migrated Production: The total migrated production from the practice's previous software.
- Total (Net Production): The amount of production generated plus/minus any production adjustments made.
The next section inside the consolidated grid shows the net collections from receipts in the selected date range.
- Receipts: The dollar amount of payments that have been accepted and entered into the system.
- Deleted Receipts: The dollar amount of payment receipts that have been deleted out of the system. The amount will be displayed in red color inside closed brackets to indicate a negative transaction.
- Receipt Updates: The total dollar amount involved in receipts that were updated, in the instance that the payment amount on an insurance receipt is updated (for example, the receipt was made for $100, but then the receipt was updated to reflect a payment of $120). If the total receipt update is a negative amount then the amount will be displayed in red color inside closed brackets.
- Refunds: The dollar amount of payments that have been refunded to the payer. The amount will be displayed in red color inside closed brackets to indicate a negative transaction.
- NSF Receipts: The dollar amount of payment receipts that have been marked as Non-Sufficient Funds. The amount will be displayed in red color inside closed brackets. Even if the NSF is reversed the amount in the check that was marked as NSF will still be displayed here.
- Reverse NSF Receipts: The total dollar amount involved in receipts that were reversed due to insufficient funds.
- Collection Adjustments: The dollar amount of collection adjustments made against an outstanding balance, either to increase or decrease the receivable. If the total Adjustment made is a negative amount then the amount will be displayed in red color inside closed brackets.
- Over Payment Recovery: The dollar amount involved in overpayment recovery from insurance receipts.
- Total (Net Collection): The dollar amount of receivables collected after any collection adjustments are made.
- Transaction Charges: The transaction charges associated with payment types like care credit.
- Total: The total dollar amount of the transaction charges.
- Payment Summary: The payment summary sections inside the consolidated total show the applied payments and unapplied credits in the selected date range.
- Unapplied Payments (Current): The unapplied payments from receipts added within the selected date range.
- Applied Payments (Current): The credits applied to codes from receipts added within the selected date range.
- Applied Payments (Prior): The credits that have been applied to codes from receipts that have been added before the selected Date Range.
- Total Applied Payments: The total applied payments in the selected date range.
The next sections inside the summary view are Grouped by provider or location depending on the Group By option the user selects.
If the user chooses to group by provider then the section after the consolidated total will be the net productions and collections mentioned above for each provider. For each section of the provider, the net collection and production will be shown for each location and the provider total.
If the user chooses to group by location then after the consolidated total, the net production and collection will be shown for each location. For each section of the location, the net collection and production will be shown for each provider.
Click on the blue-colored entries to view more information on the corresponding entries.
The detailed view of the report will display the following columns.
| No | Filters | Description |
|---|---|---|
| 1 | Date Range (Max 3 months)* |
The date range can be selected for a maximum of 3 months. *By default, the date range will be Today. |
| 2 | Provider | Select this option to focus your report based on the selected treatment provider(s). |
| 3 | Location* |
Select the location(s) to focus the report on the treatment location(s). *By default, the location will be the user’s default location. |
| 4 | Action | Use this filter to specify the action of the transaction done (whether a code was completed or deleted, or the fee was updated, a payment was made or the receipt refunded, and so on). |
| 5 | User | Select this option to focus your report to display only on the transactions or completed codes or both, made by the selected user. |
| 6 | Patient Flag | Select the Patient Flag(s) to focus the report only on patients that have the patient flag(s) associated with the profile. |
| 7 | Patient | Select the patient(s) to focus the report only on the balances for the specific patient(s). |
| 8 | Group By* |
Choose to group by location, provider or patient. *By default, 'None' is selected. |
| 9 | Columns | Choose the columns you wish to see in this report. |
| 10 | Group By Action and Show Totals | Select this option to show the total UCR fee, Gross Production, Insurance Amount, Patient Amount, and Unapplied Amount grouped by each action. |
| 11 | Exclude Membership Discount Credits | Select this option to exclude Membership Discount Credits from this report |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 5 Treatment Locations or a date range exceeding 14 Days will not generate on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result - Detail View
Now, let's take a look at the results of the Daily Journal Report (Detail View).
- Trans. Date: The date the action was performed in the system.
- Patient Name: The name of the patient.
- Patient ID: The system-assigned number used to identify this patient and their records. On clicking on the Patient ID, the user is taken to the patient's ledger.
- D.O.S.: The date the patient was seen by their treatment provider for the completion of services.
- Deposit Date: The date the insurance payment was deposited into the office's account.
- Code-Description: The name and description of the procedure code.
- Tooth/Area: The tooth or area where the procedure code was performed.
- Surface: The surface of the tooth to which the procedure code applies.
- Location: The short name of the location associated with the code or receipt.
- Provider: The short name of the provider associated with the code or receipt.
- UCR Fee: The UCR fee of the procedure code is based on your office's standard fees, as configured in your practice settings.
- Amount: The amount associated with the transaction completed, or the total fee of the procedure code at the time of check-out.
- Ins. Amt: The insurance is payable at the time of code completion.
- Pat. Amt: The patient is payable at the time of code completion.
- Transaction Charges: The transaction charges associated with the payment.
- Payment Amount: The total amount paid (including the transaction charge).
- Action: The action performed by the user (e.g., code completed, deleted, fee updated, payment made, or receipt refunded).
- Payment Method: The method of payment used, such as Regular, Advanced, Payment Plan, Patient Portal, Payment Portal, or Capitation.
- Carrier: The insurance carrier linked to the payment, refund, or adjustment.
- Receipt #: The system-assigned number used to identify the payment entered into the system.
- Unapplied: The amount of the receipt that remains as unapplied credits.
- User's Name: The name of the user who completed the transaction in the system.
If users in your practice cannot use this report, please ensure that the relevant permissions are enabled.
To enable Permissions for the Daily Journal Report:
- Navigate to the System Menu > Practice Settings > Administration > Profiles.
- Click Manage Permissions for the intended profile.
- Select Insights.
- Select the Generate Daily Journal Report option under Operational Reports to enable the permission.
- Click Save.
- On the Confirm Action modal that appears, click Yes to proceed.
- A toast notification appears on the top right stating, 'Profile updated successfully'.
Practices can use this comprehensive guide to efficiently generate reports, explore various use cases, and apply the necessary filter criteria to generate the desired report. Following this guide will help you create reports quickly, understand the different views available, and customize reports to meet specific needs.
Click here to explore the complete list of permissions and their descriptions.