These resources are brought to you by the Cooperative Extension System and your Local Institution

Personal Finance Home

Have a question? Try asking one of our Experts

With respect to keeping monthly utility bills and statements, could you advise me on how to set up a spreadsheet to record the monthly cost and usage of each type of utility?

Last Updated: May 26, 2009

View as web page


You can use Microsoft Excel software (or something equivalent) and set up a spreadsheet with individual columns for the 12 months of each year and rows for the monthly cost and monthly usage. Then program the spreadsheet to sum the columns across. Each month, when you receive a bill from your utility company, add that month's cost and usage and update the spreadsheet totals. If you prefer to do these calculations without a computer, set up the spreadsheet the same way on a sheet of paper. Then you'll just need to do the math by hand or with a calculator. We would like your feedback on this Personal Finance Frequently Asked Question.

Browse related Faqs by tag: personal finance, budgeting


Have a specific question? Try asking one of our Experts

Unlike most other resources on the web, we have experts from Universities around the country ready to answer your questions.