Tally Tutorials

GUEST BOOK

2011-04-18T15:46:00.000+05:30

FUTURE USE OF COMPUTER IN DAILY LIFE

2011-03-30T13:35:00.001+05:30

CELL PHONE SAFETY

2011-03-30T13:33:00.002+05:30

We use mobile phone daily. We should know what bad effects of this on our health & how we can reduce it. This is just guide for that.

HOW TO SEND FAX FROM COMPUTER TO FAX MACHINE -WINDOW XP

2011-02-04T17:30:00.002+05:30

<<...>>

my audience

2011-01-13T15:31:00.002+05:30

Viewers of this blog

2009-12-18T13:27:00.002+05:30

Country Visitors Last New Visitor
1. India 16,383 [Chart IN Visitors] December 18, 2009
2. United States 922 [Chart US Visitors] December 17, 2009
3. United Arab Emirates 817 [Chart AE Visitors] December 17, 2009
4. United Kingdom 248 [Chart GB Visitors] December 16, 2009
5. Pakistan 146 [Chart PK Visitors] December 17, 2009
6. Saudi Arabia 139 [Chart SA Visitors] December 16, 2009
7. Nepal 125 [Chart NP Visitors] December 17, 2009
8. Bahrain 122 [Chart BH Visitors] December 14, 2009
9. Qatar 103 [Chart QA Visitors] December 16, 2009
10. Singapore 102 [Chart SG Visitors] December 16, 2009
11. Bangladesh 92 [Chart BD Visitors] December 16, 2009
12. Oman 92 [Chart OM Visitors] December 13, 2009
13. Tanzania, United Republic of 83 [Chart TZ Visitors] December 17, 2009
14. Malaysia 79 [Chart MY Visitors] December 2, 2009
15. Ghana 71 [Chart GH Visitors] December 17, 2009
16. Australia 66 [Chart AU Visitors] December 2, 2009
17. Canada 65 [Chart CA Visitors] December 16, 2009
18. Uganda 63 [Chart UG Visitors] December 15, 2009
19. Kuwait 61 [Chart KW Visitors] December 15, 2009
20. Norway 52 [Chart NO Visitors] December 17, 2009

Tally 9 - FAQs on Excise for Dealers

2009-06-24T10:49:00.002+05:30

Tally 9 – FAQs on Excise for Dealers

Q1. How do I enable Excise for Dealers in Tally 9?

Answer:

Go to Gateway of Tally > F11: Features > F3: Statutory & Taxation

1. Set Enable Dealer - Excise to Yes

2. Set Set/Alter Dealer - Excise to Yes

3. Specify Company Excise Details in the sub-screen that displays

Q2. Can I create Purchase and Sales vouchers for Non-Excisable goods also?

Answer:

Yes. You can use the default Sales and Purchase Voucher types available in Tally to enter purchase and sales vouchers for Non-Excisable goods.

Q3. How do I account for Sales / Purchase transactions of Excisable goods?

Answer:

To issue Cenvatable Invoices on sale / removal of excisable goods, a dealer in excisable goods is required to create separate Voucher Types (such as, Excise Purchase and Excise Sales) and set Use for Dealer Excise to Yes.

Q4. How do I enter Excise Details for Supplier and Customer ledgers?

Answer:

To enter Excise details in Supplier and Customer ledgers, set the option Excise Details to Yes in the Supplier/ Customer master creation screen

1. Enter Customer/ Supplier related excise information

Q5. How do I enter Excise Details for a Stock Item?

Answer:

Go to Gateway of Tally> Inventory Info. > Stock Item> Create/Alter

1. Set Excise Details to Yes in the Stock Item Master Creation screen

2. In the sub-screen of the stock item, fill in the relevant Excise Details such as Tariff classification, applicable duties of Excise and Method of calculation

Q6. Can I define the stage of purchase at the time of purchase entry?

Answer:

Yes. During purchase entry, the Nature of Purchase table displays the user-definable default nature of purchase stipulated in the Party Master. Nature of Purchase is based on the status of the selling dealer (supplier) or the stage of sale of excisable goods.

Q7. Can Purchase value and Assessable value be different?

Answer:

Yes. While creating an Excise Purchase Invoice, at the Excise Details for sub-screen, the Assessable value entered in the amount column is prefilled by default. However, it is undefinable if the Assessable Value is different from the Purchase value.

