View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You can use a program such as Microsoft Money that's designed to keep
track of income and expenses.

Or, you can enter the data in a list in Excel, then summarize the data
using a pivot table. For example, with a list like this:

Date Item Category Amount
1/1/05 Groceries Food $25.00
1/1/05 Gas Car $30.00

you could create a pivot table that summaries by category, by month.
There's a PivotTable intro and links on Jon Peltier's web site:

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm


budget question wrote:
We are looking for a budget program where there are categories such as food
where you type in individual receipts and it totals it for you so we can keep
track of how much we spend and on what in the overall budget.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html