You’re correct, it’s possible for linked accounts to have incorrect data, typically due to the data aggregator (e.g. Yodlee) and/or financial institution.
Consider using the Docs: Bank Statement Reconciliation Sheet , which integrates with your Transactions sheet.