Category: Utilities

Accounts receivable ageing report in excel

Ageing Statement analysis is a key control for any business. The ageing analysis can be for accounts receivable, accounts payable, advance received, advance paid, inventory etc. Any delay in settling the transaction may have some adverse impact on business. Therefore, the ageing analysis will help in finding such delay in settling the transaction and early

Central Excise Invoice in excel – Excel Utility

DOWNLOAD  GST invoice preparation utility in excel The Manufacturer of excisable goods, who charge excise duty has to prepare invoice as per rule 11 of central excise rule 2002. This excel template is prepare to generate the invoice under central excise rule. The invoice can be prepared, saved and printed as per the requirement of

PAN application form in excel with Database facility.

Updated on : 26th March 2017. This utility is prepared to generate the form No. 49A PAN application form in excel. Details for PAN application can be updated, saved and printed in this utility. Permanent Account Number (PAN) is a unique identification number allotted by the Department of income tax to the Assessee. Application is

Invoice preperation utility in Excel

DOWNLOAD  GST invoice preparation utility in excel Preparing invoice, maintaining the record and keeping the track of receivable may be time consuming and difficult task. This invoice template in excel is prepared to make this easy for the service providers. Service providers can prepare invoice and also charge service tax in the invoice. Following are

Excise Invoice Preparation utility in excel

DOWNLOAD  GST invoice preparation utility in excel The central excise invoice format in excel is developed to prepare central excise invoice as per the provisions of central excise rule. you can prepare invoice, edit that if you want to and print the invoice. Update the company master data in the Home sheet, this information will

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

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

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

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