Run payroll report by date payment was applied
Allow me to run the payroll report by the date the payment was applied to the client's ledger rather than the transaction date.
We collect payments from clients and leave them as unapplied payments until we get the ERA because sometimes the amount the client owes varies and we have to adjust the payment before applying it to the client's ledger. This causes more work when running the payroll report because then we have to backdate it to make sure those payments are included.
AdminSarah M
(Admin, theranest)
shared this idea
-
Rachel Bishop
commented
Definitely seems like all the data is available to support payroll by payment applied date. We have clients who like to pay ahead and have just discovered that some of those applied payments are not being captured in payroll analysis.
-
Richard at Sylvania Therapy
commented
The ERA prosess also creates inaccurate payment reporting : There's a legal, accounting and tax issue in using the ERA payment date in the client ledger and as the date payroll is based on. Many times it is merely the date that the payer has approved the payment for processing. In many cases the payer ERA reported payment date IS NOT the date that the EFT arrives in the bank. We have many examples of the funds not reaching our bank ( not getting "paid") until days or even weeks after the "payment date" on the ERAs in TN. If we pay our therapists weekly or every two weeks then ERA's posted with prior "payment dates" outside of those windows will be missed by the reports. We can't post an ERA until the funds are in the bank or else we would be applying payments and paying providers for sessions that have not actually been paid. If you are on a cash basis for accounting this is not accurate. Also, showing that a payment has been received well before it actually has been in the client ledger is inaccurate! Payment posted date needs to be a date indicated in the ledger and available to use for reporting such as the payroll report. Right now we can't use the payroll report and have to keep separate EXCEL sheets in order to pay our providers based on ACTUAL receipt of payment! ADD "PAYMENT POSTED DATE" to the ledger and reporting options.
-
Amy Juarez
commented
It would also be incredibly helpful if the report would show unapplied payments (by the date that they were unapplied) that were already paid out as a negative on the report. This would help to prevent any double payments or overpayments.
-
Thomas The Test Engine
commented
Would be helpful for users to be able to track payments that were applied > Unapplied > reapplied again to ensure double payments aren't made to staff. Thanks!
-
Jamie Knott commented
I echo this. Additionally, sometimes there is a large payment where part of it has been applied and the other part is waiting to be applied to future dates. Changing the date when applying the rest of the payment, will screw up what was already applied in regards to payroll. Causing us to pay out providers twice.
-
Bonnie Maisen commented
I think that the payroll report should have an option to show payments APPLIED during the date range, rather than the transaction date range.