Okay, here is a first cut.

The heart is the Bookings worksheet. Here you enter the following details of any bookings, or retrospective attendance (Owed)

-column A: name

-column B: date

-column C: Y if a booking, not owed

-column D: Y if owed

-column E: Y if and when paid

-column F: Y if cancelled

-column G: Y if due (determined from C:F)

-column H: year of date (calculated)

-column I: month of date (calculated)

-column J: date w/c (calculated)

-column K: amount due - bookings not yet paid(calculated)

-column L: amount bookings paid (calculated)

-column M: amount owed (calculated)

The rest is pivotting from here.

**Weekly Summary pivot**

This is a simple pivot showing counts of all of the categories over date, over w/c, over month, over year.

**Attendance**

Another pivot that is a list of who is attending/attended for any given week. You select the w/c from the report filter and it shows the list.

**Paid**

A pivot that summarises the income received, over w/c, over month, over year.

**Owed**

A pivot that summarises the income owed, over w/c, over month, over year. Unlike Paid, it shows the name owing.

**Due**

A pivot that summarises the amount due, that is booked not paid or cancelled (not owed), over w/c, over month, over year. Also it shows the name due.

Take a look, see what you think, and, if you like it, how it might be refined.