MIS for manufacturing and trading companies in the UAE and the Gulf

Every month: net sales, gross margin, inventory days, debtor days, creditor days, the cash conversion cycle, staff costs, EBITDA and cash, with interest cover one request away in the KPI library. Debtor days with post-dated cheques, and the split between local and export sales, take the cheque and sales ledgers, which sit one click behind receivables and sales.

• Post-dated cheques received are not cash. Keep them as a receivable of their own until they clear.
• Post-dated cheques issued are still owed; keep them with payables until they clear.
• Letter of credit margin deposits are restricted cash, apart from the current account.
• End of service benefits. The provision is a liability and the monthly charge a staff cost; visa, labour and accommodation costs are staff costs too.
• VAT at 5% in the UAE: output and input VAT net to one balance payable or receivable, never inside sales or purchases.
• The owner's current account, common in family businesses, is equity unless it is a formal loan.

From the company's trial balance over the six months to June 2026, in dirhams, worked by hand:

The days are worked on the last three months, as the board works them. The gap between debtor days with cheques and creditor days is trade the business funds itself, partly through trust receipt loans.

In Magic MIS, the same books loaded a month at a time give this board for June 2026:

Enlarge:

Al Noor Trading & Industries LLC's board for June 2026, from six months of its books. Example company; figures invented.Close

Magic MIS wrote these sections of the commentary for June 2026, word for word. The AI wrote the sentences; the engine filled every figure, and each one opens to its ledgers on the board:

Performance

Revenue from operations for Jun 2026 was AED 2,023,831.60, a change of AED 6,495.19 (0.3%) on last month, so revenue was broadly flat.

Direct costs were AED 1,434,167.08, up AED 73,463.51 (5.4%) on last month. EBITDA was AED 127,321.68, a change of AED (78,132.84) (-38.0%). Profit before tax was AED 52,119.65, a change of AED (78,758.11) (-60.2%). Profit after tax was AED 52,119.65, equal to profit before tax, with the same change on last month of AED (78,758.11) (-60.2%).

Margins

Gross profit was AED 589,664.52, a change of AED (66,968.32) (-10.2%) on last month. With revenue broadly flat and direct costs higher, the gross margin narrowed compared with last month.

The fall in gross profit carried through to EBITDA and profit before tax, which declined by similar absolute amounts, indicating that overheads were little changed from last month.

Enlarge:

The commentary for June 2026 in the product. Example company; figures invented.Close

1. Export the trial balance from Tally, Zoho Books or your ERP as Excel, CSV or PDF. There is no live connection.
2. Upload it. Each ledger is placed once on a line of the report, by rules first and the AI only for what the rules can't place; check the post-dated cheques, letter of credit margins and end of service on the ledger map.
3. Get a checked Excel workbook with live formulas, a board you change by chatting, and the month written up.
4. Next month, upload the new trial balance: the placing is remembered, so it is a refresh, not a rebuild.

Click any figure on the board to see its working, the month and the ledgers behind it. It is prepaid credits with no subscription, and every action shows its price before it runs; see the credit packs.

Set the company's conventions once: when its financial year starts, books kept in AED, dates day first. Present shows the board full screen with the company's own logo.