Balance Sheet Reconciliations for Private Clubs: The Accounts That Go Wrong

Most club accounting problems show up on the balance sheet first. The income statement can look reasonable for months while unreconciled clearing accounts, stale member deposits and mismatched payroll liabilities build up underneath. Then the audit starts, or a new controller arrives, and the club learns the true numbers.

This guide covers the club balance sheet accounts that most often go wrong, how to reconcile them, and what a monthly reconciliation package should include. It pairs with our club month-end close checklist.

Key takeaways

• Clearing accounts, member AR, deferred dues and payroll liabilities go wrong most often.
• Every reconciling item should be dated, explained and assigned to someone to clear.
• A preparer and a separate reviewer should sign each reconciliation.
• Clubs that keep reconciliations current usually have shorter, cheaper audits.

What a balance sheet reconciliation is

A reconciliation proves that the general ledger balance for an account agrees with an independent source: a bank statement, a subsidiary ledger, a payroll report or a detailed schedule. Every reconciling item should be explained, dated and cleared within a reasonable time. A reconciliation with a growing list of old unexplained items is not reconciled.

The club accounts that go wrong most often

• Cash and credit card clearing. POS batches, merchant fees, chargebacks and timing differences pile up in clearing accounts when nobody matches deposits to batches daily.
• Member accounts receivable. The aging in the club management system should agree to the general ledger. Differences usually come from manual journal entries posted to AR in the ledger without a matching member charge.
• Deferred and prepaid dues. Annual or quarterly billing creates deferred revenue that must be released each month. Errors here move revenue between years.
• Initiation fees and refundable deposits. Deferred initiation fees and refundable membership deposits need a member-level schedule that ties to the ledger.
• Gift cards, house accounts and member credits. Outstanding balances should match a detailed listing.
• Payroll liabilities. Accrued wages, tax withholdings, benefits and garnishments should agree to payroll provider reports and clear when paid.
• Tips and service charges payable. Amounts collected for staff should clear each pay period.
• Sales tax payable. Should agree to returns filed and clear when paid.
• Inventory. F&B and pro shop inventory should agree to physical counts.
• Fixed assets and construction in progress. CIP balances should tie to active project listings and move to fixed assets when projects finish. See club capital asset inventory.
• Reserve and designated funds. Board-designated reserve balances should tie to bank or investment statements and to board resolutions.

How often to reconcile each account

Not every account needs the same attention. The schedule below works for most clubs.

What a good reconciliation package looks like

• One reconciliation per account with the ledger balance, source balance and a list of reconciling items.
• Each reconciling item dated, explained and assigned to someone to clear.
• Preparer and reviewer sign-off with dates. The reviewer should be someone other than the preparer.
• Supporting documents attached or linked.
• A one-page summary showing every account, its status and the age of open items.

Reconciliation matching tools can do much of the routine work; see club accounting automation. Auditors look for exactly this package. A club that keeps it current every month usually has a shorter, cheaper audit. See why club audit fieldwork stalls.

Catching up on reconciliations that are months behind

Start with cash. Reconcile the most recent month first to establish a reliable current balance, then work backward only as far as needed to explain the difference. Next, tackle member receivables and deferred revenue because they affect member statements and revenue. Then payroll liabilities, sales tax and the rest.

Write off nothing without understanding it, and bring any material adjustments to the finance committee with an explanation. A catch-up project for a club several months behind typically takes four to twelve weeks depending on volume and records. Our club accounting cleanup service is built for this.

Common questions

Which club balance sheet accounts should be reconciled monthly?

At minimum: cash, credit card clearing, member receivables, deferred dues and initiation fees, payroll liabilities, sales tax payable, inventory and reserve or investment accounts.

Why doesn't our member AR aging match the general ledger?

Usually because journal entries were posted directly to AR in the ledger without matching member charges, or because system interfaces failed for a period. Each difference needs to be traced to a source.

Who should review club reconciliations?

Someone other than the preparer, typically the controller or club CFO, with sign-off and dates on each reconciliation.

How long does it take to catch up on unreconciled accounts?

For a club several months behind, a catch-up project typically takes four to twelve weeks depending on transaction volume and the quality of records.