Government Fees Forecast (90 days)

On the first of each month, reads your renewal calendar and your own fee table from Google Sheets, lists the iqama, visa and registration renewals due in the next 90 days and totals the expected fees by month. It also checks the Muqeem service report so finance can see what was already renewed.

Steps in this flow

  1. First of the month 7:00
  2. Google Sheets: read the renewal calendar
  3. Google Sheets: read the fee table
  4. Report period (last 90 days)
  5. Muqeem: services report
  6. Build the 90-day forecast
  7. Anything due?
  8. Email the forecast to finance
  9. Google Sheets: save the forecast

All templates