Hi folks - a query which will probably seem a little bit too banal,
but you never know.

I work in hospitality, and therefore receive a lot of tips. I want to
pay all of my tips into the bank account of my landlord to allow me to
get ahead with my rent, I will be doing this via direct payment and
this is acceptable to her.

We both need some way of keeping track of these excess payments, and
reconciling it with the weekly rental payments. I was thinking an
Excel spreadsheet - which we both share - would be the way to go.

My rent is AUD150 per week.

I need some way of entering details such as the following:

Mon - $150 (paid one weeks rent, therefore the "paid to" date is
automatically incremented by one week)
Tues - $23.50 paid
Wed - $67.20 paid
Thurs - $37.90 paid
Fri - $32.20 paid
(equals $160.20 paid, therefore the "paid to" date is automatically
incremented by one week, with $10.20 added to the next lot of
payments)

Any thoughts here?

=====================

Dave

There are 10 types of people, those who understand binary and those who don't.