Feb 6, 2009

Tally ODBC with Microsoft Excel

Tally ODBC extracts data from Tally and designs the reports in MS Excel. The steps to be followed are:

Start Tally and keep it open till the Mail Merge process is completed.

Ensure ODBC Server is displayed on Tally’s calculator pane.

Open MS Excel.

Click on Data > Get External Data > New Database Query from the Menu.

Select TallyODBC from the Choose Data Source dialog box.

The screen appears as:

Query Wizard displays fields from Tally. Select and click the “>” button to select fields required in your query.

The screen appears as:

Use the Filter Data dialog box to limit the data to suit your requirement.

Sort your data in ascending or descending order in the Sort Order dialog box.

Click on Finish to complete the Query process.

Click on OK from the Returning External Data to Microsoft Excel dialog box to display the selected columns on the Excel sheet.

The screen appears as:

 

 

 

 

Creating ledger a ledger in tally 9

Creation of a Ledger account

The information required for creation of ledgers depends on the features opted by you. If the setting of the Accounting Features [F:11] of your company is No for all options, your ledger creation screen would need minimal information.

It should be noted that Tally automatically creates two ledger accounts, viz., Cash (under Cash-in-hand) and Profit & Loss Account (direct Primary account). It does not make any other presumptions. You must create all other account

heads. There are no restrictions in ledger creation except that you cannot create another Profit & Loss A/c (actually an account that behaves like one). You may create any number of Cash accounts (by another name like "Petty Cash" ).

Gateway of Tally > Accounts Info. > Ledgers > Single Create