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.
1- First step is to enter the data you want to compare in the "Comparison parameters".
- 1- REPORT: Select which type of report you want for your analysis; Profit and Loss, Cash Flow, Balance Sheet.
- 2- DATA SET: Select which you want to use; Historical data, Budget 1, Budget 2, etc.
- 3- STARTING: Enter the start date of the parameters used for your chosen data set.
- 4- ENDING: Enter the end date of the parameters used for your chosen data set.
- 5- 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).
- 6- TRASH: Click on the trash icon to remove that data set selected for analysis.
- 7- ADD A DATA SET: Add a new row of data set parameters to use in the analysis.
- 8- PRINT: Use the printing feature to produce a PDF copy of your Analysis report.
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).
- 1- DETAIL LEVEL:
- 2- VARIANCE ($/%): Select the amount of variance (difference) between data sets. You have the options of using a dollar amount ($) and percentage amount (%).
- 3- EDIT: Return to the comparison parameters to modify the data sets you are using in your analysis.
- 4- COMMENT: Add comments or notes to the line that is highlighted (ex: explain the variance in historical and budgeted sales...).
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.
Related Articles (please refer to the links below)