Struggling with MIS Reports for Purchase? How Do You Track Pending Orders and Costs?

Please help me with the MIS report for the Purchase Department. How can I find pending orders, balance material, costing of materials, etc.? If there is an Excel format available, please send it to me.

You could have given a little more information about yourself. What is your designation? What is the volume of procurement spend in your company? How many POs are issued per month? If not many POs are issued per month, tracking the POs on Excel should not be a problem. You can reconcile POs with the Goods Receipt Note (GRN) from the store. If getting the GRN takes longer, then you may start reconciliation with security itself.

When you say the "costing of the material," do you mean to track the stock value per day? For this, you may download relevant software on inventory management from the following website: https://download.cnet.com.

Alternatively, do you mean to say that you wanted to know how to do costing while procuring the material from the vendor? This is a very deep subject. For this, you need to take formal training.

I conduct training in the field of Purchase and Inventory Management. To know more about my training activities, you may visit <link outdated-removed>.

Thanks,

Dinesh Divekar