Q8. How do I refer to Purchases with CENVAT Credit availability while passing excise duty in a Sales invoice?

Answer:

On selecting a Stock Item while creating an Excise invoice,, a list of Purchase invoices against which the Stock item was purchased and for which the CENVAT Credit is available displays. Select the required Purchase reference to pass on the credit.

Q9. How do I print Supplier and Manufacturer details in an Excise invoice?

Answer:

In the print configuration for the Sales invoice, click F12: Configure and set Print Trader Supplier Info to Yes to print Supplier and Manufacturer details in an Excise invoice.

Q10. How do I view the Excise Stock Register?

Answer:

To view the Excise Stock Register,

Go to Gateway of Tally > Display > Statutory Reports > Dealer Excise

Reports > Excise Stock Register

Q11. How do I view the Excise Purchase Bill Register?

Answer:

To view the Excise Purchase Bill Register,

Go to Gateway of Tally > Display > Statutory Reports > Dealer Excise Reports > Excise Purchase Bill Register

Q12. How do I view Form-2 (Statutory Quarterly Return) in Tally?

Answer:

To view Form-2 (Quarterly Return),

Go to Gateway of Tally > Display > Statutory Reports > Dealer Excise Reports > Form-2

Q13. How do I enter PLA RG 23 Serial Number in Tally?

Answer:

In the Excise Details sub screen of a Purchase Voucher, enter the (PLA RG 23) Serial number recorded in the Manual Purchase register to print it against the Supplier/Manufacturer Invoice number. Follow the same procedure in a Sales Invoice.

Q14. How do I enter Opening stock inventory for Excise item?

Answer:

Go to Gateway of Tally > Inventory info > Excise Opening Stock to enter

opening stock for an Excise Item.

Q15. How do I find out Total duty passed on and Balance duty available

Item wise or purchase bill wise?

Answer:

Go to Gateway of Tally > Display > Statutory Reports > Dealer Excise

Reports > Excise Stock register/Excise Purchase Bill Register to obtain the

Item wise/Purchase bill wise amount of duty passed and balance duty available.

How to Creat Excise Invoice in tally 9

2009-06-22T16:42:00.000+05:30

MY blog Viewer Statistics as 18.5.2009

2009-05-22T14:39:00.001+05:30

<<...>>

Budgets

2009-05-13T17:14:00.001+05:30

Tally allows you to create multiple budgets. There could be a budget for specific purposes, e.g., for the bank, for the head office, optimistic budget, realistic budget, pessimistic budget, etc. Departmental Budgets can also be created, e.g., Marketing Budget, Finance Budget, etc.

As usual, you first create budgets. You can of course alter them.

Budget figures are used to compare against actual and to display variances. This is done by bringing up a new column when displaying a statement and selecting the appropriate budget.

We shall now go through the creation and alteration of budgets.

Gateway of Tally > Accounts Info > Budgets

How to Manage and Operate Budgets?

Gateway of Tally > Accounts Info > Budgets Create

Name

Give the budget a name, in this case, Corporate Budget. As you may have other budgets as well, the name distinguishes them.

Under

In the true Tally tradition, you can have a hierarchical budget set-up. At the top level is the Primary Budget. You can set up more than one Primary Budget. Under each Primary Budget, sub-budgets can be created.

Period of Budget

Specify the period of the budget. The period could be a month, a year or any period starting from any date to any date.

Set/Alter Budgets of

You may want to set the budget for groups of ledger accounts or for ledger accounts individually or for cost centers or all of them. We shall take up budget for group only. Follow the same process for setting budgets for individual ledgers and cost centers.

Budget for Groups

Yes, if you want to set budgets for a group or groups of ledgers.

If yes, fill in the fields in the Group Budget sub-screen:

Account Name

Give the names of the groups for which the budget is being set.

Cost Centre

For each group name, a cost centre may be earmarked, i.e., Indirect Expenses for a particular cost centre or a group of cost centers only. If you select 'Not Applicable', then the budget is not for any particular cost centre but the company as whole.

Type of Budget

Budgets could be of two types:

On Net Transactions – where transaction amounts are to be monitored and not the balances. Net is net of debits and credits for the specified period. Hence, net transactions for Indirect Expenses would mean the debit amount for the specified period after reducing the credits for the same period. Opening and closing balances not withstanding.

