monies spent and monies recieved

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Harold Silber - 03 Jan 2007 05:10 GMT

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

Reply to this Message

Bob Phillips - 03 Jan 2007 10:05 GMT

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)

Signature

---
HTH

Bob

(change the xxxx to gmail if mailing direct)

> Good day
> I have Excel 2007. What I am looking for is a simple spreadsheet which I
[quoted text clipped - 8 lines]
> Johannesburg
> South Africa

Reply to this Message

SM - 03 Jan 2007 20:24 GMT

> It doesn't sound as if you need a template, it is pretty basic what you
> require.
[quoted text clipped - 6 lines]
>
> =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.

Reply to this Message

Bob Phillips - 04 Jan 2007 19:13 GMT

Look at SUMIF in Help.

Signature

---
HTH

Bob

(change the xxxx to gmail if mailing direct)

>> It doesn't sound as if you need a template, it is pretty basic what you
>> require.
[quoted text clipped - 11 lines]
> adapted for my own purposes. What kind of formula is this an example of so
> I can look for tutorials on t'internet thingy.

Reply to this Message

Bob Phillips - 03 Jan 2007 10:14 GMT

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

Signature

---
HTH

Bob

(change the xxxx to gmail if mailing direct)

> Good day
> I have Excel 2007. What I am looking for is a simple spreadsheet which I
[quoted text clipped - 8 lines]
> Johannesburg
> South Africa

Reply to this Message

Harold Silber - 05 Jan 2007 04:59 GMT

Great ,, Thanks Bob

> Good day
> I have Excel 2007. What I am looking for is a simple spreadsheet which I
[quoted text clipped - 8 lines]
> Johannesburg
> South Africa

Reply to this Message

Rate this thread: