Billing and Receivables > Using Billing and Receivables Reports > Running Collection Reports
The Reconciliation report generates a list of your collections by cash, personal check, insurance check, and credit card charges during a specific date range. The report also includes the daily total for each date, listing any discrepancies between the calculated amount and the receivables file amount. Run this report for the previous month’s receivables to ensure the validity of your bank statements.
Additional Details: Additional Details:
An asterisk is displayed for dates where there is a mismatch between the transaction and receivables files.
There are several reasons for a mismatch:
Whenever transactions are posted to an insurance plan, a mismatch occurs because insurance plan transactions are not stored in the receivables file.
A final daysheet has not been run.
Dangling transactions are present.
To generate the Reconciliation report:
Select Reports > Practice Management > Collection Reports > Reconciliation. The Output Options window is displayed.
Select the output option and click OK. The Reconciliation Report Setup window is displayed.
Select the starting and ending dates from the drop-down lists.
Select the provider(s) you want to include in the report, or accept the default of 999 to include information for all providers.
To include the details for each transaction in the report, select Include Detail Transactions.
Click OK.
Additional Reconciliation Report Information:Additional Reconciliation Report Information:
The Reconciliation report contains the following fields:
Date—Date of payment.
Cash—Dollar amount for cash payments posted (codes 1.00-1.99).
Check—Dollar amount for personal check and insurance check payments posted (codes 2.00-2.99 and codes 3.00-10.99).
Credit Card—Dollar amount for credit card payments posted (codes 11.00-20.99).
Daily Total—Total payments posted for each date.
Subtotals—Totals for cash, check, and credit card payments for the specified date range.