New Return Preparation Utility (RPU 1.3) with New File Validity Utility (FVU 4.8)

Some major changes have been done in TDS/TCS return utility and it’s FVU regarding addition or correction in Challans, Removal of nature of remittance in 27Q etc.  Therefore please go through the below details before submitting TDS Return of the 2nd Quarter of F.Y. 2015-16 and onwards.  This FVU is applicable w.e.f. 29-09-2015 Key Features … Read more

TDS Deduction Calculator from Monthly Salary

TDS Deduction Calculator from Monthly Salary in ExcelCalculates TDS to deduct monthly from Salary for the current year i.e. F.Y. 2015-16 from Employee declaration form. Provide also quick computation sheet to calculate tax liability.House Rent –  I am staying in a house and I agree to submit rent receipts when required. The Rent paid is … Read more

Simple Income Tax Formula for A.Y. 2016-17

Latest Simple Income Tax Formula for A.Y. 2016-17Latest Simple Income Tax Formula for Assessment Year 2016-17Latest Simple Income Tax Formula for F.Y. 2015-16Latest Simple Income Tax Formula for Financial Year 2015-16 New Simple Income Tax Formula for A.Y. 2016-17 in excel format freeNew Simple Income Tax Formula for Assessment Year 2016-17  in excel format freeNew … Read more

Master Tax Calculators in one Excel file free for F Y 2014-15

Preparation of Form 16 (Both Part A & )… The format of form no 16 is desigend accorting to Financial Year  2014-15 & onwards (As per Income Tax department instruction, the part A of form no 16 will be download from http://contents.tdscpc.gov.in/ It Excel sheet include  DDO DATA,  EMPLOYEE DATA,  STATEMENT, FORM NO 16,  GROSS SALARY,  … Read more

Income Tax Calculator for Individual, Company & Firm for AY 2016-17 in Excel free

Version 5 Income Tax Calculator – Individual, Company & Firm Following type Income Calculate Tax for Assesment Year 2016-17 & Financial Year 2015 -16 Also Its include 2015- 16 AY Tax calculator 1) Salary income 2) House property 3) PGBP Income 4) Capital gain:- :- U/s 111A :- U/s 112 and Normal capital gain 5) Other source income 6) Agriculture income … Read more

Depreciation Automatic Calculator as per Companies Act 2013

 Automatic  Depreciation Calculator as per Companies Act 2013Format Items Example: S.no Description Category Carrying value  if purchased before 1/4/2014 or purchase cost Date of purchase Salvage value(Upto 5% of cost If sold during the year(Mandatory) Date of Sale(Leave Empty if no Sale) Sale Price(Leave empty if no sale) Useful life Remaining Life. Retained earnings effect Depreciation … Read more

Excel complete all formulas with examples

Excel complete all formulas with examples (VERY USEFUL DONT MISS)ATOZ ALL FUNCTIONS / FORMULAS:SPLIT FORE NAME AND SUR NAMEPRECENTAGESHOW ALL FORMULASUM USING NAMESINSTANT CHATSBRACKET IN FORMULAAGE CALCULATIONAUTOSUM SHORTCUT KEYABSADDRESSANDAVERAGECEILINGCELLCHOOSECLEANCOMBINCONCATENATECONVERTCORRELCOUNTCOUNTACOUNTBLANKCOUNTIFDATEDATEDIFDATEVALUEDAYDAY360DELTAEASTEDATEEMONTHERROR.TYPEEVENEXACTFACTFINDFIXEDFLOORHLOOKUPHOURIFINDEXINDIRECTINFOINTISBLANKISERRISERRORISEVENISLOGICALISNAISNONTEXTISNUMBERISODDISREFISTEXT LARGELEFTLENLOOKUP (ARRY)LOOKUP (VECTOR)LOWERMATCHMAXMEDIANMIDMINMODMODEMONTHMROUNDNNANETWORKDAYSNORTHNOTNOWODDORPROPERQUARTILEQUOTIENTRANDRANKREPLACERIGHTROMANROUNDROUNDDOWNROUNDUPSECONDSIGNSMALLSOUTHSTDEVSTDEVPSUBSTITUTESUMSUM AS RUNNING TOTALSUMIFSUMPRODUCTITEXTTIMETIMEVALUETODAYTRANSPOSETRIMTRUNCUPPERVALUEVLOOKUPWEEKDAYWORKDAYYEAR SIMPLIFIED COLLECTION FROM SIMPLETAXINDIA.IN CLICK HERE TO DOWNLOAD ALL EXCEL FUNCTION IN EXCEL FILE