Budget creation in Tally.ERP 9

To create a Budget in Tally.ERP 9
Go to Gateway of Tally > Accounts Info > Budgets > Create
1. In the Budget Creation screen enter a Name for your budget.
2. Select from the List of Budgets for Under field. You can have a hierarchical setup for budgets. In the List of Budgets, Primary is at the top of the hierarchy and you can create more primary budgets. Sub-budgets can be created under Primary budgets.
3. Enter the period of the budget in the From and To fields. The period entered can be a month, a year or any other period.
4. In Set/Alter Budgets of, select
• Groups - To create a budget for a Group of ledger accounts.
• Ledgers - To create a budget for Ledgers.
• Cost Centres - To create a budget for Cost Centres.
5. Accept to save.
You can modify a budget, using the alter option.
Go to Gateway of Tally > Accounts Info > Budgets > Alter
1. In the Budget Alteration screen, modify the fields as required. Change the period or change budgets of Groups, Ledgers and Cost Centres.

Note: By default, Set/Alter Budgets is set to No. Set this option to Yes to alter

Microsoft Excel Tips

1. In cell A1 press <Ctrl ;> to insert today's date – press <Enter> or <down_arrow>

2. In cell A2 press <Ctrl Shift ;> to insert the current time – press <Enter> or <down_arrow>

3. Press <Ctrl spacebar> to select column A then <Ctrl d> to fill the whole column with today’s date

4. Press <Ctrl z> to [Undo] the last command then <Ctrl 0> to hide column A

5. Press <Ctrl Shift 0> to unhide the column then repeat step 2 to get the new current time

6. In cell A4 press <Alt => to sum up the two times (needless to say you wouldn’t normally sum times!)

7. Now press <Ctrl `> (the key in the top left corner) to show exactly what’s stored in the cells

Pass or fail and Grade in Excel

=IF(E1>=210,"pass","fail")    

     
         * E1 - Total cell

         * 210 - pass mark

=IF(E1>=500,"A+",IF(E1>=400,"A",IF(E1>=300,"B+",IF(E1<=300,"fail"))))

         

          * E1 - Total cell

          *      >500 = A+

              499 - 400 = A

              399 - 300 = B+

                < 300 = fail

What are the forms to be used for filing annual/quarterly TDS/TCS returns?

Form No	Particulars	Periodicity
Form 24	Annual return of "Salaries" under Section 206 of Income Tax Act, 1961	Annual
Form 26	Annual return of deduction of tax under section 206 of Income Tax Act, 1961 in respect of all payments other than "Salaries"	Annual
Form 27	Statement of deduction of tax from interest, dividend or any other sum payable to certain persons	Quarterly
Form 27E	Annual return of collection of tax under section 206C of Income Tax Act, 1961	Annual
Form 24Q	Quarterly statement for tax deducted at source from "Salaries"	Quarterly
Form 26Q	Quarterly statement of tax deducted at source in respect of all payments other than "Salaries"	Quarterly
Form 27Q	Quarterly statement of deduction of tax from interest, dividend or any other sum payable to non-residents	Quarterly
Form 27EQ	Quarterly statement of collection of tax at source

Income Tax Slab for Financial Year 2012-13

Income Tax Slab for Financial Year 2012-13
Assessment Year 2013-14
	Tax	Man	Women	Senior Citizen
	Rate	(In Rupees)	(In Rupees)	(In Rupees)
1	0.00%	Upto 2,00,000	Upto 2,00,000	Upto 2,50,000
2	10.00%	2,00,001 to 5,00,000	2,00,001 to 5,00,000	2,50,001 to 5,00,000
3	20.00%	5,00,001 to 10,00,000	5,00,001 to 10,00,000	5,00,001 to 10,00,000
4	30.00%	Above 10,00,000	Above 10,00,000	Above 10,00,000
Note :- 1) Surcharge is Nil and 3% Cess will be charged on Above Tax
2) Age of Senior Citizen is = 65 Years
3) Corporate Tax will be 30% and surcharge and cess will be Nil.
4) Befnefit of Rs. 1.50 Lakh for Interest on Housing Loan will be continued

Above Tax Slab will be applicable w.e.f. 01.04.2012

HISTORY OF TALLY :-

Tally 4 - 1988

Tally 4.5- 1993
Tally5.4 - 1998(with inventory)
Tally6.3-  2001
Tally7.2 - 2005(vat)
Tally8.1- 2006(Apr)
Tally9 -  2006(Dec)
Tally.ERP 9. - 2009