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 - 14.03.01 AccuBuild® Accounting Export

Views: 841 Last Updated: 04/20/2023 08:37 am 0 Rating/ Voters
Be sure to rate this article 5 Stars if you find it helpful!

 Our developers worked with AccuBuild to determine what was needed to import the information into their software.

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.

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 AccuBuild Accounting software,

Click the Exports button on the Bid toolbar

Select Job Budget File

Quick Bid Export - Job Budget options

Click the Options Button next to "Job Budget File" - the Modify Options for Job Budget File dialog box opens

Quick Bid Job Budget Export dialog box - AccuBuild selected

From the Export Format drop down, select "AccuBuild" (exports to an XLS file)

Select the options and filename/location where the export file is to be saved

Material Tax and Labor Burden

This Accounting Export includes an option to "Include and Distribute Material Tax".

  • When checked, Material Tax is rolled into the Material Cost Code from which it is derived. 
  • When unchecked, Material Tax is not included in the Export at all.

Job Budget Export - Include and Distribute Material Tax?

This Accounting Export also includes 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).


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 Job Budget File export allows you to create a Budget in AccuBuild Accounting Software, based on the final Bid information from Quick Bid. For assistance importing a budget file into AccuBuild Accounting Software, please consult your AccuBuild Accounting Software User Guide or AccuBuild Accounting's support.

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".

Export Column Definition

Column headers (Cost Code, Description, etc.) are included in this export.

Job Budget Export - AccuBuild columns defined

Quick Bid also provides an export for Materials that can be imported into AccuBuild's Accounting software, see AccuBuild® Materials Export for more information.

Column # Column Header Column Value
1 Cost Code 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>
2 Description If Use Account Codes is not checked: <Cost Code Description>
If Use Account Codes is checked: <Account Code Description>
If Cost Code does not have an assigned Account Code: <Cost Code Description>
3 Area If Group by Areas is not checked: Blank If Group by Areas is checked: <Area Name>
4 Material <Material Net Amount>
If Include and Distribute Material Tax is checked: <Material Net Amount + Tax>
If Include and Distribute Material Tax is not checked: <Tax> does not display
5 Hrs <Labor Hours>
6 Labor <Labor Net Amount>
If Distribute Burden is checked: <Net Amount + Burden>
If Distribute Burden is not checked: <Burden> does not display
7 Subcontractor <Subcontractor Net Amount>
If Include and Distribute Material Tax is checked: <Subcontractor Net Amount + Tax>
If Include and Distribute Material Tax is not checked: <Tax> does not display
8 Equipment <Equipment Net Amount>
If Include and Distribute Material Tax is checked: <EquipmentNet Amount + Tax>
If Include and Distribute Material Tax is not checked: <Tax> does not display
9 Other <Other Net Amount>
If Include and Distribute Material Tax is checked: <Other Net Amount + Tax>
If Include and Distribute Material Tax is not checked: <Tax> does not display
10 Total <Row Cost Total>



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 2023 - On Center Software, Inc. by ConstructConnect - All Rights Reserved.