Payments Report

The Payments Report lists payments received from customers. Use it for payment reconciliation, tracking reversed payments, and checking prepayment balances.

When to Use This Report

• Reconcile payments received over a given period
• Find reversed or failed payments
• Check which payments are allocated to invoices versus held as prepayments
• Review payments by method (direct debit, card, manual, etc.)

Filters

For general guidance on running reports and using filters, see Using Reports.

Date Range

• On or After / Before — filter by payment date

Reversal Dates

• Reversed On or After / Before — filter by the date a payment was reversed. Use this to find failed direct debits or chargebacks within a period.

Payment Method

Filter by how the payment was made (direct debit, card, bank transfer, etc.).

Reversed / Non-Reversed

Choose whether to show:

• All — both active and reversed payments
• Reversed — only reversed payments
• Non-Reversed — only active payments

Allocation Type

Choose whether to show:

• All — all payments
• Invoice Payment — payments allocated against invoices
• Prepayment — payments held on account as credit

Invoice Date Range

• Invoice Date On or After / Before — filter by the date of the invoice the payment is allocated to

Customer Details

Filter by customer name, status, and other customer properties. See Using Reports for details.

Output Types

• On Screen — standard tabular view showing one line per payment
• CSV Output — full data export for spreadsheet analysis
• CSV Output (Accounts) — formatted for accounting package import
• Invoice Allocation — shows which invoice each payment is allocated to
• Customer Level — groups payments by customer showing totals
• Customer Level by Type — groups payments by customer and payment type
• Print — print-friendly layout

Tips

• Use the Reversed filter to quickly find failed direct debits after a payment run.
• The Invoice Allocation output type is useful for matching payments to specific invoices during reconciliation.
• Filter by Prepayment allocation type to review credit balances held on customer accounts.