How to Sync Charges from your Platform to QuickBooks

Within our Gym Management Software, you’re able to connect to QuickBooks to automatically sync all charges on your platform with your QuickBooks account.

There are 3 main setup steps to take before you’re ready to sync your charges to QuickBooks:

1. Connect to QuickBooks
2. Make sure you have “Locations” set up in QuickBooks for mapping your locations.
3. Make sure you create “Accounts” in QuickBooks and map your purchaseable items for sale (packages, products, plans for sale, group memberships, etc.).

Once you’ve completed those steps, you’re ready to sync your charges! Here’s how to sync charges from your platform to QuickBooks:

• How to Sync Past Charges Manually
• How to Enable Automatic Syncing.

The step-by-step instructions are below.

Step-by-Step Guide: – Sync Past Charges Manually

Step 1: Make sure you’re signed in with your Exercise.com for Business Admin / Owner account.

Step 2: IMPORTANT: Make sure you have mapped your Locations and Items for Purchase to QuickBooks BEFORE syncing charges.

• Click Here to See How to Map Locations to QuickBooks
• Click Here to See How to Map Items for Purchase in QuickBooks

Step 3: Click the Account tab, then click “Connected Apps” on the left side menu

Step 4: Scroll down to the QuickBooks option and click on the “Sync Past Charges” button.

Step 5: Select your time frame for syncing past charges and then click “Sync Past Charges”.

You can click the calendar icon to select custom dates.

Step 6: Click the “Sync Past Charges” button to confirm your dates and start syncing.

You will not be able to sync charges for today’s date in order to prevent duplicates.

SUCCESS! Now you should see some a confirmation message, and the sync will happen in the background:

It will take some time for all of your charges to sync to QuickBooks, depending on the number of charges in the time period you selected.

Step-by-Step Guide: – Enable Automatic Syncing

Step 1: Make sure you’re signed in with your Exercise.com for Business Admin / Owner account.

Step 2: Click the Account tab, then click “Connected Apps” on the left side menu

Step 3: Scroll down to the QuickBooks option and click on the “Manage QuickBooks Settings” button.

Step 4: Click the toggle switch to enable automatic syncing.

Step 5: Scroll down and click the “Save QuickBooks Settings” button to save your changes.

Your charges will now sync automatically!

Charge Details in QuickBooks

Each charge is entered in QuickBooks as a “Deposit” with 4 line items: Gross, Fee, Refund, Fee Refund.

• Gross: The total amount charged to the customer
• Fee: The transaction fee for the charge
• Refund: Any refund for the charge
• Fee Refund: Amount of the transaction fee refunded when a charge is refunded

Prevent Duplicate Line Items When Reporting by Location

Make sure to customize your Location reports in QuickBooks and filter by “Distribution Account”, then select the Income accounts you want to view.

Otherwise you may end up with duplicate “Net” amounts for the charge.

Here is how to set up your Location report filters to remove duplicates:

Step 1: Click the Settings icon in the top right corner of QuickBooks.

Step 2: Click “All lists” in the “LISTS” column.

Step 3: Click the “Locations” option.

Step 4: Click the “Run report” link for the Location you want to view.

Step 5: Click the “Customize” button to update the filters.

Step 6: Under the “Filter” category, check the box for “Distribution Account”.

Step 7: Select all the items you want to track for this Location in the dropdown selector.

Step 8: Click the “Run report” button.

Step 9: Click the “Save customization” button to save these changes for next time.

 

This will clear up any duplicate “Net” line items showing in your Location Reports.