Payments Received by Clinician Reconciliation
Answered

I did an analysis of one therapist from 12/31/2018 to 5/5/2019.  Here is what I pulled from the past pay periods:

 

Date Total Adjustment Net
12/31/2018 - 01/13/2019 3,131.36 -81.49 3,049.87

01/14/2019 - 01/27/2019

3,434.29 181.88 3,616.17
01/28/2019 - 02/10/2019 2,715.69 -269.40 2,446.29
02/11/2019 - 02/24/2019 3,708.03 -1486.66 2,221.37
02/25/2019 - 03/10/2019 4,655.81 0.00 4,655.81
03/11/2019 - 03/24/2019 4,676.16 -793.67 3,882.49
03/25/2019 - 04/07/2019 4,350.66 -142.41 4,208.25
04/08/2019 - 04/22/2019 4,582.92 -1,162.62 3,420.30
04/23/2019 - 05/05/2019 3,998.41 -969.3 3,029.11
Totals 35,253.33 -4723.67

30,529.66

 

 

 

 

If I run a report on this therapist from 12/31/2018 to 5/5/2019, I get the following number:

34,461.64

 

How do I reconcile these figures?  There is a $4k difference.

 

Thanks,

Katrina.

1 comment

  • Comment actions Permalink
    Avatar
    Mike

    Hi Katrina,

    It may help to explain how the pay period snapshot feature works to explain the accounting discrepancy. When you lock a pay period, the system takes a snapshot of how the entire billing system looks at that moment. Then it can use the snapshot as a point of comparison to calculate any adjustments that occurred to the time periods that have already been paid out afterwards.

    When you looked at this clinician's Payments Received by Clinician report for 12/31/18 through 5/5/19, you were looking at how this time period exists today. This will include insurance payments that arrived after this time period that were allocated to appointments within this time period. It will also include payments that were added after the pay period was closed but dated within the pay period (like Medicaid payments since you have to enter these manually). 

    Each time a pay period is locked, the system compares the current state of your accounting to the previous locked pay period snapshots and factors any changes into adjustments. While I'm not able to identify the specific transactions accounting for the difference in the current functionality, our Product Team are working on a more detailed version of this report and you can follow our progress on the Product Roadmap: SimplePractice Product Roadmap

    Please let me know if you have additional questions and I will be happy to help.

    Hi Katrina,

    It may help to explain how the pay period snapshot feature works to explain the accounting discrepancy. When you lock a pay period, the system takes a snapshot of how the entire billing system looks at that moment. Then it can use the snapshot as a point of comparison to calculate any adjustments that occurred to the time periods that have already been paid out afterwards.

    When you looked at this clinician's Payments Received by Clinician report for 12/31/18 through 5/5/19, you were looking at how this time period exists today. This will include insurance payments that arrived after this time period that were allocated to appointments within this time period. It will also include payments that were added after the pay period was closed but dated within the pay period (like Medicaid payments since you have to enter these manually). 

    Each time a pay period is locked, the system compares the current state of your accounting to the previous locked pay period snapshots and factors any changes into adjustments. While I'm not able to identify the specific transactions accounting for the difference in the current functionality, our Product Team are working on a more detailed version of this report and you can follow our progress on the Product Roadmap: SimplePractice Product Roadmap

    Please let me know if you have additional questions and I will be happy to help.