QuickBooks: Journal Mapping
Map transaction types, sub-departments, and discounts to QuickBooks GL accounts
Overview
Journal Entry Setup maps Club Caddie transaction types and sub-departments to QuickBooks general ledger accounts. Each mapping tells the QuickBooks sync which account a given type of sale or discount should post to when it syncs as a journal entry. Payment methods, voucher types and classes are mapped on their own screens, listed under "Fix a sync that fails" below. This article shows the Desktop app. Some clubs call the sync the QuickBooks export; this article uses the word sync, as the screen does.
Use this article when you are:
- Setting up the QuickBooks integration for the first time, after connecting QuickBooks Online or QuickBooks Desktop
- Adding a new GL account in QuickBooks that needs to be mapped on the Club Caddie side before it can be used
- Troubleshooting a sync error that points to an unmapped or incomplete mapping
- Setting up the Discount Account field added in release 5.7
Before you start
Settings → QuickBooksIntegration → Journal Entry Setup.
The QuickBooksIntegration item sits in the Settings left menu, written as one word with no space. The Journal Entry Setup tab is one of several tabs on that screen alongside Chart Of Account, QuickBooks Desktop, Chart Of Accounts Oracle Extension, Quick Books Vendor, Settings, QuickBooks Online, QuickBooks Reset Sync, and Great Plains Extension.
The Journal Entry Setup tab shows a list of existing mappings (Transaction Type, credit account, Debit Account, and an Action column with View/Edit and Delete) and an Add Journal Entry button in the upper right.
Set up a journal entry mapping
- From Journal Entry Setup, click Add Journal Entry.
- Set Journal Entry Type. This field has two options: Transaction Type and Sub Department. Choosing Transaction Type does not display the sub-department dropdown. If you need to map a sub-department (including the Discount Account field), select Sub Department instead.
- Pick the specific transaction type or sub-department you're mapping (for example, a sub-department like "Pro Shop Balls").
- Assign the Credit Account or the Debit Account from your imported Chart of Accounts, whichever side that mapping posts to. A sub-department sale usually credits a revenue account.
- Add a Memo if you want one.
- Click Save.
If the QuickBooks account you need doesn't appear in the dropdown yet, it needs to be created or activated in QuickBooks first, then re-imported into Club Caddie via the Chart of Accounts import (Import Data for QuickBooks Desktop, Import from QuickBooks for QuickBooks Online).
Map a discount to its own GL account
New in release 5.7: Journal Entry Setup includes a Discount Account field, which sits between Debit Account and Class in the Add Journal Entry popup. It maps a sub-department's discount dollars to a specific QuickBooks chart-of-account, so discounts post to that account separately instead of blending into the sales/revenue line.
The Discount Account field appears only under the Sub Department journal entry type, not under Transaction Type.
To set it up:
- Settings → QuickBooksIntegration → Journal Entry Setup → Add Journal Entry.
- Set Journal Entry Type to Sub Department.
- Pick the sub-department.
- Assign a Credit Account.
- Assign a Discount Account. If the account you want is not listed, add or activate it in QuickBooks, then re-import your Chart of Accounts.
- Click Save.

Discount dollars mapped this way sync to QuickBooks. The mapping is not display-only. A mapped discount posts as a debit.
Mapping changes apply going forward, not retroactively. Changing a discount mapping affects future syncs. A date that already synced keeps its original mapping. To change it, redo the day with Support: delete that day's entries in QuickBooks, reset the sync date to the last earlier day with a sale, then re-sync that day by itself. Running the sync again without those steps can post a second entry.
The steps above cover mapping a discount to a sub-department for the first time. To change the discount mapping on a sub-department that already has one, open its row with View/Edit in Journal Entry Setup instead of adding a new entry.
Verify a sync
After running a sync (Settings → QuickBooksIntegration → Sync with QuickBooks section, select a date range, run the sync), confirm the entries landed where expected:
- Check the Profit & Loss statement or General Ledger in QuickBooks for the sync period.
- For a discount mapping specifically, the GL Code Report V2 (Reports module) shows the discount amount Club Caddie will send for a discounted sale. QuickBooks confirms what posted to the mapped Discount Account.
A completed sync shows a success message in Club Caddie. For a first-time sync, running it against a single date is the safer way to confirm mappings are correct before syncing a full range.
Fix a sync that fails on "Balance debits and credits" or a similar mapping error
Work through these five locations in order. The missing or mismapped entry is almost always in one of them:
- Settings → QuickBooksIntegration → Journal Entry Setup → Transaction Types: every transaction type needs a GL code.
- Settings → Register Settings → Department (sub-departments): each sub-department needs a GL code.
- Settings → Register Settings → Custom Payment Methods: each custom payment method needs a GL code.
- Settings → Register Settings → Club Voucher Type: each voucher type needs a GL code.
- Settings → Class Management → Set Chart of Account: if class-specific GL codes are used, each class needs an assignment.
Common Questions
Does the Discount Account field apply to Transaction Type mappings too, or only Sub Department?
Only Sub Department. Selecting Transaction Type as the Journal Entry Type does not display a Discount Account field.
If I change a mapping, does it correct entries that already synced?
No. Mapping changes apply to future syncs only. A date that already synced keeps its original mapping. To change it, redo the day with Support: delete that day's entries in QuickBooks, reset the sync date to the last earlier day with a sale, then re-sync that day by itself. Running the sync again without those steps can post a second entry.
Where do I confirm a discount actually posted to the account I mapped?
The GL Code Report V2 in the Reports module shows the discount amount Club Caddie will send for a given sale. Check the Discount Account you assigned in QuickBooks after the sync.
What if the QuickBooks account I want isn't in the dropdown when I'm setting up a mapping?
It needs to exist and be active in QuickBooks first. Add or activate it in QuickBooks, then re-import your Chart of Accounts in Club Caddie (Import Data or Import from QuickBooks) before it will appear as an option.
Does QuickBooks Desktop use the same mapping steps as QuickBooks Online?
Journal Entry Setup and the mapping steps are the same screen for both. The connection process itself differs: QuickBooks Desktop connects through a flashing icon in the Windows toolbar rather than the browser OAuth flow QuickBooks Online uses.
My sync failed after we deactivated an account in QuickBooks. What do I fix?
A Club Caddie mapping still points at the account you made inactive, so the sync fails when a transaction tries to use it. With QuickBooks Desktop the error starts "There is an invalid reference to QuickBooks Account" followed by the account number. Point that mapping at an active account, then check QuickBooks for that date. If the entry isn't there, run the sync again for that day. If it is there, or the sync covered more than one day, contact Support first, because running it again can post a second entry. For a custom payment method: go to Settings → Register Settings → Custom Payment Methods, click Edit on the payment method (on Browser, open the row's ⋮ menu first), choose an active account in the Chart Of Account dropdown, check the row's CoA entry too, and click Save. For a transaction type or sub-department, open the mapping in Journal Entry Setup with View/Edit (Browser: Edit), choose an active account and save. An inactive account can also sit in any of the five locations listed under "Fix a sync that fails" above. If the account you want is not in the dropdown, activate it in QuickBooks and re-import your Chart of Accounts first (see the question above).