All Collections
Integrations with Fyle
QuickBooks Online 2.0
How to set up the Fyle QuickBooks Online integration v2.0?
How to set up the Fyle QuickBooks Online integration v2.0?
Set up Fyle QuickBooks Online Integration to start importing and exporting expenses.
Gayathiri Sridhar avatar
Written by Gayathiri Sridhar
Updated over a week ago

Before you can start exporting expenses from Fyle to QuickBooks Online, you must follow the onboarding process to set up the Integration. Onboarding is a five-step process; complete the steps by following the details below.

You will be able to access the Integration from the Fyle Admin settings and navigate to Integration> Accounting > QuickBooks Online. This will open the Integration in a new tab and automatically log you in with your Fyle credentials.

1. Connect to your QuickBooks Online Company

Once you've logged in successfully to the integration app, you need to connect to your QuickBooks Online account.

  • Click on Connect QuickBooks Online.

  • Enter your QuickBooks Online login credentials.

Sign in using Quickbooks login credentials
  • Select the QuickBooks Online company to which you want to export all the expenses from Fyle and Connect.

  • After connecting to QuickBooks Online, you'll be redirected back to the Integration. Click on Continue to proceed further.

The Integration takes a few seconds to connect to your selected QuickBooks Online company and import all the data required to complete the setup.

2. Map Employees

Next, you can choose how you represent your Employees on QuickBooks Online.
This would help export an expense from Fyle to a corresponding employee/vendor record in QuickBooks Online.

The Integration can also automatically map the employee's setup in Fyle to their equivalent in QuickBooks Online with a match based on a unique parameter such as name, email address, and employee code.

3. Export Settings

Once the Fyle employee dimension is mapped to the QuickBooks Online equivalent, you can now configure how to export expenses from Fyle to QuickBooks Online.

Export settings are a mandatory step for the Integration to function.

In this step, first, you can select at what stage the expenses should be ready to export from Fyle to QuickBooks Online.

You could choose to export expenses when approved and awaiting payment clearance OR simply when paid out. When the expenses reach the selected state ( Payment processing/Paid), the Integration will automatically import the data in real time and keep it ready for you to export in a single click.

Then, select whether you want to export reimbursable or credit card expenses.

Export Reimbursable Expenses

Enable the option to export reimbursable expenses from Fyle. This will open a section to gather more details on exporting your reimbursable expenses from Fyle to QuickBooks Online.

a. How should the expenses be exported to QuickBooks Online?

Reimbursable expenses from Fyle can be exported as Expenses, Bills, Journal entries, or checks.

b. Based on the transaction type selected above, the relevant account to which the entry has to be posted. For example, in the case of a Bill, an accounts payable account needs to be selected to which the bill has to be posted, whereas, for a Journal entry or Check, you would be choosing a Bank account in QuickBooks Online to which the transaction has to be posted to.

c. How should the expenses be grouped? When exporting expenses from Fyle to QuickBooks Online, all the expenses in a report or a payment can be consolidated in a single transaction, or each expense in Fyle can be coded as an individual transaction.

d. Set the date of the transaction You could choose to set the date of the transaction in QuickBooks Online as

  • spend date,

  • date of approval or verification in Fyle,

  • date when you are running the export ( current date), or

  • date of the latest expense in that report or payment ( if you have chosen to group it that way in step c).

Export Corporate Card Expenses

Enable this option to export all corporate card expenses from Fyle to QuickBooks Online.

Corporate credit card expenses can be exported as Bill; Credit card expenses and Journal entry vs. corporate debit card expenses can be exported as debit card expenses in QuickBooks Online, respectively.

If you are exporting corporate card expenses as a bill, you need to select a default credit card vendor. The Integration will use the default vendor in case the merchant in a Fyle expense does not match the vendor in QuickBooks Online.

Similarly, if you are exporting as a credit card expense or a Journal entry, a default credit card account needs to be set to which all the credit card entries will be posted.

Note: If your organization uses a corporate card from more than one card vendor, we suggest you set up corporate card mapping from the Mapping section to ensure that expenses from a specific card are coded to the right corporate card account in QuickBooks Online.

Lastly, select how the expenses should be grouped and the date that should reflect in the corporate card expense in QuickBooks Online. Note that if you export corporate card expense as corporate card purchase or debit card expense, then by default, each expense will be created as a single expense transaction in QuickBooks Online with the date as spend date.

4. Import Settings

In this section, you would be able to select the dimensions you want to import from QuickBooks Online and use in Fyle while creating expenses.

You could import your Chart of accounts as Categories, Vendors as Merchants, and Tax codes as Tax groups in Fyle.

You can also import QuickBooks Online dimensions such as Class, Department, and Customers as a select type ( dropdown) expense field in Fyle. You can either import these to default select type fields such as Project that is present in Fyle or create a new one right from within the Integration.

5. Advanced Settings

Lastly, in the advanced setting, you can enable the options to customize and automate your export workflow. This section is optional, and you can enable this based on your business requirement.

The advanced setting has options such as Scheduleding automatic export, wherein you can set up a frequency for the Integration to automatically export expenses from Fyle to QuickBooks Online.

Another option is to customize the data set that needs to be passed to the description column of the exports in QuickBooks Online. A sample preview of how the exports will look with the selected fields will also be available.

The advanced setting also hosts options such as exporting expenses with the date of the next open accounting period, auto-sync payment status for bills, auto-create vendors, and creating a single itemized offset credit entry for Journal.

Once you have enabled the required settings, hit save, and you have now completed configuring the Integration. Of course, you can always revisit and change the settings by heading to the Configurations section in the dashboard.

You are ready to start exporting expenses through the integration app. Learn how to export expenses.

Contact us at [email protected] if you need assistance with the setup.

Did this answer your question?