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.