Revenue by Payment Type Report
Tutorial 9.9: Revenue by Payment Type Report
Introduction
The Revenue by Payment Type report splits your takings across the four payment methods Luminate supports — Cash, Card, Gift Voucher, and Other — for any date range you choose. It shows what you collected, what you refunded, the net amount, and each method's share of total revenue. This is the report to reach for when you're reconciling banking, comparing card vs cash mix month-on-month, or spotting an unexpected drop in voucher redemptions.
Who this is for: Owner, Admin, Manager What you'll learn:
- Open the Revenue by Payment Type report
- Read the four summary cards at the top
- Interpret the Net Revenue by Payment Method bar chart
- Read the breakdown table (Collected, Refunded, Net Amount, % of Total)
- Sort the table and adjust the date range
- Export the data as a CSV
Time to complete: 5–10 minutes
Prerequisites
- Logged in as Owner, Admin, or Manager
- At least one completed transaction in the date range you want to view (otherwise the report shows zeros)
- For exporting: Owner or Admin role
Step-by-Step Instructions
Step 1: Open the Report
- Click Reports in the sidebar
- Under Financial Reports, click Revenue by Payment Type
- The report opens with a default date range applied
The page header reads "Revenue by Payment Type" with the subtitle "Revenue and refunds split by payment method".
Step 2: Adjust the Date Range
Use the Date Range card below the header to change the period:
- Click the start date and end date pickers
- Click Apply to update the report
- Click the reset button (circular arrow icon) to return to the default range
The same preset buttons available on other reports work here — Today, This week, Last week, Last 7 / 30 / 90 days, This month, Last month, This year, Last year. Click any preset to apply it instantly.
Tip: Use Last month at the start of each month to reconcile the previous month's takings against your bank statements and card terminal reports.
Step 3: Read the Summary Cards
Four summary cards appear above the chart, each showing a single headline figure for the selected date range:
| Card | What It Shows |
|---|---|
| Net Revenue | Total collected minus refunds across all payment methods |
| Total Collected | Sum of every payment received (gross, before refunds) |
| Total Refunded | Sum of every refunded payment |
| Transactions | Number of completed transactions in the range |
These cards are independent of the breakdown table — they always cover the entire date range, even if you've sorted the table.
Step 4: Read the Bar Chart
Below the summary cards, the Net Revenue by Payment Method bar chart visualises the net revenue for each method side-by-side. This is the fastest way to see your revenue mix at a glance — for example, a salon that takes 80% by card and 20% by cash will see two bars of very different heights.
- Hover any bar to see the exact net revenue for that method
- The chart hides itself when no method has positive net revenue (e.g. a date range with only refunds)
Step 5: Read the Breakdown Table
The Payment Method Breakdown table lists all four payment methods on separate rows, even when one of them has no activity in the range (a zero row helps make it obvious that no card payments were taken, rather than the row being missing).
| Column | Description |
|---|---|
| Payment Method | Cash, Card, Gift Voucher, or Other |
| Transactions | Number of completed transactions paid (in part or full) by this method |
| Collected | Total amount received via this method during the range |
| Refunded | Amount refunded against this method (shown in red with a minus sign when greater than zero) |
| Net Amount | Collected minus Refunded — your actual takings for this method (bold) |
| % of Total | This method's share of overall net revenue, to one decimal place |
Sorting: Click any column header to sort the table by that column. Click again to reverse the sort order. The default sort is Net Amount descending, so your largest revenue source appears at the top.
Step 6: Export to CSV
To export the breakdown for accounting or further analysis:
- Set the date range you want to export
- In the Payment Method Breakdown card, click the Export button (top right of the table card)
- Click Export as CSV
- The file downloads to your computer with a filename like
payment-type-report-2026-04-01-to-2026-04-30.csv
The CSV contains the same six columns as the on-screen table.
Note: Exporting is available to Owners and Admins only. Managers can read the report on screen but cannot download the CSV — ask an Owner or Admin if you need the file for accounting.
Understanding How the Numbers Are Calculated
A single transaction can include payments by more than one method (a split payment of £30 cash + £20 card, for example). The report treats each payment line independently:
- The £30 cash appears in the Cash row's Collected
- The £20 card appears in the Card row's Collected
- The transaction itself is counted once in the Transactions column for both methods (because both methods were involved in completing it)
That's why the sum of the Transactions column can be higher than the Transactions summary card — split payments are counted in each method's row, but only once at the salon level.
Refunds: A refunded transaction's payments appear under Refunded for the original method. So a £45 card payment that's later refunded shows as £45 Collected and £45 Refunded for Card, with a Net Amount of £0.
Date filter: The date range applies to the transaction's completed timestamp in the salon's local timezone — not to the payment timestamp. A transaction completed on the last day of April with a refund processed in May will show its collection in April's report and its refund in May's.
Common Pitfalls
"The figures don't match my Daily Revenue report"
Daily Revenue reports your service and product revenue (after discounts, before payment splits). This report reports the payments themselves — gross amounts received. If a £100 transaction had a £20 discount and was paid £40 cash + £40 card, Daily Revenue shows £80; this report shows £40 Cash + £40 Card. They're different lenses on the same transactions.
"Why does Other have a value when I don't take Other payments?"
"Other" is used by some imports and integrations (e.g., older transactions imported from a previous system, online deposits, or alternative payments staff have categorised as Other in the POS). Filter on the Transactions list to investigate.
"A method I'd expect to see is missing"
The four methods are always shown, even with zero values. If you don't see Cash listed at all, refresh the page — the report may have failed to load. If the count is zero, no transactions in that range used that method.
"Refunds are showing in red but Net Amount is still positive"
That's correct — refunds are subtracted from Collected to produce Net Amount. As long as Collected exceeds Refunded for that method, Net Amount stays positive. The red colour highlights the refund line, not the row as a whole.
Tips and Best Practices
- Reconcile card takings monthly — Pick Last month and compare the Card row's Collected figure to your card terminal's monthly statement. Any discrepancy flags missing or duplicate captures
- Watch the cash mix over time — Run This year vs Last year to see how the cash share of your revenue is trending. A falling cash percentage often correlates with a more digital-first customer base
- Spot voucher redemption peaks — Run a wide range and look at Gift Voucher's % of Total. Big spikes around Christmas and February often follow voucher gifting season
- Investigate refund spikes — A high Refunded figure for one method (especially Card) is worth investigating — it could be a chargeback pattern or a staff member processing erroneous refunds
- Export for accounting — Use the CSV export at month end to feed payment-method totals into your accounting software's reconciliation flow
Related Tutorials
- Tutorial 9.1: Understanding Your Dashboard — Quick performance overview
- Tutorial 9.2: Running Revenue Reports — Daily revenue across services and products
- Tutorial 2.4: Processing Transactions — How payment methods are recorded at the POS
- Tutorial 2.5: Using the Cash Drawer — Cash payment reconciliation at the till
Frequently Asked Questions
Are deposits included in this report?
Yes. Deposits paid online or in salon are recorded as payments against the transaction, so they appear under whichever method was used (typically Card for online deposits).
Are tips included?
Yes. The Collected column reflects every payment received against the transaction, including the tip portion. To see tips broken out separately, use the Daily Revenue report (Tutorial 9.2) or the Staff Performance report (Tutorial 9.3).
What about taxes and discounts?
Both are captured at the transaction level, not the payment level — so they affect the headline transaction total but not how that total is split across methods. This report shows you the gross collected amounts.
Why is the Transactions summary card different from the sum of the table's Transactions column?
A split-payment transaction (e.g., part cash, part card) is counted once in each row's Transactions column but only once in the salon-level summary card. The summary card shows the number of unique transactions in the range.
Can I filter by staff member?
No. This report is salon-wide. To see payment-method splits per staff member, run the Staff Performance report (Tutorial 9.3).
Why doesn't a transaction I just paid for appear?
The report only includes transactions in Completed or Refunded status. Drafts, pending transactions, and unpaid invoices are excluded. Make sure the transaction has been completed (fully paid and saved) before expecting to see it here.
Last Updated: May 2026