How do you calculate forecast revenue and average hourly rate based on accepted proposals?

In Jestor, the hours-billing template's dashboard automatically calculates forecast revenue and average hourly rate, using project proposals that clients have already accepted as the basis.

How the calculation is done

Forecast revenue considers projects still in the proposal stage, adding up the estimated value based on hours sold and the defined hourly rate. Average hourly rate is calculated from proposals that have already been accepted, showing how much is being charged, on average, per hour of work delivered.

Indicator	How it's calculated
Current revenue	Projects with already-accepted proposals
Forecast revenue	Projects still in the proposal stage
Average hourly rate	Based on hours sold in accepted proposals

How to track these indicators

Register projects with the hourly rate and contracted hours at the proposal stage.
Track forecast revenue by adding up projects not yet accepted.
Check the average hourly rate based on projects already closed.
Use the dashboard's filters to view by project or by client.

Why choose Jestor

Automatic indicators: no extra spreadsheet is needed to track revenue and hourly rate.
Per-client view: a chart shows how much revenue each client is bringing in.
Data-driven decisions: the average hourly rate helps price new proposals with more confidence.

Does forecast revenue include projects that have already been rejected?

No, it only considers projects still in the proposal stage, awaiting the client's acceptance.

Is the average hourly rate recalculated automatically with every newly accepted proposal?

Yes, the indicator is updated as new proposals are accepted and factored into the calculation.

Can you see the total number of hours sold?

Yes, the dashboard shows the total hours sold based on projects whose proposals were accepted.

Reference video

Check out more hands-on tutorials on the Jestor YouTube channel.

Get to know Jestor

With Jestor, you can automate workflows, connect teams, and build internal systems your way — all without code and powered by AI.

Discover Jestor at jestor.com and see how to take your company's operations to a new level of efficiency and control.

How Do You Set a Different Homepage for Each Role as Soon as the User Logs In?

In Jestor, when editing a role, you can paste the link to a specific page (like a dashboard) into the homepage field, so that every user with that role lands directly there as soon as they log in. Why this improves the user experience Without this setting, everyone would land

What's the Access Difference Between a Member-Type User and a Builder-Type User?

In Jestor, a member-type user is meant for anyone who just uses already-configured processes, while a builder has access to create and edit tables, apps, automations, and the account's structure. Why separate these two access levels Not everyone on the team should be able to change

Why Does Grouping Tables and Apps for the Same Process Into the Same Folder Make Maintenance Easier?

In Jestor, grouping tables and applications for the same process into a single folder makes it quick to find everything related to a specific Kanban or flow, saving you from wasting time hunting for scattered pieces across the platform. Why folder organization avoids clutter Just like an unorganized computer desktop,

Can You Duplicate an Entire Application, With All Its Elements, Right From the Action Bar?

Yes. In Jestor, the action bar (opened with Ctrl+K or Cmd+K) lets you clone an entire application, with every element it contains, just by choosing the source app and giving the copy a new name. Why cloning from the action bar is faster Manually rebuilding an app from