Managing OnCost™ Estimates

Export an Estimate to Excel

Easily pull construction estimate data into Excel spreadsheets using ConstructionOnline's OnCost™ Estimating

BACKGROUND

ConstructionOnline's OnCost™ Estimating software makes tracking construction project costs, margins, and profits simple with detailed estimate files that track more than 30 key points of data.

To provide ultimate flexibility regarding the management of construction contracts, ConstructionOnline™ offers multiple options for exporting project estimates to Excel, making it easy for users to share & update data as needed. 

STEPS TO EXPORT AN ESTIMATE TO EXCEL

  1. Navigate to the desired Project via the Left Sidebar.
  2. Select the Financials tab to automatically open the Estimating category.
  3. At the top right of the Estimate, click the gray three-dot actions menu.
  4. Hover over the Export to Excel option and choose from the following export types:
    1. Export for Reference: Choose this option to create an Excel file for referencing and sharing externally from ConstructionOnline.
      1. Please note the Excel file exported using this option will not be able to be imported into ConstructionOnline.
    2. Export for Import: Choose this option to create an Excel file that can be revised and imported back into ConstructionOnline to update an existing Estimate or create a new Estimate.
    3. Export for Accounting: Choose this option to create an Excel file that can be revised and imported to update an existing Estimate's Actuals, Invoiced, and Committed values. 

      exporttoexcel
  5. If you choose to Export for Reference
    1. Within the Create Excel File for Reference window, choose from the following options: 
      1. Detail Level
        1. Full Estimate: Includes all Categories, Subcategories, and Items in the export
        2. Project Totals: Includes only the Estimate Project Totals sheet in the export
      2. Export Options
        1. Select the ◻️ Exclude rows with no value option to omit Estimate rows that have no value from the exported Excel file. This option is not selected by default. 
  6. If you choose to Export for Import
    1. Within the Create Excel File for Importing window, choose from the following options: 
      1. Detail Level
        1. Full Estimate: Includes all Categories, Subcategories, and Items in the export
        2. Project Totals: Includes only the Estimate Project Totals sheet in the export
      2. Columns to Include
        1. All Columns are selected by default but can be disabled by deselecting the ☑️ check mark beside their title. If you wish to deselect all of the available Columns, click the blue "Deselect All" text. 

          ☑️ Code               
          ☑️ Description  
          ☑️ Quantity        
          ☑️ Unit Cost
          ☑️ Base Cost
          ☑️ Markup
          ☑️ Classification
          ☑️ Notes
          ☑️ Specifications
          ☑️ Actuals
          ☑️ Invoiced
          ☑️ Committed
          ☑️ QuickBooks Actuals
          ☑️ QuickBooks Invoiced
          ☑️ QuickBooks Committed
      3. Export Options
        1. Select the ◻️ Exclude rows with no value option to omit Estimate rows that have no value from the exported Excel file. This option is not selected by default. 
  7. If you choose to Export for Accounting
    1. Within the Create File for Accounting window, choose from the following options: 
      1. Accounting Software
        1. QuickBooks: Accounting values entered in the Excel file will appear in the QuickBooks Actuals, QuickBooks Invoiced, and QuickBooks Committed columns when imported back into the Estimate 
        2. Other Software/Manual Entry: Accounting values entered in the Excel file will appear in the Actuals, Invoiced, and Committed columns when imported back into the Estimate
      2. Detail Level
        1. Full Estimate: Includes all Categories, Subcategories, and Items in the export
        2. Project Totals: Includes only the Estimate Project Totals sheet in the export
      3. Columns to Include
        1. The QuickBooks Actuals, QuickBooks Invoiced, and QuickBooks Committed columns are selected by default. Columns can be selected/deselected by marking the ☑️ check mark beside their title. If you wish to select all Columns, click the blue "Select All" text. 

          ◻️ Code               
          ◻️ Description  
          ◻️ Quantity        
          ◻️ Unit Cost
          ◻️ Base Cost
          ◻️ Markup
          ◻️ Classification
          ◻️ Notes
          ◻️ Specifications
          ◻️ Actuals
          ◻️ Invoiced
          ◻️ Committed
          ☑️ QuickBooks Actuals
          ☑️ QuickBooks Invoiced
          ☑️ QuickBooks Committed
      4. Export Options
        1. Select the ◻️ Exclude rows with no value option to omit Estimate rows that have no value from the exported Excel file. This option is not selected by default. 
  8. Finalize your selected Export preferences by clicking the blue "Export Estimate to Excel" button to initiate the creation of the external Excel file.
    1. Upon completion, the exported Excel file will be available in the Downloads section of the web browser in use. 

ALTERNATIVE ACCESS POINT

  • Estimates can also be Exported to Excel for Accounting purposes using the Estimating Toolbar by using the following steps:
    • Open the Estimate you wish to export to Excel 
    • Open the Estimating Toolbar by clicking the brick icon at the top right of the Estimate
    • Select the Reports tab and click the "Export to Excel" option

      toolbar
    • Then, follow Steps 7 & 8 above to export your Estimate as an Excel file. 

ADDITIONAL INFORMATION

  • Exporting an Estimate to Excel is available for all OnCost Estimates in ConstructionOnline, including Estimate Templates. 
  • Estimate files exported to Excel are delivered by default in the .XLSX format.
  • Formulas and/or additional functions built into OnCost Estimating are not included in Excel exports. 
  • Permissions: ConstructionOnline Company Users who have Estimating permissions set to "Can View" and “Can Create, Edit, & Delete” can export Estimates to Excel.
  • Mobile App: Exporting an Estimate to Excel is exclusively available for Company Employees via browser access to ConstructionOnline.
    • Estimates are presented in View-Only Mode on the CO™ Mobile App. 

HAVE MORE QUESTIONS?

  • Frequently asked questions (FAQ) regarding OnCost Estimating can be found in the FAQ: Estimating article. 
  • If you need additional assistance, chat with a Specialist by clicking the orange Chat icon located in the bottom left corner or visit the UDA support page for additional options.