Charges/Payments Reconciliation Report is one of the effective reports to identify the payments received against the charges billed for a given period of time. It is an Excel spreadsheet report with summarized and detailed information about the charges entered into the system and payment posted against it along with on-account information. It also provides missed charges information.

Search filters for the report includes Accounting Dates, User, Legal Entity, Provider and Insurance. The excel report has six sheets which provide the following information.

Sheet 1: Daily-Month Activity Summary

Sheet 2: Payment Deposit

Sheet 3: Posting Details

Sheet 4: Missing Encounters

Sheet 5: Unapplied and Unposted payments

Sheet 6: Charges and Unposted Charges

Image 1 shows a sample Daily-Month Activity Summary sheet of the J6 report.

Image 1