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

Options
Conor Pendergrast
Conor Pendergrast Expensify Success Coach - Admin, Expensify Team, Expensify Student Ambassador Posts: 175 Expensify Team
edited August 2022 in Integrations and API

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: