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!

FAQ: QuickBooks Online: The transaction needs to be in the same currency as the A/R and A/P accounts

Conor Pendergrast
Conor Pendergrast Expensify Success Coach - Admin, Expensify Team Posts: 145 Expensify Team

The QuickBooks Online export error "The transaction needs to be in the same currency as the A/R and A/P accounts you use" generally occurs because the currency on the Vendor record in QuickBooks Online doesn't match the currency on the A/P account. 

To resolve this, find the Vendor record in QuickBooks Online and update that to use with the correct A/P account, currency and an email matching their Expensify email. You can find the correct Vendor record by exporting your QuickBooks Online vendor list to a spreadsheet (click the export icon on the right-hand side of the page), and search for the email address of the person who submitted the report.

If you have multiple Vendors with different currencies with the same email, Expensify is likely trying to export to the wrong one. Simply remove the email address from the Vendor in QuickBooks Online you aren't trying to export to, sync your policy (Settings > Policies > Group > [Policy Name] > Connections > QuickBooks Online > Sync Now), and export again (Export To > QuickBooks Online).

If this still fails, you'll need to confirm that the A/P account selected in Expensify is set to the correct currency for the export. You can check this through Settings > Policies > Group > [Policy Name] > Connections > QuickBooks Online > Configure > Export (check that both A/P accounts are the correct currency).


Tagged: