MIS (Management Information System)
MIS (Management information system) includes reporting of monthly expenses, Cash flow statement, Finished goods report, Debtors ageing, Creditors ageing and Bank reconciliation statement etc.
Above data is required for decision making. Management will get to know overall financial performance and working capital requirement by the above MIS report.
Even the above MIS report can be used in preparation of cost sheet by knowing fixed and variable expenses at par. So that management can know the break-even point on regular basis.
Following are some useful formats
Cash Flow Statement for the month of XXXX
| |
Particulars
| |
CASH INFLOWS
|
Amount (Rs)
|
Opening Balance
|
-
|
Collection from Parties
|
-
|
Collection From Branch
| |
Received from HO
|
-
|
Other Recovery \ Adjustment
|
-
|
Total
| |
CASH OUTFLOWS
| |
Salary, Wages and other Allowances
|
-
|
Electricity Charges
|
-
|
Communication Exp
|
-
|
Statutory Liabilities
|
-
|
Sundry Creditors
|
-
|
Sundry Debtors
|
-
|
Expenses Advance
|
-
|
Advances Against Salary \ Wages
|
-
|
Loan to workers \ Staff
|
-
|
Secured Loans
|
-
|
Head Office
|
-
|
Branch \ Division
|
-
|
Financial Charges
|
-
|
Cash Expenses ( Routine)
|
-
|
Closing Balance
|
-
|
Total
| |
Breakup for Closing Balance
| |
Cash in hand
|
-
|
Cash at Bank (BRS enclosed)
|
-
|
Total
|
-
|
Profit & Loss A/C or Expenses Statement
Profit & Loss a/c for the month of April
| ||
Particulars
|
Actual
| |
May'08
| ||
Sales :
|
0
| |
Finished Goods - CST Sales
|
0
| |
Sampling Charges & others
|
0
| |
Less :
|
Sales Return
|
0
|
Finished Goods - CST Sales
|
0
| |
Job Work- CST
|
0
| |
Job Work- TNGST
|
0
| |
Inter Stock Transfer - FG
|
0
| |
Job Work- Mending
|
0
| |
Sampling Charges
|
0
| |
Net Sales
|
0
| |
Increase / (Decrease) in Stock
|
0
| |
Opening Stock
|
0
| |
Finished goods
|
0
| |
Semi Finished Goods
|
0
| |
Work- In - Process
|
0
| |
Closing Stock
|
0
| |
Finished goods
|
0
| |
Semi Finished Goods
|
0
| |
Work- In - Process
|
0
| |
Raw Material Consumption
|
0
| |
Yarn
|
0
| |
Fabric
|
0
| |
Others (incl. Trading of Goods)
|
0
| |
Job Work & Proc. Charges Exps
|
0
| |
Gross Profit
|
0
| |
Less:
|
Manufacturing Expenses
|
#REF!
|
Labour Charges
|
0
| |
On Rolls
|
0
| |
Welfare Expenses
|
0
| |
ESI & P.F
|
0
| |
Provision for Bonus etc.
|
0
| |
Power & Fuel
|
0
| |
Stores & Spares
|
0
| |
Repair & Maintenanace
|
0
| |
Machines
|
0
| |
Building
|
0
| |
Electrical
|
0
| |
Others
|
0
| |
Personnel Expenses
|
0
| |
Salaries
|
0
| |
Bonus, Gratuity etc.
|
0
| |
ESI & P.F and Dues
|
0
| |
Staff Welfare
|
0
| |
Administrative Exp.
|
0
| |
Insurance Exp.
|
0
| |
Travelling & Conveyance Exp.
|
0
| |
Boarding & Lodging Expenses
|
0
| |
Security Charges
|
0
| |
Legal & Professional Fees
|
0
| |
Printing & Stationary
|
0
| |
Communication Exp.
|
0
| |
Financial Charges
|
0
| |
Rent,Rates & Taxes
|
0
| |
Rent to Employees
|
0
| |
Internal Audit Fees / (Provision reversed)
|
0
| |
Festival Exps/ Puja
|
0
| |
General Exp - ( including other Admn Exp)
|
0
| |
Vehical Running Exp.
|
0
| |
Provision written back
|
0
| |
Interest SIDBI
|
0
| |
Selling Expenses
|
0
| |
Freight & Cartage
|
0
| |
Packing Material
|
0
| |
Repair & Maintenance , Fuel -Tempo
|
0
| |
Turnover Discounts & Commission
|
0
| |
Advertisement Expenses/knit Show
|
0
| |
Allocated Expenses-HO
|
0
| |
Profit / (Loss) before Interest & Dep.
|
0
| |
Interest on fixed assets & W.C. (HO)
|
0
| |
Profit/ (Loss)After Interest but before Depreciation
|
0
| |
Depreciation
|
0
| |
Net Profit / (Loss)
|
0
|
PLEASE FORWARD TO MAIL
ReplyDeletethanks for helpful post. A management information system is a computerized system and database of financial data or information, which organized, structured and programmed in such way, that it can produce report in every level of management in a company. MIS actually shows the comparison between the targeted result and real scenario of the organization. And also focus the variables, related to the performance.for more info: http://pridesys.com
ReplyDeleteSIR I NEED IN EXCEL FORMET
ReplyDeleteI really appreciate your hard work you put into your blog and detailed information you provide. Further More Information About MIS training institute in Delhi Contact Here-+91-9311002620 Or Visit Website- https://www.htsindia.com/Courses/business-analytics/mis-training-instiute-in-delhi
ReplyDeletemuch obliged for accommodating post. An administration data framework is a mechanized framework and data set of monetary information or data. We updated all the trending new information related to any topics.
ReplyDeleteTo be more updated about all the news around you, you can check this website
www royal enfield classic 350
Your post is really good thanks for sharing these kind of post but if anyone looking for Best Consulting Firm for Fake Experience Certificate Providers in Delhi, India with Complete Documents So Dreamsoft Consultancy is the Best Place.Further Details Here- 9599119376 or Visit Website- https://experiencecertificates.com/experience-certificate-provider-in-delhi.html
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteThe article you have shared here is very informative and the points you have mentioned are very helpful. Thank you so much. Ethnic advertising agency in UK
ReplyDeleteYou have a genuine capacity to compose a substance that is useful for us. You have shared an amazing post about Merchant Cash Advance Help thanks for sharing this information with us.
ReplyDeleteI am pleased that this article provided me with some important information. Thank you so much for sharing it. Keep up the good work. advance funding partners
ReplyDeleteExcellent blog, thanks for sharing this article. Best erp software for manufacturing company. We are customized software providers.
ReplyDelete