Coda and spreadsheets each have their unique strengths. But one of the things where Coda is head and shoulders ahead of spreadsheets, is in the ability to generate different views off a set of columns.
I have started this demo to show what can be done.
For now I have a table with monthly incomes and expenses, with a monthly balance, and an annual carry-forward button.