Using last close
Last close separates actual values from forecasted values.
Understanding last close
In Runway, ‘last close’ refers to the cutoff date between actual values and forecasted projections.
Values on or before the last close are calculated from your actual formula
, which refers to a database that has your actual business data.
Here’s an example of an actual formula
for the ‘Revenue’ driver, which sums up the values of all the rows in the ‘Income Statement’ database that fall under the ‘Revenue’ category:
Values that fall after last close are future projections calculated from your forecast formula
. Here’s an example of a forecast formula
, mapped to the ‘Revenue Forecast’ driver, which calculates future values of ‘Revenue’ based on some growth assumptions:
Updating last close
- Once you’ve closed your books in your accounting system for a given month, just click
LAST CLOSE
in any model, page or database in Runway.
- Select the month from the dropdown menu to update your driver values.
FAQ
What if my driver values are hardcoded?
Hardcoded values take precedence over any values calculated from your actual or forecast formulas.
Note: both actual and forecast values can be hardcoded for any month for your drivers. Hardcoded values can be easily identified by the dotted lines underneath them. Any hardcoded values that fall beyond your last close date will show up on your plans timeline.
Couldn’t find what you were looking for? Try typing your query in the search bar above, or feel free to get in touch with our support team.