Salesforce

The Day Sheet Report

« Go Back
Article Info
000005023
How to run a Day Sheet & how to understand the MTD & YTD figures included on the report.
Solution

For more information on scheduling this report/task to run automatically in Dentrix G6.5 and higher, see article 86271.  

 


 

 

How To Run The Day Sheet:

1. Open

      For Dentrix: Office Manager Reports Management Day Sheet

      For Easy Dental: Open Reports. Click Management Reports Day Sheet (Charges and Receipts). 


- There is also a toolbar button that resembles a report with a sun on it that will accomplish this.

 

 

2. Select the desired options (date range, provider range, billing type range, procedure date, entry date, and what totals to include on the report.)


2.1. To generate the Day Sheet for a particular day in the past: In the Select Date, From and To fields, enter the same date from the past or enter a range.


NOTE: The date to the left in the Batch Processor is not necessarily the date that was entered in the Day sheet.

3. Click OK to send the Day Sheet to the Batch Processor.

 

4. From the Batch Processor, either Print or Print Preview the Day Sheet.

 

TIP:
To be able to tell at a glance how a Day Sheet was run, check the Date column(s). If there are two sets of dates then the Day Sheet was run by Entry Date. If there is only one date column the Day Sheet was run by Procedure Date.

 


Understanding the Calculations Used For MTD & YTD Totals:

1. Entry Date and Procedure Date.


1.1. As each transaction is entered on an account and the Chart, two dates are stored with it.

1.2. Both dates default to the current system date.

1.3. The date that is not displayed anywhere and cannot be changed is called the Entry Date.

1.4. The date that can be modified by the user is called the Procedure Date.

1.5. Normally these two dates are the same; however, if the Procedure Date is changed by the user at any time (before the transaction is placed in History), the two dates will be different.

1.6. Procedure Date:

1.6.1. The date shown everywhere a transaction is displayed or printed (unless there is an option on a report for Entry Date or Procedure Date).

1.6.2. The Procedure Date is used for insurance claims, aging, billing statements, finance charge calculations, etc. -- everything visible from a patient's standpoint.

1.7. Entry Date:

1.7.1. Used to keep the practice totals -- the figures displayed from Practice Analysis.

1.7.2. This philosophy is following true accounting principles.

1.7.3. The practice totals are stored by provider by month.

1.7.4. During the current month the totals are accrued.

1.7.5. When the month is closed, all transactions entered for the month being closed are totaled by entry date and placed in History.

1.7.6. Once a month is closed the totals for the month will not change under normal circumstances because the transactions used for the totals can not be edited.

1.7.7. This is why transactions entered for a previous month are stored with the month during which they are entered.

1.7.8. The option to store totals by procedure date is not available because the procedure date can be changed and may affect previous month?s totals, which violates the integrity of accounting principles.

1.8. For reporting purposes, the Day Sheet, Procedure Summary, Payment Summary and Adjustment Summary all give an option to print by either Procedure Date or Entry Date. If the two dates are always within the same month, the monthly reports will be the same with either option.

1.9. The Entry Date Day Sheet prints a column for the Entry Date and another for the Procedure Date.

1.10. The Procedure Date Day Sheet prints only a column for the Procedure Date.

1.11. It is recommended that an Entry Date Day Sheet be printed daily so that the transaction dates can be verified if they are being changed.

1.11.1. It has been found that when users are entering different dates, typographical errors for the month or year occur.

1.11.2. In this case the transaction does not show on the Procedure Date Day Sheet.

1.11.3. The Entry Date Day Sheet shows every transaction entered that day.

1.11.4. If there are any transactions with a different Procedure Date, an additional Day Sheet for each day affected can be printed by Procedure Date.

2. Day Sheet Totals.

2.1. There are four columns of totals available at the bottom of the Day Sheet.

2.2. The Current column prints on every Day Sheet and is calculated from the transactions printed.

2.3. If the Day Sheet is printed for 'Today,' without the Include Extended MTD Totals option selected,

2.3.1. The totals for the MTD column are read directly from the Current MTD totals record that is used for Practice Analysis (this greatly increases the speed of the Day Sheet for a large practice at the end of a month).

2.3.2. In this case the MTD column is by Entry Date whether or not the Day Sheet is printed by Procedure Date.

2.4. When the MTD column is not read directly from Analysis totals (when the Day Sheet is printed for a previous day or when the Include Extended MTD Totals option is selected), the MTD totals are calculated by reading the transactions from the procedure log.

2.5. To always get the MTD column on the Procedure Date Day Sheet by Procedure Date, the Include Extended MTD Totals option must be selected, or the Day Sheet must be printed for a previous day.

2.6. If the Day Sheet is not generated for 'Today,' the Extended MTD Totals are included for the MTD column, whether or not the option is selected, as long as the MTD column is included.

2.7. The Year-to-Date and Previous Month columns are only available when the Day Sheet is printed by Entry Date (and a Billing Type range is not used). These totals are read directly from the totals records that have been stored for Practice Analysis.

Article Properties
The Day Sheet Report
14333

Powered by