What does publish mean in Xero
Ensure you understand publishing
When you publish a report, it takes a "snapshot" of the ledger at that time.
If transactions were posted AFTER this published report, the report will NOT have the new transactions included.
You need to publish again.