Skip to main content

Creating a Payments Report

Review and track payments received against invoices

The Payments Report allows you to review payments received against invoices, providing a clear overview of payment amounts, dates, methods, invoice statuses, and outstanding balances.

Payments can be filtered by date range, payment method, sales consultant, contact, and payment status, with options to group results by invoice, payment method, consultant, or contact. Reports can be generated in HTML, PDF, or CSV format.

Jump to:


Running the report

1. Navigate to Reports > Payments Report.

2. Select a payment date period.

3. Choose a Report Type to determine how payments are presented:

  • All Payments: View individual payment records.

  • By Invoice: Review payments grouped by invoice.

  • By Payment Method: Review payments based on how they were collected.

  • By Consultant: Review payments associated with individual sales consultants.

  • By Contact: Review payments associated with individual contacts.

4. Apply any additional filters:

  • Payment Method: Filter by a specific payment method.

  • Sales Consultant: Filter payments associated with a particular consultant.

  • Contact: Filter payments associated with a particular contact.

  • Invoice Status: Filter by the current status of the associated invoice.

  • Payment Status: Choose Completed, Processing, or All.

5. Select your preferred Report Format:

HTML, PDF, CSV

6. Click Generate Report.


Report Examples

^ A full summary, including all sales items

^ A report organized by payment method


Key points

  • If an invoice has multiple payments recorded against it, each payment will appear as a separate entry in the All Payments report.

  • At the bottom of the report, you'll find the Total Payments Received, with totals displayed separately for each currency.

Payment dates

  • Payment dates reflect when a payment is counted as received in your gallery's timezone.

  • For delayed payments processed through Stripe, the payment date reflects when Stripe confirms the payment was successful, rather than when the funds arrive in your bank account.

Current invoice balances

  • The Current Balance column reflects the invoice's balance when the report is generated, not its balance immediately after the individual payment was recorded.

  • This balance may also include payments that are still processing, even when the report is filtered to show only Completed payments.

Payment status and invoice status

  • These are separate filters. For example, a completed payment can still appear against an invoice with an Overdue or Voided status, depending on the invoice's current state.


FAQ

Why is a payment missing from my Payments Report?

Successfully processed payments will show up on the invoice. If they don't show up there, then the payment has not been completed, or failed.

Does the report include partial payments made against an invoice?

Yes, even though "partial payments" are classified as such, they are still considered a fully valid payment, and will show up on this report.

Are refunded or reversed payments included in the report?

No, only successful completed payments will display on the report.

Does the report include payments recorded manually, or only those processed through Stripe?

The report includes all payment types, including processed, recorded, and terminal payments.

Does the Payments Report include payment processing fees or taxes?

No, it doesn't - only payments made on line items are included.

What is the difference between the Payments Report and the Sales Report?

  • The sales report shows more details surrounding the actual invoice.

  • The sales report does not include the payment method.

  • The sales report includes the actual artworks included in the sale.

Did this answer your question?