Skip to main content
Planview Customer Success Center

How Fiscal Year/Finance Month Affects Estimates and Cut-Off Dates

For Labor/non-Labor reports, PPM Pro allows you to configure Fiscal Year and Finance Month settings (sometime referred to as "finance fields")  to assist you on reporting on financial data.

Manually managing finance fields

If you want to manage the finance month manually, you can enable the finance fields on Organization/Finances/Finance Settings. This means that the selected Finance Month acts as the Cutoff Date, which starts at month boundary. Current Estimate will be Actual below Finance Month and Forecast for finance month and beyond. As the project progresses, the total current estimate of the project reflects the sum of all Actuals for the project.

Current Estimate = If (Date < Finance Month Date, Actuals, Forecast)

Using system dates (not finance fields):

If you don't want to manage the finance month manually, do not enable the finance fields. This means the system date act as the Cutoff Date. The cutoff date would change based on run frequency for the report.

  • Daily Frequency: Cutoff Date is today
  • Weekly Frequency: Cutoff Date is week start date
  • Monthly Frequency: Cutoff Date is month start date
  • Quarterly Frequency: Cutoff Date is quarter start date
  • Yearly Frequency: Cutoff Date is year start date.

Below are the report fields and what fields inform them depending on their relationship to the cutoff date:

Field Name Date < Cutoff Date Date >= Cutoff Date

Cost Estimate Capitalized

Cost Actual Capitalized Cost Forecast Capitalized
Cost Estimate non-Capitalized Cost Actual non-Capitalized Cost Forecast non-Capitalized
Cost Estimate Total Cost Actual Total Cost Forecast Total
Cost Variance Labor (Forecast vs Actual)    
Cost Variance Non-Labor (Forecast vs Actual)    
Cost Variance Total (Forecast vs Actual)    
Cost Variance Labor (Forecast vs Estimate)    
Cost Variance Non-Labor (Forecast vs Estimate)    
Cost Variance Total (Forecast vs Estimate)    
Labor Billing Estimate Billable Labor Billing Actual Billable Zero
Labor Billing Estimate Capitalized Labor Billing Actual Capitalized Zero
Labor Billing Estimate Non-Billable Labor Billing Actual Non-Billable Zero
Labor Billing Estimate Non-Capitalized Labor Billing Actual Non-Capitalized Zero
Labor Billing Estimate Total Labor Billing Actual Total Zero
Labor Cost Estimate Billable Labor Cost Actual Billable Zero
Labor Cost Estimate Capitalized Labor Cost Actual Capitalized Labor Cost Forecast Capitalized
Labor Cost Estimate Non-Billable Labor Cost Actual Non-Billable Zero
Labor Cost Estimate Non-Capitalized Labor Cost Actual Non-Capitalized Labor Cost Forecast Non-Capitalized
Labor Cost Estimate Total Labor Cost Actual Total Labor Cost Forecast Total
Labor Hours Estimate Billable Labor Hours Actual Billable Zero
Labor Hours Estimate Capitalized Labor Hours Actual Capitalized Labor Hours Forecast Capitalized
Labor Hours Estimate Non-Billable Labor Hours Actual Non-Billable Zero
Non-Labor Cost Estimate Non-Capitalized Non-Labor Cost Actual Non-Capitalized Non-Labor Cost Forecast Non-Capitalized
Non-Labor Cost Estimate Total Non-Labor Cost Actual Total Non-Labor Cost Forecast Total