Overhead Allocation
Based on Project Job Days

(Content is best viewed on a larger screen.)

  1.  Save this file where it can be accessed for monthly updates.  File management instructions are shown at the bottom left of the app.
  2.  Enter data only in the green boxes.
  3.  Sample quarters are provided as examples.
  4.  The appropriate overhead allocations will be calculated automatically once the data has been entered.
  5.  Make the adjustments monthly, quarterly or annually by making a General Journal entry to your accounting platform.
  1. Enter Project Name at “Job” column.
  2. Enter date Project was started (01/22/20XX) at “Start” column
  3. Enter date Project was completed (9/12/20XX) at “Complete” column.
  4. Enter days this month that Project was active. If project was started during the month, enter from start day to end of month. If project was completed during the month, enter days from first of month to completion day.