On Closing Balance – where you wish to monitor the balance of the accounts and are not too keen on the transactions, e.g., balances of Bank Accounts, balances of debtors.

Amount

The budget amount for the account for the specific cost centre.

Budget for Ledger Accounts

Gateway of Tally > Accounts Info > Budgets > Create

You may choose Alter if a Budget exists for other entities like Groups and Cost Centers but not for Ledgers.

Name for the Budget

1. Give the name of Budget. E.g. Corporate Budget under Primary Budget.

2. Specify the period of the Budget. The period could be a Month, a Year or any period starting from any date to any date.

3. Under Set/Alter Budgets of, you may set the budget for groups of ledger accounts or for ledger accounts individually or for cost centers or all of them.

4. Here we shall take up Budget for ledgers. Hence, set Yes under Ledgers and let others remain No.

5. Select the ledgers for which you wish to set the Budget.

Budget for an account allocated to a cost centre

A budget can be created for each ledger account pertaining to a cost centre, e.g. Accountancy Fees for Finance Group. Then, Accountancy Fees could be repeated for another cost centre, e.g., a Branch. However, if you select not applicable then the budget is not for any particular cost centre but the company as whole.

Type of Budget

Under the Type of Budget a pop-up of two different kinds of Budgets appears.

On Closing Balances

Where you wish to monitor the balance of the accounts and are not too keen on the transactions. For e.g., balances of Bank Accounts or Debtors. This means that the magnitude of transactions is ignored. You are concerned only with the amount remaining in the account. This is useful for Balance Sheet items.

On Nett Transactions

If you are concerned with the magnitude of transaction amounts use this option. Revenue items reflect the transacted amounts. Why nett? This is because you do not expect to have a negative figure in such accounts and if they exist, they are adjustments. E.g., an expense account like travel will always have debit entries only unless there is a reversal due to error or charge to a customer.

Caution

When using Nett Transactions, the Budget Closing Balances actually get adjusted even if you have not selected this type. The figures in the Profit & Loss Account will reflect the Closing Balance figures.

Note: For comparing closing balance figures in final statements, especially the Balance Sheet items, viz., assets and liabilities, choose Closing Balances.

For comparing transactions against budgets, especially revenue income and expenses, choose On Nett Transactions.

Apportionment of budget specified for periods longer than a month

o Ledger Budgets are apportioned for each month on the basis of number of days.

o Group Budgets do not get apportioned. Hence Budget for Current Assets will not automatically flow to sub-groups.

o Closing Balances Budget: Each month will have the same budget value except that the actual Opening Balance is also taken into account.

o Net transactions Budgets specified for a period get equally apportioned over the period.

o Enter the budget amount for the specific ledger.

o You can Budget as many ledger accounts as needed and finally accept the screen.

Creating Delivery note in TALLY 9

2009-04-25T17:24:00.004+05:30

VAT ( Value Added Tax )

2009-03-16T18:13:00.009+05:30

VAT is a system of indirect taxation, which has been introduced in lieu of sales tax. It is the tax paid by the producers, manufacturers, retailers or any other dealer who add value to the goods and that is ultimately passed on to the consumer. VAT has been introduced to ensure a fair and uniform system of taxation. It is an efficient, transparent, revenue-neutral, globally acceptable and easy to administer taxation system. It benefits the common man (consumer), businessman and the Government.

Further, VAT enhances competitiveness by removing the cascading effect of taxes on goods and makes the levy of tax simple and self-regulatory, ensuring flexibility to generate large revenues.

The cascading effect is brought about by the existing structure of taxation where inputs are taxed before a commodity is produced and the output is taxed after it is produced. This causes an unfair double-taxation. However, in VAT, a set-off is given for input tax (tax paid on purchases). This results in the overall tax burden being rationalized and a fall in prices of goods.

VAT makes the tax structure simple, hassle-free, export-oriented and how the integration of VAT with Tally will help you in the smooth functioning of your business and eliminate the complications that might otherwise arise in VAT.

The essence of VAT is in providing set-off for input tax and this is applied through the concept of input credit/rebate. This input credit in relation to any period means setting off the amount of input tax by a registered dealer against the amount of his output tax. The Value Added Tax (VAT) is based on the value addition to the goods, and the related VAT liability of the dealer is calculated by deducting the input credit from the tax collected on sales during the payment period. This concept is explained with an example, in the Computation of VAT section .

