Once you’ve set up your QuickBooks Online connection, you’ll be able to configure your import and export settings.

Step 1: Configure import settings

The following steps help you determine how data will be imported from QuickBooks Online to Expensify.

1. Under the Accounting settings for your workspace, click Import under the QuickBooks Online connection.
2. Review each of the following import settings:
• Chart of accounts: The chart of accounts are automatically imported from QuickBooks Online as categories. This cannot be amended.
• Classes: Choose whether to import classes, which will be shown in Expensify as tags for expense-level coding.
• Customers/projects: Choose whether to import customers/projects, which will be shown in Expensify as tags for expense-level coding.
• Locations: Choose whether to import locations, which will be shown in Expensify as tags for expense-level coding.


As Locations are only configurable as tags, you cannot export expense reports as vendor bills or checks to QuickBooks Online. To unlock these export options, either disable locations import or upgrade to the Control Plan to export locations encoded as a report field.

• Taxes: Choose whether to import tax rates and defaults.

Step 2: Configure export settings

The following steps help you determine how data will be exported from Expensify to QuickBooks Online.

1. Under the Accounting settings for your workspace, click Export under the QuickBooks Online connection.
2. Review each of the following export settings:
• Preferred Exporter: Choose whether to assign a Workspace Admin as the Preferred Exporter. Once selected, the Preferred Exporter automatically receives reports for export in their account to help automate the exporting process.

• Other Workspace Admins will still be able to export to QuickBooks Online.
• If you set different export accounts for individual company cards under your domain settings, then your Preferred Exporter must be a Domain Admin.
• Date: Choose whether to use the date of last expense, export date, or submitted date.
• Export Out-of-Pocket Expenses as: Select whether out-of-pocket expenses will be exported as a check, journal entry, or vendor bill.

These settings may vary based on whether tax is enabled for your workspace.
• If tax is not enabled on the workspace, you’ll also select the Accounts Payable/AP.
• If tax is enabled on the workspace, journal entry will not be available as an option. If you select the journal entries option first and later enable tax on the workspace, you will see a red dot and an error message under the “Export Out-of-Pocket Expenses as” options. To resolve this error, you must change your export option to vendor bill or check to successfully code and export expense reports.
• Invoices: Select the QuickBooks Online invoice account that invoices will be exported to.
• Export as: Select whether company cards export to QuickBooks Online as a credit card (the default), debit card, or vendor bill. Then select the account they will export to.
• If you select vendor bill, you’ll also select the accounts payable account that vendor bills will be created from, as well as whether to set a default vendor for credit card transactions upon export. If this option is enabled, you will select the vendor that all credit card transactions will be applied to.

Step 3: Configure advanced settings

The following steps help you determine the advanced settings for your connection, like auto-sync and employee invitation settings.

1. Under the Accounting settings for your workspace, click Advanced under the QuickBooks Online connection.
2. Select an option for each of the following settings:
• Auto-sync: Choose whether to enable QuickBooks Online to automatically communicate changes with Expensify to ensure that the data shared between the two systems is up-to-date. New report approvals/reimbursements will be synced during the next auto-sync period.
• Invite Employees: Choose whether to enable Expensify to import employee records from QuickBooks Online and invite them to this workspace.
• Automatically Create Entities: Choose whether to enable Expensify to automatically create vendors and customers in QuickBooks Online if a matching vendor or customer does not exist.
• Sync Reimbursed Reports: Choose whether to enable report syncing for reimbursed expenses. If enabled, all reports that are marked as Paid in QuickBooks Online will also show in Expensify as Paid. If enabled, you must also select the QuickBooks Online account that reimbursements are coming out of, and Expensify will automatically create the payment in QuickBooks Online.
• Invoice Collection Account: Select the invoice collection account that you want invoices to appear under once the invoice is marked as paid.