INTERNAL: Financial Transactions Report (fka Day Sheet) Logic around Moved Cash option

This article is to provide clarity and an explanation of the logic behind the "Include Moved Cash" option within the Financial Transactions Report (fka Day Sheet).

Screen_Shot_2022-10-06_at_9.03.11_AM.png

Example:

  1. $100 Payment posted under provider “A” (practice wants to move the money to Provider B)

  2. System posts $100 reversal under provider “A.”

  3. The system posts $100 under provider “B.

When we change the filter to “Include Moved Cash” to “NO”, our system hides transactions #2 and #3 since both are system-created (child) transactions.

So, for provider “A,” it shows as payment increased when compared to “Include Moved Cash” as “Yes” since the reversal adjusted the original payment is hidden. but, the system will hide the payment moved in Provider “B” as well; this will adjust/decrease the payment in that provider account. So, when you check under the practice group view, there will not be any difference in the total patient payment.

It is a bit complex, but if we make the changes to the logic, it will lead to another data inconsistency problem.