View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default monies spent and monies recieved

It doesn't sound as if you need a template, it is pretty basic what you
require.

Just use column A for a label (customer name, job id or whatever), column B
for a date, and ciolumn C for costs , D for receipts.

You can then have another sheet with the labels in column A and use
formulae such as

=SUMIF(Sheet1!A:A,A2,Sheet1!D:D)-SUMIF(Sheet1!A:A,A2,Sheet1!C:C)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Harold Silber" wrote in message
...
Good day
I have Excel 2007. What I am looking for is a simple spreadsheet which I
can use for my part time business (photography).
Monies recieved and then also a seperate column for all expenses (costs).
So that I will be able to work out profits etc etc
When I open up "NEW" ,,, there are a lot of different templates on
microsoft online but I am not sure which one to use.

Thank you
Harold
Johannesburg
South Africa