Creating a Scenario

In order to create scenario, go to Gateway of Tally -> Accounts Info -> Scenario -> Create.

It will forward you to the scenario creation screen. There you have to enter the following details:

Name : Enter a suitable scenario name here.

Include Actuals : If you want the report to have actual figures as well, enter 'Yes'.

EXCLUDE Forex Gains/Loss Calculations : In case you do not want the unadjusted Forex Gains/Loss element to appear in the scenario, type 'yes'. Type 'No' if you want Forex Gains/Loss element to appear in the scenario report.


EXCLUDE Inventory Tracking Calculation : In case you do not want the pending Sales or Purchase Bills to appear in the scenario, type 'yes'. Type 'No' if you want pending Sales or Purchase Bills to appear in the scenario.

Include : From the given list include the type of voucher that you want to affect this scenario you are creating. Only provisional Voucher types created for this company are permitted for selection i.e. all transactions recorded using Memorandum, Reversing and Optional marked vouchers of other voucher types are available for selection.

Exclude : This option is used while modifying an existing scenario. In case you don't want any particular type of voucher in an existing scenario, you have to open the scenario in Alter mode, select the type of voucher, already included, which you want to exclude. Then accept to save the scenario.

Activation of Scenario feature

Press F11 at Gateway of Tally then press F1(Accounting features) at the company feature menu. There set the option "Use Reversing Journal and Optional Voucher?" to 'yes' under the heading Budgets and Scenario Management. Press enter.

Scenario

It is a very useful feature in tally which enables us to foresee the financial situation of the business based on certain probable conditions. It is useful for generating reports with provisional figures without actually affecting the main database. It is also helps in forecasting by entering forecast figures in provisional vouchers and including them to get forecasted reports.

Vouchers that are used in Scenario management are:

• Memorandum voucher

• Optional Voucher

• Reversing Journal

Any number of scenario each including and/or excluding one or more types of these voucher entries can be created.

Renumbering of Voucher Automatically

In the voucher type, if you have chosen Automatic method of voucher numbering, then in that case if you delete or insert or even change the date of any saved voucher, tally will again renumber all the vouchers automatically in a chronological manner.

Excise Report

To view the Dealer Excise Report, go to Display from Gateway of Tally then go to statutory reports and then to Dealer Excise reports.
(Gateway of Tally -> Display -> statutory reports -> Dealer Excise reports)

There you can view two type of reports like Excise Stock Register and Form 2.

Form 2 is the return to be submitted by the dealer of excise duty every quarter.
Excise Stock Register shows the daily receipt and issue of excisable goods.

Excise invoice Printing

When the sales invoice has been made, you will require printout of the invoice from Tally. In order to print, press Alt + P at sales invoice screen. Then you will get the printing screen, you can find preview of excise invoice as per Rule 11 of the Central Excise Rule, 2002. Set the print configuration as desired. To select the excise duty break up and purchase details in Sales Invoice, you have to go to configure button(F12) and set the option "Print trader Supplier Info" to 'Yes'. The details of supplier, customer and manufacture are shown in the Sales invoice. The purchase and sales details of excise as well as the duty details are shown here.