What the payment performance report contains.
The Payment Performance report helps firm staff understand how clients are paying, how much has been collected, and how payment activity changes over time. It tracks payment volume, processing fees, deposits, late fees, and payment methods — how and when clients pay, and how long invoices take to be paid — with breakdowns by client, partner, and office.
Access
To view the Payment Performance report, users need: View Module, View Reports.
Report defaults
| Setting | Value |
|---|---|
| Default date type | Payment Date (payment attempt/transaction) |
| Default view period | Current calendar year |
| Default filter list | Payment Date This Year |
| Default filters | Selected Date; Paid Through Aiwyn |
| Historical data range | Current calendar year plus four prior calendar years (e.g., 2025–2021) |
Amounts on this report include payments that have not been allocated to an invoice.
Tabs
| Tab | What it shows |
|---|---|
| Payment KPIs and Charts | Firm-wide payment KPI tiles and trend charts |
| Client Payment Insights | Payment figures by client |
| Partner Payment Insights | Payment figures by partner |
| Office Payment Insights | Payment figures by office |
Payment KPIs and Charts
KPI tiles
| KPI | Definition |
|---|---|
| Total Payment Volume | Total amount of payments either pending or deposited into the bank account. Includes payments not allocated to an invoice |
| Processing Fees Paid | Fees withheld from the firm's payout — the amount Aiwyn keeps from the firm through Stripe's application fee mechanism |
| Net Payment Volume | Total Payment Volume minus Processing Fees Paid |
| Median Payment Amount | The middle value of all payment amounts |
| Deposited Volume | Total amount of payments deposited into the bank account. This is a portion of Total Payment Volume and includes payments not allocated to an invoice |
| Pending Deposit Volume | Total amount of payments initiated but not yet deposited into the bank account. This is a portion of Total Payment Volume and includes payments not yet allocated to an invoice |
| Transactions | Count of individual payment transactions |
| Late Fee Volume | Total amount of deposited late fees. Includes payments not allocated to an invoice |
| Late Fee Transaction Percentage | Percentage of payment transactions that include at least one deposited late fee line item |
| Percent of Aiwyn Payments | Percentage of payments that were processed through Aiwyn |
| Paying Clients | Unique count of clients that have made at least one payment |
Charts
| Chart | Type | What it shows |
|---|---|---|
| Payment Volume by Week and Method | Stacked bar |
Weekly payment volume trend, broken out by ACH, Check, Credit Card, and Other |
| Client Count by Payment Method | Bar | Unique client count by ACH, Check, Credit Card, and Other |
| Median DSO by Week and Method |
Bar | Weekly median days sales outstanding trend, broken out by payment method. Days outstanding is the number of days between the invoice transaction date and the receipt transaction date |
Insights tabs
| Tab | Table | What it shows |
|---|---|---|
| Client Payment Insights | Client Payment Insights | Payment insights by client. Amounts include payments not allocated to an invoice |
| Partner Payment Insights | Partner Payment Insights | Payment insights by partner. Amounts include payments not allocated to an invoice |
| Office Payment Insights | Office Payment Insights | Payment insights by office. Amounts include payments not allocated to an invoice |
Client Payment Insights columns
The Client Payment Insights table shows one row per client with the following columns:
- Client Name
- Client Number
- Client Group Name
- Client Status
- Partner Name
- Billing Manager Name
- Partner Office
- Total Payment Volume Amount
- Processing Fees Paid
- Total Net Payment Amount
- Deposited Volume
- Pending Deposit Volume
- Total Aiwyn Payments Percentage
- Total Non-Aiwyn Payments Percentage
- Median DSO Days
- Transaction Count
- Collected Late Fee Dollar Amount
- ACH Percentage
- Debit Card Dollar Amount
- Debit Card Percentage
- Credit Card Dollar Amount
- Credit Card Percentage
- Check Dollar Amount
- Check Percentage
- Wire Dollar Amount
- Wire Percentage
- Other Payment Method Dollar Amount
- Other Payment Method Percentage
Partner Payment Insights columns
The Partner Payment Insights table shows one row per partner with the following columns:
- Partner Name
- Partner Office
- Total Payment Volume
- Processing Fees Paid
- Net Payment Volume
- Deposited Volume
- Pending Deposit Volume
- Total Aiwyn Payment Percentage
- Total Non-Aiwyn Payment Percentage
- Median DSO Days
- Transaction Count
- Collected Late Fee Volume
- Collected Late Fee Transactions
- ACH Dollar Amount
- ACH Percentage
- Debit Card Dollar Amount
- Debit Card Percentage
- Credit Card Dollar Amount
- Credit Card Percentage
- Check Dollar Amount
- Check Percentage
- Wire Dollar Amount
- Wire Percentage
- Other Payment Method Dollar Amount
- Other Payment Method Percentage
Office Payment Insights columns
The Office Payment Insights table shows one row per office with the following columns:
- Partner Office Name
- Total Payment Amount
- Processing Fees Paid
- Net Payment Volume
- Deposited Volume
- Pending Deposit Volume
- Total Non-Aiwyn Payments Percentage
- Median DSO Days
- Transaction Count
- Collected Late Fee Volume
- Collected Late Fee Transactions
- ACH Dollar Amount
- ACH Percentage
- Debit Card Dollar Amount
- Debit Card Percentage
- Credit Card Dollar Amount
- Credit Card Percentage
- Check Dollar Amount
- Check Percentage
- Wire Dollar Amount
- Wire Percentage
- Other Payment Method Dollar Amount
- Other Payment Method Percentage
Available filters
Use filters to narrow the report by:
- Selected Date
- Date Type
- Paid Through Aiwyn
- Client
- Client Number
- Client Group
- Client Status
- Client Partner
- Project Partner
- Client Manager
- Project Manager
- Partner Office
- Payment Method
- Firm
Common ways to use this report
- Compare payment volume across weeks and payment methods.
- Monitor the amount deposited and still pending deposit.
- See how many clients paid during the selected period.
- Review payment activity by client, partner, or office.
- Track the volume and frequency of collected late fees.
- Watch how long invoices take to be paid, by payment method, using the Median DSO chart.
Related
- Report reference
- Aiwyn KPI glossary
- Payment failures report reference
- Outstanding AR report reference
- Report data latency by source system