Reports

Find the data you need to strengthen and build your business.

Payments Report

Austin Written by Austin
... on a nifty November day.


📖 In This Article

What can you use this Report for?
Filters and Options
What is displayed in the report?
Tips and Tricks


The Payments Report lists each Payment recorded against items in invoices, by the payment date, optionally grouped by Staff member.

What can you use this Report for?

Generate this report to calculate staff salaries and commission on payments and to generate a list of payments, including Vouchers and the use of Account Credit.

Filters and Options

Filters Description
Date Payment processed (or dated) within the timeframe.
Location Payment Location.
Staff Payments of items attributed to selected Staff Members (provider or salesperson) to include in the report.
Show Taxed Items Only If ticked, only items with sales tax will be displayed.
Payers Payments made by selected Payers will be included in the report.
Methods Payment methods to include in the report.
Sort Group by Practice for a single global total or Group By Providers for a breakdown of payments per Provider. Please note: When using the Group By Providers option, the Salesperson will be shown instead of the Provider for any invoiced items allocated to the Salesperson.
Services Services to include in the report.
Classes Classes to include in the report.
Inventory Inventory items to include in the report.
Passes Passes to include in the report.
Others Other items to include in the report.

What is displayed in the report?

  • The Summary table lists the total amount paid for each type of payments with sales tax details.
  • Below are details table with the total amount paid per payment method for each item, with sales tax details.
  • When “Group by Providers” is selected, a summary per Provider and/or Salesperson is displayed and detail tables are also divided per Provider/Salesperson.

 

Column Description
Payment Date Date the payment was processed (or dated).
Invoice No. Invoice number.
Invoice Date Date of the invoice.
Location Payment Location.
Client Name of the Client the item was invoiced for.
Salesperson Staff member attributed to the sale of  the item (provider if no salesperson set)
Item Name of the invoiced item.
Method Payment method.
Subtotal Total amount invoiced for the item (excluding sales tax).
Sales Tax Sales tax added to the item’s total amount.
Item Total Total amount invoiced for the item (including sales tax).
Sales Tax Paid Part of sales tax paid with the payment method
Paid (inc. sales tax) Total amount paid with the payment method for the item.

Tips and Tricks

Refunds are not accounted for in this report.

If an item was partly paid with 2 different payment methods it will be displayed twice (2 different rows), therefore the item total price will be displayed twice. The subtotal, sales tax and item total columns are not to be used to reconcile revenues.

Help Centre

How can we help?

Chat with Us!
🍪 Cookies