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 PostsSee All
Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo