Category: Excel VBA Dashboard

Categories
Excel Formulas & VBA Code Excel VBA Dashboard India Payroll Payroll

Merge Part A and Part B of Form 16 in Excel

Greetings!

I believe, You are searching a free tool which can merge or combine Part A and Part B in 1 PDF in automation process. if yes, you are at right place.

As per Income tax India Form 16 TDS Certificate Part A should be download and convert from Trace website (tdscpc.gov.in) and Employer have to prepare Part B of Form 16. Both Should be Merged in One PDF for digital signature process.

Every Employee or professionals are looking a tools which can help in this process. Three are many software available in market / google search to do the same but they are paid.

But, trust me you can Merge any two more pdfs in 1 pdf in excel sheet without any wasting money in very simple way and fast.

I have developed a Excel sheet which can use N numbers of times and you can merge 2 different folders PDF files in 1 PDF as per your customization.

You can download this sheet from www.99Excel.Com and watch the below video to learn tutorial.

Direct Link to download sheet:
http://99excel.com/download/index.html

Thanks,

Kumar Ajit

Categories
Excel VBA Dashboard India Payroll

Income Tax Calculator 2019-20 AY 2020-21 in Excel – Easily

Click here to download income tax calculator in excel slab wise. This sheet have the excel formulas to along with marginal tax relief as per FY 2019-20.

@iptmnoida #iptmindia #excelformulas

Categories
80C Deductions 80DDB Excel VBA Dashboard Gratuity House Rent Allowance (HRA) Human Resource (HR) India Payroll Payroll Provident Fund (PF)

Income tax calculation sheet for the financial year 2019-20 [AY 2020-21] Automated Salary Tax Calculator along 15+ other Features

Click here to download automatic Complete Payroll Calculator in Excel. This Excel Software have includes most likely all part of Payroll Calculation. It’s Includes following Feature:-

  • You can calculate Cost to company CTC Automatic once you put total ctc.
  • You can restructuring of allowances and CTC components as per your need.
  • Income Tax  to be calculate automatic.
  • You can set your investment Declaration / Proofs Planing as per requirement.
  • This sheet will calculate House rent allowance ( HRA Rent Exemption calculation) under section 10(13A) automatic as per your rent paid and selected location.
  • You can customize your structure like add / less : PF (Employees’ Provident Fund), Employment State Insurance ( ESIC), Gratuity, Mediclaim, any other benefit, Bonus, Minwages.
  • You can control to deduct PF on Basic OR PF on Allowances or PF on min wages of PF or you can select No if you are not eligible for pf deduction.
  • You can Se-off loss / income from house property u/s 24(b) as per Income Tax Act.
  • You can add reimbursement components as per bills planing to get more benefit in tax.
  • This sheet will give you Net payment Automatically as per your change.
  • Best part of this software is that, you can generate  your salary pay slip from CTC in one click and change payslip in excel as per needs.
  • We have added logo on slip so that you can change it.
  • You can generate any month salary slip from excel format in one click even you can generate full and final slip.
  • Free download
  • Paid Support Available at :
  • Email: ajityadav121@gmail.com
  • Call/WhatsApp: +91 9654421288

Click here to Download Automated Excel Sheet to calculate cost to company (CTC), Income Tax Calculation for financial year 2019-20 along with all investment planning (Deduction U/C VI-A)  and all Major Exemptions allowed + reimbursement  in Salary.

This sheet will allowed to planning your tax saving, make salary structure as per your choice and know the Net in hand Automatically.

Thanks!

Categories
Excel VBA Dashboard

All Time best dashboard in Excel

Buy All Time Best Excel-VBA Dashboards from http://99excel.com/download/index.html

Download free amazing and ready to use dashboards! Free download dashboards ,
All Time Best Excel-VBA Dashboards :-

Excel Sheet Password Breaker,
Export Email from Outlook to Excel,
Get Comments to in cell text and text to comments in excel,
Move any type files in any folder as per excel data,
Save a sheet back-up automatic when you want,
Export Excel data in to HTML,
Convert any date or Time Zone to another Timezone,
Send mails from excel through outlook with separate or common attachment (s),
Bulk Email Validation In Vba Excel,
PDF Merger – Merge unlimited PDFs in one pdf file automatic,
Net in-hand automatic salary calculator in excel,
Merge excel files data in one sheet from multiple files automatic,
Set password in PDF files as per excel database separately with master password,
Rename or get all list of files from a folder and change the name as per sheet data automatic,
Excel formula to Get Numeric From alphabet Cells,
Payroll and CTC calculation as per Indian rules with all features along with payslip automatic,
Separate data from sheet in separate sheets or files,
Convertor for jpg,png data in excel or PDF,
Images file convert in PDF file,
Attendance system in Excel for local drive for unlimited users,
Language converter – translate any language excel data in English by formula,
Protect or Unprotect All Files In A Folder automatic as per sheet data,
Create PDF from word using mail merge from excel automatic,
VBA Project Password Breaker,
Export HTML data in to Excel,
Generate unlimited website pages automatic from excel