Monthly Revenue Report

[jsayles]

We need a new report that takes a start_date and end_date (defaults to month boundaries) and displays a report of all revenue in that period.

Data Set: UserBill.objects.filter(due_date__range=(start_date,end_date))

Total: sum of bill amounts
Total Paid: sum of payments
Total Outstanding: difference (displayed and highlighted if not 0)
Memberships Total: sum of SubscriptionLineItems
Memberships by Resource: for each SubscriptionLineItem.resource
Overages Total: sum of CoworkingDayLineItems and EventLineItems
Coworking Overages: sum of CoworkingDayLineItems
Events/Meeting Overages: sum of EventLineItems
Non-Member Total: Bills where user is not an active member in the period

List all open or unpaid bills. A clean report shouldn't have any.