Net Payments Report
The Net Payments report is for practice managers and anyone responsible for end-of-day or end-of-month financial reconciliation. It shows every completed payment alongside the refunds issued against it, so you can see the true cash your practice captured for any period — not just the gross amount taken.
In short
The Net Payments report lists payments and their associated refunds as separate rows, each with a signed amount. Summing those amounts gives you net cash captured: money in, less money refunded back out.
Why this matters
The standard Payments report shows gross figures — every payment taken, with no deduction for refunds. That is useful for auditing individual transactions, but it overstates the cash your practice actually holds.
If your dispensary had a busy Saturday with £4,200 in payments and £380 in refunds, the Payments report shows £4,200. The Net Payments report shows both sides and nets to £3,820 — the figure that should match your till or payment terminal reconciliation.
This report is particularly useful:
At month-end, when you need net revenue figures for your accounts
When investigating a discrepancy between your payment terminal totals and Lupa
Any time a client has been refunded and you want to confirm the net position for that day or period
How to run the Net Payments report
From the main menu, go to Reports.
Select Net Payments from the list of available reports.
Set your Date range — choose the start and end dates you want to review.
If your practice has more than one site, use the Store filter to narrow results to a specific location or leave it set to all stores.
Click Run (or Apply) to load the report.
What you'll see
The report displays one row per completed payment and one row per completed refund that was issued against a payment. Each row shows:
Column | What it contains |
Type | Either payment (money in) or refund (money out) |
Date | The date of the original payment, in your clinic's local time |
Amount | The positive value of that row's cash movement |
Net amount | Positive for payments, negative for refunds — sum this column to get net cash captured |
Method | How the payment or refund was processed (e.g. card, cash) |
Client | The client the payment is linked to |
Employee | The team member who initiated the payment |
Store | The site the payment belongs to |
Transaction reference | The external reference from your payment terminal |
Refund rows are attributed to the same date and store as the original payment they reverse, so they always net against the correct period even if the refund was processed on a different day.
Tips
Reconciling a specific day: Filter to a single date and sum the Net amount column. This figure should match the net settlement amount from your payment terminal for that day.
Refunds not shown here: The Net Payments report covers refunds that are directly linked to a completed payment. Refunds applied as account credit or against a credit note are not included, because they do not reverse a specific payment that came in.
Date accuracy: Payments are shown on the calendar date your clinic recorded them, based on your local time zone. This means a payment taken late in the evening will always appear on the correct local date.
Exporting: Use the export option to download the report as a CSV if you need to share figures with your accountant or import them into your accounting software.
Frequently asked questions
How is the Net Payments report different from the Payments report? The Payments report shows every completed payment as a single positive row — it is a gross view. The Net Payments report adds a corresponding row for each refund issued against those payments, with a negative net amount, so you can calculate the true cash position for a period.
Why does a refund appear on the date of the original payment, not the date I issued it? Refunds are attributed to the date of the payment they reverse. This keeps the net figure accurate for the period the money came in — if you refund a payment from last Tuesday, the net for last Tuesday changes, which is the correct accounting treatment.
A refund I issued is not appearing in the report. Why? Check whether the refund was applied as account credit rather than directly against a payment. Account-level and credit-note refunds are not included in this report because they are not tied to a specific payment that came in. You can review those separately in the client's account history.