Income tax assessee profiles and assessment status in excel

In this excel utility Income tax profiles of the assessee's and the assessment status of 3 years can be maintained. Key features:·Assessee's profile details like Name, Address, Mobile No., E-Mail can be stored.·Details for last 3 assessment year can be maintained ( AY 2014-15, AY 2013-14, AY 2012-13)·Link the related file and open by one click.·Open the websites with auto fill of assesse detailsTo create a profile, you have to enter the PAN in the list sheet and double click…

Continue Reading

Password Manager for user details.

In this excel workbook, you can manage the username and password details for website.Enable macros to use this workbook.Click on the User list button to update the login details. First time when you click on User List, it will ask you to create the password.User Name and password will be secured and each time it will ask password to view and update the user list.Date of birth for login, password to open ITR V and Password to open 26AS…

Continue Reading

ITR 1 in excel for AY 2014-15 with auto fill function.

This excel utility is prepared for Preparation of Income Tax Return ITR 1 for the Assessment Year 2014-15. Enable Macros to use this utility. Use TAB to update the details in MAIN sheet. This can be used for offline filing (Physical submission of Printed forms) return ITR 1 to the department. The details required like Name, Address, Income, Deduction and Tax payment details can be updated in the Main Sheet. This information will be automatically updated in the form ITR…

Continue Reading

Process Payroll in Excel

Processing Payroll in excel with tax computation, Monthly Salary statement, Pay slip etc. Process up to 10 employees salary. LATEST VERSION OF PAYROLL SOFTWARE IN EXCEL FOR FREE  1    Update Employee master with employee details.       In employee master select status "EXISTING" Or "LEFT"       if you select the status "LEFT" the salary will not be processed for that employee       If a employee leaves , you need not delete the record, just change the status to "LEFT"       2   …

Continue Reading

How to make auto fill forms in excel using linked pictures

Auto fill forms can be prepared in excel using linked picture option easily. If we prepare format of any form in excel, it will take lot of time and if it contains picture, logo and colours, it is difficult to align and set for print. To avoid this we can scan and insert the blank form in picture format and insert the linked pictures of the field to update the form.In the given example the application for digital signature is…

Continue Reading

Currency count for salary disbursement with special requirement

When the cash salary is to be disbursed to many employees, the currency of different denominations are required to make the payment. Some times currency notes of few denominations may not be available. Before making the payment the payer should be ready with the cash of required denominations. The Currency count for salary disbursement excel sheet will help to do this. Currency count for salary disbursement excel sheet is prepared to calculate the currency notes of different denominations required for paying…

Continue Reading

Billing and debtors management utility for CA’s

New latest version of Invoice preperation utility in Excel July 31st is the last date for filing the Income tax return, when I requested my CA friend to file my tax return, in turn I received a request from him prepare a worksheet to prepare and maintain his billings. Based on his request I prepared the worksheet and I am sharing the same with you with brief note on how to use this.This is a simple and free to use utility, you…

Continue Reading
Close Menu