I am using the same reporting period (July-Nov 2023) and accounting method (Accrual). Also, I did exactly what you described, which is to list out all the different Transaction Types in the P&L expense list and select those same types in the query for the Expenses Only report. That's the first thing I did, and it came up with very different totals, which tells me that the query that the P&L uses under the hood uses a different list of transaction types (and/or some other query term) that is hidden and I can't seem to replicate it in the Expenses Only report.

Honestly, I wish the standard reports would explicitly show the query terms and values in the customization pane so we can tell what those reports are starting with (which helps us know how to modify it). It's like wanting to drive to a friend's house but you don't know exactly where you're starting from.