EngineerOffice-QuickBooks Integration - Send Settings

See Also


Use the EngineerOffice-QuickBooks Integration Settings screen to transfer data from EngineerOffice to QuickBooks database. Using the Send Settings option, you can specify what data will be sent from EngineerOffice to QuickBooks.


Click on the Send Settings option to view the list of modules. The screen allows you to restrict the data that is sent from EngineerOffice. You can send data from the following EngineerOffice modules to QuickBooks:


  • Employees

  • Clients

  • Projects

  • Job Codes

  • Account Codes

  • Time Entries

  • Invoices

  • Payments

  • Vendors



With this service you can reduce data entry time and minimize errors. Select the module name in EngineerOffice to view the filter settings for that module. For each module you define what data you want to send to QuickBooks.


The filter options on the right would change based on the module selected. For each module, the screen would display:


QuickBooks File

This shows your current QuickBooks database that will be used for data synchronization.



Use this button to locate the QuickBooks database for data synchronization. By default, EngineerOffice always connects to the currently open QuickBooks company file. However, if QuickBooks is not running, then EngineerOffice tries to open the file specified in the QuickBooks File field.


Do Not Send . . . Data:

Check this option if you do not want EngineerOffice to send data for the selected module. You can check this option if you do not want to send data for a specific EngineerOffice module to QuickBooks. For example, if you do not want to send employee data from EngineerOffice to QuickBooks, you check the Do not send Employee Data option. Data from other modules is sent to QuickBooks according to their specific filter settings.


Ignore Last Sync Date:

When selected, EngineerOffice ignores the date when it had last synced with QuickBooks for the selected table for the integration. The Last Sync On date is displayed below the table list. This date is used for reference when we want EngineerOffice to sync since the last synchronization date. By default, it is unchecked.


Active Only:

When selected, only active EngineerOffice data is looked during data transfer (for example, active employees, clients, vendors, etc.).


When sending contacts, you can choose to send the selected types of contacts as vendors in QuickBooks. A drop-down on the screen allows you to select the contact types that you want to send as a vendor from EngineerOffice.


If the ‘Transfer ‘From retainer’ as invoice line item’ option is selected on the Send Settings > Payments screen, the retainer along with the payment is sent over to QuickBooks as a single line item and a single invoice is created. Else, if the option is unselected, the retainer is sent over to QuickBooks as a separate item and two separate invoices (retainer and payment) are created.


Overwrite Rules for Duplicate Records

In this section specify the overwrite rule for the selected table. Choose from Never, Always or Most Recent. For example, both EngineerOffice and QuickBooks have records for employee John Doe.



When chosen, neither EngineerOffice nor QuickBooks version of a field data is updated. Thus, you will have two versions of the data. For example, if this employee record has different addresses, these two fields would not be updated and both addresses would exist.



When selected, the contents of the QuickBooks field will always overwrite the EngineerOffice field in Get mode. Again, if two different addresses exist, the address in QuickBooks will replace the address in the employee's EngineerOffice profile. However, billed entries will not be modified.


Most Recent

When selected, EngineerOffice compares the Last Modified On date-time stamps for the QuickBooks and EngineerOffice fields. The more recent one updates the field in the other database.


Filters allow you to restrict the information that is transferred between EngineerOffice and QuickBooks. For example, if you would like to transfer only one group of clients from EngineerOffice to QuickBooks select that Client Group ID in both the From and To drop-down menus of the Client Group ID filter. The filter fields keep on changing depending upon the table selected for the synchronization settings. The intersection of data produced by applying all filters is what will be transferred. Click Save to save your filter settings and overwrite rule for the selected table. These settings will be used when you sync data between EngineerOffice and QuickBooks.


Date Filters

Last Modified:

Each record saves a Last Modified On date that is used to determine which record is most recent. This is useful and saves time, if you want to avoid scanning the records every time you use the synchronization option.


You can filter the information for sync, based on this date using the From-To options. Filters allow you to restrict the information that is transferred between EngineerOffice and QuickBooks. If you select All in this submenu, then data for all EngineerOffice tables is transferred to/from QuickBooks.



This option is available for time entries only. It allows you to select a From-To date range for getting selective time data from QuickBooks instead of all.


Other Filters

In this section you have other filters which you can use to restrict the data sent from EngineerOffice to QuickBooks using relevant fields and From-To settings to specify a range. If you choose All (selected by default) all data is sent.


Last Sync on:

This displays the date when EngineerOffice was last synced with QuickBooks for the selected module. This date is used for reference when you want EngineerOffice to sync since the last synchronization date.


See Also