On Center Home | MyOnCenter Portal | Start an On-Screen Takeoff Trial | Request a Quick Bid Demo | Contact Us | SALES: 1-866-627-6246
 
 
Learn more about Searching
Looking for help for one of ConstructConnect's Other products? Login


Tools
Table of Contents

QB 4.99 - 14.05 Job Data (Cost) File Export

Views: 179 Last Updated: 06/01/2022 08:13 am 0 Rating/ Voters
Be sure to rate this article 5 Stars if you find it helpful!

Quick Bid allows you to export bid costs (Material, Labor, Subs, Equip, Other, with Tax/Burden, but without Overhead or Profit) into a Job Data File file (in CSV format) that you can edit in your favorite spreadsheet program and then import into your Accounting package.

Alternates and Change Orders
If you are working in a Change Order, when you run an Export, it is for that Change Order only. To run a report or export on the Base Bid with or without accepted child bids, select the Base Bid from the Bid Navigator, and then open the Exports dialog box.
Caution

Although the Bid, Labor, and Material Exports are available to any licensed user, the Accounting and Custom Exports are only available to users under a maintenance subscription.

If you've allowed your maintenance subscription to expire, you can renew easily by clicking File > Check Authorization and clicking the Renew link.

QB License Activation dialog box - renew link

That link opens the MyOnCenter customer portal where you (or whoever can pay the invoice) may renew your maintenance subscription.

You can also contact Customer Success to discuss renewing your maintenance subscription.

This export is a raw data export of bid costs, rather than one that is custom-formatted for any particular Accounting system - this means it's more flexible and can be imported into almost any Accounting package, after you make some adjustments to the csv file.

Exporting the Job Data File

To export a Job Data File,

Click the Exports button and select the Job Budget File under Accounting and Custom Exports

Quick Bid Exports dialog box

Click Options - the Modify Options for Job Budget File dialog opens

Notes

Global Options (Include Bid Number and Use Account Codes) are not applied to the Job Data File, although the Account Codes associated with each Cost Code are exported, whether the option is selected or not.

The Job Data File is a cost export - it does not include Overhead or Profit.

Use the Lookup button to choose where the export file is saved and what to name it - by default, exports are saved in the Database folder with a name based on the name of the Bid or Change Order. Update the File Name but do not change the file extension (such as *.csv).

Click Open

Click OK - the options dialog box closes

In the Exports dialog box, click Export to save the Job Budget File export

Once the Job Data File Export is complete, you can open that file in Excel or whatever application you use to view/manipulate CSV files.

Category Codes are Unsupported
At this time, custom Category Codes are not supported with this export. If you have configured custom Category Codes, your export show them as "M", "L", "S", "E", and "O".

Job Data File Fields

The export looks like this when it's opened in Excel (or another spreadsheet app):

Job Data File opened in Excel

Here are the fields that are exported:

  

Column Field Description/Where it comes from...
1 or A BidAltCOName The Bid (Project), Alternate, or Change Order Name
If the export does not contain Costs from more than one Bid/Child Bid, this column is blank (so, if you are in a Bid that doesn't have any Alternates or Change Orders, or you uncheck the option to include them, or you are generating the export from a Change Order, this column is not populated). 
2 or B SectName The Section Number and Name
3 or C  AreaOrTypicalAreaName The Bid Area or Typical Area to which the cost is associated
Typical Areas, if included, show the Quantity calculated for each Typical Areas, however, Column 24/X (the money column) shows "0" as these costs are shown in the Bid Area to which they get allocated.
4 or D  LabMatEqOtSub  Indicates the "type" of Cost (Labor, Material, Subs, Equip, or Other)
5 or E  CostCodeName Cost Code
6 or F  AccountCodeName Account Code
7 or G  Description Cost Code Description
8 or H  Quantity The cumulative total quantity for this Cost Code derived from the Item's calculation in all Conditions
For Markups (Tax/Burden) and Indirect Expenses, this is "0"
9 or I  UOM The UOM associated with the above (left) Quantity derived from the Item's calculation in a Condition
For Markups (Tax/Burden) and Indirect Expenses, this is blank for expenses calculated off Labor
10 or J  Amount The total Cost less Markups and Indirect Expenses (they are broken out individually) and not including Overhead or Profit (they are not included in the Job Data File export)
11 or K  CrewDay * For Labor Costs, the number of Crew Days (the total labor cost divided by the Daily Wage, divided by the number hours/day, divided by the number in the crew) *
12 or L  HoursPerDay * Number of hours/day as shown in the Cover Sheet *
13 or M  ManDay * For Labor Costs, the number of Crew Days (the total labor cost divided by the Daily Wage, divided by the number hours/day) *
14 or N  ProdDay * For Labor Costs, the Quantity of UOM for a cost divided by the number of ManDays (which is CrewDays multiplied by the # in the Crew) *
15 or O  BidAltCONotes From the Bid, Alternate, or Change Order's Cover Sheet.
16 or P  AccountCodeDesc The Account Code associated with this Cost Code.
17 or Q  BTCostCodeName ** Burden/Tax Cost Code **
18 or R  BTAccountCodeName ** Account Code associated with the Burden/Tax Cost Code **
19 or S  BTDescription ** Burden/Tax Cost Code Description **
20 or T  BTAccountCodeDesc ** Account Code Description associated with the Burden/Tax Cost Code **
21 or U  Escalation Escalation on Materials or Labor Costs
22 or V  BurdenTax Tax (Material)/Burden(Labor) that is applied to the Cost Code
23 or W  TotalLaborHours The total Labor Hours for this Cost Code (ManDays * Hours per day)
24 or X  AmountExcludeTPA Unburdened Cost for this Cost Code
Shows "0" for Rows whose Quantity is assigned to a Typical Area (the extended Bid Area rows are calculated, not the Typical Area row).

*Production information shown for Material Costs can be ignored.

**If this field is populated, the amount in the Column 24/X, AmountExcludeTPA, is the Tax or Burden for the Cost Code listed in Column 5/E). This Tax/Burden value is also shown in Column 22/V (BurdenTax) on the Material, Labor, Sub, Other, or Equipment's Cost Code's row. This allows you flexibility when importing, however be sure you don't import both.

When you are done changing the layout of the data, save the file and then import that file into your Accounting program.

Note
For assistance importing an Accounting or Material export into your Accounting package, please contact the vendor or manufacturer of your Accounting program.

 Job Materials Exports What is a Database



Product documentation (user guides) describes functionality in the latest version of each major release and may not match the functionality in the version you are using. Please check the Product Information and Downloads pages by clicking one of the product buttons above.

Something Wrong with this Article? Let us Know! Copyright 2021 - On Center Software, Inc. by ConstructConnect - All Rights Reserved.