Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2007

Tip: Looking for answers? Try searching our database.

How to organise expenses divided between two payers

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
admiral_victory@iol.ie - 17 Apr 2007 17:07 GMT
I have a boat which is jointly owned between myself and one other .
Under this arrangement all expenses involved in running and
maintaining the boat are to shared equally between us.

As I am retired and my co-owner is employed , most of these expenses
are initially provided by myself with the total amount then being
divided between us later.

To keep a record of these transactions I would like to construct a
spreadsheet which will have columns showing the following:-

Date
Detail of purchase( i.e.amount paid)
Remarks

I would also like to have:-

1.An indication of the running total as entered in the second column
above .

2.Another one showing the amount owed by each person ( i.e. 1/2 of
this column)  and , since payments into this spread sheet will not be
paid on the same days by each of us ,

3.another colums or columns showing , on any partitcular date , who
owes what to the expenses incurred at that date

As I am a total novice at excel , constructing such a spreadsheet is
beyond my competence and woul;d , therefore , appreciate any help
here.

B.N.
Roger Govier - 17 Apr 2007 17:25 GMT
Hi

I think I would enter those three headings on row 3 in cells A3, B3, C3
respectively
In E3 enter your co-owners name.
Make entries in A, C and D  whenever your co-owner pays any money into
the "fund".

In cell B1 enter
=SUM(B4:B1000)  this will show the running total of all purchases
In cell D1 enter
=(B1/2)-SUM(D4:D1000)

This will show the amount of money that the co-owner owes at any point
in time.
Signature

Regards

Roger Govier

>I have a boat which is jointly owned between myself and one other .
> Under this arrangement all expenses involved in running and
[quoted text clipped - 28 lines]
>
> B.N.
admiral_victory@iol.ie - 17 Apr 2007 19:11 GMT
Thank you for the prompt reply.

I'll try out your suggestions.

B.N.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.