Accounting Events
As products are sold and payments are processed, Clubspot will automatically make credits and debits in your COA to account for them. This guide explains which events in Clubspot impact accounting. You can replace our default accounts with your own via the Chart of Accounts section.
Income Accounts
Your sales or income accounts are credited in Clubspot the moment a sale takes place. This includes POS sales, registrations, or any other online purchases. Recurring charges like dues, facilities, or membership add-ons are credited to their respective income accounts when the invoice they are on is finalized and generated. Income accounts can be mapped to specific products, events, or POS locations. By default, all sales that are unmapped will be credited to 4000 - Sales. For more information on mapping, see our guide here.
Clubspot Default Accounts
Clubspot will automatically populate your chart of accounts with several default accounts needed to accurately track all transaction types. These accounts can be replaced by any existing accounts in your chart of accounts. To do so click into any of our default accounts, click Replace and select the account from your COA that you would prefer to use instead.
Code | Name | Description |
|---|---|---|
1000 | Cash | Funds deposited to your bank by Stripe, and recorded offline payments. |
1200 | Accounts Receivable | Receivables from all outstanding invoices and membership balances. |
1201 | Unbilled Accounts Receivable | Funds that have been added to members’ house accounts but have not been invoiced for. |
1202 | Asset Clearing | Any credits or debits applied to a member’s balance impact AR and Asset Clearing. Adding a credit to a member’s balance will credit AR and debit Asset Clearing |
220X | [Tax Rate Name] | Records funds from any tax rate that you create in Clubspot. |
3200 | Processing Fees | Fees paid to Stripe for payment processing. |
4000 | Sales | Our default Sales account for all transactions that are not mapped to other income accounts. |
5000 | Cost Of Good Sold | Records any cost of goods sold where a product has a cost of goods associated and there has been a sale. |
6900 | Bad Debt | Records the unbilled accounts receivable from a membership that has been canceled (Expired). |
7100 | Cash in Transit | Records online payments that have been successfully processed but not yet paid out to your bank account. When they are paid out a debit is made to Cash. |
1201 - Unbilled Accounts Receivable
When a sale is made that is added to a house account, Clubspot will make a corresponding debit to Unbilled A/R. Importantly, this debit takes place when the sale has been completed, but the invoice has not been finalized. Once an invoice is issued, a credit is made to Unbilled A/R and a debit is made to A/R. Debits to Unbilled A/R do not impact a member’s balance as they have not yet been billed for those charges.
1200 - Accounts Receivable (A/R)
When an invoice is finalized, Clubspot will make a debit to A/R. The corresponding credit will be applied to the sales account or to Unbilled A/R for house account charges included on that invoice. A credit is made to A/R once that invoice is paid or the member’s balance is reduced through a payment.
1202 - Asset Clearing
When an admin update is made to a member's balance, both AR and Asset clearing are updated. Asset Clearing is the sum of all manual debits and credits applied by an admin to a member’s balance.
7100 - Cash in Transit
Cash in Transit represents your current balance in Stripe. When an online payment like a card payment or an ACH direct debit is processed, you will receive those funds in your bank account in a bulk amount and at a slight delay depending on your payout frequency. To account for this delay, online payments that are successfully processed are debited to Cash in Transit. When Stripe completes a bulk payout to your bank account, Cash in Transit is credited, and your Cash account is debited.
1000 - Cash
Cash is debited when you receive a payout from Stripe or you mark a check or other offline payment as paid. For online payments, you will receive one debit to Cash matching the Stripe payout amount once it has been successfully paid out. Individual transactions to Cash will be debited for offline payments recorded in Clubspot.
3200 - Processing Fees
Processing Fees account for the portion of online transactions that Stripe (and the issuing banks and credit card companies) claims. When an online transaction is successfully processed, the Processing Fees account is debited, and the Cash in Transit account is credited. This reduces the amount that is paid out by Stripe.
Replace Clubspot Standard Accounts
Your chart of accounts in Clubspot is populated with a set of pre-existing, Clubspot standard accounts. Some examples are Sales, Cash, Accounts Receivable, etc. These are necessary to track all accounting transactions in our system.
If you’d like to quickly replace a pre-existing CoA default or a previously mapped account, you can do so by navigating to Reporting>Chart of Accounts. Then simply find the account you are looking to replace, then click the “replace” button in the right corner, and find the desired account. These accounts are required to track all possible accounting transactions, so if you don’t replace them, they will just remain as they were.
Common Transactions
Below are a few common transactions to note as examples.
A member charges their house account and then pays their invoice online.
Account # | Account Name | Debit Amount | Credit Amount | Comments |
|---|---|---|---|---|
4000 | Sales | 20.00 | Sale takes place | |
1201 | Unbilled A/R | 20.00 | ||
1201 | Unbilled A/R | 20.00 | Invoice finalized | |
1200 | A/R | 20.00 | ||
1200 | A/R | 20.00 | Invoice is paid | |
7100 | Cash in Transit | 20.00 | ||
7100 | Cash in Transit | 20.00 | Funds paid out | |
1000 | Cash | 20.00 |
An immediate payment with tax and processing fees.
Account # | Account Name | Debit Amount | Credit Amount | Comments |
|---|---|---|---|---|
4000 | Sales | 20.00 | Sale takes place | |
7100 | Cash in Transit | 22.00 | ||
2200 | State Tax | 2.00 | ||
3200 | Processing Fees | 0.94 | ||
7100 | Cash in Transit | 0.94 | ||
7100 | Cash in Transit | 21.06 | Funds paid out | |
1000 | Cash | 21.06 |
Applying a check to a member’s account.
Account # | Account Name | Debit Amount | Credit Amount | Comments |
1202 | Unbilled A/R | 5.00 | Payment Recorded | |
1200 | A/R | 5.00 |
