How do Bills sync from QuickBooks to Contractor Foreman

How Bills Transfer from QuickBooks to Contractor Foreman

The integration between QuickBooks and Contractor Foreman allows for a two-way synchronization of bills, ensuring that your financial data remains aligned across both platforms. While many users are familiar with bills flowing from Contractor Foreman to QuickBooks, it’s equally important to understand how bills created in QuickBooks are transferred into Contractor Foreman—and how to do it properly.

Critical Requirements for Proper Synchronization and Job Costing in Contractor Foreman

There is a critical caveat: for the bill to be fully usable within Contractor Foreman—especially for job costing purposes—it must be entered into QuickBooks in a very specific way.

When a bill is created in QuickBooks, the following general details are synchronized and appear correctly in Contractor Foreman:

• Supplier (interpreted as Vendor or Subcontractor in Contractor Foreman)
• Terms
• Bill Date
• Due Date
• Bill Number

These details ensure that the basic structure of the bill is captured accurately across both platforms.

The Two Ways to Enter Line Items in QuickBooks

Once the general details are entered, QuickBooks presents two options for inputting the bill’s line items:

1. Category Details
2. Item Details

1. Category Details – Not Recommended

The Category Details section is the default and most commonly used method, especially by accountants. In this section, you select a general expense account (category) for each line item.

While bills entered using Category Details will still sync into Contractor Foreman, some information will be missing in Contractor Foreman:

• Item type always will be “Other”
• There is no unit cost and there is no QTY, by default QTY is 1 and Unit Cost is the total amount
• No units in QuickBooks, means no units in Contractor Foreman.
• No cost code.

With that in mind, there is a major issue:

No Cost Codes will transfer, and the bill will be locked in Contractor Foreman, meaning you won’t be able to edit or assign cost codes manually afterward.

This severely limits the ability to perform proper job costing and project financial tracking within Contractor Foreman.

2. Item Details – Recommended for Proper Sync and Job Costing

The second method is using the Item Details section. This is the preferred and recommended way to enter bills if you plan to integrate with Contractor Foreman.

Why?

• In this section, instead of selecting categories, you select from your list of Products and Services in QuickBooks.
• These Products/Services are mapped to your Parent and Child Codes in Contractor Foreman.
• When entered this way, each line item carries over with the correct quantity, rate, total, and most importantly, the Cost Code.

This structure allows Contractor Foreman to read and assign the data properly, giving you full access to itemized costs within the platform and enabling detailed job costing.

What Transfers from QuickBooks

By Category detail:

1. The Basic Information:
   1. Supplier (interpreted as Vendor or Subcontractor in Contractor Foreman)
   2. Terms
   3. Bill Date
   4. Due Date
   5. Bill Number
2. Item Name
3. Total
4. Description
5. Attachments

By Item detail:

1. The Basic Information:
   1. Supplier (interpreted as Vendor or Subcontractor in Contractor Foreman)
   2. Terms
   3. Bill Date
   4. Due Date
   5. Bill Number
   6. What Does Not Transfer
2. Item Name
3. QTY
4. Unit Cost
5. Total
6. Cost Code
7. Description
8. Attachments

What does not transfer?

By Category detail:

1. Item Type
2. QTY
3. Unit Cost
4. Unit
5. Cost Code

By Item detail:

1. Item Type
2. Unit

Conclusion

While syncing bills from QuickBooks to Contractor Foreman is possible, it requires discipline and consistency in how data is entered in QuickBooks. Failing to follow the proper structure will result in bills that are incomplete for project management purposes in Contractor Foreman. To maintain clean job costing and detailed project tracking, always use the Item Details section in QuickBooks and ensure that your products/services are properly mapped to Contractor Foreman cost codes.