VAT works in two different ways:

1. If VAT-registered businesses receive more output tax than the taxes paid as input, they will need to pay the difference to the Commissioner of Taxes (State).

2. If the input tax paid is more than the output tax collected,

o You can carry forward the Input credit and adjust it against the output tax in the subsequent months.

o You can have the Input Credit refunded to you at the end of the current or following year, by the Government.

o You can receive refunds for Input Credit on exports within a period of three months

Term

Description

This is a tax paid on purchases

This is a tax charged on sales

The amount of Input tax that is permitted to be set off against Output tax.

Dealers with annual gross turnover not exceeding a certain threshold (threshold - decided by the respective State Governments) can opt for a composition scheme whereby they will pay tax as a small percentage of their gross turnover. However, retailers opting for this composition scheme will not be entitled to Input Credit.

The State Governments fix the periods and the procedures for the payment of the lump sum.

source for industrial tools

RCM business

Best use of Internet

Advantages of VAT over Sales Tax

2009-03-16T18:13:00.007+05:30

· As VAT is a multi-point tax with set-off for tax paid on purchases, it prevents repeated taxation of the same product.

· Simple and Transparent – In the Sales tax system the amount of tax levied on the goods at all stages is not known. However, in VAT, the amount of tax would be known at each and every stage of goods sale or purchase.

· VAT has the flexibility to generate large and buoyant revenues, as it levies tax on value additions.

· Zero rating of tax on exports is possible in case of VAT.

· Fair and Equitable – VAT introduces uniform tax rates across the state so that unfair advantage cannot be taken while levying the tax.

· Procedure of simplification – Procedures, relating to filing of returns, payment of tax, furnishing declaration and assessment are simplified under the VAT system so as to minimize any interface between the taxpayer and the tax collector.

· Ability to provide same revenue to the Government with lower rates of tax.

· Tax does not become a cost of doing business.

VAT Rates

According to the White Paper, there are 550 categories of goods under the VAT system. They are classified into the following four groups, depending on the VAT rate:

VAT @ 4%

The largest number of goods (270) comprising of basic necessity items such as drugs and medicines, agricultural and industrial inputs, capital goods and declared goods are under 4% VAT rate.

Exempted from VAT

There are about 46 commodities under the exempted category. This includes a maximum of 10 commodities that each state would be allowed to select, from a broader approved list for VAT exemption. The exempted commodities include natural and unprocessed products in unorganized sector as well as items, which are legally barred from taxation.

VAT @ 1%

This is for a specific category of goods like gold, silver, etc.

VAT@12.5%

The remaining commodities are under the general VAT rate of 12.5%.

tally tutorial source for industrial tools RCM business Best use of Internet

Beauty of Mathematics

2009-03-03T17:05:00.001+05:30

AMAZING

Reconciliation of Bank accounts

2009-02-27T13:43:00.001+05:30

Reconciling the Company's Bank Accounts with the Banker's Statement is a fundamental and regular task of Accounting. Our first presentation of this facility aims to tackle two issues.

First, there should be the ability to 'check back' the correctness of the reconciliation. This has been done, by marking the 'Bank Date' against the voucher. For instance, if you have issued a Cheque on 8th April, which was ultimately cleared by your Bank on 19th April, - you would set the Bank Date for the voucher to be 19th April. This means, that when you next need to 'check back' whether the entry made by you is correct, you will only need to verify the Bank Statement of the 19th.

Second, that you should be able to 'recover' the reconciliation as of any date. This is of crucial importance to Auditing. The Bank Reconciliation is one of the pre-requisites of Auditing and verification of the correctness of accounts at the year end. However, it is not a 'real-time' task – in the sense, that it is not done by the auditor's on the first day of the next year. This means, that the reconciliation made on 31st Mar, should be 'viewable' even in August, - by when almost all the Cheques would have subsequently been marked as reconciled. This has again been achieved using the concept above.

