Understanding the day sheet
These tables explain the details and totals on the day sheet.
Transaction Details (Location)
The following table describes which details appear for each transaction in a given location.
|
Detail |
Description |
|---|---|
|
Transaction Date |
Date entered for the transaction (Note: Transaction date may be different from modified date) |
|
Modified Date |
Date the transaction was created (initially entered into the system) or modified (Note: Transaction date may be different from modified date) |
|
Patient Name |
Patient's name |
|
Code |
Procedure code, payment, or adjustment |
|
Description |
Procedure code, payment, or adjustment description As applicable for a procedure, the tooth number and treated surface |
|
Charges |
Charges and charge adjustments |
|
Credits |
Credit adjustments, insurance payments, and patient payments |
|
Prov |
Provider's ID (Note: For charges and charge adjustments only) |
|
Total |
Total Credits and total Charges (Note: If the selected Report Type is Payments Only, and you are filtering the report by payment tags, only the Location Details table is affected, so the Total line may not match the Applied Payment and Unapplied Payment lines of the Location Totals table.) |
Transaction Totals (Location, Organization, and Provider)
The following table describes which totals appear for a given location, organization, or provider.
|
Total |
Description |
|---|---|
|
Current |
From the beginning to the ending date of the specified date range |
|
Month-To-Date |
From the first day of the calendar month that the ending date of the specified date range is in up to the ending date of the specified date range. |
|
Year-To-Date |
From the first day of the calendar year that the ending date of the specified date range is in up to the ending date of the specified date range |
|
Previous Month |
From the first to the last day of the month prior to the calendar month that the ending date of the specified date range is in |
The following table describes how the totals are calculated for a given location, organization, or provider.
|
Calculation |
Description |
|---|---|
|
Procedure Charges |
Total amount of the charges for all completed procedures (Note: Does not include charge adjustments) |
|
Entered Payments |
Total amount of all payments entered from this location |
|
Applied Payments |
Total amount of all payments from this location that are applied to charges from the organization (Note: This is based on the transaction date of the charges) |
|
Unapplied Payments |
Total amount of all payments from this location that are not applied to charges from any location (Note: For organization and location totals only) |
|
Entered Credit Adjustments |
Total amount of all credit adjustments entered from this location |
|
Applied Credit Adjustments |
Total amount of all credit adjustments from this location that are applied to charges from the organization (Note: This is based on the transaction date of the charges) |
|
Unapplied Credit Adjustments |
Total amount of all credit adjustments from this location that are not applied to charges from any location (Note: For organization and location totals only) |
|
Charge Adjustments |
Total amount of all charge adjustments |
|
Charges Billed to Insurance |
Total amount of the charges for all procedures from this location that are associated with insurance claims (Note: On the custom day sheet, this amount includes only charges that are associated with claims that have been sent or printed) |
|
Estimated Insurance Write-offs |
Total amount of all estimated insurance write-off adjustments (Estimated Insurance Write-off = Charge - PPO Fee) (Note: Calculated, based on primary insurance plans only, for patients with a primary insurance plan) |
|
Estimated Net Production |
Charges - Applied Credit Adjustments (production types only) - Estimated Insurance Write-offs (Notes: Calculated, based on primary insurance plans only, for patients with a primary insurance plan; calculated based on service dates, whereas the other calculations for this report are based on transaction dates, so the applied credit adjustments, based on the service dates of the procedures on the report, usually do not match the Applied Credit Adjustments on the report; and there is no way to match the value for this measure by looking at other values on the report) |
|
New Patients |
Total number of new patients (Note: Determined by the First Visit Date in the patient's record and the location where services were rendered) |
|
Patients Seen |
Total number of unique patients with a completed procedure from this location. (Note: Determined by the Preferred Location in the patient's record; for provider totals, determined by the Primary Provider in the patient's record) |
|
Average Production Per Patient |
Charges divided by Patients Seen |
|
Average Charge Per Procedure |
Charges divided by the number of completed procedures |
|
Previous Balance |
For the date prior to the beginning date of the specified date range, Charges + Charge Adjustments - Applied Payments - Applied Credit adjustments - Unapplied Payments - Unapplied Credit Adjustments |
|
Balance as of mm/dd/yyyy |
Previous Balance + (for the ending date of the specified date range, Charges + Charge adjustments - Applied Payments - Applied Credit Adjustments - Unapplied Payments - Unapplied Credit Adjustments) |
|
Net Change |
Balance as of mm/dd/yyyy - Previous Balance |