Run payroll report by date payment was applied

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.

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.

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.

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!

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.

Richard at Sylvania Therapy, Business Mgr Dec 11 09:10 am The Payroll Data Export Report instructions by Ian G are not correct . They say : Pulls in Payments that were accepted in the specified date range. AND : Transaction Date Range - This is the date you applied the payment, not the Date of Service. THIS IS NOT CORRECT although this is what the report should do. Whatthe report uses for transaction date is the "payment date" contained in the ERA from the insurer. This is not the date that the payment was applied in TN and it is not the date that the payment was received in the bank, the ACTUAL payment date. I process the ERAs only when the funds are deposited in our bank. If the report actually used the applied date we could use it. OR if the ability to correct ( overrride) the payment date on the ERA was available in the process of processing the ERA or individual line item of within the "process payment" function within the ERA received tab. Without either of these, the second being the preferred choice, it is not possible to use this report to calculate payouts to staff.

I think that the payroll report should have an option to show payments APPLIED during the date range, rather than the transaction date range.