Intended audience: accountant. Setup involves configuring QuickBooks account and item defaults at the company level, then optionally overriding them per project. No IT involvement is required.

Siteline offers the ability to export your invoice information to QuickBooks Enterprise via a file-based integration, providing a downloadable IIF file for each pay application that you can then import into QuickBooks Enterprise.

This page covers the one-time company and project configuration. For the recurring monthly export workflow, see Usage. For more on importing IIF files into QuickBooks Enterprise, see QuickBooks's IIF documentation.

After we have enabled your QuickBooks integration, you will need to go to your company settings in order to add some information needed for the invoice exports.

From the settings, add default information about your accounts and items in QuickBooks. For any individual project, you'll be able to customize this information if you would like to use accounts or items that are different from the default.

When adding accounts and items, it is important that the name used here is exactly the same as the name used in QuickBooks. If any of the accounts are a sub-account, such as a parent account called Accounts Receivable with a sub-account called Progress Billing, include both names separated by a colon (in this example, it would be Accounts Receivable:Progress Billing).

The Invoice item (progress) chosen here will be associated with every progress line item that is exported to QuickBooks. If your billing is consolidated into a single line item, one item will be exported to QuickBooks. If you export every line item that you billed, each line item will be associated with the same QuickBooks item. The Invoice item (retention) chosen here will be associated with the retention line item for any invoice that has it.

Siteline will only map to one Invoice Item for progress and retention in QuickBooks.

Note that only one accounts receivable account can be used here. The A/R account field in Siteline must map to an account of "Accounts Receivable" type in QuickBooks. All other accounts must be of a different type for the file to be imported into QuickBooks.

Once you have set up your default information, you will have an opportunity to update this on a project by project basis if needed. By default, each new project created will have the defaults included, but you can change this during project set up.

If the name of the customer or project in Siteline is different from the name of the customer or job in QuickBooks, you'll also have the opportunity to add the QuickBooks names for these entities here. For the import into QuickBooks to work properly, the name of the customer and job listed here must match what you have in QB.

If you need to update this later, you'll be able to do so in project settings.