CORE BackOffice and QuickBooks are integrated, letting you sync your Agent billing date and commission disbursement data to QuickBooks, so you can track your brokerage income and Agent expenses.
All online and desktop versions of QuickBooks, except for QuickBooks Self-Employed, can be integrated with CORE BackOffice.
To add the integration, go to Settings > Integrations > Add QuickBooks.
If you've chosen to integrate QuickBooks Online, you'll be taken to a login page where you'll enter your credentials for QuickBooks Online to authenticate the connection.
If you are integrating QuickBooks Desktop you'll be taken to a page with instructions on how to set up your connection with CORE BackOffice.
Next, you'll be taken to a setup page where you'll see a group of workflows. These workflows allow you to map your data from CORE BackOffice into QuickBooks based on your accounting preferences.
You'll want to select 1 workflow for brokerage income and 1 for Agent expenses.
If you are using the Agent billing feature in CORE BackOffice, you can set up the Agent billing workflow as well.
To setup a workflow, click the name of the workflow.
On the next page, click the Use This Template button and confirm your connections are correct.
Click Save to proceed to the next step.
On the next page you'll see some options for setting up your workflow. These will vary depending on the specific workflow you're setting up.
You can select which bank account the agent billing is paid to when setting up the sync between CORE BackOffice and Quickbooks by choosing the desired account from the Checking Account drop-down.
Once you've made your selections click Apply, then scroll to the top and click the Run button.
Your workflow is setup!
You'll want to repeat this process for each of your workflows.
Make sure you only set up one workflow for brokerage income and Agent expenses. If you set up more than one workflow you will be syncing over duplicate data when you sync your transactions.
Next, go back to CORE BackOffice.
To sync agent billing invoices, click into the Billing Log of an Agents profile.
You can click the Sync button to create a new invoice in QuickBooks for this item.
If your item is unpaid a new unpaid invoice will be created in QuickBooks.
If you then mark your invoice as paid in CORE BackOffice and re-sync, it will update the existing invoice to paid. Or you can sync a paid invoice and a paid invoice will be created in QuickBooks.
To sync commission disbursement data, go to a transaction, and you'll see a Sync to QuickBooks button.
You can sync your commission disbursement data anytime after you've created your commission disbursement.
If you sync to QuickBooks and then have to make changes to your disbursement in CORE BackOffice, don't delete the entries in QuickBooks. Make the changes in CORE BackOffice and re-sync to QuickBooks and the existing entries in QuickBooks will be updated.
There are also 2 Auto-Sync options. Go to Settings > Permissions and scroll to the bottom where you'll see two options.