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?
|