Payments Per Provider Report

Details of payments received, for a selected provider. This report lists payments linked to a provider via invoice, excluding unallocated and unreconciled payments. The Excel version offers more detailed information without display limits

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.

Summary Section

This section shows a breakdown of patient payments and medical aid payments per provider.

FieldDescription/Rules
Patient paymentsSum of patient payments of all types.
Med aid paymentsSum of medical aid payments of all types. 
Insurance paymentsSum of insurer payments of all types.

 

Detail Section

Each detail line represents a payment on an invoice. Therefore, if a single payment is allocated to 2 invoices, two detail lines must be displayed.

These fields appear on the PDF version of the report:

FieldDescription/Rules
Payment datePayment date of transaction.
Payment typePayments are grouped into different payment types.
Payment amountPayment amount allocated to the invoice.
Invoice no.Invoice number of the invoice the payment was allocated to.
ProviderTreating provider invoice is linked to.

 

 The Excel version has the following additional information:

FieldDescription/Rules
Recon dateThis is the date the payment transaction was created in the db. 
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.
Account no.Account number that the invoice is linked to.
PatientPatient linked to the invoice.
Invoice amountTotal amount of the original invoice.
BranchBranch invoice is linked to (only visible for a multi-branch practice).