Skip to main content

QuickBooks and Member Splash

How to record Member Splash deposits in QuickBooks and categorize them by fee type with a monthly journal entry.

Member Splash already tracks every payment by fee type, so you don't need to enter individual payments in QuickBooks. Instead, record each deposit as uncategorized income, then use one journal entry, monthly or as often as you like, to split it into your income categories.

KEY CONCEPT: Use Member Splash for the details, such as who paid what and which memberships sold best. Use QuickBooks for your income totals by category.

Member Splash support can't give accounting advice. Check this approach with your treasurer or accountant before you use it.


Step 1: Record Deposits as Uncategorized Income

Online payments are deposited into your bank account, usually the day after they're made.

If your bank is linked to QuickBooks:

  1. Go to Transactions → Bank Transactions and select your bank account.

  2. Click the deposit marked For Review.

  3. Choose Uncategorized Income as the account and click Add. You can also set up a QuickBooks rule to do this automatically.

If your bank isn't linked:

  1. Click New and select Bank Deposit.

  2. For Received From, choose a vendor. Adding Member Splash as a vendor works well.

  3. Set the account to Uncategorized Income, enter the amount, and save.

Repeat for each deposit.


Step 2: Get Your Totals by Fee Type from Member Splash

  1. Go to Finances → Sales Summary.

  2. Switch to Date Paid and choose the dates you're categorizing, such as last month.

  3. Turn on Show Only Summary Rows to see one total per fee type.

See Sales Summary. To match individual deposits to the payments in them, use Finances → Batch Reports. See Batch Reporting.

NOTE: ACH payments can take several business days to reach your bank after they settle, so they may land in a later deposit. A payment can also be returned if the member's account doesn't have enough money.


Step 3: Categorize with a Journal Entry

  1. In QuickBooks, click New and select Journal Entry.

  2. Set the Journal Date to the last day of the period you're categorizing.

  3. Add a line for each fee type: choose its income account, such as Dues, and enter its total in Credits. You can use one Dues account, or sub-accounts for each membership type. That level of detail is up to you, since Member Splash already has it.

  4. Add a final line for Uncategorized Income with the combined total in Debits. QuickBooks fills this in to balance the entry.

  5. Save the journal entry.

Your uncategorized deposits now show under the right income categories. Run a Profit and Loss report to check.

Most clubs do this monthly. After the first time or two, it takes about 10 minutes.

Did this answer your question?