while uploading spreadsheet sync, having business validation error you can use only one foreign currency per transaction, what could be the possible way to resolve this?

The error occurs because QuickBooks Online only allows one foreign currency per transaction. The most common cause is a mismatch between the currency assigned to your vendor or customer in QuickBooks Online and the one you used in your spreadsheet rows. To isolate it, review your spreadsheet to ensure all items, accounts, and the main transaction use a single currency.

If you need to record different currencies, enter those as separate transactions instead of combining them in one. For questions about Spreadsheet Sync product help and technical assistance, I'd recommend contacting our Intuit Experts team. They can look into this matter and guide you in uploading the file to QuickBooks Online Advanced.

If you have any other concerns, feel free to reach out to us anytime.