Reports
The Reports page shows how your membership and your money are doing over any period, and every table on it downloads as a spreadsheet. The Payments page lists every payment your chamber has taken.
The short version
- Pick a period: the last 7 days, 30 days, 90 days, 12 months, or your own from and to dates.
- Money in covers dues, events, sponsorships, net of refunds.
- Renewal rates are worked out from payment history. Members who left come from status changes.
- Every section has a CSV link.
- Owners, admins, staff and board can see reports. Volunteers can't.
Choosing a period
Open Reports in the sidebar. Across the top, pick 7 days, 30 days, 90 days, 12 months, or set the From and To dates for your own range. Reset goes back to the last 12 months, which is what the page shows at first. Days are your chamber's calendar days.
Tables over time group themselves to suit the length: by day for a month or less, by week (Monday to Sunday) up to about six months, and by month beyond that.
The headline numbers
- Active members right now, and how many are lapsed.
- New members: members whose join date falls in the period.
- Collected: money in over the period, net of refunds, split by source.
- Renewal rate: of the renewals that came due and have been decided, how many were paid.
- Members who left: active members who lapsed or were cancelled in the period.
- Outstanding dues: what members past their renewal date owe now.
- Sponsor balances: what sponsors still owe.
- Next 90 days: dues coming up from renewals, and how much of it is on autopay.
Money in
The Revenue by month section (or by week or day, for shorter periods) is a bar for each day, week or month, split into Dues, Events, Sponsorships, with a table underneath. Each source is counted this way:
- Dues: dues payments, on the day they were paid.
- Events: paid event registrations taken online, by cash or by check, on the day (your chamber's time) the registration was confirmed. A canceled online registration still counts, less whatever was refunded. A canceled cash or check registration is treated as handed back. Complimentary and free registrations add nothing.
- Sponsorships: sponsorship payments, on the day they were paid.
Refunds count against the original payment's date. A refund lowers the net of the period the payment was made in, not the period it was refunded in. Under the table, the money is also broken down by payment method.
The Events section lists events held in the period with registrations, attendees, how many checked in, ticket money and sponsorship. Sponsorships by package and Sponsor balances cover sponsors. See Events and Sponsorships.
Renewals and the renewal rate
The Renewals section lists the renewals that came due in each period and whether they were paid. It's rebuilt from your payment history: every dues payment records the renewal date it paid from and the next one it set, so Pilaster knows each date a member was due and whether a payment covered it.
- Renewed: a payment covered that renewal date.
- Not renewed: unpaid once your grace period is over, or the member was cancelled.
- Pending: unpaid, but still inside the grace period.
The renewal rate is renewed divided by renewed plus not renewed. Pending renewals aren't counted either way until they're decided. The grace period is the one your chamber set for lapsing (see Renewals).
Overdue and lapsed lists members who owe dues now, most overdue first, with what they owe and when they last paid.
Members who left
Recently left shows active members who lapsed or were cancelled in the period. It comes from the record Pilaster keeps of every status change. Members your team archived (a duplicate, a bad import, a business that closed) are counted apart and never as leaving.
Status changes are recorded from when this record started for your chamber. If your period begins earlier, the page says "tracked since" with the date, and the count only covers changes after it.
Members by tier and industry
Members by tier shows active and lapsed members at each membership level, and the yearly dues of the active ones at each level's current price. Members by industry counts active members by industry. Both are as things stand now, whatever period you pick.
Recruitment
Recruitment shows the prospects added, joined and lost in the period, by where each lead came from, what the ones that joined are worth a year, and how many days joining took on average. It also says how many prospects are open now and what they're worth. Prospects are never counted as members anywhere else in Reports. See Recruiting new members.
Downloading CSV files
Each section has a CSV link that downloads its table for the period you're looking at. Where the page shows only the first few rows, the CSV has them all. The money section also links to separate downloads of dues payments, event payments and sponsorship payments. Export Members at the top downloads every member with their main contact.
Cells that start like a spreadsheet formula are made safe, so opening a file in Excel never runs anything.
The Payments page
Payments in the sidebar lists every payment, newest first: dues, event tickets and sponsorships, counted by the same rules as Reports, so the two agree. Its subtitle shows what's been collected this month, net of refunds.
- Tabs for All, Dues, Events and Sponsorships, and a filter by method.
- Search by name, reference or receipt number.
- Refunds and disputes show on the row.
- Each row opens where that payment is managed: the member, the event, or the sponsorship's payments.
For recording and deleting dues payments, see Dues.
Who can see reports
Reports are read-only. Owners, admins, staff and board can open the Reports page and download its files. Volunteers see Reports locked in the sidebar. The Payments page is open to the same roles; changing a payment there takes an owner, admin or staff role.