Bank Accounts may have a different 'Starting Date' for reconciliation purposes. When you create a Bank Account, you are requested to give an 'Effective Date for Reconciliation' just before the Opening Balance. Normally, this would be the Books Beginning from date itself. However, you could have imported data from a previous version of Tally or from any other system (where the reconciliation process was not available or was different. In that case, you may not wish to reconcile the bank account with your bank statements from the very beginning. Give the date from which you want the reconciliation facility to be activated. Then, previous entries will not appear for reconciliation, but will be taken as a reconciled Opening Balance.

A quick experiment with Reconciliation will show you what is meant. Here is how you go about it:

1. Bring up the monthly summary of any Bank Book. (You could do this from the Balance Sheet, Trial Balance, or Display/Account Books/Bank Books, and selecting a Bank).

2. Bring you cursor to the first month (typically April), and press Enter. This brings up the Vouchers for the month of April. Since this is a Bank Account, an 'additional' button F5: Reconcile will be visible on the right. Press F5.

3. The display now becomes an 'Edit' screen in 'Reconciliation' mode. The primary components are :A column for the 'Bankers Date'

4. The 'Reconciliation' at the bottom of the screen, showing:

5. Balance as per Company Books

6. Amounts not reflected in Bank

7. Balance as per Bank

The Balance as per Company Books reflects your Balance as on the last date (in our example case, 30- Apr).

The Amounts not reflected in Bank is the debit and credit sums of all those vouchers whose Bank Date is either BLANK, or GREATER than 30-Apr (i.e. these vouchers have not yet been reflected in the Bank Statement).

The Balance as per Bank is the Net effect of your Book Balance offset by the amounts not reflected in the Bank – which should equal the balance in the Bank Statement. (Of course, some variation may persist due to entries made in the Bank Statement which you have not yet entered in your Books – but since you WILL definitely enter them, and only then print your reconciliation, it will ultimately reflect the correct balance).

You will find, as you mark off the individual vouchers by setting the 'Bank Date', that the Reconciliation at the bottom of screen keeps reflecting those changes instantly. When you are finished, press Ctrl +A (or press Enter as many times as necessary to skip over the unmarked vouchers), and accept the screen. (If your screen has a largish number of vouchers it may take some time to complete the acceptance – be patient).

The next time you come for reconciliation, you will be presented only with those vouchers which remain un reconciled. Thus, the task keeps becoming simpler.

(It may be possible, that due to an error of entry made earlier, you wish to see those vouchers which are already marked as reconciled – so that you may modify their marking. To do this, press F12:Configure. In case you have already pressed a few keys BEFORE pressing F12, Tally will query whether you wish to discard changes made so far, if any, by asking 'Quit Y/N'. Simply press Y – and the configuration screen will appear. Here, specify whether you wish to see the reconciled vouchers also).

Remember, to print your Reconciliation, just press Alt+P!

source for industrial tools

RCM business

Best use of Internet

Account Books in Tally 9

2009-02-19T11:19:00.005+05:30

Books of account record the individual transaction details you have entered. Although you may post items to many different ledgers, Tally brings all the transactions of one category together into a book of account for viewing and printing. For example, the Cash Book records all the transactions affecting cash, the Sales Book records all the sales transactions.
1) All books are displayed first as a monthly summary with opening and closing balances.

2) Select a month and press [enter] to display all transactions for the month. The opening and closing balances as well as transaction totals are also displayed.

3) Select a transaction to bring up the voucher. This voucher comes up either in display or in alteration mode depending upon the access rights available to you.

Day book

2009-02-18T15:35:00.004+05:30

Gateway of Tally > Display > Day Book

The Day Book is a list of all transactions for a particular day, by default the current date. It can also list all the transactions for a period. Transactions include all financial vouchers, reversing and memorandum journals as well as inventory vouchers.

For example:

Day Book for a period:
Day Book

The list can be filtered to show transactions of a particular voucher type. Use Chg Vch button.

When in a specific voucher, e.g. Delivery Notes, options like Extract and Columnar become available.

Vocher entry major types

2009-02-18T15:13:00.002+05:30

In Tally , Voucher entry consist of mainly two types I) material in & out II) Amount in & out.

In each type sub varieties are there as below

I) Material In & Out

Sales voucher
Purchase voucher
Goods receipt notes
Rejection in
Rejection Out
Delivery notes Etc.

II) Amount In & Out

Receipts
Payments
Contra
credit notes
Debit notes
Commission
Discounts. Etc

