When to use it
- Close the day - a climbing gym’s manager opens Activity at closing time and checks that Total Billed, Collected, and Due now match the till.
- Chase old debt - a martial arts school opens Amount Due, sets Owed for to 3 months, and exports the PDF as a call list for the month.
- File a VAT return - a padel gym opens Tax for last quarter, grouped by Tax rate, and copies the totals into its return.
- Separate two companies - a gym that sells through two billing entities narrows Tax to one of them to file each company’s return.
Reports in this category
All three follow the club selected in the breadcrumb. Amount Due also needs permission to read billing. For how the money figures are counted, see Analytics definitions.
Activity
Analytics > Finance > Activity lists the charges of a period, newest first, each joined to what it was for. It is the same feed as a member’s Activity tab, for the whole gym. It always opens on Today and offers only short periods (today, yesterday, this or last week, this or last month, the last 7 or 30 days); a custom range can be up to 31 days. Three figures head the list, for staff who can read billing:- Total Billed - what the period’s charges billed.
- Collected - payments received in the period, whatever they paid for.
- Due now - what is owed now. The part not due yet, such as a booking still ahead, is shown under it as upcoming.
Amount Due
Analytics > Finance > Amount Due shows who owes your gym money and for how long, as of today. Use it as a collections list. It has no period; the date it was read is shown above the table.Rows
Switch Rows on the filter bar:- By household (the default) - one row per account that receives a statement, with every member’s charges added together, as the household’s statement bills them.
- By person - one row per person.
Filters
- Owed for (under Filters) - only the rows owing for at least 1 month, 2 months, 3 months, or 4+ months. The totals and the export follow it.
- Billing entity - only one company’s money, when your organization has two or more billing entities.
Summary and table
Above the table: Due now (the total owed), 3+ months (the part owed for three months or more), Owing (how many rows owe something), and Wallet (the Wallet funds held).
The Wallet sits beside the debt and is never subtracted from it: someone who owes 100 and holds 100 in their Wallet still shows as owing 100. With All clubs selected, people who only hold Wallet funds are listed too, after everyone who owes. The Wallet column is hidden when you narrow the report to a billing entity other than the default one, because the Wallet belongs to the default company.
Expand a row to see its charges, each under the column of its age and linking to what it was for. Sort by any column; the report opens with the largest debt first.
Export downloads the list as Excel, CSV, or PDF. The PDF is laid out to hand to your accountant.
Tax
Analytics > Finance > Tax adds up a period’s sales the way a sales tax or VAT return asks for them. It opens on Last month; a custom range can be up to a year.Layout
Two controls above the table set its layout:- Sections - group the sales by Revenue account (the default), Tax rate, or Club.
- Rows - one row per Day (the default) or per Month within each section.
Columns
A sale counts on the day it was made, at what it is worth now: a cancelled, refunded, or re-priced sale is counted at its current value. So the report agrees with the other money reports for the same days.
Filters and export
Narrow the report with the club in the breadcrumb, and with Billing entity and Revenue account under Filters when your organization has more than one of either. Export offers two downloads, each as Excel or CSV: the Summary (the table as shown) or the Charges (every sale behind it).Worked examples
Closing the day at a climbing gym
At 22:00 the duty manager opens Activity on Today. Collected shows 1,240, and the card terminal and cash drawer add up to the same. Two rows read Unpaid: day passes sold at the desk that were never paid. The manager opens each member’s profile from the row and takes the payment before leaving.Collections at a martial arts school
On the first of the month, the owner opens Amount Due By household and sets Owed for to 2 months. Eight families owe 2,300 between them. Expanding one row shows three unpaid monthly charges and a Wallet of 50 the family forgot about. The owner exports the PDF for the office manager to call through.A quarterly VAT return for a padel gym
The bookkeeper opens Tax with the period on Last quarter, Sections on Tax rate, and Rows on Month. The standard-rate section’s subtotal and the reduced-rate subtotal go straight into the return, and the Charges export is kept as the working papers.Tips and best practices
- Set tax rates on everything you sell. A sale with no rate lands under No tax rate and in Non-taxable; see Tax rates.
- Read Amount Due by household for families. Parents get one statement for their children, so call them about one total.
- Use Owed for, not sorting, for a call list. It narrows the export too.
- Re-run Tax after late changes. A sale refunded after you filed changes the period it was made in, because it counts at what it is worth now.
Troubleshooting
Related
- Analytics overview - Filters, comparisons, and exports.
- Revenue analytics - Revenue, payments, and invoices over time.
- Sales > Finance > Charges - The charges behind these reports.
- Wallet - Wallet funds and how members spend them.
- Billing entities - Selling through more than one company.