The Cash Over Time Weekly Payments Report is a handy tool for keeping tabs on payments from payment plans set up through HFD. It gives you all the details you need for each payment, like patient info, payment amounts, fee breakdowns, and transaction specifics. This way, providers can easily monitor their cash flow and reconcile payments.
Glossary
| Field | Description |
HFDID | The unique identifier for the Contract. |
ParentProviderID | Unique ID for the Provider’s Company as a whole. |
ProviderID | The unique identifier of the provider that originated the contracts. |
CompanyID | An open text field that providers can use to help identify the Provider. |
PracticeName | The legal name of the provider location. |
PaymentID | Unique ID for Each Payment |
Provider Patient ID | Unique Patient ID if provided by the provider |
Patient First Name | Patient’s First Name |
Patient Last Name | Patient’s Last Name |
Payment Type | Indicates if a payment is a Principal/Interest payment or Down Payment. |
GrossAmount | Total Amount the Customer Paid. |
Fees | The total in Fee Amounts paid which includes late fees and non-sufficient funds (NSF) fees. |
AmountToProvGross | Total Amount Sent to the Provider before Processing Fees. |
ApplyToPrincipal | Amount applied to Principal from the payment. |
ApplyToInterest | Amount applied to Interest from the payment. |
CCFee | Fee Charged by Merchant Processors. |
RetentionFee | HFD Retention Fee. |
NetAmountToProvider | Total Amount the Provider Received. |
CustomerPaidDate | Date the Customer Made a Payment. |
ProviderPaidDate | Date the Provider Received a Payment. |
TransactionType | Indicates if the payment was a Charge or a Refund. |
PaymentSource | Automatic Payment or Manual Payment Made on Customer Portal. |
PaymentMethod | The payment option used to make the payment: Credit Card / Debit Card / ACH. |
AccountingCode | If the Payment was not successful, the code for the failure (STOP / NSF/INVAL/RFND). |
Merchant | The payment processing merchant that processed the payment. |