Daily Register

With the Daily Register function, you can print a report that lists all the transactions entered into CGM webPRACTICE during a specified range of dates. It can be printed in either a detailed or summary format and a single sorting option can be selected.

This report can be used to generate a DMS List. To activate this function you will need to add the report to the DMS Report Integration function located on the System, Database Maintenance Menu. This report can also be printed from the Transaction Journals menu located on the Reports menu.

Data Field Information

Prompt	Response	Req	Len
Sort by	Select how you want the report sorted: Date, Performing Dr, Insurance Dr, Location Code, User Code, or Billing Group. You can only select one sort option.	Y
Print Patient Detail	If you want to print individual patient accounts, select this check box.		1
Sort Order	If you selected Print Patient Detail, select whether you want the patient detail sorted Alphabetic or Numeric.		1
Print Transaction Detail	If you selected Print Patient Detail and want to print the transaction detail, select this check box.		1
Print Applied to Transactions	If you selected Print Transaction Detail, select this check box to print the individual transactions that every payment and adjustment was allocated to and the amount allocated. The transaction detail and the amount allocated to each transaction prints directly below the original transaction line.		1
Description or Superbill #	If you selected Print Transaction Detail, select whether you want the charge description (Procedure Description) or the superbill number (Superbill #) to print.		1
Include Payment Breakdown	If you selected Print Transaction Detail and you print this report to Excel, select this check box to separate the payments into two columns for Ins Pmts and Pt Pmts. An Ins Carrier Type column is also included that indicates the carrier that made the insurance payment: P-primary, S-secondary, or T-tertiary.		1
Print By	Select Accounting Date to print the report by accounting date, or select Service Date to print the report by transaction service date. If you print with transaction detail, the Acct Date always prints in the first column and the Service Date in the second column, regardless of your selection; the appropriate column is sorted based on your selection.	Y
Print from Date	Type the date you want the report to start with or click the calendar icon to select a date.		10
Print through Date	Type the date you want the report to end with or click the calendar icon to select a date.		10
Include A/R Total	If you want to print the current accounts receivable total, select this check box.		1
Include MTD and YTD	If you want to print the month-to-date and year-to-date totals for the charges, payments and adjustments, select this check box.		1
Print from List	If you want to print this report based only on the patients contained in a previously defined DMS List, select the list you want to use. For example, if you want the report only for Medicare patients, you first create a list of all your Medicare patients, then print the daily register report and select the Medicare patient list you just created for 'Print from List'.		20
Batch Number	Type a batch number to print only the transactions within that batch, type '0' to print all non-batched transactions or leave blank to print all transactions.		17
Default Last Batch	If you want the last batch number (used by the current user, in the current database, for the current date) to default, select this check box. If you select this check box while in any function in the system that contains a Batch Number field and then you access a different function that contains a Batch Number field, the Batch Number field will automatically default the last batch number used.
Summary Only	If you want to print only the summary of the report, select this check box.		1

Sample Report
This report should be run on a daily basis and be kept as a permanent record as part of your paper backup system. If you select to include patient and transaction detail, the information included on the report is: the transaction accounting date, transaction service date, patient account number and name, any Report Comment contained in the patient's Billing Information, the transaction code and description, the performing doctor code, insurance doctor code, referring doctor code, location code, the transaction amount of the charge, payments and/or adjustment, and the patient's current account balance. If any payments are unallocated, the Per Dr and Loc columns display UN for unallocated.

The Summary page will print the following totals for each accounting date, for the sorting option selected: total charges, payments, adjustments, number of patients with posted transactions, and the number of 'new patients'. The number of patients with posted transactions total will count a patient one time for each 'date' the patient is seen for the accounting date range you select. So, if you select to print the report for the last month and a patient was seen on three different dates, it would count that patient three times. However, if that patient had been seen two times on the same date, it would only count that patient one time. The new patient total is calculated based on the date stored in the 'Date of First Visit' field in the patient's name and address screen. The date of first visit has to match either the accounting date or date of service of the transaction within the date range selected, to be included. Totals for the Month-to-Date and Year-to-Date amounts will also print if you selected to include them.

If you print the report sorted by Performing Dr, Insurance Dr, Billing Group, or Location Code and there are any unallocated payments, an Unallocated total prints on the Summary page. This unallocated total always prints for the selected date or date range — even if those payments are allocated later — because it accurately reflects that they were left unallocated when originally posted.

You can also print this report to Excel by selecting the Microsoft Excel via MyReports option in the Printers dialog box. If you select the Notify me when report is complete check box, you will receive a pop-up message when the report is complete. You can select to view the report using the link in the pop-up or you can elect to retrieve the report from MyReports at a later time. For additional information about the available printing options, see Printing in CGM webPRACTICE. The spreadsheet is wide, so the output is shown below in two parts: the left portion followed by the right portion.