What this does: Connects ChamberMaster to QuickBooks Online (QBO) and sends your billing transactions there as journal entries.
Applies to: ChamberMaster and MemberZone, with QuickBooks Online. For QuickBooks Desktop, see Import ChamberMaster Journal Entries into QuickBooks Desktop.
Before you start: Have your QuickBooks Online login ready, and make sure your account and customer names match in both systems.
Time needed: About 10 minutes to connect the first time, then a few minutes for each export.
Connect ChamberMaster to QuickBooks Online
You only need to do this once. After that, the connection stays in place for every export.
- Click Setup in the left-hand rail, then click Billing Options & Settings.
- Expand the Billing Solution panel if it's closed.
-
In the QuickBooks Online box, click the Connect to QuickBooks button.
- Sign in to QuickBooks Online and approve the connection.
- Back in ChamberMaster, click Save.
Checkpoint: The QuickBooks Online box shows that you're connected.
Match your accounts and customer names
QuickBooks Online matches each transaction to an account and a customer by name. When both match, the transaction lands on the right customer and account. When a customer doesn't exist in QuickBooks Online, that entry fails.
- Accounts: Make sure each account in your ChamberMaster chart of accounts uses the same name as in QuickBooks Online.
- Customers: Add any new members to QuickBooks Online as customers, spelled exactly as in ChamberMaster.
- Renamed members: Run the Member Record Updates report to find members whose names changed, then update them in QuickBooks Online. See Check for member name changes in ChamberMaster.
Send journal entries to QuickBooks Online
Do this regularly, for example once a month, to keep QuickBooks Online up to date.
- Click Billing in the left-hand rail, then click the Reports tab.
-
In the Executive section, click the export that matches your accounting method:
- Journal Entry Export - Accrual Basis sends invoices, credits and payments (income is counted when you bill it).
- Journal Entry Export - Cash Basis sends only payments and sales receipts (income is counted when you're paid).
- In the Format list, select QuickBooks Online.
- Choose your date range and any other export options, then click the Refresh Report button.
- Review the list. Make sure every transaction you want to send is selected, then click the Export button.
Checkpoint: Within a few minutes, you get an email with the status of the export. It tells you whether any entries failed.
Fix a 401 error
A 401 (unauthorized) error means the connection between ChamberMaster and QuickBooks Online has stopped working. Reconnect to fix it.
- Click Setup in the left-hand rail, then click Billing Options & Settings.
- In the QuickBooks Online box, click the button to disconnect, then click Save.
- Refresh the page.
- Connect again by following Connect ChamberMaster to QuickBooks Online.
- If the error comes back, check your ChamberMaster chart of accounts for subaccounts. There must be no spaces before or after the colon between the account and subaccount, for example Revenue:Dues, not Revenue : Dues.
Common pitfalls
- Entries fail for new members: Add new members to QuickBooks Online as customers before you export.
- Transactions seem to be missing: Entries that don't affect A/R won't appear on the customer. Check your QuickBooks Online financial reports instead.
- Mismatched names: A small spelling difference in an account or customer name stops the match. Compare names before every export.