Sprocket’s Club Finance reports help bookkeepers and finance teams monitor revenue, manage Accounts Receivable (AR), reconcile payouts, and support period close. This article outlines the available reports, what each one is best for, and how to choose the right report for the question you are trying to answer.
What you’ll find in this article
Where to find Club Finance reports
How report visibility works (permissions)
A quick guide to each Club Finance report and when to use it
Tips for consistent reporting during reconciliation and close
Where to find Club Finance reports
You can run financial reports by going to Reports and selecting the report you need from the Club Finance section.
Report visibility depends on permissions
Each Club Finance report has its own permission tied to visibility. That means a staff member may see some finance reports but not others, even if they can access the Reports area.
If you cannot find a report listed below:
Confirm your role includes Reports access
Confirm you have the specific permission for that individual report
Tip: If you are setting up a bookkeeper role, use the minimum finance permissions guidance in the “Introduction to club financials in Sprocket” article.
Choose the right report based on your accounting method
Start by confirming whether your club is cash-basis or accrual-basis:
Accrual-basis clubs typically use Revenue Transactions for Accrual Clubs (RTAC) for revenue reporting
Cash-basis clubs typically use Revenue Transactions for Cash Clubs (RTCC) for revenue reporting
If you are unsure which method your club uses, check Club > Settings or reach out to your Client Success Team.
Club Finance reports and when to use each one
AR and collections
AR Aging
Best for: Understanding outstanding balances by age so you can prioritize collections and follow-up.
Outstanding Payments
Best for: Seeing who owes money and how much, typically used for collections workflows and AR cleanup.
Bad Debt Write-Off
Best for: Reviewing balances written off as uncollectible.
Note: For the full write-off workflow, follow the Payments collection article titled “Writing Off Bad Debt”
Revenue reporting
Revenue Transactions for Accrual Clubs (RTAC)
Best for: Accrual-basis revenue reporting, period close, and fiscal year review.
Tip: RTAC includes surcharge fields such as Surcharge and Amount Subject to Surcharge.
Revenue Transactions for Cash Clubs (RTCC)
Best for: Cash-basis revenue reporting based on actual payments collected.
Tip: RTCC includes surcharge fields such as Surcharge and Surcharge Amount.
Payment and transaction research
Cash Transaction Detail
Best for: Line-by-line payment research and reconciliation.
Also useful for: Payout reconciliation when filtering on Reimbursement Date.
Cash Transaction Summary
Best for: A rolled-up cash view when you do not need line-by-line detail.
Note: This report includes a Surcharge Amount column but does not include the surcharge name.
Credits, discounts, and refunds
Credit Summary
Best for: Understanding credits issued and applied, including totals and trends.
Discount Summary
Best for: Reviewing discounts applied across registrations or invoices, useful for audit and reconciliation.
Refunds
Best for: Tracking refunds processed and confirming refund activity for close.
Invoicing
Invoice Details
Best for: Reviewing invoiced charges and payments, especially if your club uses invoicing for collections outside of standard registration checkout.
Financial aid
Financial Aid Budgeting
Best for: Planning and managing financial aid budgets.
Financial Aid Usage
Best for: Reviewing how financial aid has been applied, including totals and utilization.
Donations
Donations
Best for: Tracking donation revenue and donation-related reporting.
Team-level finance
Team Finance
Best for: Team-level financial summaries when teams have finance activity tied to them.
Team Finance Details
Best for: Transaction-level detail for team finance activity.
Reporting tips for period close and compliance
Keep your date range logic consistent across reports, especially when comparing totals.
Use the Accounting Class filter when you need to reconcile revenue by category, team, or bookkeeping class.
For payout reconciliation, start with the Admin Dashboard Payouts panel, then validate using Cash Transaction Detail filtered by Reimbursement Date.
Next steps
If you need help saving, scheduling, or sharing report runs, continue to Custom & Scheduled Financial Reports.
If a report is missing, confirm you have the specific report permission, then review Best practices for club finance teams or Common issues and how to resolve them in this collection.
FAQs
Where do I find Club Finance reports?
Go to Reports and select the report you need from the Club Finance section. Visibility depends on your individual report permissions.
How do I know whether to use RTAC or RTCC?
Accrual-basis clubs typically use Revenue Transactions for Accrual Clubs (RTAC). Cash-basis clubs typically use Revenue Transactions for Cash Clubs (RTCC). If you are unsure, check Club > Settings or contact your Client Success Team.
Why can’t I see a specific finance report?
Each Club Finance report has its own permission. Confirm you have Reports access and the specific permission for that individual report.
Which report should I use for payout reconciliation?
Start with the Admin Dashboard Payouts panel, then validate totals using Cash Transaction Detail filtered by Reimbursement Date.