Utilities
Easy MIS report format of performance for small business.
MIS report format of performance for small business: Management information system reporting or MIS reporting is a set of data compiled and presented to management. This information is helpful in analyzing the business situation. This will also help in decision making for different level of management. This MIS report format will help for small business … Read more
Simple project management dashboard in excel
Simple project management dashboard in excel: Project is a unique non routine task, the completion of which requires many sequence of activities. To complete any project successfully proper planning, execution, reviewing monitoring is very essential. The list of activities to complete the project is to be identified and the time required to complete each activity is … Read more
FD calculator for monthly interest recognision
When an organisation keeps money in many fixed deposit, the interest should be recognized on periodic basis. Usually it is calculated on monthly, quarterly, half yearly or yearly basis. When there are many fixed deposit, it is difficult to calculate accrued interest for a period. This fd calculator Excel sheet is prepared to calculate the monthly interest accrued … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
Billing and debtors management utility for CA’s
The new latest version of Invoice preparation 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 … Read more