Monthly Financial MIS Report format for Plastic Pipe and Water Tank Manufacturing Company?

sam-timilsina
Can anyone please provide me with the monthly Financial MIS Report format for a Plastic Pipe and Water Tank Manufacturing Company? I am the Accounts and Finance Manager for the company.
audnis
There is no separate topic to talk about for a FINANCIAL ACCOUNTANT as every bit of information is gauged in monetary terms.

1. First, Raw Materials - Major Raw Materials. Stock at the start of the month, Purchases during the month in Quantity and Value, Consumption during the Month, and Stock in Hand with Value, with a last column indicating the minimum stock holding limit in quantity for a period. This allows for a comparison between the stock on hand and the Minimum Stock Should be available. THIS GIVES THE MANAGEMENT INSIGHT INTO PLACING ORDERS AND THE ORDERS ALREADY PLACED OR STANDARD ORDERS PLACED FOR DELIVERY EVERY MONTH.

2. Sales Report, Sales of items sold during the month with a comparison against the previous month and the same sales during the previous year. = HIGHLIGHT DIFFERENCES +/- WITH REASONS.

3. Collection Report. Money received during the month, from previous outstanding balances, current sales, full payments, and outstanding payments.

4. Collection Outstanding Statement - Month-wise and Outstanding with Debtors more than 90 days and beyond, for the management to take action.

5. Suppliers' Payment Outstanding: with due dates for settlement.

6. List of Bank Guarantees issued and their due dates, purpose, and actions for cancellation or renewal.

7. List of Letters of Credit issued.

8. List of Bank Dues - Loan interest, Loans with EMI.

9. List of Machinery and actions for service due and renewal of Annual Maintenance Contract.

10. Staff List and individuals placed in each department, their performance, and any discussion points such as leave and others.

11. Then comes the government dues like TDS and other remittances, and the company's cash liquidity availability in the bank.

12. An Accountant constantly reviews various aspects on a day-to-day basis, and everything gets incorporated into his Management Information Reports.

13. Normally, a standard Quick Balance sheet is prepared: Assets - less Liabilities = Owners' Equity. It is a direct calculation, not involving all writing off, on a yearly basis. It is reviewed every week or fortnightly to determine the Net worth in Quick terms.

14. Collection is the statutory aspect of running an industry. Therefore, finance is of utmost importance to keep the industry operational.
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute