End of day balances are automatically identified and summarised in Excel, showing the minimum, maximum and average for each month, and the overall period.
Analysing the available balance over a long period may indicate how seasonal the cash flow requirements of the account holder are.