Creating Scenarios to View Projected Financial Statements in Tally Prime
In Tally Prime, scenarios allow businesses to project financial statements by including or excluding specific vouchers. This feature is helpful for analyzing hypothetical situations like provisional transactions, forecasts, or alternative business strategies. This article provides a step-by-step guide to creating and using scenarios in Tally Prime with a real-world example.
Step-by-Step Guide
Step 1: Enable Scenario Management in Tally Prime
Before creating scenarios, ensure the feature is enabled:
Go to Gateway of Tally > F11: Features.
Select Accounting Features.
Set Use Scenario Management to "Yes".
Press Ctrl+A to save the settings.
Step 2: Create a Scenario
Once Scenario Management is enabled, you can create scenarios:
Go to Gateway of Tally > Accounts Info > Scenarios.
Select Create.
Enter a name for the scenario, e.g., "Projected Sales Q1 2024".
Under Include Actuals, choose "Yes" to include actual transactions.
Under Exclude Vouchers, select the type of vouchers to exclude, e.g., "Optional Vouchers".
Save the scenario by pressing Ctrl+A.
Step 3: Record Provisional Vouchers
To project financial outcomes, record provisional transactions using optional vouchers:
Go to Gateway of Tally > Vouchers.
Press Ctrl+O to switch to optional mode.
Record a voucher, such as a sales invoice, as optional.
For example, record a sales transaction for ₹200,000 as an optional voucher.
Save the optional voucher.
Step 4: View Projected Financial Statements
Use the created scenario to view projected financial statements:
Go to Gateway of Tally > Display More Reports.
Select a financial statement, e.g., Profit & Loss Account or Balance Sheet.
Press Alt+C to change the scenario.
Select the scenario, e.g., "Projected Sales Q1 2024".
The report will display the financial statements, including optional vouchers and actual transactions as per the scenario configuration.
Example: Projected Sales Q1 2024
Let us assume the following data:
Actual Sales (Jan-Mar 2024): ₹500,000
Projected Sales (Optional Voucher): ₹200,000
Using the "Projected Sales Q1 2024" scenario, the Profit & Loss statement will display:
Category
Amount (₹)
Actual Sales
500,000
Projected Sales
200,000
Total Sales
700,000
Step 5: Analyze the Results
With the scenario applied, the total sales figure of ₹700,000 reflects both actual and projected sales. This provides valuable insights for planning and decision-making.
Conclusion
Creating scenarios in Tally Prime allows businesses to simulate financial outcomes under different conditions. By following this guide, you can use scenarios to make informed decisions, plan for the future, and assess the impact of various business strategies. This feature helps improve financial analysis and strategic planning.