Transaction Journals to Excel

With the Transaction Journals to Excel function, you can print a report of all the Procedure, Payment, or Adjustment transactions entered into CGM webPRACTICE during a specified range of dates. The report is generated as a Microsoft Excel spreadsheet, where you can sort or calculate the data to meet your needs. This report is also available on the Reports, Transaction Journals menu.

Upon accessing this function, select the Journal to Print option you want (Procedure, Payment, or Adjustment). The fields available on the next screen vary by the option selected.

Data Field Information

Prompt	Response	Req	Len
Journal to Print	Select Procedure, Payment, or Adjustment to indicate which transaction type to include on the report.

Procedure Journal to Excel

Prompt	Response	Len
Print from date	Type the date you want 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
Print By	Select Accounting Date to include transactions based on their accounting date, or select Service Date to include transactions based on their date of service.
Assignment Charges Only	If you only want to include charges that Assignment was accepted for, select this check box.	1
Batch Number	Type the code you want or click the magnifying glass to search a list of every 'unlocked' batch. You can also create a new batch by typing in a batch number that does not exist and you will be asked if you want to create it.	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.
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.	20

Payment Journal to Excel

Prompt	Response	Len
Print from date	Type the date you want 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
Print By	Select Accounting Date to include transactions based on their accounting date, or select Service Date to include transactions based on their date of service.
Include Payment Breakdown	If you want the payments separated into two columns for Ins Pmts and Pt Pmts, select this check box. When selected, 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
Batch Number	Type the code you want or click the magnifying glass to search a list of every 'unlocked' batch. You can also create a new batch by typing in a batch number that does not exist and you will be asked if you want to create it.	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.
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.	20

Adjustment Journal to Excel

Prompt	Response	Len
Print from Date	Type the date you want 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
Print By	Select Accounting Date to include transactions based on their accounting date, or select Service Date to include transactions based on their date of service.
Batch Number	Type the code you want or click the magnifying glass to search a list of every 'unlocked' batch. You can also create a new batch by typing in a batch number that does not exist and you will be asked if you want to create it.	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.

You can 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.

Sample Report

The Excel output varies by the Journal to Print option selected and includes columns specific to each transaction type. Each report includes patient account number, patient name, transaction codes and descriptions, accounting and service dates, performing and insurance doctor codes and descriptions, location, billing group, insurance carrier, patient class, patient identifier, type of service, and other data appropriate to the option. The Excel output supports filtering, sorting, and calculation in the spreadsheet. Because each report is wide, the samples below are shown in sections.

Procedure Journal to Excel (shown in three sections)

Payment Journal to Excel (shown in three sections)

Adjustment Journal to Excel (shown in two sections)

Notes:

If the Exclude $0.00 Items on Reports check box is selected in the Invoice Billing Integration (System, Database Maintenance Menu, Integrations, Invoice Billing Integration), $0.00 transactions posted to patient accounts are excluded from the Procedures option of this report.
If you use expanded Procedure Entry to store a different location, referring doctor, or performing doctor code for each procedure entered, those codes reflect properly for each procedure on the Procedures option.
For the Payment option, the CGM PAY Pmt ID that prints on every receipt is included to assist with end-of-day reconciliation.
For the Payment option, CGM PAY clients receive an additional Note column that prints The payment Receipt was not received from the Merchant for this transaction. when an unposted CGM PAY payment was collected but the receipt was not received.