I'm a bit puzzled with the way the executive summary report (EE) works. More specifically the Cash portion. The 'Cash received' and 'Cash spent' lines seem to display the total cash received and spent since the beginning of time. with the 'Cash surplus' and 'Closing bank balance' then both showing the balance of the previous two numbers (although they are not calculated the same way).
I would find it more logical if 'Cash received' and 'Cash spent' would display the total of the period selected.