The four views
Actual, Forecast, PLAN and PLAN vs. ACTUAL in QUANTICAL.ERP controlling - the live P&L for any period, extrapolated to the year, as a plan and as a review.
You find controlling in the left sidebar under Controlling > Controlling. The menu item appears only for administrators.
At the top you choose the view, in the row below the Date Range. The default is the current month. Every figure on the page refers to this period. The Search employee field at the top right filters the tables to individual people.
Actual
Actual is the live P&L: every booked hour becomes revenue at the valid hourly rate, the salaries from the master data are counted for the days of the period, the overhead is added proportionally. At the bottom stands the net profit with its margin. The figures change with every booking, without export and without a spreadsheet.
How the individual cost lines come about is explained under Costs and overhead.
Forecast
Forecast extrapolates the actual values of the days of the period that have already passed linearly to a full year. The yearly overhead enters in full. So early in the year you see where the result is heading if business continues as before.
The budget table extrapolates in the forecast as well. For the real budget status use the Actual view.
PLAN
PLAN joins past and future: for the past days of the period the actual values apply, for the future days the plan values from budget planning, that is person-days per week times eight hours times hourly rate. The costs of the future days come from the stored salaries. Next to the views stands the Plan basis, the period the plan refers to.
Projects without a budget allocation in the plan period are reported in a notice above the key figures. For them the table shows no revenue, no costs and no margin.
PLAN vs. ACTUAL
PLAN vs. ACTUAL is the review. The view exists only for periods that lie entirely in the past. It sets plan and actual side by side line for line, from total revenue through every cost type to net profit, and shows the variance in euros and percent. The project table compares plan revenue and actual revenue as well as plan hours and actual hours per project.
If the chosen period still contains future days, the page offers to switch to the PLAN view. The other way round, a period entirely in the past leads from PLAN to PLAN vs. ACTUAL.
QUANTICAL.ERP remembers the chosen view as well as overhead and social security in your browser. On the next visit you find controlling the way you left it.
Controlling
The live P&L in QUANTICAL.ERP - revenue, personnel costs, overhead and net profit for professional services firms, plus utilisation, hourly rate and budget per project.
Costs and overhead
How QUANTICAL.ERP calculates base salary, bonus, social security, other costs and overhead for the P&L - from the employee master data and two central settings.