Many trading and service companies in the Gulf run daily work on one or two Excel files: rep orders, project purchase orders, maintenance tickets, rental contracts, patient appointments or student fees. Turning that file into a system follows the same steps in every sector: unify names written in Arabic and English, unify mobile numbers and dates, split customers into a sheet with a unique number, then upload the file to a tool that builds screens, forms, reports and roles around it. What differs by sector is the key screen: a stage board for orders, a calendar for appointments, alerts for due dates.
- excel to system for business
- contracting company management system instead of excel
- turn rental contracts spreadsheet into software
- sales rep order tracking system
- how do I build a real estate office system from excel
- maintenance ticket system in Arabic
Why do Gulf companies live on Excel, and when does it stop working?
Because Excel was the sensible answer the day the company started: five employees, one branch, an owner who knew every customer by name. Then it grew the usual Gulf way: a second branch in another city, reps in the field, a new accountant every couple of years, and a season that doubles orders. The file stayed the same, except it now travels through WhatsApp groups under ten names.
IllustrationThis guide skips the general advice; that is in how to turn an Excel sheet into a system, and the timing signs are in when to leave Excel. Here we open six typical files from six sectors and see what each becomes.
What problems do our companies' files share?
Before the sectors, these are flaws seen in the region's files in particular. Fix them before any conversion:
| Problem | Example | Fix |
|---|---|---|
| Two languages in one name column | Al Noor Trading, then the same name in Arabic | Two columns: Arabic name and English name |
| Mobile formats | 0501234567, +966501234567 and 501234567 | One format with the country code |
| Mixed dates | Gregorian in one row, Hijri in another | One column in one calendar, a second column if you need the other |
| Amount and VAT together | 1150 incl. and 1000 + VAT | Three columns: before VAT, VAT, total |
| A sheet per branch or month | Sheets: Riyadh, Jeddah, January, February | One sheet with Branch and Date columns |
| A city spelled ten ways | Dubai, DXB, Dubayy, and Arabic variants | One unified list |
| Status by color | Green means paid | A Status column with written values |
How does a trading or contracting file convert?
Trading and distribution: the rep orders file
| In the file | In the system |
|---|---|
| An items sheet with wholesale and retail prices | An items table, and the rep does not see cost price |
| Orders typed by a clerk from WhatsApp messages | The rep enters the order on a phone at the customer's |
| A Status column updated when remembered | A stage board: New, Approved, Preparing, Delivered |
| A sales sheet compiled at month end | A report by rep and area, always current |
Contracting and fit-out: the projects and purchase orders file
| In the file | In the system |
|---|---|
| A file per project, each formatted differently | One projects table, and everything points to a project number |
| Purchase orders approved in a chat | A request with recorded approval by amount |
| Site petty cash in a notebook | The site supervisor logs the expense with a receipt photo |
| Project cost calculated at billing time | The project page shows spend against contract value |
How does a maintenance or real estate file convert?
Maintenance and operations: the tickets file
| In the file | In the system |
|---|---|
| A ticket typed from a phone call | A ticket form: customer, site, fault type, priority |
| The technician's name in a column | Assignment to a technician who sees only their tickets on a phone |
| Done typed days later | The technician closes the ticket on site with a photo and note |
| Annual maintenance contracts in another file | A contracts table tied to the customer, with an alert before expiry |
Real estate offices and property management: the contracts and rent file
| In the file | In the system |
|---|---|
| A sheet of properties and units | A units table with status: vacant, let, under maintenance |
| Contracts with start and end dates | A calendar of end dates and an alert before renewal |
| Rent payments marked by color | A payments table per contract: due, paid, overdue |
| An owner statement prepared by hand | A report per owner with collected and overdue amounts |
Rental contracts in Saudi Arabia and the UAE are registered through official platforms with their own procedures. Your internal system tracks and reminds; it does not replace them. More in build a property management app.
How does a clinic or school file convert?
Clinics and medical centers: the appointments file
| In the file | In the system |
|---|---|
| An appointment table per doctor, each in a sheet | One calendar filtered by doctor |
| The patient retyped at every visit | One patient record with a file number and visits underneath |
| No-shows marked with a color | Appointment status: confirmed, attended, no-show, canceled |
| Nobody knows the no-show count | An attendance rate report by doctor and day |
Private schools, training centers and nurseries: the registration and fees file
| In the file | In the system |
|---|---|
| A sheet per class or course | One students table with a Class column |
| The guardian typed with every child | A guardians table with children linked to it |
| Installments as columns: installment 1, installment 2 | A payments table per student with due date and status |
| Chasing late payers by random calls | A list of overdue accounts sorted by amount and age |
How does the conversion actually work in Fanann?
The steps are the same whatever the sector. Open Excel to App and upload the file:
- 1Read
Sheets, the header row, each column's type (date, amount, mobile, choice list and so on), duplicates and links between sheets are detected, using no credits.
- 2Propose
After one sentence from you about your business, an app is proposed: a table per sheet with a list, form and detail page, a stage board or calendar where it fits, reports, and owner, manager and staff roles.
- 3Adjust
Switch off what you do not need, rename fields or change their types, and write your note to the builder.
- 4Build
Your rows are written into the app's database as they are, and the screens are built around them. You add users from inside the app.
- File
- .xlsx or CSV, up to 10 MB
- Interface
- Arabic (right to left) and English
- Roles
- Owner, manager, staff
- Form
- A web app, or mobile on paid plans
Import has a row limit per table and for the whole app that you are shown before building, and you can import more later from the control center. The walkthrough is in the Excel to system guide.
What do I write to the builder for my sector?
The sentence before the proposal (what do you run with this file?) makes a large difference. Ready examples:
| Sector | Intro sentence |
|---|---|
| Distribution | Rep orders for a food distributor with three branches in the Eastern Province |
| Contracting | Purchase orders and petty cash for residential fit-out projects in Riyadh |
| Maintenance | AC maintenance tickets under annual contracts with buildings in Sharjah |
| Real estate | Contracts and rent for 120 residential and commercial units for five owners |
| Clinic | Appointments for a dental clinic with four doctors |
| School | Registration and fees for a nursery with two branches |
This is a property management office's file: an Owners sheet, a Units sheet (building, unit number, type, status), a Contracts sheet (tenant, mobile, contract start and end, annual rent, number of payments) and a Payments sheet. I want a calendar of contract end dates with an alert 60 days ahead, a list of payments due this month and another of overdue payments sorted by days late. The collections employee records a payment and attaches a receipt photo, and cannot change the contract value. The manager approves any discount or deferral. A report per owner: their units, collected, overdue, and vacant units. Show VAT in a separate column for commercial contracts. Arabic interface, right to left, with English. Record who logged each payment and when.
Try it in FanannWeb, mobile or a PC program, and how do I roll it out?
Pick the one that sounds like you to see the advice.
A web app. One link for head office and branches, opened on computers and phones.
A phone-friendly web app to begin with, and an iPhone and Android app on paid plans if you need one. See mobile apps.
A Windows program with a local database that works with no internet on that computer, from Windows Studio. Backups are your responsibility.
- Week 1Tidy the file and build
The readiness list, then upload, review and build.
- Week 2Trial with one branch or team
Reconcile numbers with the file and fix what confuses people.
- Week 3Roll out and retire the file
The old file becomes read-only, with a short intro session.
- Week 4Test and review
Test the paths, then choose the next file.
For country-level plans: digital transformation for Saudi companies and digital transformation for UAE companies.
Every sector has a file everyone knows and everyone fears. Start with it.
Key takeaways
- Every sector has a heart file. Start with that one alone.
- Gulf files share the same flaws: names in two languages, mobile numbers in several formats, mixed Hijri and Gregorian dates.
- Pick the main screen by the nature of the work: stages, a calendar or due-date alerts.
- Patient and student data is sensitive: narrower permissions, and check the rules first.
- VAT (15% in Saudi Arabia, 5% in the UAE) shows on documents; the tax invoice stays with the accounting solution.
Frequently asked questions
How do I turn my company's Excel file into a system?
Does this suit a small contracting company?
Can a clinic's appointment file become a system?
Does the system handle VAT?
What if my file mixes Arabic and English?
Can I start with one branch?
Ask your AI assistant about this
Copy this prompt into the AI assistant you use, then add the details of your own case.
I am reading this guide: “From Excel to a system: a guide for Gulf trading and service firms” https://fanann.com/en/blog/excel-to-system-for-gulf-businesses/ My question: excel to system for business Use that page as a source and explain the answer step by step for my situation, tell me what to check before I start, and cite the page link.