How do I get a Monthly Report with Insurance Payments, Adjustment and Patient Payments Listed?

The Financial Transactions (Day Sheet) screen provides you with a day-end or month-end report. The report is based on the payment posted date and not on the date of service.

Let's get started:

1. Hover over the Billing tab and select Financial Transactions (Day Sheet):

Financial Transactions.png

2. Under the Default tab, input the date range (max 31 days). You can filter the report for a specific patient, Office, Exam Room, and Reason code > click on Update.

Screen_Shot_2022-08-31_at_2.58.29_PM.png

3. On the Grand totals tab, each section will show you totals for the parameters set at the top of the page. Debit shows the total charges based on the procedure posted date. Credit will show you the total insurance payments posted; Adjustment will show the total adjustments posted, and the Patient Payment section will show the total patient payments posted.

For details on which patient appointments make up each of the totals listed on the Grand totals tab, clicking on the blue Credits & Adjustments; Patient Payments; Charges tabs will provide specifics.

4. Credits & Adjustments tab shows the detailed insurance payments and adjustments based on the payment posted/adjusted date.

Screen_Shot_2022-08-31_at_3.00.10_PM.png

5. Patient Payments show the payments which were paid by the patients. You can sort the report by Posted date, Method of payment, or by the user who posted the payments (Creator).

Screen_Shot_2022-08-31_at_3.01.02_PM.png

6. Charges are similar to Debit but this will list all the charges along with the appointments.

Screen_Shot_2022-08-31_at_3.02.11_PM.png

7. Action will allow you to export the report into an excel format or Print the report.

  • Print All will print all 4 sections on one page.
  • Print Current section will print only the section which you are on.
  • Export All to File will export all 4 sections' reports into one excel sheet.
  • Export Current Section will export only the section which you are on.
  • Advanced Export will allow you to generate the report for more than a month.

Screen_Shot_2022-08-31_at_3.02.57_PM.png