Softwiro
Free Excel templates

Free Arabic Excel templates with working formulas

Ready-made spreadsheets with working formulas for Excel and Google Sheets, free and with no sign-up. The workbooks are in Arabic; each page below describes one in Arabic.

Garment factories

Garment style costing sheet Cost per piece from materials, operations, overheads and rejects, the selling price for a target margin, and a comparison of style margins. Details and download (Arabic) Production tracking sheet by stage Quantities out of each stage for every production order, completion, what remains, days to delivery and late orders. Details and download (Arabic) Piece-rate payroll and worker efficiency sheet Daily output per worker and operation, piece-rate pay, efficiency from standard minutes (SAM), and a monthly statement per worker. Details and download (Arabic) Fabric requirements and marker sheet Fabric per piece in metres and kilograms from the marker, fabric per order by plies, and shortages against stock. Details and download (Arabic)

Shops and stores

Clothing shop inventory sheet by colour and size Stock per colour-size code from receipts, sales, returns and adjustments, stock value, and reorder alerts. Details and download (Arabic) Customer accounts and credit sales sheet Invoices, payments and returns per customer, the running balance after every transaction, credit-limit alerts and a customer statement. Details and download (Arabic) Cash book and daily expenses sheet Daily cash in and out by category, the running cash balance, and monthly revenue, expense and net totals for the year. Details and download (Arabic) Sales invoice sheet with VAT A printable invoice with item lookup, discounts and VAT, and an invoice register with monthly sales and tax totals. Details and download (Arabic) Installments and collection tracker Track customers who buy on installments: contracts, down payments, monthly amounts, payments, remaining balance, late installments with days late, collection status and a list of who is due or late today. Details and download (Arabic) General shop inventory tracker (stock in/out, reorder, slow movers) Items with buy and sell prices and a minimum level, one in/out movement log, current balance valued at purchase price with profit margin, a reorder list for items below minimum, and a summary with stock value and slow-moving items. Details and download (Arabic) Supplier purchase orders and payables tracker Suppliers with payment terms, purchase orders with expected delivery, goods receipts that create what you owe, payments per receipt, and an aging table of supplier debts. Details and download (Arabic)

Online selling

Online store orders and profit sheet Logs cash-on-delivery online orders, works out each order's profit after shipping, returns and discounts, then net profit by month after ads. Details and download (Arabic)

Delivery companies

Delivery company sheet: shipments and cash collection Shipments by merchant, courier and zone, fees, merchant net and courier commission, with merchant settlements and courier accounts for any period. Details and download (Arabic)

Accounting

Journal entries, trial balance and financial statements sheet Journal entries posted to a ledger and a trial balance, with an income statement and a balance sheet, and an alert on every unbalanced entry. Details and download (Arabic) Business expenses and monthly budget sheet An expense and income log, a monthly budget per category, and actual versus budget by category and month with variance, over-budget flags and monthly net. Details and download (Arabic)

Schools and students

Student grades sheet: marks, ranks and report cards Record one subject for one class: totals, percentages, grades, ranks with ties, pass or fail, class statistics and a printable report card for each student. Details and download (Arabic) Student attendance sheet A monthly attendance grid for one class: present, absent, late and excused counts per student, attendance percentage, absence-limit alerts and a monthly summary. Details and download (Arabic) Study planner and lesson tracker Lessons per subject with study status, self-test scores, lessons needed per day before each exam, and the ten weakest lessons. Details and download (Arabic) Nursery and school fees tracker (Excel) Fees by stage, an installment plan with dates, sibling discounts, payments per student, the amount due to date against paid to show arrears, a follow-up list and a collection summary by stage. Details and download (Arabic) Tutoring center manager (Excel) Groups with teachers and fees, students per group, attendance, monthly fee payments, who has not paid, teacher pay as a share of collections with what was paid, and a monthly summary. Details and download (Arabic) School class timetable (Excel) Classes, teachers and a log of periods that flags a teacher booked in two classes in the same period and a class booked twice, counts each teacher's periods against their weekly quota, and shows a timetable grid per class and per teacher. Details and download (Arabic) Exam schedule with committees and invigilators (Excel) Classes with student counts, committees with seats, invigilators with a limit, and a log of exams that flags a class sitting two exams in one period, a committee or invigilator booked twice and a class larger than its committee, plus invigilation counts and a per-date summary. Details and download (Arabic) Homework and behavior tracker for teachers (Excel) Track the homework you set, who handed it in on time, late or not at all, and simple behavior notes. Get a delivery rate per student, assignment and class, and a follow-up list. Details and download (Arabic) School bus subscriptions tracker (Excel) Bus lines with drivers and capacity, subscribed students, monthly payments, the amount due to date and arrears, free seats per bus and an alert when a bus is full. Details and download (Arabic) University applications tracker (Excel) Track applications to local and overseas universities: deadlines you enter, required documents with a status for each, fees in the currencies you name, days left, and an alert for late or near deadlines. Details and download (Arabic)

Real estate

