Project Budgets, Estimates, and Variance Reporting

This has been requested in the past but I want to articulate the request well and place it in ideas.

Currently, there is no way to enter a budget, estimate, or projected financial outcome for a project and compare it against actual results.

I propose adding an “Enable Project Estimates” option (checkbox) within the project setup screen. When this checkbox is ticked, a section would appear allowing users to enter estimated or budgeted amounts for the project.

The estimate section should:

  • Allow selection of General Ledger accounts from the Chart of Accounts.
  • Allow multiple lines to be added as needed.
  • Allow users to enter estimated amounts against each selected account.
  • Support both income and expense accounts.
  • Allow estimates to be edited at any time during the life of the project.
  • Optionally maintain a history of estimate revisions for audit and reporting purposes (same as the history button for invoices)

The Project Report would then display:

  • Estimated (budgeted) amounts.
  • Actual amounts.
  • Variances (favorable or unfavorable).
  • Variance percentages.
  • Estimated profit or loss.
  • Actual profit or loss.

Great idea, I support it.