Skip to main content

RedTeam Go - QuickBooks Trigger Points

This resource provides details on the actions performed in RedTeam Go that cause transactions to move to QuickBooks via the integration.

When RedTeam Go is connected to QuickBooks Online or QuickBooks Desktop, certain actions in Go send records to QuickBooks automatically. This article lists those trigger points: what you do in Go, and what is created or updated in QuickBooks as a result.

Before sending a transaction, Go makes sure the records it depends on exist in QuickBooks: the owner (as a customer), the job, the vendor or employee, and the cost codes (as items). If they are missing, Go creates them first.

Trigger points

When this happens in RedTeam Go

RedTeam Go sends

QuickBooks creates or updates

The project is set to In Progress

Owners, job, and the cost codes in the bid (base bid plus accepted alternates, units and phases)

Customers, job, items and an estimate. Whether the estimate holds the construction budget or the owner estimate depends on your integration settings.

A Field PO is approved while the project is in Bidding or Pending

Owners, job, the Field PO's cost codes and vendor

Customers, job, items and vendor. Depends on whether your integration settings track job cost in Bidding and Pending.

A subcontract is locked

Owner A, job, subcontractor, and the cost codes in the awarded items

Customer, job, vendor, items and a purchase order. This happens when the subcontract is locked, before it is signed.

A subcontractor change order is approved (including a termination)

The change to the subcontract

The subcontract is updated in QuickBooks

A purchase order is signed or accepted

Owner A, job, vendor, and the cost codes on the PO

Customer, job, vendor, items and an open purchase order. A change made with Add To PO is sent under the original PO number. The vendor's invoice for the PO is entered in QuickBooks against that PO, not in RedTeam Go.

An expense or Field PO is approved by the PM and accepted by the accountant, or saved by the accountant with Save & Accept

Owner A, job, vendor, and the cost codes on the expense

Customer, job, vendor and items, plus: an expense for a purchase already paid by card (the payment method is the card); a bill for an invoice not paid yet (payment method left blank, Field PO marked Upload as Vendor Bill); a purchase order for a Field PO not marked as a vendor bill

An expense or Field PO is unaccepted by the accountant

The removal

The expense, purchase order or bill is deleted in QuickBooks Online or zeroed out in QuickBooks Desktop

A time card is approved by the PM

Owner, job, employee, the time card's cost codes and any non-job overhead codes

Customer, job, employee, items and time tracking

An owner change order is approved (signed by the owner or approved by the PM)

The owner affected, job, and the change order's cost codes

Customer, job and items; the estimate is updated with the change order

An internal change order is created (for example, an automatic over-budget adjustment)

The budget change

The budget (estimate) is updated

A sub bill is accepted by the accountant

Owner A, job, subcontractor, and the cost codes on the bill

Customer, job, vendor, items and a bill. If the bill holds retainage, the retainage is sent as a separate bill.

A sub bill is deleted

The removal

The bill is deleted in QuickBooks Online or zeroed out in QuickBooks Desktop

An owner bill is approved or notarized by the accountant

The owner, job, and the cost codes on the bill

Customer, job, items and an invoice

Note: A sub bill is sent to QuickBooks when the accountant accepts it, not when the PM approves it. When accepting, the accountant can change the transaction date that appears in QuickBooks.

Save & Accept skips PM approval and sends an expense straight to QuickBooks. If an entry still needs the PM's review, click Save instead.

What comes back from QuickBooks

  • When a bill is paid in QuickBooks, RedTeam Go fills in the date in the Paid column.

  • Costs entered directly in QuickBooks flow back into Total Cost to Date on the Job Cost Statement, marked as pulled from QuickBooks. Because they were never committed in RedTeam Go, they can make a job look more than 100% complete. Enter costs in RedTeam Go first so they are reviewed and committed against the budget.

Check what was sent

Step 1: Click Accounting in the top menu, then click QuickBooks Online Integration (or QuickBooks Desktop Integration).

Step 2: Review the Integration Logs. Each row shows the Item, its Status and when it was sent. Use Filter Settings to show only certain statuses or transaction types.

  • Waiting for References or Preparing Data: Go is still sending the records the transaction depends on. Most transactions finish within a few minutes.

  • Successful: the transaction is in QuickBooks. Click View status for dependencies to see the job, vendor and items that were sent with it.

  • Failed: read the Message, fix the cause (for example, map a new card payment method to its QuickBooks account in Settings), then click the Re-Queue Item icon to send it again.

Did this answer your question?