This guide walks through the steps if you are also switching to Quickbooks Online as part of your Clubspot implementation.

We recommend obtaining a Quickbooks online subscription a month or two before your scheduled go-live date with Clubspot. You can review the different Quickbooks plans here. Clubspot is supported in all Quickbooks plans, so you can review the different features that may be applicable to your club. Most clubs on our platform end up going with the Plus plan.

Prior to uploading your chart of accounts into Quickbooks, it is worth reviewing some of the features supported by Quickbooks for classifying transactions as well as considering the structure of your chart of accounts.

While not always the case, clubs often have chart of accounts that are overly complicated and contain far too many accounts. Clubspot contains a multitude of reports showing granular data plotted over time, and the ability to filter and refine your queries. This often results in clubs using Clubspot shifting from using their monthly accounting data for the bulk of their business intelligence and insights, to instead looking at the income transactional data within Clubspot. This often allows clubs to simplify their COA, eliminating complex or overly specific accounts accounts.

If you are opting to simplify your chart of accounts, we recommend doing so either before setting up your Quickbooks account or after entering and validating your starting balances and data. That way you can easily validate one-to-one that your starting balances were correctly entered into the system. If you edit accounts mid process it can become difficult to validate that your current system’s trial balance matches your QBO trial balance.

Important to consider for your implementation are the class and department attributes supported by Quickbooks and Clubspot.

Any accounting transaction from Clubspot to Quickbooks will contain an account, but it can also optionally contain a class and/or department. Classes and departments help to segment your accounting data in Quickbooks so that you can for example pull a P&L by class, or by departments. These attributes can also be useful in simplifying or better organizing your chart of accounts!

Also known as locations in Quickbooks, departments are best used as static grouping of accounts. For example, you can group your income accounts for food, beverage, beer, wine, and your food and beverage related expense accounts into a department called F&B. Clubspot can assign departments based on the income account used in a transaction, or you can opt to dynamically assign a department at the item-by-item or POS location level. Reach out to your onboarding manager if you would like your departments structured in this way.

Departments are typically the most straightforward way to generate a “Departmental P&L” in Quickbooks, a commonly used report in the private club space.

Classes in Quickbooks allow you to apply dynamic relationships for your transactions. For example, your income accounts will be applied at the item or subtype level, but you have the ability to assign an accounting class based on the POS location where an item is sold. You could also assign a class based on the context of a sale, like whether it was through an event signup, or through the banquets section.

What this allows clubs to do is have a clean and simple chart of accounts, where you might have a single income account for “food”, and then the class can be set to Pool, if that food item is sold through the Pool POS. If that exact same item is sold through the banquets section, that could be set to “Private Events” class, or if sold through main dining it could be assigned the “Dining” class.

Utilizing classes in this way can help provide more visibility in terms of your operations and can save from unnecessary duplication of products and income accounts. You for example would not need a separate account for “Food-Pool”, “Food-Dining”, “Food-Private Events”. With Clubspot in quickbooks you can gave a single burger sold out of all three places, all going to a “Food” income account but picking up the class based on the context of the sale.

Many clubs also use classes to run event-level P&Ls. They do this by assigning a class to a social event in Clubspot, and all expenses related to a certain event get classed accordingly in the Quickbooks AP platform.

Once you obtain your license you can proceed to your QBO setup.

• Import your chart of accounts - We recommend entering your starting balances as part of this import, as of the current fiscal year. More about this in “Enter starting balances” below.

• Connect bank account and credit cards

• Enter your vendors

You may also want to create or import a budget. This step can take place after linking Clubspot and is not a prerequisite to linking QBO with Clubspot.

Once you have uploaded and verified your chart of accounts in Quickbooks you will be ready to connect Clubspot and QBO. When you make this connection, Clubspot will pull in the chart of accounts in Quickbooks and then you can begin the account mapping process to ensure all of your products and sales are assigned to the appropriate accounts, classes, and departments.

When you are ready to sync over your chart of accounts, simply go to Reporting —> Quickbooks in Clubspot and then select the “Enable More Features”. Once you authenticate the account your chart of accounts will be pulled into Clubspot. See here for more instructions on syncing Quickbooks.

Once you have done so, let your Clubspot onboarding manager know and they will schedule a call to go through the next step of assigning income accounts to your different product sales. That meeting will follow the outline of our accounting checklist which you can view here.

To make sure your Quickbooks account is up-to-date you will need to enter starting balances for your accounts and you may also need to enter prior account activity. While there are multiple methods of doing this, Clubspot recommends entering your starting balances from the beginning of your fiscal year, and then monthly, summary entries up until your go-live date with Clubspot.

1. You may have already imported your COA with your YTD starting balances, but if not you can follow the steps here to enter those starting balances.

2. Enter monthly summary journal entries to populate your current year data. We recommend using journal entries - one entry per month of the current fiscal year - to enter your current fiscal year’s activity. You can only complete this process after you have stopped processing in your current club management system.

3. Once you have entered each month’s activity as a summary journal entry in QBO, validate the trial balance in your previous accounting system with what is in Quickbooks. The balances of all accounts should match. It is vital to validate your entries from step 2 before proceeding.

When your trial balance matches your current Quickbooks balances, you will be ready to turn on the sync of Clubspot transactions and push that data to Quickbooks. Your Clubspot onboarding manager will review the transactions locally in Clubspot with your prior to pushing them to Quickbooks and will walk you through the payment reconciliation process.