Reports and CSV exports

Open Reports to review membership, money, payments, bonds, receivables, and program information. Choose a report, set the dates or filters, then review the results before exporting.

When Guided reports and dashboard is enabled in Club → Staff & tools, Money → Reports opens the dashboard. Finance tools still opens the existing finance tabs. Your old saved links continue to work.

Use Find a report to start with Who has renewed? or Who still owes money? Choose Break down by, then apply filters. Different filters must all match; several values within one filter mean any of those values. The chart and table show the same answer. Select a labeled record count to see its matching records. Filters and the display choice survive reload and Back.

Renewal progress counts prepared renewals, not every potentially eligible household. Renewed means the renewal record is paid. Leaving and ended renewals remain in the prepared total. A renewal-status filter narrows the records while the progress percentage keeps its period, membership-type and residency population. How this is calculated explains the counts. The period number is the recorded renewal period; current club settings do not rename older periods. Unpaid bills show today's balances, with payments on their way shown separately. Without a due date, age is estimated from when the bill was sent or created and marked as an estimate.

Save report remembers your choices, not a copy of the results. It defaults to Only me. Managers and admins can share their own reports with eligible staff in the same club. Opening a shared report still requires permission to its data. Save a copy leaves the original alone. A saved renewal period stays fixed; change it when you want another period. When editing your own saved report, choose Update report to replace its choices; Save a copy creates a separate report. A confirmation names the report and links to the saved view.

Download CSV asks whether you want the summary or all matching records, including household names. Review the choices before confirming. Download the calculation notes alongside the CSV to keep its filters, time basis and creation time. The file is prepared using current data, so it can differ from a screen opened earlier. Reports with more than 10,000 source records ask you to contact support; filters cannot bypass that limit. If only the download is too large, narrow its filters and try again. Downloads include every matching record, not just the first page. Repeated attempts may ask you to wait a minute. A connected tool must get your approval before preparing an export. Files are returned once, not saved as permanent download links.

Reports is under Money. Treasurers, managers and admins can open it. A strip at the top shows active memberships, dues collected, the unpaid bills total and how many households have renewed. Six tabs sit below it:

• Dues and unpaid bills: dues billed, collected, credits applied and still outstanding for a renewal year (arrows switch year), then Unpaid bills by age, the open invoices by how late they are, each with its household and days late. Download CSV gives you the aging list.

• Statements: how many households have had their annual statement. Treasurers and admins can start or pause the send here. Starting it asks you to confirm and says how many households it will email; households that already received their statement are skipped. See Household statements. A connected AI tool can do the same: starting the send waits for your approval on the website, and pausing only needs a confirmation in the tool.

• Bond money held: how much bond money the club owes back today, how many households hold a bond, and what has been received, refunded or kept, with a household-by-household list. Download CSV gives you the list. A household whose joining payment the bank took back can still be listed with part of a bond: the bond counts only the money the club still holds on their joining invoice, and goes back up to the full amount when they pay again. A household that never finished paying its joining invoice has no bond yet.

• Credits & refunds: a month's review of credits issued, credit given back from cancelled bills, credit paid out by check, credit back from voided refund checks, invoice adjustments (late fees, waivers, corrections), card refunds, manual check or cash payments, and refund checks queued. Below the review, treasurers and admins get Open the check run to work the approved refund checks. Managers can't open the check run, so they see the approved checks here instead, with a Download CSV of that list.

• Payouts: for a month, each Stripe bank deposit tied back to the member payments in it, net of fees. Reconciliation CSV downloads it. Payouts are copied from Stripe every night, so a very recent one may not be there yet.

• Month-end close: the treasurer's month-end checklist and, under Close or reopen a month, the list of months. A month can be closed only after it ends, and Close makes its books final, so nothing new can be dated inside that month. Closing asks you to confirm, names the month and says what it locks: nothing new can be dated inside it (for example, a check can't be marked cleared or returned on a day in that month), while anything dated later is not affected. Send the Journal for your accountant (CSV) (the general ledger, or GL, export) to your accountant first. In the journal, a payment the bank took back shows as its own minus row in the month it was taken back; for a check marked returned after it cleared, that is the returned date you entered, not the day you recorded it. Reopen needs a reason. Only treasurers and admins see the close and reopen buttons. A connected AI tool can close or reopen a month too, but each one waits for your approval on the website first.

Use receivables reports for unpaid balances, payment reports for reconciliation, and membership reports for household and tier counts. Use the bond report before approving bond refunds. Exports download the records shown by the current report filters.

Account credit is money the club owes a household until it is used. In that journal it has its own lines, all in the credit category, each dated on the day it happened:

• credit_issued (a minus amount): credit given to a household.

• credit_applied (a plus amount): credit used to pay a bill.

• credit_given_back (a minus amount): a bill was cancelled, so the credit used on it went back to the household.

• credit_paid_out (a plus amount): credit paid to the household by check. The check itself is its own line when it is mailed.

• credit_payout_voided (a minus amount): the refund check that credit was paid out in was voided before it was mailed, so the credit went back on the household's account. It is dated the day the check was voided.

• credit_taken_back (a plus amount): unused camp lottery credit removed because the payment that paid for it was reversed.

Added up over every month, the credit lines equal the credit households still hold, shown as a minus amount. Earlier versions of the journal printed only credit_issued. If you download a month again that you exported before these lines were added, it will show credit_applied lines your earlier copy did not have.

In the monthly review, Credit given back from cancelled bills lists each cancelled bill whose credit went back, Credit paid out by check lists credit refunded by check, with the reason it was paid out (for a relinquishment, the season), and Credit back from voided refund checks lists credit that went back on the account because its refund check was voided.

In the monthly review, Refund checks queued links each household to its Billing & bond tab and shows each check's status in plain words. Treasurers and admins also get a link to open the check run. Managers can see the list but not the check run itself.

Reports are snapshots. Open the related household or invoice when you need to correct a record. Do not use an export to change financial history. See Invoices, payments, and credits.