How to prepare MIS Report in Tally.ERP9?

Posted by Manal on October 7th, 2018

MIS stands for management information system. Business managers at all levels of an organization, from assistant managers to executives, rely on reports generated from these systems to assist them in evaluating the business day-to-day activities or assessing emerging problems, and following progress.

Below are some of the important point which are to be considered while creating MIS Reports:

• You need to know Microsoft Excel before creating any MIS report. Then create report template based on your requirements.
• Remember you should create MIS template in such way that it is easy to read for your upper management (Team Leader, Manager, MD etc.). So they can easily find the insight from report.
• Collect all the raw data which are required for report. May be you need to collect data from different departments such as Marketing, Sales, Customer service, Information technology etc. or from your different clients.
• Mining or clean up your raw data, i.e remove all the unnecessary data from the raw one.
• Always keep your raw data in separate sheet. So that it is easy to link to your report.
• Connect your data to your MIS template using the excel formula. Now your raw data converted into well-structured Report. This report will provide helpful information to your organization or to the People for whom you have created a report.
• Final and the most impotent step is to check your report whether numbers are following the trend or not, any #N/A, any #values etc.

For further details, contact our team of experts on 00966-583117703 or visit our website at http://manalpro.com/tally/mis-reporting/.