Payment Collection Report
Review collected payments and method mix.
The Payment Collection report shows collected payments over time and helps you review how customers are paying.
Use this report for cash collection review, payment-method analysis, and follow-up planning. It answers what was collected, not only what was invoiced.
Open Payment Collection
- Open Reports.
- Select Finance.
- Choose Payment Collection.
- Set the date range.
- Select a currency when needed.
- Choose day, week, or month grouping.
Use This Report To
- Review collection volume.
- Compare payment periods.
- Check payment method trends.
- Investigate collection slowdowns.
Use it after reminder campaigns, gateway changes, checkout-link launches, or offline payment policy changes. It helps show whether customers actually paid, not just whether invoices were sent.
Filters
Use date range and currency. Group by day, week, or month depending on how closely you need to inspect payment activity.
Use daily grouping when investigating a gateway issue or a specific collection drop. Use monthly grouping for finance review.
Keep the same date range and currency when comparing periods. Mixed currencies or changed date ranges can make collection trends look better or worse than they really are.
How to Read It
Use the trend for timing and the breakdown for method mix. If collections are low, review overdue invoices and failed or pending payment flows.
The report is useful after payment reminders, payment gateway changes, or checkout updates. If online payments drop but offline payments increase, review whether clients are avoiding a gateway because of fees, availability, or failed checkout attempts.
When method mix changes, check customer instructions and public invoice pages. Customers may switch methods because the preferred method is hidden, failing, or less clear than an offline instruction.
Investigation Checklist
- Compare collected payments with the Invoice Aging report.
- Check whether recent invoices were sent and viewed.
- Review pending offline payment notices.
- Check gateway status in Finance settings.
- Review provider dashboards for failed or incomplete payments.
Also compare one online payment and one offline payment when both methods are used. The report should match the operational process for each method, not only the total collection number.
Reconcile With Source Records
When totals matter, open sample payments from the table and compare each one with the invoice, customer, payment method, gateway transaction, refund state, and currency. Fix source records before exporting or sharing the report.
If refunds or chargebacks occurred, review them before presenting collection totals. Gross collections can look healthy while net collected revenue is lower.
Troubleshooting
If expected payments are missing, confirm the invoice payment date, currency, method, and whether the payment was recorded manually or through a gateway.
If online payment volume drops, check gateway status, public invoice payment buttons, provider dashboard errors, and recent changes to offline instructions.
If a payment is missing from the report but appears on an invoice, check payment date, currency, refund status, and whether the payment was recorded against a different invoice or customer.
If online collections dropped after a settings change, test a public invoice payment path before assuming customers simply stopped paying.
Collection Review Routine
For weekly review:
- set one date range and currency
- compare totals with invoice aging
- review method mix changes
- inspect failed or pending gateway payments
- verify large offline payments
- note refunds, chargebacks, or disputed payments separately