An MIS report format for a UAE company, page by page

In the UAE, "MIS" is the word most owners use, especially where the finance team trained in India or South Asia. The UK calls the same report management accounts and the US a monthly financial reporting package; the content is the same.

1. Summary. Revenue, gross profit percentage, net profit, cash and bank, receivables, and two lines on the month. Many owners read only this page on their phone, so make it complete on its own.
2. Profit and loss. The month, the year to date and the same month last year, in grouped lines: revenue by stream, cost of sales, gross profit, salaries, rent, other overheads, EBITDA, depreciation, finance costs, the corporate tax provision where it applies, net profit.
3. Balance sheet. Month end against the prior month end: fixed assets, inventory, receivables, cash and bank, payables, VAT payable or receivable, the end-of-service benefits provision, loans and equity.
4. Cash and bank. The balance in each account, the movement from opening to closing, and post-dated cheques due in the next 30 days if the business still uses them.
5. Receivables ageing. 0 to 30, 31 to 60, 61 to 90 and over 90 days, with the five customers owing most of what is overdue. In many UAE businesses this is the page that matters most.
6. KPIs. Gross margin, salaries as a share of revenue, debtor days, creditor days, the current ratio, and cash runway if the business is making a loss.
7. Commentary. The number, the comparison and the reason for each section, then what deserves attention this month.

Commentary:

Revenue was AED 1.24m, up AED 135,000 (12.2%) on August and AED 60,000 (5.1%) on September last year, mainly from the new hotel supply contract. Gross profit fell to 22.4% because the contract was priced below our usual margin. Cash fell AED 75,000 as debtor days rose from 61 to 68; three customers account for AED 410,000 of the over-90-days balance.

What deserves attention: chase the three customers over 90 days, and check the margin on the hotel contract before it renews.

• Currency and scale. Show AED in full figures or in thousands, and keep to one. If a parent reports in another currency, give it a page of its own; don't mix.
• The financial year. Many UAE companies run January to December, and some follow a parent's April to March year. The year to date must follow the company's own year.
• VAT. VAT payable or receivable belongs on the balance sheet as its own line, not inside other liabilities.
• Corporate tax. Where the company is within the corporate tax regime, show the provision as its own line so the owner sees profit after tax.
• End-of-service benefits. Show the provision's movement each month, or the year-end charge surprises the owner.
• Receivables discipline. Long credit terms are common; the ageing page earns its place every month.

The mistakes that recur: sending the trial balance and calling it an MIS; a different layout every month; no comparison with last year, so seasonality looks like performance; receivables as one total instead of aged buckets; and commentary that says "sales increased" without the size or the reason.

UAE businesses keep their books in Tally, Zoho Books, QuickBooks or an accountant's system. The starting point is the same: export the trial balance, place each ledger on a report line once, and build the pages from there.

Magic MIS does that build. Upload the trial balance export, set the company's conventions once (when its year starts, the currency the books are kept in, how its dates are written), and the MIS comes back as a checked Excel workbook, a dashboard and drafted commentary, in which the AI writes only the words: every figure in a sentence is filled in by the calculation engine from the ledgers, and a person reviews it before it goes anywhere. The MIS report format guide goes further, and the format above works in Excel just as well.