When syncing Expense objects, you are able to create Bills inside of Quickbooks Online based on Transactions in Brokermint.

Link to Workflow Configurator documentation.

Functionality

Whenever a Transaction is created or updated in Quickbooks Online, our Workflow will check to see if it passes the Brokermint Filters defined in the Workflow Configurator. If it does, the Workflow will create a Bill in QBO with fields as described further down in the document.

• The Workflow will create separate Bills for EACH SIDE represented in the Transaction. If the same Agent appears on multiple sides of the Transaction, two separate Bills will be created for that Agent.

• If the Configurator was set to create an Itemized Bill, the Workflow will examine your setting for “Commissions to Track” and then create one Bill for each Agent on that side of the Transaction. Then, on each Bill, the Workflow will create one Line Item for EACH item on that Agent’s Commissions.

  • If “Starting Point Agent Split” is selected, only “Post-Split Deductions” from Brokermint will be sent to Quickbooks Online.

  • If “Starting point Commission Basis” is selected, both “Pre-Split Deductions” and “Post-Split Deductions” will be sent to Quickbooks Online.

  • The Configurator allows you to have these Line Items map to Categories or Items. Regardless of whichever is picked, the Workflow will try to match the Tags of the Deduction items from Brokermint with any matching Categories or Items, respectively. If a Tag cannot be matched to an identically spelled Category/Item in QBO, the Workflow will instead use the Category/Item specified in “When match based on Tags cannot be found, use”.

  • The Workflow will then fill out your remaining fields based on your Configurator settings.

• If the Configurator was set to create a Non-Itemized Bill, the Workflow will examine your setting for “Commissions to Track”.

  • If “Office Net”, “Office Gross”, or “All items with Specific Tag” is selected, the Workflow will create one Bill for each side of the Transaction.

    • Details on these options:

      • “Office Gross” takes the “Gross Income” from Brokermint for the Selling / Buying side.

      • “Office Net” takes the “Office Net” from Brokermint for the Selling / Buying side after Commissions, Deductions, and Other Income are accounted for.

      • “All Items with Specific Tag” checks all Deductions / Income / Fees for items matching the tag that you specify. The Workflow then sums up all these amounts into one number.

    • The Workflow will then fill out your remaining fields based on your Configurator settings.

      • If Vendor is set to “Agent / Pay To”, only Commissions with a Payee of type “User” or “Contact” will sync. The Workflow will filter out Commissions with a Payee of an Account, as those are brokerages and will not count as valid Vendors.

  • If you chose “Agent Net” for “Commissions to Track”, the Workflow will create a separate Bill for EACH Agent on that side of the Transaction.

    • As an example, if your Brokerages represents both sides of the Transaction and there are 2 Agents on the Buying Side and 1 Agent on the Listing side, the Workflow will create 3 Bills (one for each Agent).

    • The “Agent Net” amount is the “Net Commission” of each Agent in Brokermint.

    • The Workflow will then fill out your remaining fields based on your Configurator settings.

      • If Vendor is set to “Agent / Pay To”, only Commissions with a Payee of type “User” or “Contact” will sync. The Workflow will filter out Commissions with a Payee of an Account, as those are brokerages and will not count as valid Vendors.

QBO Mapping and Example - Itemized Bill, Commission Basis

QBO Mapping and Example - Non-Itemized Bill, Commission Basis, Office Net