Export Expense Reports to QuickBooks
- Expense reports are not automatically sent to QuickBooks. This process is initiated by the user as described in the slideshow below.
- Make sure your connection to QuickBooks has been updated recently.
- Only reports can be exported to QuickBooks, not individual expenses.
- If reports contain both reimbursable and non-reimbursable expenses and you log them differently, export the same reports twice using different settings for reimbursable and non-reimbursable expenses. This is described in more detail on slide 5.
When deciding what to Export As…
- Exporting reports as a check or credit card charge is used when an employee or vendor is being reimbursed with company money.
- Exporting reports as a bill is used to signify that a report has been received but will be paid at a later time. This is usually associated with billable expenses which are going to be invoiced to another party.
- Exporting as a general journal entry is used to associate the report as either a debit or credit.
If the export options detailed here don’t work for you, please visit our custom QuickBooks export page.
How to Export Reports from Expensify to QuickBooks
Step 1: Choose which report(s) to export
From the Reports page, select the reports you would like to export, click “Export To”, and choose “QuickBooks”.
Step 2: Choose your QuickBooks company
If you have multiple QuickBooks companies connected to one Expensify account, use the dropdown menu to select which QuickBooks company to export to.
Troubleshooting tip: if your expenses aren’t exporting to QuickBooks, check that you are exporting to the correct company file.
Step 3: Export methods
There are four basic ways to export to QuickBooks: as a check, a bill, a credit card charge, or a general journal entry. This choice largely depends on your accounting practices and will influence some of the other options available later. See above for examples of when you might use each option.
Step 4: Reimbursable and non-reimbursable expenses
Choose whether to export only reimbursable expenses, only non-reimbursable expenses, or both.
Tip: If you classify reimbursable and non-reimbursable expenses differently in QuickBooks, you will want to export the same reports twice with different settings. First with only reimbursable expenses checked and then with only non-reimbursable expenses checked.
Step 5: Options based on export method
These options will change depending on whether you are exporting as a check, bill, credit card charge, or general journal entry.
Step 6: Individual expenses vs. single report item
Exporting each expense as an individual item will use the dates of each individual expense. Exporting as a single item with split/itemized transactions or as just a single item will use the date of export.
Step 7: Default accounts
The default expense account refers to where expenses will be placed in the case that they haven’t been categorized. This field is required.
Default class and default customer/job refer to where expenses should be allocated in the case that they haven’t been tagged with one or the other. These fields are optional.
Once you have selected your export options, click Export.
What happens next?
- QuickBooks Online - Like magic, all of the exported expenses will appear in your QuickBooks account.
- QuickBooks Desktop - Open up the QuickBooks Web Connector and click “Update Selected” to bring the exported expenses into QuickBooks.