Most spreadsheet applications have built in formulas and functions that will do the math for you so you don't have to. You can keep a running balance of your accounts and you can have each category totaled as well. You can keep it as simple or make it as sophisticated as you please.
Spreadsheet templates are used for many reasons and each template vary according to the purpose it is used for. Spreadsheets are designed with different calculations depending on various needs.
"Spreadsheets for Small Business" is a complete package of ready-made spreadsheets that optimizes and facilitates a series of business processes such as sales exec commission tracking, calculating business expenses and planning budgets. The "Spreadsheet for Small Business" package incorporates valuable programmed spreadsheets such as "Small Business Expense Spreadsheet" - provides accountants and tax-preparers with a complete report on relevant business expenses; "Producer's Budget" - helps users to establish budgets and keep track of their spending; "Monthly Personal Budget" - designed to track daily, weekly and monthly spending for individuals.
When VisiCalc hit the scene back in the eighties (in the last century), the relatively small group of Apple II users went crazy. It was like manna from heaven for the poor accountants, scientists and engineers who were used to filling in enormous analysis sheets with a pencil. Now, they could use VisiCalc to do the same task, AND calculate the result automatically.