QuickBooks Online: Export Error (Business validation error)
We are trying to export an expense from Expensify to QB Online, as we are used to doing so. This time we are getting this error : "Business Validation Error: All A/R and A/P accounts must be in the same currency". We do not understand as we haven't changed anything and so far it worked very well. Please advise. Thanks.
Hi @DL_ETSOFT, thanks for posting on the Community and welcome! Can you share the report ID of the report in question with me here? The report ID is unique but does not grant anyone access to your information. It simply helps the Expensify Success Team locate the report for troubleshooting purposes.
Typically this means that the currency on the report doesn't match the currency set on the A/R or A/P account that the report is exporting to. With that in mind, is there anything different about this report or the account when it comes to currency?
We are having the same problem. We have been able to export reports for all but one employee. There are 3 separate reports for this employee and we have been unable to export any of the 3.
All currencies are set to the same in both Expensify and QB Online.
I have the same issue - this is something that worked at least up to Aug 20th. Nothing has changed, and now the export function won't work. The Vendor in Quickbooks and the Report in Expensify are in the same currency. Nothing has change in the setup from last time it worked.
me too, noone seems to be able to help. quickbooks says its expensify problem....
Someone please help...
Im experiencing the same issue
For some reasons, some settings seem to have been changed. As advised by Expensify team, review the settings in Settings > Policies > [Policy Name] > Connections > Configure > Export page.
That doesnt solve anything, they are the same. Anyone else have a fix for this?
DLETOFT, did you ever get this fixed?
One way I was able to get it fixed is to go into the Settings/Policies/Connections and Configure.
From there you need to ensure that "Export reimbursable expenses" the Accounts Payable account is selected that matches the currency of the Policy.
This way, Expensify is exporting into Quickbooks both the expenses and the AP in the same currency.
This worked for me, anyways.
When receiving this error, it is generally because the currency on the vendor doesn't match the currency on the A/P account. To resolve this, you must have a vendor record with the correct currency and an email matching their Expensify email.
If you have multiple vendors with different currencies with the same email, we may just be trying to export to the wrong one. Our system stores the vendor emails in the order they were synced in and modifying a vendor record can change that order. This is what can cause this error even though you've been able to export to that vendor previously.
If you remove the email from the vendor you aren't trying to export too, sync your policy, and export again, it should export successfully.