Dec 18, 2009

Viewers of this blog





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

Jun 24, 2009

Tally 9 - FAQs on Excise for Dealers


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.

May 22, 2009

May 13, 2009

Budgets

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.

 

Mar 16, 2009

VAT ( Value Added Tax )

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

Input tax

Output tax

Input Credit

Composite Dealers

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.

Advantages of VAT over Sales Tax

· 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%.

Mar 3, 2009

Feb 27, 2009

Reconciliation of Bank accounts


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!

Feb 19, 2009

Account Books in Tally 9

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.






Feb 18, 2009

Day book

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

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
  1. Sales voucher
  2. Purchase voucher
  3. Goods receipt notes
  4. Rejection in
  5. Rejection Out
  6. Delivery notes Etc.
II) Amount In & Out
  1. Receipts
  2. Payments
  3. Contra
  4. credit notes
  5. Debit notes
  6. Commission
  7. 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.

Feb 16, 2009

Virtual DJ : The Ultimate DJ Mix Software

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