This is the report generated by the Sheets Tiller Community Solutions Add-on? The source data is definitely the Transactions sheet, @bwromeo.
Can you try turning off filters on your Transactions sheet, sorting by date, and double checking that there isn’t data matching those transactions in the Transactions sheet?