Appointment – End of Day Reconciliation Sheet Report gives detailed information on the appointments for the specified date range. The details include patient name, MR#, Legal entity, Provider, DOS, TOS (Time of Service), Appointment status, the user who created the appointment, the patient’s primary and secondary insurances, the user who verified the eligibility.

The report also provides co-payment information: amount, how much is collected, payment # and pay method if collected.

A summary of the total appointments and co-payments for the given date range is given at the end of the report.


1. A7 report is a reconciliation between the co-pay amount that was supposed to be collected and the actual collected amount. If a copay amount was saved in the patient’s insurance, it will be shown in the Copay amount field. The collected amount will be reflected in the Copay collected field only when the co-pay payment was collected through the appointment.

2. The report has both PDF and Excel export options.

Search Filters of A7 Report

Field Description
DOS From/ To To search  using Date of Service
Legal Entity To search for a particular legal entity
Provider To search for a particular provider
PR.INS. Primary Insurance
SE. INS Secondary Insurance
Modified By User Filter according to the user who updated the appointment.
Appt Type To filter results for a specific appointment type
Sort By Insurance, provider, user, DOS

Search screen of A7 Report

Sample A7 Report