If we learn OR understand mainly Sales, Purchase, Payment & Receipts entry, Then all other entry are similar to above entry only relevant situation different names are there.

Virtual DJ : The Ultimate DJ Mix Software

2009-02-16T11:00:00.003+05:30

VirtualDJ is the hottest MP3 mixing software, targeting every DJ from bedroom DJs to professional superstars like Carl Cox.
With its breakthrough BeatLock engine, your songs will always stay in the beat, and you can work your mixes incredibly faster than any other DJ could.

The automatic seamless loop engine and the brand new synchronized sampler will let you perform astounding remixes live, with no preparation at all.
The visual representation and the cues allow you to clearly see the song's structure, and never be surprised by a break anymore.
The vinyl controls will let you scratch like on a real turntable, except that with the beatlock engine your scratches will never end out of the beat.

Add to that an infinite number of cue points you can save for each songs, a bunch of wonderful effects automatically beat-synchronized.

Add also several interfaces to suit everybody from the beginner to the professional DJ, the possibility to record your mixes to burn them on CDs, to broadcast on the Internet and have your own radio station, to save your CDs directly in MP3, to use a headphone to preview the songs or an external mix table to perform in a club.

Lastly, enter the new era of DJs by mixing video clips (DVD, DivX, MPEG...) which you can send on a giant screen.

Virtual DJ brings you all that, in the most easy-to-use way, and at the most affordable price.

Virtual DJ software features

Twin independent zero-latency players with:

Standard controls (play, pause, stop, cue)
Volume control
Pitch control (from -34 to +34%)
3 band equalizers with Kill + gain

One-click beat matching and synchronization (new FAME algorithm)
BeatLock engine: your songs will always stay in time, and you can work your mixes incredibly faster than any other DJ could
Automatic beat-matched cross fading
On-the-fly automatic BPM calculation
Automatic pitch matching
Automatic level matching
Automatic beat matching
Dynamic beat visualizer for easy drag'n'drop beat-matching
Real scratch simulation
Virtual scratch: Scratch your mp3 with your bare hand
Automatic beat-aware LOOP function
Synchronized sampler with 12 instant slots
Master Tempo pitch algorithm
Automatic first beat and last beat detection
Automatic 4/4 phase detection
OSC network synchronization
Infinite number of beatlocked desks (local multi-instance or network)
Infinite number of cue points saved per songs
Beat-aware effect plugins (included: beatgrid, flippin, vocal remover, filter, flanger, backspin, brake, etc...)
VST effects compatibility
Video mix with TV output (mix songs and/or video clips !)
Full karaoke support
Proprietary of FreeFrame video effects
Infinite number of video effect simultaneously
DJ-adapted video transition plugins
Song database engine with easy-to-use search feature
Cover Flow or text-only song browsing
Compatible with iTunes playlists
ID3 compatibility
Automatic filter folders
Automatic Hot-Swap of external hard drives
Ready-to-burn file recording to burn your own mixed CDs
Broadcast on the Internet
CD to MP3 encoder
Optional 3D sound card, 2 sound cards or Y-splitter for real-time monitoring or external mixtable use
ASIO soundcard compatibility
Fully customisable (skin engine and shortcut macro engine)
External MIDI keyboard compatibility for shortcuts
Compatibility with most external controllers (DMC2, DAC3, iCDX, TotalControl, BCD2000, DJConsole, etc...)
Optional automatic mixing: Virtual DJ recognizes the style of the music (techno, hip hop, lounge) and adapt its mix in consequence

You can download trial version from here. DOWNLOAD

tally tutorial source for industrial tools RCM business

Short cut keys in tally 9 & its use

2009-02-11T14:38:00.003+05:30

The shortcut keys appear in button names in the button bar (right side of the Tally screen). You can either click the button from the button bar or press the relevant function key or character underlined/double-underlined.

The buttons have a function key before the button names ( Eg: F1: Select Cmp) which means you need to press F1 key (Function Key) to select the 'Select Company' screen

The buttons have an underlined character ( Eg: F3:Cmp Info), which means you need to press ALT + F3 to select the 'Company Info' screen.

Some buttons have a double-underlined character (Eg: As Voucher) which means you need to press CTRL + V to select the 'Voucher' in voucher mode.

The shortcut keys available in Tally are listed in the below slide show:

Tally 9 Shortcut Keys

