Best Practices Using QuickBooks Online

A connection to QuickBooks Online lets you combine the power of Expensify’s expense management features with QuickBooks’s accounting capabilities. By following the recommended best practices below, your finances will be automatically categorized correctly and accounted for in the right place.

• Configure your setup immediately after making the connection, and review each settings tab thoroughly.
• Keep Auto Sync enabled.
  • The daily sync will update Expensify with any changes to your chart of accounts, customers/projects, or bank accounts in QuickBooks Online.
  • Finalized reports will be exported to QuickBooks Online automatically, saving your admin team time with every report.
• Set your preferred exporter to a user who is both a workspace and domain admin.
• Configure your coding settings and enforce them by requiring categories and tags on expenses.

Accessing the QuickBooks Configuration Settings

QuickBooks Online is connected at the workspace level, and each workspace can have a unique configuration that dictates how the connection functions. To access the configuration:

1. Click Settings near the bottom of the left-hand menu.
2. Navigate to Workspaces > Groups > [workspace Name] > Connections.
3. Scroll down to the QuickBooks Online connection and click the Configure button to open the settings menu.

Step 1: Configure Export Settings

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

1. Click the Configure button under the QuickBooks Online connection to open the settings menu.
2. Under the Export tab, review each of the following export settings:
   • Preferred Exporter: Choose a Workspace Admin to set as the Preferred Exporter.
     • Concierge exports reports automatically on behalf of the preferred exporter.
     • Other Workspace Admins will still be able to export to QuickBooks Online manually.
     • If you set different export bank accounts for individual company cards under Settings > Domain > Company Cards, your Preferred Exporter must be a Domain Admin in addition to a Workspace Admin.
   • Date: When exporting reports to QuickBooks Online, you can choose the report’s submitted date, the report’s exported date, or the date of the last expense on the report.
     • If you choose a Credit Card or Debit Card for non-reimbursable expenses, we’ll use the transaction date on each expense during export.
   • Reimbursable expenses: Reimbursable expenses export to QuickBooks Online as:
     • Vendor Bills (recommended): This is a single itemized vendor bill for each Expensify report.
     • Checks - This is a single itemized check for each Expensify report. You can mark a check to be printed later in QuickBooks Online.
     • Journal Entries - This is a single itemized journal entry for each Expensify report.
   • Non-reimbursable expenses: Non-reimbursable expenses export to QuickBooks Online as:
     • Credit Card expenses - Each expense will be exported as a bank transaction with its transaction date.
     • Debit Card Expenses - Each expense will be exported as a bank transaction with its transaction date.
     • Vendor Bills - A single detailed vendor bill is generated for each Expensify report.
       • If the accounting period is closed, the vendor bill will be posted on the first day of the next open period. If you choose to export non-reimbursable expenses as Vendor Bills, you can assign a default vendor to the bill.
       • The export will use your default vendor if you have Default Vendor enabled. If the Default Vendor is disabled, the report’s submitter will be set as the Vendor in QuickBooks.
   • Billable Expenses: In Expensify, you can designate expenses as billable. These will be exported to QuickBooks Online with the billable flag.
     • This feature applies only to expenses exported as Vendor Bills or Checks. To maximize this functionality, ensure that any billable expense is associated with a Customer/Job.
   • Export Invoices: If you are creating Invoices in Expensify and exporting these to QuickBooks Online, this is the account the invoice will appear against.

Step 1B: Optional Configuration When Company Cards Are Connected

1. Click Settings near the bottom of the left-hand menu.
2. Navigate to Domains > [domain name] > Company Cards.
3. If you have more than one company card connection, select the connection first.
4. Locate the cardholder you want to configure in the list,
5. Click the Edit Exports button and assign the account the card expenses should export to in QuickBooks Online.

Step 2: Configure Coding Settings

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

1. Click the Configure button under the QuickBooks Online connection to open the settings menu.
2. Under the Coding tab, review each of the following settings and configure the options to determine what information will be imported:
   • Categories: QuickBooks Online Chart of Accounts are imported into Expensify as categories. This is enabled by default and cannot be disabled.
     • Equity-type accounts will also be imported as categories.
     • Other Current Liabilities can only be exported as Journal Entries if the submitter is set up as an Employee in QuickBooks.
   • Classes and Customers/Projects: If you use Classes or Customers/Projects in QuickBooks Online, you can import those into Expensify as Tags or Report Fields:
     • Tags let you apply a Class and/or Customer/Project to each expense.
     • Report Fields enables you to apply a Class and/or Customer/Project to all expenses on a report.
       • Note: Although Projects can be imported into Expensify and coded to expenses, due to the limitations of the QuickBooks API, expenses cannot be created within the Projects module in QuickBooks.
   • Locations: When enabled will import into Expensify as a Report Field or, if you export reimbursable expenses as Journal Entries and non-reimbursable expenses as Credit/Debit Card, you can import Locations as Tags.
   • Items: If you use Items in QuickBooks Online, you can import Items defined with Purchasing Information (with or without Sales Information) into Expensify as Categories.
   • Tax: Once enabled, QuickBooks Online tax rates can be further configured on the Settings > Workspaces > Groups > [Workspace Name] > Tax page.
     • Note: Tax cannot be exported to Journal Entries in QuickBooks Online.

Step 3: Configure Advanced Settings

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

1. Click the Configure button under the QuickBooks Online connection to open the settings menu.
2. Under the Advanced tab, review each of the following settings and configure the options you wish to use:
   • Auto Sync: When enabled, the connection will sync daily 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.
     • Reimbursable expenses will export after reimbursement occurs or the report is marked as reimbursed outside Expensify when using Direct or Indirect reimbursement.
     • Non-reimbursable expenses will export automatically after the report is final approved.
   • Newly Imported Categories Should Be: When a new account is created in the QuickBooks Online chart of accounts, this setting controls whether the new category in Expensify is enabled or disabled by default. Disabled categories are not visible to employees when coding expenses.
   • Invite Employees: When enabled, Auto Sync imports QuickBooks Online employee records and invites them to the workspace.
   • Automatically Create Entities: If you export reimbursable expenses as Vendor Bills or Journal Entries, Expensify will automatically create a vendor in QuickBooks (If one does not already exist). Expensify will also automatically create a customer when exporting Invoices.
   • Sync Reimbursed Reports: Enabling will mark the Vendor Bill as paid in QuickBooks Online if you reimburse a report via ACH direct deposit in Expensify. If you reimburse outside of Expensify, then marking the Vendor Bill as paid in QuickBooks Online will automatically mark the report as reimbursed in Expensify.
     • QuickBooks Account: Select the bank account your reimbursements are coming out of, and we’ll create the payment in QuickBooks.
     • Collection Account: When exporting invoices from Expensify to Quickbooks Online, the invoice will appear against the Collection Account once marked as Paid.