Help Centre
News
Help Centre
News
Daily
A day in the practiceLogin to Healthbridge NovaHow to add a patientHow to add an appointment to the CalendarHow to Book and Join a Telehealth AppointmentHow to Perform a Benefit Check in Healthbridge NovaHow to Capture an InvoiceHow to Create and Manage QuotationsHow to manage patient accounts Part 1How to manage patient accounts Part 2How to add notes to a Patient Account Working with the Healthbridge Nova inboxHow to do a Manual RA Capture.How to Fix and Resubmit Claims in Healthbridge NovaHow to search for patient accountsHow to view transactions and invoices on an account How to manage captured invoices How to follow up on Invoices How to cancel a cash Invoice How to add a Credit Note How to add a Debit Note How to manage Unallocated Credits How to capture a payment How to Bill PMB Conditions at 300%WhatsApp Patient onboarding
Operational
How to Transfer Liability from Medical Aid to Patient in Healthbridge NovaHow to Send Bulk Messages in Healthbridge NovaAccount AgeHealthbridge Nova ReportsHow to Manage Electronic Remittances in Healthbridge Nova
Setup
How to Add a Provider in Healthbridge NovaHow to Add Custom Charge Codes in Healthbridge NovaHow to Customize the Calendar in Healthbridge NovaHow to Set Up Private Rates in Healthbridge NovaHow to Add a Branch in Healthbridge NovaHow to Change Your SMS and Email Templates in Healthbridge NovaHow to Set a Mandatory ID Number When Creating Patient Accounts in Healthbridge NovaHow to reset passwords (System admin rights required)Percentage Billing How to add a new userHow to link your Gmail CalendarHow to setup Invoice Templates How to set up appointment reminders and confirmation templates linked to specific visit typesHow to set up Network pricing and contracts
Reports
Monthly Transaction ReportPayment Summary ReportPayments Per Provider ReportPayment Details ReportDebtors Movement Report
Stock
Stock Overview Stock Level ListingQuarantine Stock Listing Purchase Orders (PO's) and ReceivingGoods Received Listing (GRV)Supplier Returns Listing (SRN)Stock Adjustments Stock Movement Label Printing and Hardware RequirmentsHow to manage stock daily Stock Reports How to Take on Stock Vendor Management
Specialists
Modifier Coding Cheat sheetHow to Add Modifiers to an InvoiceGynaecology & Obstetrics Modifier CheatsheetPaediatric Modifier Cheatsheet
Add-Ons and Integrations
Practice Agent: WhatsApp Booking Links

Debtors Movement Report

A summary of the transactions that contributed to the movement in your practice’s patient accounts in a selected date range.

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 generated only for transactions originating from Healthbridge Nova. Transactions imported from myMPS are not included in this report.
  • The data for this report is based on the timestamp when the transaction was CREATED in the database. This means the report cannot be generated using the invoice date of service, and it does not consider payment dates. We may refine it later, but for the first version, we only need to focus on the transaction’s create date and time in the audit table.
  • The report includes only transactions that directly impact invoices. This means unallocated payments, journals, and unreconciled RA payments are excluded from the calculations.

Summary Tab

FieldDescription/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 balanceClosing 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.
ColumnDescription/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 Patient Liable and Medical Aid Liable invoice movement.

The number should be positive/negative based on how it is displayed in the Summary tab. 

Amount excl. VATAmount - saved VAT amount.
VAT amountVAT amount saved for the transaction.
Created byName and surname of user who created transaction.

Was this article helpful?

Powered by Product Fruits