If today is July 22, 2024 and I had a netsuite transaction on July 1, 2024 and I delete that transaction - the transaction will still show up on the transformed balance sheet.

The transform is using a configurable 3 day lookback period to determine when to propagate transaction changes to the transformed models. This is a poor design as if users make transactional changes prior to the lookback period - your transformed model will be correct even though the underlying source data is correct.

The only solve is to manually re run the transform with a full refresh - which is not even something you can configure in FiveTran to happen on an automatic schedule.