Month End Close – Overlapping TimeSheet Trick for OpenAir

The necessity for overlapping timesheets is typically driven by the need to enter two timesheets within a given week. For example, your company is on a monthly accounting calendar but you have weekly timesheet submissions. You can create two timesheets for the timesheet period, one ending on the last day of the calendar month and the other beginning on the first day of the next calendar month.

Note: Disabling the internal switch timesheet overlapping ensures unique timesheets for each timesheet period.

If you have the switch enabled that creates an overlapping timesheet for the second part of the week at month-end, AND you want to use a minimum number of hours per day timesheet rule, there is a known defect that throws an error for the first half of the week because the days in the second half of the week are not filled in. Oddly, the second half of the week timesheet works fine.

However, there is an interesting workaround combination:

The workaround is to also use three other timesheet rules:

  1. Require a time entry every day independent of work schedule
  2. Exclude days with no hours from the daily rules
  3. Exclude weekends from the daily rules

While rules 1 and 2 might seem somewhat contradictory, they provide the desired behavior. The first rule apparently knows you have a split week timesheet, even though the second one doesn’t.

To Navigate:
Administration > Application Settings > Timesheets Settings > TimeSheet Rules


Keep in Touch

Stay informed of tips,
news, and webinars

p:  703-957-8370

Upcoming Webinars
Jun 13

About Us:  Our mission is to enable and empower Professional Services Organizations to become profitable, scalable, and efficient through change management, technology deployment, and skill set training with a Customer First approach.  We are celebrating our 10th year of success and look forward to growing and learning with you.