Use comparison rows in a budget or forecast worksheet to automatically include values from another data stream, such as last year's actuals, last year's budget, the current year's forecast and so on. You can use these values in formulas to calculate the new values or simply have it at hand for references purposes.
Distribute total values quickly to determine the individual budget values. You can spread a total you manually enter or a total from a comparison stream, either evenly or proportionally across the period.
This video shows how to convert a budget into a forecast. It is suitable for users who have permission to manage budgets and forecasts.
1:23 min
We use cookies!
By clicking "Accept all", you agree to the storing of cookies on your device to enhance site navigation, analyze site usage and assist in our marketing efforts.
Privacy preference center
When you visit any website, it may store or retrieve information in your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and the primary purpose is to ensure the website functions as you expect it to. While this information typically doesn't directly identify you, it contributes to a more personalized browsing experience. Because we respect your right to privacy, we provide the option to control certain types of cookies. Click on the different category headings below to learn more and modify our default settings according to your preferences. However, blocking some types of cookies might impact your experience of the website and the services we are able to offer.
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.
Functional cookies
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.
Performance cookies
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
Targeting cookies
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
Budgets & Forecasts 
