Will do. I’ll take a closer look as soon as I get a moment. I’m thinking that I’ll need to join the Categories
sheet into the queries in Actuals Prior to Period P10
and Actuals in Period S10
in order to check for the Debt
flag, and then for debt transactions exclude transactions where Category
matches Account
. I could probably get away with not checking for the Debt
flag, but I can imagine edge cases where that shortcut would backfire.