Payment Details Report
Details of patient and medical aid payment transactions, for the whole practice.
GENERAL NOTES
- The user can select a date range type to filter on:
- Payment date: This is the payment date recorded for the transaction.
- Transaction create date: This is the date that the transaction was recorded in the system, and can be different from the payment date.
PAYMENT TYPE SUMMARY
The purpose of this tab is to show the totals per payment type, to assist the practice in cashing up their physical payments slips at the end of each day/week.
Field | Description/Rules |
Payment type | These are the same payment types as in the “Payments” tab. |
Amount | The sum of the payment amounts for that type. |
PAYMENTS
Each detail line represents a payment transaction.
Field | Description/Rules |
Payment date | Payment date of transaction. |
Payment type | Payments are grouped into different payment types. |
Transaction create date | This is the date the payment transaction was created in the db. |
RA no. (if linked) | Only shown if the payment is linked to a remittance advice. |
Payment ref. |
|
Receipt no. | Receipt no. generated by the system for the payment transaction. |
Paid by | Indicates if it was paid by a patient or by a scheme. |
Payment amount | Total amount of the payment. |
Allocated amount | Part of payment that is allocated to invoices. |
Invoice(s) | Invoice numbers of the invoices that the payment was allocated against. |
Account no. | Account no. that the payment is linked to. |
Account holder surname | Surname of account holder. |
Account holder name | First name(s) of account holder. |
Unallocated amount | Part of payment that is unallocated. |
Created by | Name and surname of the user who created the transaction. |
BREAKDOWN
- The purpose of this tab is to show all the payments in the dataset, broken down into its allocated and unallocated parts.
- Each line represents either:
- an allocation part of the payment to a specific invoice; or
- the unallocated part of the payment
Example 1: A medical aid payment of 270 that is fully allocated to a single invoice.
Example 2: A patient payment of 500. 100 is allocated to an invoice for Peter, 250 is allocated to an invoice for Linda, and 150 remains unallocated.