QuickBooks is an amazingly powerful tool. It can be configured (and misconfigured) countless ways. But the high level concept of how to export from Expensify to QuickBooks desktop is relatively straightforward. There are a bunch of detailed instructions in our help section, but here’s a quick step-by-step guide — feel free to print it out so you can follow along.
Phase 1: Clean up your account
First, if you’ve already started exporting and it’s not working for you for some reason, I suggest cleaning up your account so we can start over from scratch. Don’t worry: you won’t lose any data or affect your QuickBooks company file or Expensify reports in any way — this just removes any old connections so we can rebuild them from scratch.
- Sign in to Expensify using the https://expensify.com link (eg, do notsign in via Intuit Workplace). This just keeps things easy.
- If necessary, reset your password by going to https://expensify.com/signin and clicking “forgot your password?”
- Click “Settings” in the upper right, then “Connections” on the left, and click “delete” next to any existing QuickBooks connections. This won’t affect your data, but it will just disconnect it from your Expensify account.
- Remove your “Intuit” secondary login. Just more cleanup. Click “Settings” in the upper-right, then “Account” on the left, and click “[remove]” next to any “intuit” line in the “Secondary Logins” section.
Phase 2: Connect to QuickBooks and export the report
Next, let’s go set up a new connection to QuickBooks using the QuickBooks web connector, and then export our first report.
- Shut down QuickBooks, QuickBooks web connector, or essentially anything Intuit or QuickBooks-related on your desktop.
- Close all web browsers.
- Open a new web browser (I strongly recommend Google Chrome).
- Sign in to the Expensify website direct using this link: https://expensify.com
- Note: Do NOT sign in via Intuit Workplace, Intuit App Center, or by clicking anything inside of QuickBooks. This is an advanced feature.
- Click “Reports” at the top of the Expensify site.
- Click the name of the report you want to export.
- If there are no reports here, click “new report” and create one for testing — add at least one expense to it by clicking “new expense”. Basically, expenses needed to be added to a report before they can be exported to QuickBooks.
- If someone else submitted this to you, click “approve” first, and choose “final approve”.
- If you created this report, click “archive” first.
- If no companies are listed, follow these instructions.
- When done, go back to step (1) and start over.
- If it doesn’t open, reboot computer and try again.
- If it still doesn’t open, call Intuit (888-222-7276).
And that should do it. It’s not exactly a painless process, but it’s an incredibly powerful one. If you get stuck in any of the above steps, please email firstname.lastname@example.org, indicate at exactly which step the problem occurred, and include a screenshot of exactly what you’re seeing. The more detail you can give us, the better we can help. Thanks!