Finance
What you have, what is owed either way, and what gets sent out.
In the bank
1,186,000 EGP
1,288,900 EGP counting the drawers and the card machine
Came in this month
2,143,178 EGP
2,200,568 EGP billed, less what has not been collected or settled
Went out this month
1,587,262 EGP
consumables, the practitioners, wages, rent and everything else
Left over this month
555,916 EGP
came in less went out — the same figure the bridge below lands on
Customers owe you
135,700 EGP
14 unpaid invoices · the oldest is 38 days old
Late paying you
56,700 EGP
2 invoices past 30 days — the chaser has stopped on them
You owe suppliers
182,702 EGP
65,162 EGP of it has to be paid this week
VAT to pay
153,360 EGP
due on the 10th · 0 exceptions to fix
Finance agent
Owns the moneyAsk it anything about your numbers.
Finance automations
5 of 5 runningInvoice Generator
Makes the invoice the moment the work is done or the order leaves.
595
runs this month
57% of the department's runs
Payment Chaser
Chases an unpaid invoice at 7, 14 and 30 days, firmer each time, then stops.
133
runs this month
13% of the department's runs
Receipt Capture
Reads a photographed receipt and logs it as an expense in the right month.
283
runs this month
27% of the department's runs
Customer Statement Generator
Sends each account customer what they were invoiced, what they paid and what is left.
29
runs this month
3% of the department's runs
Commission Statement Generator
Works out each salesperson's commission from their closed deals and sends the statement.
7
runs this month
<1% of the department's runs
The next thirty days
Going out
everything scheduled to leave the account- Suppliers and consumablesacross the month's payment runs · 182,702 EGP of it already billed1,231,943 EGP
- Practitioner share5 Oct · 22% of last month's billing798,894 EGP
- Payroll28 Sept · every month287,500 EGP
- Rent and premises1 Oct · every month187,000 EGP
- Marketing, software and us1 Oct · every month164,000 EGP
- VAT10 Oct · filed by your accountant153,360 EGP
Coming in
upcoming revenue, plus the invoices expected to landUpcoming revenueestimatenobody schedules a walk-in · run forward from the last 28 days' takings, day by day3,389,477 EGP
- Delta Systems38 days old · chased 3 times39,200 EGP
- MetLife reimbursementsinvoice INV-220221,300 EGP
- Zayed Sports Club31 days old · chased 3 times17,500 EGP
- Cairo International Schoolinvoice INV-220312,400 EGP
- Youssef El Masryinvoice INV-22197,300 EGP
- Nour El Gendyinvoice INV-22286,500 EGP
- Khaled El Masryinvoice INV-22266,300 EGP
- Ahmed Shokryinvoice INV-22135,400 EGP
- Aya Shokryinvoice INV-22205,300 EGP
- Jana Abdelrahmaninvoice INV-22164,800 EGP
- Orchid Aesthetics (referral fee)invoice INV-22044,600 EGP
- Heba Adlyinvoice INV-22174,200 EGP
- Heba Anwarinvoice INV-2214500 EGP
- Farida Mansourinvoice INV-2224400 EGP
In the bank today1,186,000 EGP
as the day opened
+ Coming in3,525,177 EGP
trading and the invoices expected
− Going out2,822,696 EGP
everything scheduled to leave
= In the bank in thirty days1,888,481 EGP
up 702,481 EGP on today, if trading holds at the current rate
Owed either way
Customers owe you
14 unpaid · paid invoices drop off this list| Account | Age | Reminders | Amount | State |
|---|---|---|---|---|
| Delta SystemsINV-2200 · Sheikh Zayed | 38d | 3/3 | 39,200 EGP | overdue |
| MetLife reimbursementsINV-2202 · Mohandessin | 19d | 2/3 | 21,300 EGP | chased |
| Zayed Sports ClubINV-2201 · Mohandessin | 31d | 3/3 | 17,500 EGP | overdue |
| Cairo International SchoolINV-2203 · Mohandessin | 11d | 1/3 | 12,400 EGP | chased |
| Youssef El MasryINV-2219 · 6th of October | 11d | 0/3 | 7,300 EGP | sent |
| Nour El GendyINV-2228 · Mohandessin | 22d | 1/3 | 6,500 EGP | chased |
| Khaled El MasryINV-2226 · 6th of October | 16d | 2/3 | 6,300 EGP | chased |
| Ahmed ShokryINV-2213 · Mohandessin | 0d | 0/3 | 5,400 EGP | raised |
| Aya ShokryINV-2220 · New Cairo | 23d | 1/3 | 5,300 EGP | chased |
| Jana AbdelrahmanINV-2216 · Sheikh Zayed | 25d | 1/3 | 4,800 EGP | chased |
| Orchid Aesthetics (referral fee)INV-2204 · 6th of October | 6d | 0/3 | 4,600 EGP | sent |
| Heba AdlyINV-2217 · Mohandessin | 24d | 1/3 | 4,200 EGP | chased |
| Heba AnwarINV-2214 · 6th of October | 21d | 1/3 | 500 EGP | chased |
| Farida MansourINV-2224 · New Cairo | 24d | 2/3 | 400 EGP | chased |
You owe suppliers
13 open bills · soonest first| Supplier | Due | Terms | Amount | State |
|---|---|---|---|---|
| Medline EgyptBILL-4406 | 6d late | 30 days | 6,441 EGP | overdue |
| Orchid AestheticsBILL-4455 | 3d late | on delivery | 9,750 EGP | overdue |
| Medline EgyptBILL-4401 | 2d late | 30 days | 8,503 EGP | overdue |
| Cairo ElectricityBILL-4451 | in 1d | on receipt | 11,400 EGP | due |
| Delta WaterBILL-4400 | in 1d | 15 days | 8,524 EGP | due |
| Derma Supplies EgyptBILL-4471 | in 4d | 30 days | 41,200 EGP | held |
| Delta WaterBILL-4404 | in 4d | 30 days | 4,038 EGP | scheduled |
| Nile MedicalBILL-4468 | in 9d | 30 days | 18,900 EGP | scheduled |
| Cairo LinenBILL-4402 | in 9d | 15 days | 9,777 EGP | scheduled |
| Delta WaterBILL-4405 | in 12d | 30 days | 1,461 EGP | scheduled |
| Medline EgyptBILL-4459 | in 15d | 30 days | 31,600 EGP | scheduled |
| Cairo Dental DepotBILL-4462 | in 21d | 45 days | 26,400 EGP | scheduled |
| Alpha MaintenanceBILL-4403 | in 28d | 15 days | 4,708 EGP | scheduled |
34% above the mean of the last three orders on an unchanged line count. Margin Watch held the payment run rather than paying it.
Where the profit went
Profit against cash
earned one number, banked another — this is the difference- Operating profitwhat the month earned
- 613,306 EGP
- Still owed by customersbilled, not yet paid
- (135,700 EGP)
- Sitting at the card machinetaken, not yet settled to the bank
- (68,400 EGP)
- Taken for sessions not yet runcash you hold but have not earned
- 146,710 EGP
- Cash the month generatedwhat actually reached the account
- 555,916 EGP
A profitable month can still be a tight one. The three middle lines are balances as they stand today, not movements in the window — which is why a longer window shows a smaller gap between the two figures.
VAT
month to date- VAT you charged customersacross 1,284 invoices
- 214,600 EGP
- VAT you paid suppliersreclaimed against the above
- 61,240 EGP
- VAT to paydue on the 10th
- 153,360 EGP
nothing to fixevery invoice this month passed the e-invoicing export
Law 6/2025 simplified · 0.5% of turnover. Your accountant. Moga prepares the pack and files nothing.