All Collections
CORE BackOffice
Quickbooks & CORE Back Office
[CORE BackOffice] How To Sync Agent Billings And Payments
[CORE BackOffice] How To Sync Agent Billings And Payments
Updated over a week ago

The 'Track Agent Billings and Payments' workflow creates an invoice in QuickBooks Online for each Agent that has billing in CORE Back Office. When a bill in CORE Back Office is marked as paid, a payment in QuickBooks will be created.

Note: It is a manual process to sync transactions and items in an agent's billing log unless you have either of these permissions enabled:

  1. Auto-sync disbursement at 100%

  2. Auto-sync billing when agent's card is successfully charged

For every next bill paid by this Agent, a new payment in QuickBooks will be created or updated.

The workflow runs on demand, when data is posted by CORE Back Office.

To set this up, select 'Track Agent Billings and Payments'.

Click Use this Template.

Verify you are logged into the correct QuickBooks account.

Click Save. This will take you to the configuration page. 

  • Bypass the 'Sync all item on first run' option

  • Invoice/Payment date: Select one of the following: (1) QuickBooks Default will default the date in QuickBooks to the day you are syncing the information. (2) Close date in CORE Back Office will create the bill date off the close date in CORE Back Office in the transaction.

Next, choose the 'Deposit to' account. This will be the account in QuickBooks that your invoice/payment will be created under.

Once you've chosen your Deposit account then you will click Apply.

Click Run and your workflow is now activated.

This will create a paid invoice in QuickBooks if you sync a paid invoice in CORE Back Office. 

If you sync an unpaid invoice, it creates an unpaid invoice in QuickBooks. If you then mark it as paid in CORE Back Office, and re-sync, it updates the invoice to paid in QuickBooks.

For Quickbooks Online, you can find your Agent billings and payments in QuickBooks under Sales> Invoices.

For QuickBooks Desktop you'll need to set up a 2nd workflow as they are slightly different:

You'll need to add both workflows shown above. 

One creates the invoice, and one creates the payment for that invoice.

Did this answer your question?