The Cash-Basis Aging Report and the Activity Report give insight into the cash entering and leaving your account in a selected period of time. The Cash-Basis Aging Report gives a detailed view of charges, payments, and adjustments and their aging in a selected period of time whereas the Activity Report gives a total picture of charges, payments, and adjustments collected in a month.
However, at any point the charges, payments, and adjustments for each group will be the same in both the reports and hence, we can use the Activity Report to reconcile the Cash-Basis Aging Report.
Let's get started
First, generate a Cash-Basis Aging Report with an encounter date type, payment date type, and a date range. In the below example, the date range is from 8/1/2020 - 8/31/2020.
Next, generate an Activity report for the same date range and date types. In the below example, the Activity Report is generated for the month of August.
Let's compare the data!
Procedure Code
Navigate to the Procedure Code tab in the Cash-Basis Aging Report and note the total charges, payments, and adjustments for a procedure code group.
Here for 99203, the total charges are $900, total payments are $73.00 and total adjustments are $20.00.
Now, navigate to the Procedure Code tab in the Activity Report and note the total charges, payments, and adjustments for the same procedure code.
Here, the total charges are $900.00, total payments are $73.00 and total adjustments are $20.00.
Facility
Expand a facility group from in the Cash-Basis Aging Report and note down the total charges, payments, and adjustments. As seen below, the total charges are $14,224.00, the total payments are $2,210.00 and the total adjustments are $300.00.
Now, note down the total charges, payments, and adjustments for the same facility in the Activity Report.
Here we see that the total charges are $14,224.00, the total payments are 2,21000 and the total adjustments are $300.00.
Hence, charges, payments, and adjustments for a Facility are reconciled.
Rendering Provider
Navigate to the Rendering Provider tab in the Cash-Basis Aging Report. Expand a Rendering Provider group and note the total charges, payments, and adjustments.
Here, the total charges are $15,614, total payments are $2,339.00 and total adjustments are $330.00.
Now, navigate to the Rendering Provider tab in the Activity Report and note the total charges, payments, and adjustments for the same rendering provider group.
Here, the total charges are $15,614, total payments are $2,339.00 and total adjustments are $330.00.
Hence, charges, payments, and adjustments for a Rendering Provider are reconciled.
Billing Provider
Navigate to the Billing Provider tab in the Cash-Basis Aging Report and note the total charges, payments, and adjustments for a billing provider. Here, the total charges for Stephanie Winter are $13,415, total payments are $2,339.00 and total adjustments are $330.00.
Now, navigate to the Billing Provider tab in the Activity Report and note the total charges, payments, and adjustments.
Here, the total charges are $13,415, total payments are $2,339.00 and total adjustments are $330.00.
Hence, charges, payments, and adjustments for a Billing Provider are reconciled.
Scheduling Provider
Navigate to the Scheduling Provider tab in the Cash-Basis Aging Report and note the total charges, payments, and adjustments. For NO Scheduling Provider, the total charges are $15,914.00, total payments are $0.00 and total adjustments are $0.00.
Now, navigate to the Scheduling Provider tab in the Activity Report and note the total charges, payments, and adjustments for the same Scheduling Provider.
Here, the total charges are $15,914.00, total payments are $0.00 and total adjustments are $0.00.
Hence, charges, payments, and adjustments for a Scheduling Provider are reconciled.
With this, we have completed the reconciliation of the Cash-Basis Aging Report with the Activity Report.
Click here to see the steps to reconcile the Activity Report with other reports and the transaction screens.
Still need help? Contact us!
Have a great idea? Tell us about it!