Debtors Movement Report
General Notes
- For every transaction that affects the liabilities of invoice lines, an audit record is stored. This report uses these audit transactions as the basis for its calculations.
- A limitation on the above: These audit records are only generated for transactions originating on Healthbridge Nova. This means that transactions imported from myMPS DO NOT form part of the report.
- The data for this report will be based on the timestamp of when the transaction was CREATED in the database. I.e. the report cannot be generated on invoice date of service, and it doesn’t care about things like the payment date of a payment. We might be able to refine it later, but for the first version we are only concerned with the create date/time of the transaction in the audit table.
- Only transactions that directly affect invoices are in the report. This means that things like unallocated payment parts, journals, and unreconciled RA payments are not part of the report calculations.
Summary Tab
| Field | Description/Rules |
| Opening balance | (DEBITS total + CREDITS total + REVERSED TRANSACTIONS sum) of ALL transactions before the selected start date of the report. |
| DEBITS section | |
| Invoices | Sum of all the invoice transactions for the selected date range. Displayed as a positive number. This includes all invoice types, including debit note invoices. |
| Payment corrections | Sum of all the payment corrections transactions for the selected date range. Displayed as a positive number. |
| CREDITS section | |
| Medical aid payments | Sum of all the medical aid payment transactions for the selected date range. Displayed as a negative number. |
| Patient payments | Sum of all the patient payment transactions for the selected date range. Displayed as a negative number. |
| Write-offs: Bad debt | Sum of all the write-off transactions of type “bad debt” for the selected date range. Displayed as a negative number. |
| Write-offs: Small balance | Sum of all the write-off transactions of type “small balance” for the selected date range. Displayed as a negative number. |
| Credit notes | Sum of all the credit note transactions for the selected date range. The invoice cancellation credit note types must be excluded from this calculation, i.e. CreditType <> (Claim reversed | Cash invoice cancellation | Claim resubmitted). Displayed as a negative number. |
| REVERSED TRANSACTIONS section | |
| Cancelled invoices | The sum of all the invoice cancellation credit note types, i.e. where CreditType = (Claim reversed | Cash invoice cancellation | Claim resubmitted). Displayed as a negative number. |
| Reversed payment corrections | Sum of all the reversed payment corrections transactions for the selected date range. Displayed as a negative number. |
| Reversed med aid payments | Sum of all the reversed med aid payment transactions for the selected date range. Displayed as a positive number. |
| Reversed patient payments | Sum of all the reversed patient payment transactions for the selected date range. Displayed as a positive number. |
| Reversed write-offs: Bad debt | Sum of all the reversed write-off transactions of type “bad debt” for the selected date range. Displayed as a positive number. |
| Reversed write-offs: Small balance | Sum of all the reversed write-off transactions of type “small balance” for the selected date range. Displayed as a positive number. |
| Reversed credit notes | Sum of all the reversed credit note transactions for the selected date range. Displayed as a positive number. The invoice cancellation credit note types must be excluded from this calculation, i.e. CreditType <> (Claim reversed | Cash invoice cancellation | Claim resubmitted). |
| Closing balance | Closing Balance = Opening balance + DEBITS total + CREDITS total + REVERSED TRANSACTIONS sum |
Transaction Details Tab
- This tab lists all the transactions that make up the summary data on the Summary tab.
- Ordered from oldest to newest based on the transaction date/time.
| Column | Description/Rules |
| Transaction create date/time | The timestamp of the transaction. Format: yyyy-mm-dd hh:mm:sss |
| Transaction type | |
| Account no. | Account no. that the invoice is linked to. |
| Affected invoice no. | Invoice no. that is affected by the transaction. For invoices themselves, it will be the invoice’s invoice no. |
| Amount | The sum of the PL and MAL invoice movement. The number should be positive/negative based on how it is displayed in the Summary tab. |
| Amount excl. VAT | Amount - saved VAT amount. |
| VAT amount | VAT amount saved for the transaction. |
| Created by | Name and surname of user who created transaction. |