Procedure for using ODBC software for transferring data

Start Tally and select the company from where you want the data to be extracted. Minimize Tally and open ODBC compliant software.
Here I will explain it using MS-Excel.
Open MS-Excel and select the menu 'Data' at the MS-Excel window, then select 'Get external Data' then select 'New Database Query'. Then select "TallyODBC" of Database tab.
Tally then connects to data source and displays the 'Query Wizard'. Select the column you want to include.
Excel displays all the columns as the columns are selected.

Tally Open Database Connectivity(ODBC)

Tally data can be embedded into other ODBC compliant software like MS-Excel, MS-Word, Visual Basic, etc by installing Tally ODBC driver. Tally data driver can be made available to external applications. Tally Data can be viewed too.

Open Database Connectivity - ODBC

Any program like MS-Excel, Oracle, etc. that is ODBC compliant can use data from Tally as Tally is ODBC compliant. Any changes in Tally will be reflected in the ODBC compliant software as the data connectivity here in Tally is dynamic in nature. Through this facility data can be extracted from Tally and the report extracted can be designed as per the users requirement.

Using Scenario in Statements and Reports

Scenario can be used in reports in which the new column button is active on the vertical button bar. It helps us to compare figures of the different columns. The usage of scenario in the Balance Sheet can be learnt by performing the steps shown here:

Open the Balance sheet by going to Display -> Balance Sheet or by pressing 'B' at Gateway of Tally

Insert a new column in the Balance Sheet by clicking on New Column button bar or by pressing Alt + C.

Enter necessary details, in the Column Details screen that appears :

• From(blank for beginning): Give the starting date of the period, for which the figures are to be taken.

• To(Blank for end) : Give the ending date of the period till which the figures are to be taken.

• Currency : Type of currency in which the amount is to be displayed.

• Method of Stock Valuation : Select the appropriate method of stock valuation here.

• Type of value to show : From the given list of 'Type of value', select the scenario based on which the amount of the new column will appear.

Then you will find two columns in the Balance Sheet for the same date, one column for the actual figures and the other based on the scenario.

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.