You can send your association's financial transactions to QuickBooks Online using our direct export option. Without purchasing a 3rd party program, users with a QuickBooks Online account can keep their financial transactions up-to-date. Once connected, exports to QuickBooks Online will require only a single click each time you wish to transfer.

 

Setup Before Export

---

Setup the Connection

1. Go to Setup

2. In the first section click Billing Options and Settings

3. Click the QuickBooks Online Connect button and enter your QuickBooks Online login information and say "yes" to the connection.

 

 

4. Click on the QuickBooks Online Connection button.

5. Enter your QuickBooks online login information and say yes to the connections.

6. Click Save. The screen should indicate that you are now connected to QuickBooks online.

 

Setup Chart of Accounts and Fee Items

You will need to ensure your Chart of Accounts within the database is set up to match your Chart of Accounts within Quickbooks. They need to be an EXACT match.

1. Go to Setup > Billing Options section > and click Chart of Accounts
2. Add each account and assign it the correct type.

   • The account name needs to be either the name of the account OR the account number. It cannot contain both.
   • The account type should be set accordingly.
   • The account description is for your reference only and can be anything.
   • The account code is only used for deferred revenue reporting and works with our recognized income reports.

After your Chart of Accounts is properly set up you will need to ensure your Fee Items are mapped to their correct accounts.

1. Go to Setup > Billing Options section > and click Fees and Dues List
2. Ensure the Account column has the correct account from the Chart of Accounts assigned to each and every fee item.
3. To update an account, click the fee item name and change the income account dropdown.

 

Exporting Transactions

---

On a regular basis, push your billing transactions to QuickBooks Online. Follow the steps below to complete this process.

 

1. Go to the billing module and open the reports tab at the top.
2. In the Executive section click the Journal Entry Export - Accrual Basis or Journal Entry Export - Cash Basis depending on your accounting needs.
3. Select QuickBooks Online from the Format dropdown menu.
4. Select your date range and any other desired export options.
5. Click Refresh Report to generate your list of transactions.
6. Review the list for accuracy ensuring any transactions you wish to export are selected and then click the Export button.
7. The file is then transmitted to Quickbooks online and you will receive an email within a few minutes providing the status of that export.

 

As with all export options, ensure that your QuickBooks Online chart of account names and customer names matches exactly what is in your database prior to clicking Export. When a match is found, the transaction is automatically associated with the correct customer and account. If no match is found, the new customer will need to be added to QBO before exporting otherwise, an error will occur with that entry.

 

Applying Payments in Quickbooks Online video here.  

 

IMPORTANT: Due to how QuickBooks Online manages imported data, not all transactions will display under a Customer account in QuickBooks Online (QBO). In QBO if A/R isn't being affected journal entries will not show on a customer's record. You can verify all transactions that are imported into your QBO software by viewing the financial reports.

 

QuickBooks Online Errors

---

• Duplicate Document Number Error

• 401 Error: The unauthorized 401 error is a QuickBooks Online connection error. To resolve, in ChamberMaster:

1. Go to Setup.
2. Click Billing Options and Settings
3. Click the QuickBooks Online Connect button to disconnect and save. Refresh your page then go through the same process except for this time when you click the QuickBooks Online Connect button you enter your QuickBooks Online login information and say "yes" to the connection.
4. If that does not solve it, look in the Chart of Accounts in ChamberMaster and confirm that there are no spaces before or after the colon (:) between account:subaccount.