Payment reports overview
Modified on Wed, Oct 7 at 2:02 PM
Payment reports overview
The Payments Report page provides links to several preset reports and an option to build a custom report. These reports help administrators quickly retrieve key payment information filtered by status, date, account type, and more.
Click Build Custom Report to open the Advanced Filters page. Select one or more filter conditions and the application will return all matching payment records.
| Filter | Options and description |
|---|---|
| Payment Type | Filter by payment category: Monthly Fee, Initial Fee, Paid in Full, or Supplemental. |
| Payment Status | Filter by payment status: Unpaid (no transaction or unsuccessful), Paid (settled transaction), Canceled (annulled by admin/manager or plan cancelled), or Pending (captured transaction). |
| Last Transaction Status | Filter by the most recent transaction status: Captured, Settled, Declined, Settled (returned), Error, Voided, Held for Review, or None (no associated transaction). |
| Payment Cancel Reason | Filter cancelled payments by reason: Error, Payment Default, No Payment Due, or Other. |
| Auto Charge | Filter by auto-charge setting: Both (all payments), On (auto-charge enabled only), or Off (auto-charge disabled only). |
| Account Type | Filter by payment account type: Bank Account (checking or savings) or Credit Card Account (credit or debit card). |
| Due Date | Filter by payment due date using a Month & Year selection or a custom Date Range. |
| Payment Date | Filter by the date a payment was marked Paid using a Month & Year selection or a custom Date Range. |
| Wellness Plan Status | Filter by the status of the associated plan. Options include: Active, In Progress, On Hold, Inactive, Canceled, Difference Paid, Difference Paying As Scheduled, No Payment Needed, Paying As Scheduled, Payments Paid Out, Opted Out, Completed, Plan Changed (legacy), Renewal, Automatic Renewal, and Manual Renewal. |
| Amount Due | Filter by a dollar range using From and To fields to view payments within a specific amount range. |
| Columns to Include | Select which columns appear on the report: Client ID, Last Name, First Name, Pet ID, Pet Name, Account Type, Payment Type, Amount, Total Monthly Fee, Due Date, Payment Date, Auto Charge, Payment Status, Payment Cancel Reason, Payment Canceled On, Last Transaction Status, Bank Name, Bank Routing Number (last 4), Bank Account Number (last 4), and Card Number (last 4). |
When viewing a payment report, the total dollar amount for all matching payments displays below the record count, broken down by Unpaid, Pending, Paid, and Cancelled. Click the Details link to the far right of any line item to view full information about the plan and its associated transactions.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article