Real estate leads and units tracker Track units for sale or rent and your leads by stage and follow-up date, with price per m², budget fit, commission on contracts and a list of today's follow-ups. Details and download (Arabic) Rent collection tracker for properties Units and tenants with monthly rent and lease dates, a payments log, balance due, months late and last payment per tenant, lease-ending alerts, a follow-up list and an expected-versus-collected summary. Details and download (Arabic)

Owners associations and compounds

Owners' association dues collection tracker Units with fixed or per-square-metre monthly dues, a payments log, due, paid, arrears, months late and last payment per unit, a late-payers list, a one-unit statement and a collection and compliance summary. Details and download (Arabic) Owners' association budget and expenses sheet Budget lines (monthly or annual), an expenses log, monthly dues revenue, actual versus budget per item and month, over-budget alerts, the remaining balance and a yearly summary. Details and download (Arabic) Reserve and emergency fund sheet for owners' associations Fund deposits and withdrawals with a running balance, planned major maintenance projects, the monthly amount to set aside for each versus what is saved, and a balance and coverage summary. Sample numbers are illustrative. Details and download (Arabic) Maintenance requests and complaints log for owners' associations A log of maintenance reports and complaints by type, priority, owner and status, days open with a late alert by priority, and a summary of statuses, frequent types, average days to close and monthly cost. Sample data is illustrative. Details and download (Arabic) Service contracts and suppliers tracker for owners associations Cleaning, security, lift, garden, pest-control and internet contracts with monthly value and dates, a supplier payments log, due versus paid per supplier, expiry alerts, monthly and yearly commitments and a renewal list. Details and download (Arabic) Owners association meetings and decisions tracker Owners and their shares, a meetings log, attendance in person, by proxy or absent, attendance percentage of shares against a quorum percentage you set, a decisions log with votes by shares, and a list of decisions not yet carried out. Details and download (Arabic) Shared electricity and water bill splitter for building units Split shared electricity, water, gas and elevator bills across the units of a building or compound by area, equally, by household size or by a fixed share, with each unit's monthly share, a printable statement and a check that shares add up to the bills. Details and download (Arabic) Residents, units and vehicles register for an owners' association A register of building or compound units with residents, phones, household size, cars, plates, stickers and parking spots, alerts for units without a phone or with too many cars, owner-versus-tenant and parking totals, and a quick contact list. Details and download (Arabic) Monthly transparency report for owners' associations Log the association's income and expenses and get a one-page printable monthly report: income by type, spending by category with percentages, net, opening and closing balance, comparison with last month, arrears, reserve fund, maintenance and decisions, plus a year summary. Details and download (Arabic)

Pharmacies and clinics

Pharmacy expiry and stock tracking sheet Batches with expiry dates and days left, expired and 30/60/90-day flags, reorder-level alerts, stock value at cost and at risk, and a needs-action list. Details and download (Arabic) Clinic appointments tracker (Excel) Patients, an appointments log priced from your own price list, paid and remaining per patient, today's list by time, next follow-up and who missed it, and a monthly revenue and attendance summary. No diagnoses stored. Details and download (Arabic) Dental clinic treatment plans tracker (Excel) Patients, treatment plans with planned sessions and an agreed price, a sessions log and a payments log, each patient's balance for the work done, plans that need a new appointment, a follow-up list and a monthly summary. No diagnoses stored. Details and download (Arabic)

Restaurants and cafes

Recipe costing for restaurants and cafes (Excel) Ingredients with unit prices, recipes, the cost of every dish, a suggested price for your target cost percentage, actual margin and cost percentage with an alert above target, best and worst dishes, and what a price rise in one ingredient does to every dish. Details and download (Arabic)

Contracting and finishing

Finishing and contracting projects tracker Projects with contract value, cost budget and dates, stages with completion, an expenses log by item, client payments, and per project actual spend vs budget, expected profit, client balance, delay and a summary of all projects. Details and download (Arabic)

Human resources

Employee payroll and attendance Employees with basic pay and allowances, an attendance log (absence, overtime and late hours), advances and deductions, net monthly salary per employee for a month chosen in Settings, a print-ready payroll statement and a cost summary. Details and download (Arabic)

Services and business

Lead and deal pipeline tracker Deals with source, stage, value, next follow-up and last contact, stage probability and weighted value, a today/overdue follow-up list and a funnel summary by stage and lead source. Details and download (Arabic) Freelancer projects, hours and invoices tracker Projects priced by the hour or at a fixed price, an hours log, invoices with due dates and status, a payments log, what clients owe, work not yet invoiced, and income by month. Details and download (Arabic) Laundry orders tracker (Excel) A price list per piece, an orders log with pieces, promised date, status and paid, total and balance per order, late-pickup and late-wash alerts, a follow-up list and a summary of orders, pieces and revenue. Details and download (Arabic)

Personal finance

Monthly savings circle (gamaeya) tracker Members and shares, share value, months and collection order, a log of monthly instalments, arrears per member, what each member collects in their month, a current-month summary and a printable monthly statement. Details and download (Arabic) Household budget and savings sheet Income and expenses by category (fixed and variable), a monthly budget per category against actual, savings goals with the monthly amount each needs, and a summary of what is left of income, the savings rate and the top three categories. Details and download (Arabic)

