---
title: "Revenue Forecast > Create a Net Revenue Forecast"
canonical: "https://technology.bytangram.com/space/TGKB/247333692/Revenue%20Forecast%20%3E%20Create%20a%20Net%20Revenue%20Forecast"
format: markdown
---
The net revenue forecast is created from the **finance & administration** module > **GL** > **net revenue forecast**. The creation of a net revenue forecast is usually managed by finance or operations, depending on your agency process. 

| **ON THIS PAGE YOU WILL FIND:** |
| --- |
| > Macro (toc) |

---

## NRF CREATION

- In the **finance & administration** module > **general ledger** > **revenue forecast**
- Click on the **new revenue** **forecast** icon

![image](media://1bc3b579-1f41-4eb3-972c-d68f83ec35cf)


- Complete the create new revenue forecast pop-up

![image](media://642e6420-600c-42ee-adf2-a470e2038989)


| **FIELD** | **FUNCTION** |
| --- | --- |
| **Title** | The name of the revenue forecast - we recommend something useful for example, the forecast period w/c DD/MM/YY |
| **Method** | Select the appropriate forecast method from the drop down - this will determine how the NRF is populated<br>> ℹ️ For more information: [https://tangram.atlassian.net/wiki/spaces/TGKB/pages/769916929](https://tangram.atlassian.net/wiki/spaces/TGKB/pages/769916929) |
| **Per Date** | This is the date the forecast will be run from. Actuals will populate all previous months within the financial year and forecast amount will populate in all future months (to job end date) |
| **Only Actual** | If this is checked it will populate the actualised revenue results only<br>> ✅ Useful when looking back at a financial year |
| **Months** | Allows you to extend the number of months you are forecasting revenue against |
| **Companies** | Allows you to select other companies within WorkBook in order to consolidate the forecast from multiple companies into one |
| **Currency** | Allows you to change the forecast currency |
| **Copy manual edits from** | Allows you to select a prior revenue forecast (with the same settings), to copy any manual edits across to the new revenue forecast |

- Click **ok**

Once created, WorkBook gives the forecast:

- A **unique ID **number
- Adds RF as a **prefix** to the title
- Adds date created and creator as the **suffix**

![image](media://38b54366-20c8-4ae1-bf2d-c0c4928f407e)


---

## THE FURTHER OPTIONS MENU

This menu gives you access to functionality such as adding a budget for comparison, publishing the revenue forecast to viewers and sending the revenue forecast to the responsible users to review, edit and approve. 

![image](media://129e3ae3-0890-4244-aee0-99a55ed80a64)


Here is a brief synopsis of what each menu item can do. 

| **MENU ITEM** | **FUNCTION** |
| --- | --- |
| **Update entire revenue forecast** | Recalculate values according to the RF settings, based upon the latest data available |
| **Recalculate the forecast budgets** |
| **Recalculate the inter-company values** |
| **Publish/Unpublish ** | Publish an RF to viewers |
| **Mark as active/inactive** | Mark an RF as active or inactive<br>> ✅ Useful for filtering your NRF list |
| **Delete current revenue forecast** | Delete a forecast<br>> 📝 The status must 'under preparation' |
| **Add a budget to the selected forecast** | Manage budgets against a forecast for the purpose of comparing actuals and forecast revenue against the client targets |
| **Remove a budget from the selected forecast** |
| **Review Actions** | Send the RF records for review by the people responsible |

---

## ADDING A BUDGET

You can add a budget to the revenue forecast by:

- Clicking on the **revenue forecast options** menu > and selecting **add a budget to the selected forecast**

![image](media://03da1382-d280-4a88-b2ed-5101cc444e2c)


- Select your **budget**
- Click **ok**

![image](media://502a2806-9e13-4746-be68-b3a51dd7d348)


- The budget will be displayed in the final column of the revenue forecast

![image](media://654d100e-fbc8-4990-adae-1fe7ca5300a9)


To get more information about where the forecast numbers come from:

- Hover over any **client forecast cell**

![image](media://b3f039a9-91e4-4500-bba5-016bc3ecc16f)


### Colour Coding

Colour coding is a quick way to identify how the forecast is tracking against the budget

- **Green and yellow** indicates whether the numbers are coming from jobs or pipeline records
- **Blue** indicates the difference between budget and forecast

![image](media://037e5440-7b54-4a48-9b82-ab080da68d2f)


In this example, we’re looking at the total for this client:

- **Total yearly budget** for this client is $77,000
- The **difference** tells us at this point in time, we’re set to miss the budget by $21,050

![image](media://e6231ca4-43be-49cd-8197-d797c76b9d82)


---

## REMOVING A BUDGET

You can remove a budget from the NRF by:

- Clicking on the **net revenue forecast options** menu > and selecting **remove a budget from the selected forecast**

![image](media://554efb73-5050-4418-aa07-860f02b3576c)


- Select your **budget**
- Click **ok**

![image](media://39bb9715-aecf-4ca2-ae1a-3c20756d7ce8)


---

## UPDATING/RECALCULATING THE NRF

There are a few ways to recalculate your net revenue forecast to include the latest information. 

### Option 1: Update Entire NRF

- Clicking on the **net revenue forecast options** menu > and selecting **update entire net revenue forecast**

![image](media://75544513-28ec-489b-9aa5-0f8b7ea9eee7)


- You can then choose to:
  - Update and recalculate everything on the NRF or…
  - Keep any manually edited values that have been added to the NRF so far, and update everything else

![image](media://7af39651-f136-4dfd-825d-2192d89eb021)


### Option 2: Recalculate the Forecast Budgets

- Clicking on the **net revenue forecast options** menu > and selecting **recalculate the forecast budgets**

![image](media://e5a2015f-d941-4794-9aa6-d826df8dd5e6)


- In the example below the previous budget was $60,000

![image](media://e4d7ab06-96dd-4a33-8c65-3e509e80cbbe)


- Once the budget has been recalculated, the NRF budget has been updated to $70,000

![image](media://28904a78-fc81-4bfd-b9a5-539840938d08)


> ℹ️ To update individual line items on your NRF please refer to [https://tangram.atlassian.net/wiki/spaces/TGKB/pages/879427710](https://tangram.atlassian.net/wiki/spaces/TGKB/pages/879427710) article

---

### Related articles

> Macro (contentbylabel)