INTACCT Estimate Detail Export Add-in

B2W Estimate's INTACCT export allows you to export detailed information from any estimate, saving it as a file which can be imported into your INTACCT accounting system.

Below are some highlights of how the export works. More details appear in later sections within this help topic.

  • The export creates a CSV formatted file.

  • The export processes both pay items and indirect items.

  • The export creates revenue records at the pay item level.

  • The export creates cost records at the item, task or component level.

  • The export allows you to export indirect cost, bond, profit and overhead at either the item level or at the estimate level.

Default Export Options

Before you can successfully export to INTACCT , you must first configure some basic export settings in the B2W Estimate Options dialog. This is part of the initial setup; once these settings are properly entered, you should not have to perform these steps again.

  1. Launch B2W Estimate.

  2. Click Options in the Administration section on the Home Page or on the ribbon bar in an open estimate.

  3. In the Options dialog, click the Imports/Exports folder, then click the Export Settings page.

  4. In the Select Export Format box, select INTACCT.

    Figure 1. See an example


  5. Enter your INTACCT Account Numbers for each B2W Estimate cost category.

  6. There are optional setting for exporting distributed indirect cost, bond, profit, and overhead.

    • If you wish to export distributed cost at the pay item level, enter only an Account Number.

    • If you wish to export the distributed cost at the estimate level, enter an Account Number and a Class ID.

    • If you wish to NOT export distributed costs enter nothing for these export settings.

Configuring a B2W Estimate for export to INTACCT

  1. Open the estimate that you wish to export to INTACCT.

  2. On the Item Listing or Estimate Detail tab, review your pay items and indirect items to ensure the following codes are in place:

    • The item's Job Cost ID will be exported as the INTACCT "CLASSID" in pay item revenue records.

    • The item's Task JCID will be exported as the INTACCT "CLASSID" in pay item cost and hours records.

    • The item's Job Cost ID will be exported as the INTACCT "CLASSID" in task, crew, or component cost and hours records.

    If either of these two fields is blank, a warning will be given and the item or component will not be exported.

Export Specification Table

Field #DescriptionTypeB2W Estimate Data
1BUDGET_IDAlphaDefault = "Project"
2ACCT_NOAlphaAccount Number
3DEPT_IDAlpha{Blank}
4LOCATION_IDAlpha{Blank}
5CUSTOMERIDAlphaPrimary customer Job Cost ID code
6ITEMIDAlphaValue based on "ITEMID Source Field" export setting
7CLASSIDAlphaJob Cost ID or Task JCID code
8PROJECTIDAlphaEstimate Job Number
9Cost / Hours / PriceNumericSummary total cost, hour or bid price for the record type being exported.

Creating the export file

  1. Launch B2W Estimate, and open the estimate you wish to export to INTACCT.

  2. Navigate to the Estimate Information tab and verify that a Start Date has been entered.

  3. Click the Tools menu, point to Import/Export, and then select Export Estimate Detail.

  4. The Export Estimate Detail wizard appears. Click Next.

  5. On the Select Export Format page, verify that INTACCT is the selected export format, and then click Next.

  6. On the Enter File Name page, click Browse, and navigate to the folder where you wish the export file to be created. The default filename will be the job title of your estimate, with a ".csv" extension.

  7. Click Save, then click Next, and then click Finish. A message will be shown once the export file has been created.

  8. Launch INTACCT and import the .csv file created by B2W Estimate.