Gyms and fitness

Gym memberships tracker (Excel) Members, plans, a subscriptions log with end dates, payments and attendance, a renewal list for expired and soon-to-expire members, who stopped coming, and a monthly summary of money and visits. Details and download (Arabic)

Beauty salons

Beauty salon bookings tracker (Excel) A services price list, staff with commission rates, a bookings log, today's list by time with today's revenue, and a monthly summary of revenue, commissions, cancellations and no-shows. Details and download (Arabic)

Workshops and maintenance

Car workshop job orders tracker (Excel) A job order per car: labor fee, parts at cost and sale price, car status, payments, balance per order and per customer, parts profit, and a list of customers who still owe. Details and download (Arabic)

Farming

Poultry farm cycle tracker (Excel) Fattening cycles with feed, mortality, weight samples, sales and expenses logs, giving mortality %, birds in the house, total cost, revenue, cycle profit, cost per kg and feed per kg sold. Details and download (Arabic) Crop season expenses and revenue tracker (Excel) Plots, an expenses log by item (labour, fertiliser, irrigation, harvest and more) and a sales log, with each plot's profit, cost per feddan, cost per kilo and status, and a season summary. Details and download (Arabic)

Events and weddings

Wedding and event budget planner (Excel) Suppliers with agreed prices, deposits and balances, due dates and late payments, a payments log, a guest list with replies and tables, and a summary of budget, paid, remaining and confirmed attendance. Details and download (Arabic)

Transport and cars

Car rental fleet tracker (Excel) Cars with insurance and licence dates, a bookings log with pickup, agreed and actual return, daily rate, deposit and payments, a maintenance log, an overdue-returns list and a summary with the value and net result of each car. Details and download (Arabic) Fleet fuel and maintenance tracker (Excel) Vehicles with licence and insurance dates, a fuel log and a maintenance log, then kilometres driven, fuel and maintenance cost, cost per kilometre, litres per 100 km, last service and a follow-up list of expired papers. Details and download (Arabic)

Charities and donations

Charity donations and disbursements tracker Log donations (donor codes only) and what was spent on beneficiaries and the charity's items, and get a one-page monthly transparency report with totals and no names: donations by type, spending by item, balance, beneficiaries served, plus a year summary. Details and download (Arabic)

Travel agencies

Travel agency bookings tracker Track trip, umrah, flight and hotel bookings: price, supplier cost and agency commission, each customer's payments and remaining balance, alerts for near travel dates with money still due, a follow-up list and a summary by booking type. Details and download (Arabic)

Al-Azhar students

Al-Azhar student grades sheet (Excel) Record marks for religious, Arabic and general subjects (year work plus final exam), get each student's total, percentage and grade, a second-round list of failed subjects and a class ranking. Subjects and weights are an editable example. Details and download (Arabic) Quran memorization and review tracker (Excel) Log each recitation session (new memorization or review) with from/to positions, number of faces and a rating. Get total memorized, last memorization and last review per student, and a late-review alert after the number of days you set. Details and download (Arabic)

IGCSE

IGCSE subject tracker with mock scores and target grades (Excel) Subjects, their papers and weights, mock scores and a target grade per subject, with a predicted grade from the mocks and what is still missing to reach the target. Grade boundaries are editable examples in Settings; check the board's official boundaries for your session. Details and download (Arabic) IGCSE past papers log and error tracker (Excel) Log every past paper you solve with subject, paper or component, session and year, score, full mark, minutes, error type and date. See each subject's average, first 3 versus last 3 attempts, the trend, and your most frequent error types. Details and download (Arabic)

American diploma

American diploma GPA calculator: unweighted, weighted and cumulative (Excel) Courses for grades 9 to 12 with credit, type (regular, Honors or AP) and letter grade, giving unweighted and weighted GPA per year and cumulative. The grade-point table and the Honors/AP additions are examples you edit in Settings. Details and download (Arabic) AP, SAT and ACT prep planner (Excel) Enter your AP, SAT and ACT exam dates, log practice tests against a target score you set, plan weekly study hours versus actual, and see the days left to each exam. Details and download (Arabic)

Teachers

Teacher weighted gradebook (Excel) A class gradebook with editable category weights (homework, quizzes, projects, final): weighted total, percentage, grade, rank, class statistics and a list of students at risk of failing. Details and download (Arabic) Lesson plan and curriculum coverage tracker for teachers (Excel) Enter your subjects, classes, units and lessons with planned and taught periods and dates. Get a coverage percentage per subject and class, late-against-plan alerts and short prep notes. Details and download (Arabic) Parent communication log for teachers (Excel) Log each contact with a parent by student, date, means and topic with a short summary. Mark what needs follow-up and when, get overdue follow-up alerts, and see a summary per student and topic. Details and download (Arabic) Remedial sessions tracker for teachers (Excel) Students who need support with subject and a short reason, a log of sessions with minutes and attended or absent, scores before and after typed by the teacher, the improvement, students who did not improve and a per-subject summary. Details and download (Arabic)