Skip to main content

RedTeam Flex - Connect to QuickBooks Online

Follow the steps below to connect your RedTeam Flex database to your QuickBooks Online account.

RedTeam Flex can integrate with QuickBooks Online to provide a complete construction accounting solution for commercial contractors. RedTeam Flex is designed to handle all of your construction accounting including progress billing, construction payments, cost of employee time and expenses, and tracking Work in Progress ("WIP") in real-time. When integrated, QuickBooks Online can be used to make payments, record receipts, keep general ledgers, handle bank reconciliations, and produce periodic financial statements.

RedTeam Flex eliminates duplicate data entry by automatically inserting project-related transactions into QuickBooks Online, including new Customers, Vendors, Projects, Cost Codes*, Employee Time and Expenses, Customer Invoices, and Vendor Invoices. Transactions posted by RedTeam remain linked, so the latest information from QuickBooks Online (payments and receipts) will be reflected in RedTeam.

*Cost Codes are sent as Class Codes when using QuickBooks Online Advanced accounts only.

1. Preparations in QuickBooks Online

RedTeam is compatible with Intuit's QuickBooks Online "Plus" and "Advanced" Editions. These Implementation Instructions will help guide you through the process of connecting RedTeam Flex to QuickBooks Online.

  1. Signup for QuickBooks Online “Plus” or “Advanced” Edition

    1. The “Plus” edition will push 2 lines into QuickBooks: one line for retainage and the other line is all the cost codes totaled from your project.

    2. The “Advanced” edition will push all lines into Quickbooks that show on your project. (RECOMMENDED)

  2. Login to your QuickBooks Online account and navigate to Settings (gear icon) > Account & Settings > Advanced and ensure that the Track Classes and Track Locations options are turned On

  3. Navigate to Settings (gear icon) > Account & Settings > Expenses and ensure that the "Track expenses and items by customer" is turned On

  4. Before connecting, ensure that your chart of accounts contains, at minimum, the account types listed below by navigating to My Apps > Accounting > Chart of Accounts and verifying that you have each of the account types listed below. While accounts can be named however you like, RedTeam Flex will need the required Account Type (Category Type) in order to connect its control accounts and send transactions properly.

    1. *RECOMMENDATION* setting up each of the below Account Name with “-RTF” (i.e. Revenue-RTF) at the end with the outlined Category Type and Detail Type listed below for each cost code. This will ensure that you know exactly what is flowing over from RedTeam Flex vs. what is not flowing over from RedTeam Flex.

  5. Navigate to Settings (gear icon) > Lists > Products and Services and ensure that the Progress and Retainage items below exist

2. Activate the Integration

  1. To connect to QuickBooks Online in RedTeam Flex click on the Apps Menu.

  2. Click "Connect to QuickBooks" in the QuickBooks Online tile.

  3. Fill in Sign in information to connect the QuickBooks Online account to RedTeam with the QuickBooks Admin's credetials.

  4. The App card may show a message of "Temporary Outage" immediately after initiating the connection. Simply log out and back in to your RedTeam Flex database to verify that the app card now reads "Operational"


2. Configure RedTeam for QuickBooks Online Integration


After the QuickBooks Online app card is operational, Click on the card and follow the steps below to configure settings in RedTeam Flex appropriately for the integration.

  1. Within the App Card, Control Accounts must be mapped to the accounts to configure QuickBooks Online for accounting integration. (unlinked accounts will show in red text)

  2. The dropdown will list entries from your Chart of Accounts in QuickBooks Online. Select the appropriate account *that you confirmed has the correct Category Type and Detail type (outlined above)* for each and enter a recognizable name for the account if needed.

    1. *RECOMMEND* do not skip over any of the Control Accounts as that may create errors and/or transactions flowing from Flex to QuickBooks in the future.

  3. Update or Create Company Credit Cards in RedTeam and link each to a corresponding Credit Card type account in QBO (unlinked cards will show in red text).

    1. *The credit cards can be created in the QuickBooks card or in Configuration / Credit Cards. If there are credit cards already showing, that indicates they were created in Configuration/Credit Cards.*

    2. After credit cards are created, they can be assigned to the correct employees to use on overhead or project expenses for job costing.

  4. Update or Create Time and Expense Codes for Employee Time and Expenses and link each code to the appropriate account in QBO for overhead time and expenses (unlinked codes will show in red text)

  5. If you plan to use tax venues to apply tax rates to customer bills, you will need to navigate to Configuration > Tax Venues and link each of your desired Value Added Tax rates to the appropriate Current Asset type account in QuickBooks Online.

  6. To adjust QBO integration settings in RedTeam, open the App Menu, select QBO (QuickBooks Online), navigate to the QBO app card, and click Preferences. Choose the relevant options to ensure proper handling of paid invoices going forward.


3. Preferences: How do you want the flow of information to work (Flex to QuickBooks)?