View more presentations from Sunil Lalge. (tags: tally9 slide)

Purchase transaction in tally

2009-02-07T16:04:00.008+05:30

This slide shows steps involved in Purchase voucher entry in Tally 9

Tally 9 Purchase Entry

View more presentations from Sunil Lalge. (tags: tally 9)

source for industrial tools

RCM business

Tally ODBC with Microsoft Excel

2009-02-06T11:50:00.001+05:30

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

2009-02-06T09:55:00.004+05:30

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

How to send an Email from tally

2009-01-31T18:58:00.001+05:30

The E-mail is the most widely used facility on the Internet. It saves time and cost of postage. Use the email feature in Tally.
• E-mail any Tally report or document like invoices or purchase orders
• Post reminder letters and statement of accounts
The following example illustrates the use of this feature in Tally
E-mail a Invoice
To send a Invoice to a customer by email:
1. Gateway of Tally > Display > Accounts Books> Sales Register >
2. Select the required Invoice from the sales Vouchers
3. Click on Email from the button bar or press Alt+M

1. The fields on the Mailing Invoice form are automatically completed if you have given the required information during creation of the master records. Select No or press Backspace to change/modify the entries. Select Yes to accept.
2. The E-mail Server field is highlighted next. This is a mandatory field. The first time you use this feature in Tally, enter the name of your SMTP server, example: mail.btinternet.com. Subsequently, Tally will automatically display the SMTP server name. Refer to your Internet Service Provider (ISP) or network administrator for further queries.
3. The From field displays the name of your company entered in the Company Creation screen and stored in the Company Information Master records. You can also modify the default information. Press Enter.
4. The From E-mail Address field displays the e-mail address entered in the Company Information Master data. Enter your email address, if you have not done so while creating a company, or if you want to change the id.
• Enter the user name and password in Authentication User Name (Only if required) and Password field respectively if the mail server requires authentication.
• In the Format field a pop-up screen lists the three formats in which you can generate your email:
o ASCII (Comma delimited)
o HTML (web-publishing)
o XML (data interchange)
Select the type that suits your recipient.
1. To E-mail Address field is a mandatory field.

It displays the recipient’s email address as entered in the Mailing and Related details during ledger creation. Enter the address if you have not done so while creating the ledger or if you want to modify the information.
1. Type the email address of another recipient to whom you want to send a carbon copy of the email in the CC (if any) field.

1. The Subject field is filled by default and displays the subject of your mail. You can change it to a subject of your choice.
• Any text you enter in the Additional Text field precedes the report in the recipient’s mail program. You can use this field to type a message to the recipient.
• Additional Options provided in the form are:
o Include Post-Dated Transactions?- Set this option to Yes to include post-dated transactions.

Note: Additional Options may vary depending upon the type of report you want to email.
1. Print Preview: Use the Print Preview screen to view the document before emailing. This shows how the document appears in the recipient’s email

Sales Item Invoice

2009-01-29T15:30:00.000+05:30

Invoicing is generally used for sale of stock where the details of the items sold are listed. Selecting the Item Invoice allows you to select the stock items to be invoiced. This format is more commonly used by trading and manufacturing organisations.

On the Sales invoice screen - click on the button (Item Invoice) on the right-hand side of the screen and the Sales Item Invoice appears as:

Tally's Item Invoice mode - displays the list of stock items, which can be invoiced as required.

The Item Invoice button toggles with Account Invoice.

Procedure

Enter the date of sale
Enter the ref; if any other wise skip it
Select party account name from pop up window. If it new one then create the party there it self by pressing ALT+C.
Select the type of sale. Like sales @ 4%, sales @ 12.5% etc.
Select the vat tax class, Like 4%, 12.5% etc.
Select the item to be sold from pop up window. ( list of items).If it new one then create the item there it self by pressing ALT+C. .
Enter the quantity to be sold.
Enter the rate of item in your currency.
More items are there, then repeat the procedure from 6 to 8.
After items are over then enter.]
Select the corresponding tax ledger from pop up window.If it new one then create the ne tax class there it self by pressing ALT+C. .
Enter the any packing & forwarding charges or freight charges if any.
Enter addition or subtraction amount for rounding of total value.
Enter the narration / Remarks if any.
Press enter to accept the details.

your sales voucher is saved.
if you you can take print out of that.