Budget vs Actual
Getting started
Add Budget vs Actual as a monday.com dashboard widget or board view and connect the first budget.
Budget vs Actual has two installable surfaces. Use the dashboard widget for a portfolio view across boards or a budget that deserves a place on a dashboard. Use the board view when the report belongs next to the board it reads.
Before you begin
- You need permission to add widgets or views in the destination monday.com account.
- The board needs at least two Numbers columns: one with the planned amount (Budget) and one with what has been spent (Actual).
- Optional: a third Numbers column for amounts that are committed but not yet spent, such as purchase orders or signed contracts.
- Optional: a Timeline column on the items, which lets the app derive the project period for burn rate and forecast.
- Formula columns are not supported. The monday.com API returns no value for formulas, so the amount has to live in a Numbers column.
Add the dashboard widget
- Open a monday.com dashboard and choose Add widget.
- Find Budget vs Actual and add it.
- On the welcome screen, click Set up.
- Pick a board. The Budget column and Actual column are guessed from the column titles; correct them if the guess is wrong.
- Optional: pick a Committed column, restrict the row to Only some groups, or give the source a Label.
- Under Display, choose One row per group or board, the Currency, and the At-risk threshold.
- Optional: under Burn rate and forecast, set a Project period from start and end dates or from a Timeline column.
- Save.
To connect more boards, open the settings and click Add another board. Portfolio roll-ups usually pair well with one row per board.
Add the board view
- Open the board and click the plus beside the view tabs.
- Choose Apps and add Budget vs Actual.
- Click Set up on the welcome screen.
- Confirm the Budget column and Actual column. The board itself is locked as the source.
- Optional: add a Committed column and a Project period, then save.
Change the settings later
Hover the widget or view and click the gear in its top-right corner. Settings are stored per app instance, so two widgets can report different boards or use different thresholds.
Next steps
- Decide what each row represents with sources and breakdown.
- Tune when a row turns yellow or red with status and thresholds.
- Add a project period to unlock burn rate and forecast.
