QuickBooks® account names are updated in three places within ClubExpress. Be sure that all three are correctly filled out:
- Control Panel – Money – Setup – Bank Accounts
- Control Panel – Money – Setup – Financial Accounts
- Control Panel – Money – Setup – Money Options
In QBD, transaction, payment and credit data is exported using IIF files – the Intuit Interchange Format. This is a tab-delimited file format where account names are spelled out. QuickBooks® looks for an account in its chart of accounts with the exact spelling shown in the IIF file.
When you are entering QuickBooks® account names into ClubExpress, be sure that the spelling is exact. If it’s not, QuickBooks® will create a new account with the spelling from the IIF file and you will have to manually move each transaction to the correct account.
When specifying account names in ClubExpress, do not include an account number.
In the QuickBooks® Chart of Accounts, specify “Membership Dues” as the QuickBooks® account name in ClubExpress.
If your account is a sub-account, specify the path to the sub-account with a colon delimiter.
In the QuickBooks® Chart of Accounts, specify “Income:Donations” as the QuickBooks® account name in ClubExpress. Note that there are no spaces around the colon. Note also that the ClubExpress account name field is limited to 50 characters. If your QuickBooks® account names are longer than this, including sub-accounts, they may need to be shortened to fit.
For financial accounts, you will need to add Account Names for both the financial accounts you've created as well as the master financial accounts.
Financial Accounts can only be used to direct payments to multiple bank accounts if you are a ClubExpress Premium Payments user.