I have my personal expenses in an Excel spreadsheet.  I have a workpage for each month where I have separate columns for food, utilities, auto, charity, etc ,etc.  Then, at the bottom, I have a line which is set up to automatically give a sum total.  12 months: 12 pages.  I also have a separate page for yearly totals.  This page is set up to carry the monthly totals into the year page. So, the year page has 12 lines, one for each month, and the columns are identical to the monthly pages.

Let's say on the yearly page, line 1 is January, and cell C1 is grocery expenses for January. Insert "=" into that cell, then click on the January page, and click on the grocery total, and it will carry that running total over to the appropriate cell in the yearly page. 

Confused?  drop me an e-mail, and I will send you a brief version so you can see how it is set up.