Hours to report should only count hours that have passed

In Time report page, there is "Hours to report" formula that says how many hours the user has unreported. It should only count those hours that have passed (thus could be reported as worked or not worked) and are not reported yet. It shouldn't count future hours to report.

It should check the current date, calculate how many working days were in the month so far, and calculate from that how many working hours have passed. Then it should deduct any reported hours for this month.

It should disregard hours of previous months. We don't want to force users fix data from the previous months if they don't want to.

But what if user hasn't reported hours for the month before next month starts? Some users will report their time before the end of the month, and some will report it at the beginning of the next month. This is why we need an information on the month that is next for reporting. It can be current month, but it can also be the month before that.

Maybe the best way can be to have a column on the Commitment table where we mark as "Reported" each month that is successfully reported (irregardless of any outstanding unreported hours). We should also have the user mark this, so that admin doesn't have to do it for everyone each month.

When user adds all his time reports, she should mark the report as complete. When she does this, we mark the commitment as reported.