Skip to main content

Introduction to Club Financials in Sprocket

Get an overview of how Club Financials work in Sprocket, including payment tracking, reporting, permissions, and the core tools bookkeepers use for reconciliation and month-end close.

Updated over a week ago

Sprocket’s Club Financials tools are designed to help bookkeepers and finance teams track revenue, member payments, and reporting in a way that supports your club’s accounting needs.

Sprocket supports both cash-basis and accrual-basis accounting methods. The accounting method your club operates under determines which revenue reports you should use and how revenue appears in reporting.

This collection covers how to manage financial setup, reporting, accounting classes, surcharges, accrual periods, connected accounts, write-offs, and reconciliation workflows.

What you’ll find in this article

  • How finance teams typically use Sprocket day to day

  • The key areas of Sprocket that support accounting and reporting

  • The minimum permissions a bookkeeper usually needs

  • The most common finance reports to run

Who this is for

This article is written for club bookkeepers and finance teams who support:

  • Recording and reviewing payment activity

  • Tracking outstanding balances

  • Running cash-basis or accrual-basis reporting

  • Supporting month-end close and season-end reconciliation

  • Preparing journal entries and exporting reports for external bookkeeping systems

How club financials are organized in Sprocket

Most finance workflows in Sprocket fall into a few buckets.

1) Payment activity and member balances

Use this when reviewing what families paid, what is still owed, and how payments are applied across registrations or invoices.

This includes reviewing what families paid, what is still owed, and how payments are applied across registrations or invoices.

Key tools in this collection include:

  • Payment and account history views

  • Credits, discounts, and financial aid tracking

  • Writing off bad debt for uncollectible balances

2) Club financial reporting

Use this when validating revenue, reviewing trends, exporting accounting data, or reconciling deposits.

Reporting helps you validate revenue, review trends, and export data for your accounting process. Sprocket supports both cash-basis and accrual-basis views, depending on how your club operates.

Core reporting topics covered in this collection include:

  • Revenue Transactions reports (RTAC and RTCC)

  • Cash Transaction Detail and Summary

  • Accounting Classes and Surcharges

  • Accrual Periods

  • Custom and Scheduled Reports

3) Administrative finance tools

Use this when configuring financial structure, managing write-offs, or reviewing connected account setup.

Depending on your setup, this can include:

  • Invoicing and invoice items

  • Financial aid budgeting and usage

  • Discounts and credits

  • Managing write-offs for uncollectible balances

  • Managing connected accounts and Stripe payouts

You’ll see deeper step-by-step guidance on each of these topics throughout the rest of the Club Financials collection.

Daily workflows that finance teams commonly handle

While every club is a little different, most finance users do a mix of the following:

  • Monitor payments received and outstanding balances

  • Review transaction-level detail when questions come in from families

  • Validate revenue by program, season, accounting class, or date range

  • Support refunds, credits, discounts, and financial aid reporting

  • Reconcile deposits and payouts when connected accounts are used

  • If reconciling payouts, start with Cash Transaction Detail filtered by Reimbursement Date.

  • Prepare month-end close reporting, including validating accrual or cash-based revenue totals

  • Export reports to support journal entry preparation and external bookkeeping workflows

Roles and permissions for bookkeepers

In Sprocket, bookkeepers are typically set up as Club Admins, but they do not need full Club Admin access.

Most bookkeepers need access to financial reports, transaction detail, AR reporting, and dashboard financial visibility.

The permissions below represent the minimum required for day-to-day reporting and reconciliation workflows.

Additional permissions can be added based on your organization’s structure.

Minimum recommended permissions (bookkeeper)

Dashboards Permissions

  • Dashboards

  • Club Dashboard

  • Financial Information on Club Dashboard

  • Team Dashboard

  • Program Overview Panel

Calendar Permissions

  • Calendar

  • Club Calendar

  • Calendar Settings

  • Admin List

  • Vacation Tracking

Club Admin Permissions

  • Club Admin

  • Club

  • Settings (Leave Rosters and Facilities unchecked unless they specifically need them.)

User Admin Permissions

  • User Admin

  • Profile

  • Account History

  • Programs

  • Payments

  • Account Options

  • Notes

  • Files / File Cabinet

  • Staff Profile (Roles & Permissions should remain unchecked for most bookkeepers.)

Player Admin Permissions

  • Player Admin

  • Profile

  • Programs

  • Current Registration Signup Credits & Discounts Apply Refund

  • Payments

  • Write-Off Bad Debt

  • Credits

  • Special Registration

  • Custom Payment Plans

  • File Cabinet

  • File Cabinet – Proof of Age (Leave Player File Tracking, Player Notes, Player Feedback, College Profile, Notes, Forms Admin, and Prospects unchecked unless needed.)

Credit/Discount Admin Permissions

  • Credit/Discount Admin

Financial Aid Admin Permissions

  • Financial Aid Admin

Invoicing Admin Permissions

  • Invoicing Admin

  • Invoices

  • Invoice Items

  • Invoice Settings

Make Payments While Impersonating Permissions

  • Make Payments While Impersonating

Reports Permissions

  • Reports

  • The specific reports your club uses (see below)

Communications Permissions

  • Communications

  • Admin Communication

  • Coaches Team message Communication

  • Contact Form Submissions Page

The most common reports bookkeepers run

Most finance users rely on a small set of core reports for day-to-day support and month-end review.

Revenue Transactions reports

These are commonly used as the primary revenue view, depending on your accounting method:

  • Revenue Transactions for Accrual Clubs (RTAC) for accrual-basis clubs

  • Revenue Transactions for Cash Clubs (RTCC) for cash-basis clubs

Transaction-level review

  • Cash Transaction Detail for line-by-line payment visibility when reconciling or investigating questions

  • Cash Transaction Summary for a summary view of payments received

  • Additional reports covered in this collection include AR Aging, Outstanding Payments, Team Finance, Financial Aid, Credits, Discounts, and Donations.

Next steps

If you’re setting up a finance user for the first time, start here next:

If you run into any issues with access or missing reports, double-check the permission set above, then review the “Common issues and how to resolve them” article in this collection.

FAQs

Which report matches Stripe deposits?

To match Stripe payouts to your bank deposits, use Cash Transaction Detail filtered by Reimbursement Date. The Reimbursement Date reflects the payout date used for reconciliation.

Did this answer your question?