Day Sheet Report

Day Sheet Report

Day Sheet

Print a Day Sheet on a daily basis to maintain a permanent record of the transaction activity for the practice. A Day Sheet includes a transaction detail, charge summary, credit summary, and optional deposit sheet. 

Day Sheet – Information Included

A Day Sheet includes a transaction detail, charge summary, credit summary, and optional deposit sheet.

Transaction Detail

  • Transactions: chart numbers, date of transaction, provider code who performed the service, place of service, billing number, diagnosis code, and the amount

  • Totals: charges, debit adjustments, patient payments, insurance payments, credit adjustments, managed care charges, and managed care payments

  • Provider balances by location

  • Total provider balances

  • Report Balance

Charge Summary

  • Charges: transactions, descriptions, amount, percent total, and count
  • Breakdown of amount produced per provider

  • Breakdown of amount produced per location

  • Report totals

Credit Summary

  • Credits: transactions (payment codes used), descriptions, amounts, percent total, and count

  • Breakdown of credits received per provider

  • Breakdown of credits received per location

  • Report totals

Accounting Summary

  • Previous accounts receivable
  • Totals: charges, credits, adjustments, and new accounts receivable

Bank Deposit Sheet (optional)

  • Payments received: date, reference, description, and amount
  • Totals: checks, cash, deposit
Notes
NOTE:  We recommend that you leave the ranges blank and print a Day Sheet daily to keep an accurate record of the transactions entered. Leave ranges blank to print all transactions.
WarningOnce a Day Sheet for a specific period has been printed and closed, the Day Sheet cannot be printed for that period again (if the Close After Printing check box is checked). This information can be printed again with the Transaction Journal Report.
Notes
NOTE: The report differentiates between prepayments received (entered on the patient’s record) and prepayment offsets (applied to a charge). The prepayment offset counterbalances the application of the payment.

To print this report, click Reports and click Day Sheet.  The Print Day Sheet window opens.

Buttons

Change to: Multi-Select or Change to: From - To: Select the Change to: Multi-Select button to use Multi-Select filtering for filtering ranges on the report. Multi-Select filtering replaces the standard From/To ranges parameters on a report with one field in which you supply your own filtering criteria by using the SHIFT key to select a beginning and ending ranges and the CTRL key to select multiple values not in consecutive order. Select the Change to: From -To button to use standard From/To filtering on report.
Notes
NOTE: Even when selected, most reports on which Multi-select is available rely on a combination of standard To/From ranges and Multi-select filtering.

Day Sheet – Options Tab

Select options to designate what prints in the report.

Options

Subtotal by Provider: Click this option to include an individual subtotal for each provider in the practice. When Subtotal by Provider is checked, the Subtotal by Location field becomes active.
Subtotal by Location: Click this option to include a subtotal for each provider’s location. 
Print Bank Deposit Sheet: Click this option to print a bank deposit sheet along with the Day Sheet.
Close After Printing: This option will close the transactions after printing. When you check this option, the Day Sheet will not reprint any transactions that print in the report. Uncheck this option to print a Day Sheet more than once.
Include YTD and MTD: Select the Include YTD and MTD box to display month-to-date and year-to-date data for the current fiscal year. The system uses the month displayed in the Year-to-Date Starting list on this tab for determining the beginning of the financial year; you can modify this setting before running the report or set a default value on the Preferences Year-to-Date Tab for reporting. If you do not select a specific date range on the Ranges tab, the month-to-date value is based on the first day of the current month and the current day while the year-to-date would include up to twelve months of data depending on when your financial year begins. If you do enter a narrower range of dates, the results of the report use these filter dates for the start and end dates for the month-to-date and year-to-date.

This information is displayed on the report in a column for year-to-date data, month-to-date data, and also another column that captures data through today's date.  These totals display for each of the sub-sections of the report.

If you select this option, you can also then select to define if the system uses the Entry Date or Date of Service for running the report.

Year-to-Date Starting

Entry Date: Select the Entry Date button to filter data based on the date the service was entered in CGM LYTEC for reporting.
For more information on setting a default filtering value for this field, see the topic Preferences Year-to-Date Tab.

Date of Service: Select the Date of Service button  to filter based on the actual date the service was rendered for reporting.

For more information on setting a default filtering value for this field, see the topic Preferences Year-to-Date Tab.

Month: From the list, select the month in which your financial year starts. The default value is January. If you select a fiscal month that occurs after the current calendar month, the report uses the month from the previous year as the fiscal year start date for filter date (for instance, if you run the report on September 1 but select a fiscal year starting in October, the data displayed range would start in October of the previous calendar year.

For more information on setting a default filtering value for this field, see the topic Preferences Year-to-Date Tab.

Reference

This reference is the same reference available in Apply Insurance Payments and Managed Care Payments. It is also taken from the Note section in the More Detail window of Charges and Payments. Generally, it is used for the check number for that specific payment.
Do Not Print References: Choose this option to exclude references in the report.

Print all References: Choose this option to print all references from the Apply Insurance Payments, Managed Care Payments, and the Note field in the More Detail window from Charges and Payments.

Only Print Lines with This Reference: Choose a reference number to include only transactions with this reference number on the printed Day Sheet. Then enter the reference number or characters.

Sort By

To sort Day Sheets in a specific order, select one of the following options.
Patient Chart: This option is selected by default. It will print billings in the order of their chart numbers.

Patient Name: Choose this option to print billings by the patient name.

Billing Number: Choose this option to print billings in the order of their billing numbers.

Billing Created Date: Choose this option to print billings by the date they were created.

Service Date: Choose this option to print billings in the order of the service date for each billing.

Entry Date/Time: Choose this option to sort the transactions in the day sheet by the date and time that they were entered.

Day Sheet – Ranges Tab

Fill out the ranges to designate what prints in the report.

Users: Enter a range of user profiles to restrict the Day Sheet to the financial activities performed by the selected users.

Patients: Enter a range of patients to be included in the Day Sheet.

Billing Numbers: Enter a range of billing numbers to be included in the Day Sheet.

Billing Created Dates: Enter a range of billing created dates to include billings created on those dates in the Day Sheet.

Entry Date: Select the Entry Date button to filter data based on the date the service was entered in CGM LYTEC for reporting.

Date of Service: Select the Date of Service button  to filter based on the actual date the service was rendered for reporting.

Managed Care Payment Numbers: Enter a range of managed care payment numbers to include those payments on the Day Sheet.

Managed Care Payment Dates: Enter a range of managed care payment dates to include payments assigned to those dates in the Day Sheet.

Patient Codes: Enter a range of patient codes to be included in the Day Sheet.

Patient Types: Enter a range of patient types to be included in the Day Sheet.

Providers: Enter a range of providers to be included in the Day Sheet.

Insurance Companies: Enter a range of insurance companies to be included in the Day Sheet.

Billing Status Codes: Select a range of bill status codes to include in the report. Billing status codes are assigned to a specific billing or to a patient's record. Billing status codes are created on the Billing Status Codes window or from the Billing Status Codes Lookup Window.