In this video, you will learn how to convert Excel sheet in PDF using VBA code. I have link a Salary slip format with row data of payroll employee and made it dynamic once serial number change in row number A1.
Copy and paste below code in your Excel VBA place and save your time and money.
Sub Create_PDF() Dim Foldername, Filename, PDFPath, SR Foldername = “C:\Users\USERNAME\Desktop\FOLDERNAME” ‘ Change it For SR = 1 To 2 Sheets(“Pay Slip”).Range(“A1”).Value = SR Filename = Sheets(“Pay Slip”).Range(“H7”).Value PDFPath = Foldername & “\” & Filename & “.pdf” Sheets(“PayRegister”).Visible = False ActiveWorkbook.ExportAsFixedFormat xlTypePDF, PDFPath, xlQualityStandard, False Sheets(“PayRegister”).Visible = True Next SR MsgBox “Successfully Saved” End Sub
Make sure that a functional email id and mobile number to authenticate the profile.
Then need to quote the Adhaar number in the form and verify the Adhaar details as well.
Select the form applicable in your case. For most individuals, it is ITR 1- SAHAJ.
SAHAJ is for individuals having income from salaries, one-house property, and income from other sources such as dividends, interest income, income from winnings, etc.
Part-B (Gross total income)
Details of Employer like TAN , Name, Nature& Address of Employer
Salary details
All the allowances which are exempted
All the value of perquisites
Net salary
Deduction in u/s 16
Income chargeable under the head ‘salaries’
Gross Rent received
Tax paid to local authorities
Annual value
30% of the annual value
Interest payable on borrowed capital
Arrears/unrealized rent less than 30%
Deduction u/s 57(iia)
Sum of the entire amount will come under Gross Total Income
Part C – Deductions u/c VI-A and Taxable total income
Here the deduction limit will be as per income tax act
Total income (Gross Total Income – Deductions U/c VI-A )
Part D – Computation of tax payable (Valuation of Tax Payable)
D1 Tax payable on total income
D2 Rebate u/s 87A
D3 Tax after rebate
D4 Cess on D3
D5 Total tax and cess
D6 Relief u/s 89(1)
D7 Interest u/s 234A
D8 Interest u/s 234B
D9 Interest u/s 234C
D10 Fee u/s 234F
D11 Total tax, fee, and interest
D12 Total tax paid
D13 Amount payable
D14 Refund
Exempt income
Part E – Other Information (banking details)
IFSC Code of the bank
Name of the bank
Account Number
Final Step
The return that which is filed will not be treated valid unless it is verified
The taxpayer has to verify and self-attest the form at the last by signing the verification content after entering all the details such as name, parent name and PAN details
For physical verification of the return, print the acknowledgment of ITR-V, sign it in blue ink, and send it to the Centralized Processing Centre (Bangalore) within 120 days of filing your return.
Important Terms to Understand In ITR-1 SAHAJ Form for AY 2020-21
Revised Return: There is an option of re-file, so if you have made certain mistakes, you can rectify them again. For the FY 2019-20 the taxpayer can furnish the revised return on or before 31 March 2021.
Advance Tax: If the tax on other income is above Rs. 10,000 in a year, the assesse is required to calculate and deposit the advance tax. This advance tax is to be paid on a quarterly basis such as on, June, December, September and March.
Annexure-less Return: Annexure-less return which means it doesn’t require to affix any documents with the ITR-1 Form.
Download Income Tax Calculator in Excel for FY 2020-21 [AY 2021-22] Comparison Old and New Regime.
Excel Tax calculator ready To help taxpayers here is a simple excel based Income Tax Calculator for the financial year 2020–21 (AY 2021-22). The calculator is made using simple excel formulas and functions.
Download free automatic salary and CTC breakup calculator in Excel.
CTC (cost to company) of an employee OR for all employee’s in a organization is always difficult task. As you know, CTC mean salary breakup should be as India laws.
I have create a VBA based Excel sheet to calculate CTC cost to company salary breakup automatic as per all rules.
What’re Features in this Sheet?
You can calculate CTC breakup one by one individually meanwhile you can calculate all employee ( up to 5000) breakup in 1 Click.
Reset option for reset all sheet as blank.
Employee Type and State name selection required for calculating.
This sheet will be calculate Basic, HRA and Special Allowance as per Minimum wages Act as applicable Indian States.
User can update minimum wages in Second attached sheet even ever required.
Basic Salary and other calculations based on excel formulas which can be changed if required.
Bonus will be calculate 20% as per Bonus Payment Act 1965.
Gratuity will be calculate as per Gratuity Payment Act 1972.
User can change HRA % 50 to 40% in case required.
User can rename the other allowances head name if required.