Monthly management pack: a UAE trading company, September
The month closed and explained within five working days: profit, cash, who owes you, VAT and the actions that matter.
AED 4.8mRevenue
24.9%Gross margin
AED 0.4mNet profit
AED 4.1mReceivables
AED 65,060VAT payable for the month
Profit and loss
| September | |
|---|---|
| Revenue | AED 4,850,000 |
| Cost of sales | AED -3,640,000 |
| Gross profit | AED 1,210,000 (24.9%) |
| Salaries and benefits | AED -412,000 |
| Rent and utilities | AED -96,000 |
| Logistics and warehousing | AED -138,000 |
| Marketing | AED -41,000 |
| Other admin | AED -57,000 |
| Operating profit | AED 466,000 |
| Depreciation | AED -22,000 |
| Finance cost | AED -18,000 |
| Net profit | AED 426,000 (8.8%) |
Receivables ageing
| Bucket | Amount | Share |
|---|---|---|
| Current | AED 2,310,000 | 56% |
| 1–30 days | AED 1,140,000 | 28% |
| 31–60 days | AED 420,000 | 10% |
| 61–90 days | AED 160,000 | 4% |
| 90+ days | AED 95,000 | 2% |
| Total | AED 4,125,000 | 100% |
VAT
| Amount | |
|---|---|
| Output VAT (5% on sales) | AED 242,500 |
| Input VAT recoverable | AED -177,440 |
| Net VAT payable | AED 65,060 |
Actions for management
- Collect the 90+ day balance (AED 95,000): two customers, both on hold for new orders
- Gross margin 24.9% vs 26% target: freight costs up on two lanes; re-quote forwarders
- File the VAT return and pay AED 65,060 by the 28th
- All sales invoices issued in the UAE e-invoicing format and reconciled to the bank
Included every month
- Bank and card reconciliations, supplier statements matched
- Accruals, prepayments, stock valuation and landed cost
- VAT return prepared; e-invoicing exceptions cleared
- Pack in your Mizo account, with drill-down to every entry
Want this for your own project?
Tell us about it and the Accounting team will prepare yours.
Illustrative sample for a fictional project. Figures are indicative only and are not an offer, valuation or professional advice. Your own study uses your plot, your market data and current rates, confirmed by Mizo's team.