View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default anyone have a simple income/expenditure sheet, excel

Don't use formulas and don't use multiple sheets. Use a database with
columns for date, amount (positive for income, negative for expenditures),
and descriptors (as many as needed) and then use a pivot table on the
resulting database. Here is what I use for my columns:

Reference Number
Date Entered
Date Rec/Paid
Status
Action
Master Account
Sub-Account
Amount

There are plenty of sites and help files available concerning pivot tables -
formulas are completely unnecessary and are a source of error.

HTH,
Bernie
MS Excel MVP


"Lesley" wrote in message
...
Hi,

I need to make a simple income and expenditure sheet for a new venture,
would like a 1 worksheet per month so this can be filled out on a daily
basis. Does anyone have one ready made before I start scratching my head
putting formulas in?