A
admiral_victory
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.
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.