The Integration Reconciliation Report is an excel report that can be used to match the transactions that are sent from RedTeam Go to QuickBooks through our Accounting Integrations. The report is only available for users who have a RedTeam Go Integration with QuickBooks Desktop and QuickBooks Online active.
TO ACCESS THE REPORT
Go to Accounting and click on your QuickBooks Accounting integration tab on the left Navigation Widow
Click Reconciliation Report
Enter the the Date Range you would like use for the Report
Click Generate
You can wait for the report to Generate and open into Excel or you can continue working elsewhere and Pending Report will be available to download from Completed Reports list when compiled.
WHAT INFORMATION IS INCLUDED/ EXCLUDED?
The Reconciliation Report will include transactions that have been sent to QuickBooks on the following Cost and Revenue items during the selected date period:
Purchase Orders
Expenses and Field Expenses
Sub Bills
Timecards
Owner Billing (Lump Sum Total)
The Reconciliation Report will NOT include the following transactions because these Budget and Award transaction values are tied to one of the above transactions.
Original Budget Values (Revenue tracked by Owner Bills)
Owner Change Orders (Revenue tracked by Owner Bills)
Subcontractor Award Amounts (Costs tracked by Sub Bills)
Subcontractor Change Orders (Expenses will be tracked by Sub Bills)
REPORT LAYOUT
The Report will show the Projects Names ordered by Project number across the top of the report
The Transactions that have been sent to QuickBooks are on the left, including the Cost Codes, Vendors/Subcontractors and Transaction dates.
TRANSACTION DETAILS
The Cost Codes are organized to appear by EXPENSE TYPE on the report
EXPENSE TYPES are the letters used in RedTeam Go to designate the type of cost item and what types of transactions they can be used with
The order of EXPENSE TYPES appear on the report:
Material (.M)
Subcontractor (.S)
Equipment (.EQ)
Other (.O)
Overhead (.OH)
Labor (.L )
General Costs (if used for a Purchase)
Permit Cost (if used for a Purchase)
Owner Billing (Lump Sum at the Bottom of the Report)
HOW EXPENSE TYPES ARE PAIRED WITH TRANSACTIONS IN RedTeam Go
Purchase Orders, Field Purchase Orders and Expenses can be made with the following EXPENSE TYPES
Material (.M)
Equipment (.EQ)
Other (.O)
Overhead (.OH)
Subcontracts and their associated Subcontractor Bills can only use
Subcontractor (.S)
Timecards used to track Labor Cost can only use with
Labor (.L)
NOTE ON LABOR: Labor items will send the total number of hours that have been applied to each Labor code during the selected period for both QuickBooks Desktop and QuickBooks Online. QuickBooks Online will also include the monetary value calculated for each Labor cost (Number of Hours x Employee Rate in Administration).
QuickBooks Desktop will ONLY receive Labor Hours from RedTeam Go because Intuit does not provide a method to send the monetary value via the integration.
TOTALS
The bottom of each EXPENSE TYPE section will include a total for that section (by Project).
The bottom of the report will also display a Grand Total of all cost items that are included on the report.
