Our developers worked with Foundation
to determine what they need to use our export.
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.
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.
<Note
On Center Software does not provide assistance with importing the Budget File into your Accounting package. Accounting packages are very complex and the vendor of your particular Accounting package is best equipped to support it.To export the budget to Foundation Accounting software,
- Click the Exports button on the Bid toolbar
- Select Job Budget File
- Click the Options Button next to "Job Budget File" - the Modify Options for Job Budget File dialog box opens
Material Tax & Labor Burden
This Accounting Export includes an option called "Distribute Burden":
- When checked, Labor Burden is rolled into the Labor Cost Code from which it is derived
- When unchecked, Labor Burden shows as a separate line item, associated with the same Labor Cost Code, but with a different Category Code (LB instead of L, by default).
- From the Export Format drop down, select "Foundation Software" (exports to a CSV file)
- Select the options and filename/location where the export file is to be saved
- Click the OK button to return to the Bid Exports screen
- Click the Export button (your file is not generated until you click the Export button)
The Budget File export allows you to create a Budget in FOUNDATION, based on the final Bid information from Quick Bid. For assistance importing a budget file into FOUNDATION, please consult your FOUNDATION User Guide or Foundation Software's support.
Custom 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 will be blank. Please return to Tools - Options - Category Codes and set them back to "M", "L", "S", "E", and "O".
After exporting, you can update your CSV file with your custom Category Codes, as needed.
<Export Column Definition
Column headers are not included in the export, they are added below as annotation only.
| Column # | Column Value |
|---|---|
| 1 | If Group by Areas is unchecked: Column not included If Group by Areas is checked: <Blank> |
| 2 | If Group by Areas is unchecked: Column not included If Group by Areas is checked: <Area Name> |
| 3 | If Use Account Codes is not checked: <Cost Code> If Use Account Codes is checked: <Account Code> If Cost Code does not have an assigned Account Code: <Cost Code> |
| 4 | <Material Net Amount> |
| 5 | <Material Tax>, <Equipment tax> or <Other Tax> |
| 6 | <Labor Net Amount> If Distribute Burden is checked: <Labor Net Amount + Burden> |
| 7 | <Labor Burden> If Distribute Burden is checked: <Blank> |
| 8 | <Subcontractors Net Amount> |
| 9 | <Equipment Net Amount> |
| 10 | <Other Net Amount> |
Export Example
Related Articles