First, what is gross profit? It's the amount of income that remains after accounting for all the bills, expenses, additional income streams, and operating costs, not including internal hourly own cost.

This forecast report helps you report on and anticipate your company's gross profit, invoicing (scheduled and invoiced) and costs (purchase orders and bills). You can look at this report as an overview, by account, and by project.

Table of contents:

  1. How to give permissions to the forecast report

  2. Where to find the forecast report

  3. How the forecast report works

  4. Summary view

  5. By account view

  6. By project view

1. How to give permissions to the forecast report

Go to Settings > User Management > Permissions and scroll down to the section called Reports. Here you can find permissions for Forecast report. You can choose to give permissions to view or edit, or both, for individual users, groups and teams.

2. Where to find the forecast report

Once you've got the permissions to the report, click Reports on the top of the view, and then click Forecast.

3. How the forecast report works

3.1. Views on the forecast report

There are three different kinds of forecast reports: summary, by account, and by project. The first one shows your forecasts for the whole company, by account shows forecasts for each account, and by project shows forecasts for each project.

3.2. Filters in the forecast report

To narrow down the search, use the search filters to see the forecasts you'd like to see. Above the report itself, you can filter by:

Financial year

You can get forecasts for each financial year (because it's a financial year-specific report).

Funnel

You can get forecasts for your won deals but can also add your sales pipeline to the forecast by clicking on the Funnel filter and selecting the pipelines you'd like.

You can also get these reports with sales pipelines included adjusted by the probability of deals closing by clicking the view icon in the top right-hand corner of the view. This will give you an even more accurate forecast on your gross profit, and future invoices and costs.

You can also decide which invoices, purchase orders and bills you'd like to include in the forecast report. You can include:

  • Values with probabilities (if sales pipeline included)

  • Scheduled invoices

  • Automatic invoices

  • Purchase orders (waiting and sent)

  • Invoices in waiting status

  • Draft invoices

  • Bills in waiting status

You can also get more search filters by clicking Add filter. Finally, you can save searches by clicking Save search. When you'd like to use a search you've saved, just select it from the Saved searches filter next to the Funnel filter.

3.3. Export the forecast report

You can export the forecasts you want by clicking the Export icon in the top right-hand corner.

4. Summary view

In the summary view of the forecast report, you can take a look at the gross profit, invoicing total, and costs total for each month of the selected financial year and the pipelines of your choice.

Here are the rows of the summary explained:

  • Gross Profit = the amount of income that remains after accounting for all the bills, expenses, additional income streams, and operating costs, not including internal hourly own cost

  • Invoicing total = scheduled invoicing total + invoiced total

  • Scheduled invoicing = the total sum of scheduled and automatic invoices that have not been invoiced yet

  • Invoiced = the total sum of invoices that have been approved and sent to customers

  • Costs total = forecasted costs + actual costs

  • Forecasted costs = upcoming costs (purchase orders that have been sent or are in waiting status)

  • Actual costs = costs that have already come (bills that have come to Taimer and have been targeted to projects)

These details enable you to forecast your profit and loss for the financial year, anticipate the revenue and costs coming in. And when you add your sales pipeline with probabilities as well, you can accurately forecast your profit and loss even before you know if your deals will close or not.

5. By account view

The By account forecast report shows you the total and monthly gross profit per account. All the accounts are listed here.

You can filter accounts by financial year, funnel, and other filters, as with the summary report. From the view icon in the top right-hand corner, you can include the following things in the report:

  • Grouped accounts

  • Sub-units

  • Values with probability (if sales pipeline is included)

  • Scheduled invoices

  • Automatic invoices

  • Purchase orders

  • Invoices in waiting status

  • Draft invoices

  • Bills in waiting status

6. By project view

Like the by account, this lists the total and monthly gross profit but for projects instead of accounts. All projects are listed here.

You can filter projects by financial year, funnel, and other filters, as with the summary report. From the view icon in the top right-hand corner, you can include the following things in the report:

  • Project tree

  • Active projects

  • Closed projects

  • Projects on hold

  • Grouped projects

  • Values with probability (if sales pipeline is included)

  • Scheduled invoices

  • Automatic invoices

  • Purchase orders

  • Invoices in waiting status

  • Draft invoices

  • Bills in waiting status

Other related articles:

Profitability report

Invoicing report

Revenue recognition report

Did this answer your question?