The Analysis Module allows you to analyze and compare the variances between different entities/scenarios and time frames. You are now able to evaluate your worst-case and best-case scenarios or compare your initial budget to your actual results and analyze the variations.
This module will allow our users to document and provide explanations for important differences, to prepare management reports for their various partners, etc. Business owners must continually refer back to their budget as a way of measuring how they are handling their actual results vs. what was budgeted.
Before you start, we recommend that you created multiple scenarios (budgets) and have actual data entered into both your BUDGET and your HISTORICAL DATA.
To know how to import historical data into Budgeto, read the following article from our Knowledge Base: How to import HISTORICAL DATA into Budgeto
To access the Analysis module, start by clicking on the Analysis menu on the bottom of the Left-side menu.
(This new section (Beta) is available for free at this time; it will be a paying option in the future. This is a preview of a new Analysis Model with new features to be added).
1- First step is to enter the data you want to compare in the "Comparison parameters".
- Report: Select which type of report you want for your analysis; Profit and Loss, Cash Flow, Balance Sheet. (1).
- Data set: Select which you want to use; Historical data, Budget 1, Budget 2, etc. (2).
- Starting: Enter the start date of the parameters used for your chosen data set. (3).
- Ending: Enter the end date of the parameters used for your chosen data set. (4).
- Historical: Select if you want to use historical data for your analysis. When you select a month from this menu, Budgeto displays your historical data in the selected report (up to the selected month). Therefore, you have a hybrid report that contains your historical accounting data and your forecasted budget data (the cutoff between the past and the future being the month selected in the drop-down menu). (5).
- Trash: Click on the trash icon to remove that data set selected for analysis. (6).
- Add a data set: Add a new row of data set parameters to use in the analysis. (7).
2- After entering the parameters you wish to use, click on the green button "Generate".
3- See your variances/data between entities below. Notice your variance (difference) between numbers (in this example, optimistic and pessimistic scenarios).
- Detail level: Select which the amount of detail you want to see in your data below. Chose from either just showing the general overview, or having a detailed list of everything entered in your budget. (1).
- Variance- ($/%): Select the amount of variance (difference) between data sets. You have the options of using a dollar amount ($) and percentage amount (%) (2).
- Edit: Return to the comparison parameters to modify the data sets you are using in your analysis. (3).
4- PROTIP! When comparing more than one data set, you can click the report titles to specify the two data sets for which you want to observe the variance.
NOTE (Exporting graphs and data)
We are currently working on implementing a new way to export your data and graphs from the Analysis Module. Take a look at our Roadmap for more upcoming features. In the mean time, you can screenshot the graphs and export them as a JPEG. Learn more by reading this article from our Knowledge Base: How to ScreenShot (SS) Budgeto's Dashboard-Graphs-Analysis Reports
Related Articles (please refer to the links below)