Are you receiving SNAP/EBT benefits? The Expensify.org/SNAP-VAX campaign is live and accepting new members. Learn more about receiving $50 for submitting a SNAP receipt and $50 for getting your COVID-19 vaccine here and join today!
Deep Dive: Configure Export Settings for QuickBooks Online
There are a lot of features within our QuickBooks Online integration, and here I'll specifically be going over Export Settings and how to configure them.
Any policy admin can export to QuickBooks Online, but only the preferred exporter will see reports that are ready for export in their Inbox.
Choose either the report's submitted date, the report's exported date, or the date of the last expense on the report when exporting reports to QuickBooks Online.
Most of the below export options (Check, Journal Entry, and Vendor Bill) will create a single itemized entry, with one date.
But please note that if you choose Credit Card or Debit Card for non-reimbursable expenses, we'll use the transaction date on each expense during export.
Reimbursable expenses export to QuickBooks Online as:
Vendor Bill (recommended)
This is a single itemized vendor bill for each Expensify report. If this period is closed, we will post the vendor bill to the first day of the next open period. If you export as Vendor Bills, you can also choose to Sync reimbursed reports (set on the Advanced tab). An A/P account is required to export to a vendor bill. Here is a screenshot of how your expenses map in QuickBooks.
The submitter will be listed as the vendor in the vendor bill.
This is a single itemized check for each Expensify report. You can choose to mark a check to be printed later in QuickBooks Online.
This is a single itemized journal entry for each Expensify report.
Non-reimbursable expenses export to QuickBooks Online as:
Credit Card expenses
Debit Card Expenses
Each expense will export as a single bank transaction with the posting date that appears on your bank statement.
For allocations, if you split an expense in Expensify, we will create a single credit card transaction in QuickBooks with multiple line items posting to the corresponding GL accounts.
Expensify pro-tip: If you want the payee field for Credit Card expenses in QuickBooks Online to show the merchant name, a matching Vendor must exist in QuickBooks Online. Expensify looks for an exact match when exporting and if it can’t find a match, the payee gets mapped to a Credit Card Misc. OR Debit Card Misc. vendor that we create. More information can be found here.
If you are centrally managing your company cards through Domains, you can export expenses from each individual card to a specific account in QuickBooks (detailed instructions here).
This is a single itemized vendor bill for each Expensify report. If this period is closed, we will post the vendor bill to the first day of the next open period. If you export non-reimbursable expenses as Vendor Bills, you can choose to apply a Default vendor to the bill.
If you have Default Vendor enabled then the vendor for the export will be set to your default vender. If Default Vendor is disabled then the report's submitter will be set as the Vendor in QuickBooks.
Expenses can be marked as billable in Expensify which will export to QuickBooks Online with the billable flag. This will only happen for expenses exported as Vendor Bills or Checks. To fully take advantage of this functionality, any expense marked as billable must have a Customer/Job associated with it.
Export Invoices To
If you are creating Invoices in Expensify and exporting these to QBO, this is the account the invoice will appear against.
- How-to: connect your policy to QuickBooks Online
- Deep Dive: Configure Advanced Settings for QuickBooks Online
- Deep Dive: QuickBooks Online Coding Configuration
- Deep Dive: Expensify Card and QuickBooks Online Auto-Reconciliation: How it works!
- FAQ: Why isn't my eReceipt exporting like my other receipts do?