Each of the items under Preferences determines how you want Flex to push, or not push, information to QuickBooks.

  • “Append Project Number to Vendor Invoice Number…”

    • if checked will add the Flex Project Number before the Vendor Invoice Number (i.e. for Flex Project 1010001 for Vendor Invoice number 092826 = will show as 1010001-092826 in Quickbooks for the Vendor number). This allows for filtering in QuickBooks if needed.

  • “May create Vendor Payment in Committed status”

    • if checked will allow Flex to send any vendor invoice to QuickBooks when “Committed” is selected in Step 2 when entering an invoice with a Due Date 365 days after what the due date is in Flex.

      • Not only does it make your Accounting Reports off, but a bill may be mistakenly paid before it should or not show as an immediate bill that needs to be paid by the actual due date.

    • RECOMMENDATION: Do not check this option as the bill may be pushed before it is Approved and Executed in Step 5 when processing an invoice and/or before going through all levels of your Approval Workflow that is set up in Configuration.

  • “Send Employee Time and Expenses, and Vendor Invoices to QuickBooks marked as Billable”

    • This option is directly related to Employee Time and Expenses as an example that they would be treated the same as Vendor Invoices.

    • If you check this then all Employee Time and Expenses will flow through to QuickBooks and look like a Vendor bill.

    • RECOMMENDATION check only if you process your own employee time and expenses in QuickBooks and do not use an outside or Third-Party service (i.e ADP, Paycor, Paylocity, etc).

      • If you do not process payroll or expenses internally, please leave unchecked.

  • “Do not send Employee Time to QuickBooks”

    • Check if you do not want your Employee Time to flow through to Quickbooks, such as in cases that you have a Third-Party processing your Payroll (i.e ADP, Paycor, Paylocity, etc).

  • “Do not send Employee Expenses to QuickBooks”

    • Check if you do not want your Employee Expenses to flow through to Quickbooks, such as in cases that you have a Third-Party processing your Payroll (i.e ADP, Paycor, Paylocity, etc).

4. Considerations: When to start your Integration

Because RedTeam connects to QuickBooks at the transaction level, it is relatively simple to implement. If you currently use QuickBooks, you can start the connection between RedTeam and QuickBooks at any time, as the connection will simply replace manual data entry of project-related transactions. It should be noted that RedTeam posts transactions to your QuickBooks as they are committed in RedTeam, and linked transactions that are uncommitted in RedTeam will be removed from your QuickBooks.

Cases:

  1. Transactions committed prior to the connection will have to be entered manually in QuickBooks Online (or must be uncommitted and re-committed in RedTeam Flex in order to send to QBO)

  2. Entries in QuickBooks that existed before the integration will not be affected.

  3. After connecting to QuickBooks, those uploaded in Flex/Transactions will not flow over to QuickBooks.


5. QuickBooks Online Accounting Transaction Status Indicators

RedTeam should be considered authoritative on the status of any given Accounting Transaction (Customer Billing, Vendor Invoice, Employee Time, and Employee Expense). Once posted to QuickBooks, Accounting Transactions should remain synchronized. In the event an Accounting Transaction becomes out-of-sync, a Posting Error will be presented to authorized users as follows:

Steps:


1. Access the transactions menu to view transaction status.


6. QuickBooks Online Accounting Adjustments

As a practical matter, you should never alter transactions posted from RedTeam to QuickBooks Online, as this will cause a variance between the two systems. In general, when a transaction needs to be adjusted or corrected, it should be uncommitted in RedTeam, adjusted/corrected, and recommitted. This will ensure the two systems remain synchronized.

Invoice approval in RedTeam is an internal control process to validate invoices before execution. This process does not directly alter data in QuickBooks.

Steps:


1. Remove any payments in QuickBooks Online if they are connected to the transaction to be adjusted.

2. Uncommit transaction in RedTeam

3. Adjust or correct transactions in RedTeam

4. Commit Transaction

5. Reapply payment in QuickBooks to transaction.


7. QuickBooks Online Transaction History

At any time, you may navigate to the QuickBooks Online App Card to see detailed Transaction Log with complete posting history, and to update the configuration of your connection between RedTeam and QuickBooks Online.
​

Steps:

  1. Select Apps from the left side menu.

  2. Click on the QuickBooks Online App Card

  3. Click on the "Transactions Log" button at the bottom left of the page.


8. QuickBooks Online Integration Transaction Troubleshooting

Any Transaction Errors should be resolved prior to closing any Accounting Period. Click the Transaction Error Icon or simply navigate to Transaction Tab | Manage Transaction Errors to resolve any errors found. Use the following table to resolve each case.
​

If a vendor invoice is not syncing with QBO, follow these steps:

  1. Verify the accounting period in QBO. If it is closed, create the current accounting period to open the relevant period.

  2. In RedTeam Flex, go to the Transactions menu, select the invoice, and click Retry to resend the sync.

  3. If the invoice is committed/executed and cannot be uncommitted due to a newer invoice, either delete the newer invoice or enable the setting to allow multiple draft invoices. Then, uncommit, commit, and execute the invoice before retrying the sync.

  4. Ensure the invoice reflects the correct amounts, as a $0 invoice will not represent retainage or materials correctly.

Notes:

1. Upon Uncommit in RedTeam, all "Queued" Transaction Updates are Dismissed.

2. Upon Void or Delete in QuickBooks, Transactions are Unposted and demoted to Draft Status.

3. Draft or Cancelled Transactions that remain Posted are considered Accounting Transaction Posting Errors.


Notes:

1. Upon Uncommit in RedTeam, all “Queued” Transaction Updates are Dismissed.

2. Upon Uncommit, Void or Cancel in RedTeam, all “Posted” Transaction Updates are Deleted in QuickBooks Online.

3. Upon Void or Delete in QuickBooks Online, Transactions are Unposted in RedTeam.

4. Draft or Cancelled Transactions that remain Posted are considered Posting Errors.

5. Upon Commit Vendor Invoices in RedTeam, the Vendor Expense will be set with the Pay On Date a year from Invoice Date and the Payment Term will be set as “Pending Approval.”

6. The QuickBooks setting for creating vendor payments in committed status is a global configuration. This change is made by the System Administrator and applies to all users.

7. Upon Execute Vendor Invoices in RedTeam, the Vendor Expense will be set with the approved Pay On Date.

Did this answer your question?