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.

FieldDescription/Rules
Payment typeThese are the same payment types as in the “Payments” tab.
AmountThe sum of the payment amounts for that type.

 

PAYMENTS

Each detail line represents a payment transaction.

FieldDescription/Rules
Payment datePayment date of transaction.
Payment typePayments are grouped into different payment types.
Transaction create dateThis 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.
  • For patient payments, this is the reference provided on the UI.
  • For RAs, it is the EFT reference number (if it exists).
Receipt no.Receipt no. generated by the system for the payment transaction.
Paid byIndicates if it was paid by a patient or by a scheme.
Payment amountTotal amount of the payment.
Allocated amountPart 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 surnameSurname of account holder.
Account holder nameFirst name(s) of account holder.
Unallocated amountPart of payment that is unallocated.
Created byName 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.

 

Was this article helpful?