Monthly balance analysis
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.
Recent Posts
See AllRevisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing...