monies spent and monies recieved
 

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

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

monies spent and monies recieved
 

I have uploaded a very small, simple sample at http://cjoint.com/?bdlnEYbBRU

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

monies spent and monies recieved
 

"Bob Phillips" wrote in message
...
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)

Can someone explain what this formula means. I mean - looking at the
spreadsheet example uploaded it looks like something I may find useful if
adapted for my own purposes. What kind of formula is this an example of so I
can look for tutorials on t'internet thingy.

monies spent and monies recieved
 

Look at SUMIF in Help.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"SM" wrote in message
...

"Bob Phillips" wrote in message
...
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)

Can someone explain what this formula means. I mean - looking at the
spreadsheet example uploaded it looks like something I may find useful if
adapted for my own purposes. What kind of formula is this an example of so
I can look for tutorials on t'internet thingy.

monies spent and monies recieved
 

Great ,, Thanks Bob

"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