MIS Reports – Best MIS Reports In Finsys ERP – For Management Meetings

Suggested MIS Reports for Daily Circulation

Daily MIS Reports – That you must see in Finsys ERP

Applicable for Following Industries : Plastic Moulding, Rubber Moulding, Steel Forging, Steel Casting, Non Ferrous Castings, Machinery Manufacture… almost all companies… except the Packaging… ( why they are excluded… ?  Since we have a specialised more detailed page for them = Click here ).

Need

In today’s world, creating Systems and Following Systems is becoming more and more important. As a part of the initiative to make our Finsys Patrons even more Systematic, we present to you our SoP ( Standard Operating Procedure ) for the Reports that must be circulated in a Standard Finsys ERP Implemented company.

 

Some of our clients have done this and are happy with the results. Hence sharing the same with you.

 

Notes :
  • If you are already using these, then great. If you are not, please start, our Finsys team members will love to train your people on these.
  • These may be started either all in 1 go, or step by step.
  • You may add some more daily Reports from the Finsys ERP, as per your convenience.

Daily reports

MD / CEO / Plant head must see the following 4 reports Every day

  1. Executive summary of all SO, PO, MRR and Invoices for the day – Yesterday
  2. Pending Sales order Register – YTD
  3. Pending Purchase Order Register – YTD
  4. Snapshot Report of Collection and Payments – Week-to-date

( Note :  YTD means Year to date… takes from 1-4-2019 upto date, and MTD means, Month to date, so, if you are on 14th May 2019, then MTD means 1-5-2019 to 14-5-2019  ).

5. Every MD must see his Sales for the day/MTD  / YTD on his mobile. There are three facilities, via IOS App, Android App, and Browser App ( m.finsys.in).

6. Must see the Material coming in, Collections happening and Payments happening, LIVE… on again the same 3 App’s available to you as a part of the Offerings.

7. You already must be doing the Approvals of the PO / SO / Job Cards / Indents… LIVE on your Mobile… if yes, Good, also see the Rate history before you press OK.   if NOT, then you are surely missing a big deal…. You dont even know what you have missed till now.

8. See the Items whose sale is dropping off, without you realising that.

And see the customers whose sale value is tapering off in lat 6 months… you realised that ? See the Trend reports available in the ERP.

Important Tip : Dont wait for the ERP to be 100% Live. It is already LIVE. Don’t for 3000 reports to be 100% correct. Start using those that are working, right now, anyway… start using it . Be a part of the Process,

Weekly reports

EVERY MONDAY

  1. Stock Report – Raw Material and BoP – FIFO stock value report – 4 colm report – item level(8 digit).. example : for 00 to 20 Group codes
  2. All RM / BOP Items below Minimum level
  3. All RM / BOP Items below Reorder level
  4. All RM / BOP items above Maximum level

 

EVERY TUESDAY

  1. Stock Report – Consumables , and Repair items – FIFO stock value report – 4 colm report – item level(8 digit).. example : for 21 to 49 and 60 to 68 Group codes
  2. All Consumables , and Repair Items below Minimum level
  3. All Consumables , and Repair Items below Reorder level
  4. All Consumables , and Repair items above Maximum level

 

Benefits of These Stores Reports

  1. Control of the situation
  2. Know who is entering data and who is not
  3. Know stock position LIVE ( almost live)
  4. All people are automatically understand the importance of entering the data live / almost live, since MD will see daily. And MD will rely on them.
  5. Issue entries are missed in some companies for some groups… will be done, since seen. ( Example Spare Parts and Consumables )
  6. Stock out position happens in repair items / many items. Since people do not remember to buy in time. This will be prevented if the Minimum levels and Reorder Levels are set + Reports daily monitored

 

 

EVERY WEDNESDAY :  Finance

  1. Debtors Outstanding Report – any 1 out of over 10 formats available – as of end of last week
  2. Creditors outstanding Report – any 1 out of over 10 formats available
  3. Staff Advance Account Trial Balance and Ledger email to MD
  4. Imprest Account Trial Balance and Ledger email to MD
  5. Debtors with Credit Balance ( Advances received ) – YTD date selection
  6. Creditors with Debit Balance ( Advances received ) – YTD date selection
  7. Non-moving Accounts
  8. Cash Flow of this month ( Cash only )
  9. Funds Flow of this month ( Cash+All Banks) ( All Sources)

 

EVERY THURSDAY :  Sales

  1. Customer wise Sales Report = any 1 format
  2. Finished Product wise Sales Report = any 1 format
  3. Sale order vs Actual Report = any 1 format
  4. FG stock in hand report with value – preferably 4 colm ( Year start to date )

 

EVERY FRIDAY :  Purchase

  1. Pending Purchase Requisitions ( Indents ) == PR made, and not approved
  2. Pending Purchase Requisitions ( Indents ) == PR approved and Po not made
  3. Pending Purchase Order == PO made, and not approved
  4. Pending Purchase Order == PO approved but material not received – any 1 format
  5. Purchase Schedule vs Actual Report – any 1 format
  6. Vendor Ratings
  7. Purchase Estimate for ROL(Reorder level) / MSL( Minimum stock level) items
  8. Delivery Date based report = Committed delivery date in PO vs actual date ( XLS report)
  9. Any 1 Rate Comparison Report
  10. Shipments received late ( after 5 pm) … if your stores works in main shift only.. people who make your stores people stay back late, lead to risk in Qnty check /Quality check.

 

EVERY SATURDAY : Production

This area is as per your ERP configuration.

This list may be modified as relevant to you

Please see which one can be used in your company

 

 

Please feel free to revert for any further details/ clarifications required.

Assuring of our best services, the Finsys Infotech Limited Parivaar

p.s.  ( post Script )

We request that Software Changes may not be asked for in the formats. It will shift the focus from the intended purpose to Kaizen. Kindly enjoy the benefits as such.  For specific Customisation Requests, please feel free to contact our marketing team / Customer Relations Team.