Building a Monthly MIS Report in Excel

Step 1: one summary sheet, pulled from existing work

Create a sheet called “MIS Summary” and pull one key figure from each area already built elsewhere in the workbook: total revenue and growth % from the ratio-analysis sheet, the top-line variance exception count from the variance report, total receivables 90+ days overdue from the ageing analysis, and a reorder-flagged product count from the inventory sheet. Each of these is a single formula or small linked table — this sheet doesn’t recalculate anything from scratch, it just assembles.

='Financial Analysis'!C5
=COUNTIF('Variance Report'!F:F,"Exception")
='Receivables Ageing'!D10

Cross-sheet references ('Sheet Name'!Cell) pull a value calculated elsewhere into the summary without recalculating it. This matters because it means updating any underlying sheet automatically flows through to the MIS summary — one set of source calculations, not duplicate logic living in multiple places.

Step 2: the part Excel can’t automate

Add a short narrative section — 3 to 5 bullet points, written by hand, summarizing what the numbers mean. This is deliberately not automatable. A manager wants to know “Marketing overspent 22% due to a one-time campaign,” not just a variance percentage sitting next to a number. Excel gets you the figures; judgment turns figures into insight, and that’s the part a pack is actually judged on.

Step 3: consistent formatting

Finish with consistent fonts and color conventions across every section pulled in. A pack assembled from four different source sheets, each with its own formatting habits, reads as sloppy even when every number is correct. Consistency is what makes the whole document read as one polished report rather than four pasted-together fragments.

A worked example

A monthly board pack built this way is one MIS Summary sheet, five key figures, and a short narrative, distributed to leadership — built from work already done across the workbook’s other sheets, not recreated from scratch every month.

Mistakes that undermine the pack

• —Recalculating logic in the summary sheet instead of referencing the existing working-sheet calculations — this creates duplicate, and eventually inconsistent, logic.
• —Skipping the written narrative, leaving the reader to interpret raw numbers unaided.
• —Breaking cross-sheet references by renaming a source sheet after the summary is built. Excel usually updates references automatically on rename — verify it did before distributing the pack.