Khalid · Business systems & automation

I build the systems small businesses run on.

I design and automate the operational backbone of a business — spreadsheets that do real accounting, scripts that turn a day of manual work into one command, and documents that a shop actually uses every day.

Khalid — portrait
9
Linked spreadsheet systems built, from task tracking to double-entry accounting
11,000+
Formulas verified across all systems — zero calculation errors
136
Product profiles generated automatically from one spreadsheet
1
Command to regenerate a month of order sheets, or a full product catalog

How I work

I learn by shipping real things. When AB Agro Mart — a fresh fish, meat, and grocery retailer — was getting ready to open, it needed the kind of operational infrastructure a bigger company would build a whole department for: task tracking, order management, a product catalog, and proper accounting. There was no off-the-shelf tool that fit, and no budget for one.

So I built it — sheet by sheet, script by script — learning Excel formulas, Python automation, and double-entry bookkeeping along the way, and testing every number against hand calculations until it held up.

Case study — AB Agro Mart Business Operating System

A full operational system for a multi-category retail business (fish, meat, poultry, dairy, groceries), built from a launch date and a blank spreadsheet.

The problem

A new retail business needed to track tasks, orders, inventory, suppliers, staff, and money from day one — with no existing systems and a hard launch date.

My role

Designed and built every system solo: spreadsheet architecture, formula logic, automation scripts, and the documents staff use daily.

The outcome

A connected set of tools the business actually runs on — order sheets that total themselves, a catalog that regenerates in one command, and books that balance.

Business Operating System

A launch-to-operations workbook: task manager, timeline, budget planner, supplier database, and an executive dashboard that rolls all of it up automatically.

Dashboard reads live from 96 tracked tasks
View proof →

Order Management System

One linked spreadsheet per month — a tab per day, a block per order — with quantities, line totals, and daily and monthly totals that calculate themselves.

10,000+ formulas, 0 errors across a full month
View proof →

Product Catalog Automation

A Python + Node.js pipeline that turns one spreadsheet of product data into 146+ formatted profile documents — category-color-coded, with real photos embedded. Also wrote the store's policy pages: About Us, Privacy Policy, Terms & Conditions, Shipping, Return & Refund, Cancellation Policy, and FAQs.

Excel → script → finished catalog, no manual formatting
View proof →

Double-Entry Accounting System

A 24-account Chart of Accounts, voucher-based General Journal, automatic Trial Balance, Profit & Loss, Balance Sheet, and Receivable/Payable tracking — stress-tested with real transactions until assets equalled liabilities plus equity.

Verified: Assets ৳505,000 = Liabilities + Equity ৳505,000
View proof →

Business automation

A webhook pipeline connecting the store's ordering system to Google Sheets, so new orders write themselves into the tracking system — no manual re-entry.

WooCommerce → Apps Script → live spreadsheet row
View proof →

Operations documents

Bilingual appointment letters, printable order slips, and rider fuel logs — designed to actually get printed and used at the counter, not just look good on screen.

English + Bangla, one page, print-ready
View proof →

Fixed Assets & Payroll

A Fixed Assets Register with automatic straight-line depreciation, plus a Payroll System handling monthly employee salary calculation.

Depreciation + salary runs, fully automatic
View proof →

HR & Employee Management

Employee Information Sheet, Employee Database, ID card design, and an In/Out Attendance Sheet — the day-to-day HR paperwork built as linked, reusable spreadsheets.

Full employee lifecycle, tracked in one system
View proof →

AB Agro Mart — e-commerce website

The storefront customers order from, live and processing real orders.

Built on WooCommerce / WordPress

Product catalog, checkout, and delivery workflow for AB Agro Mart's online store — connected to the same order and inventory systems built above, so the business runs off one source of truth instead of three.

WordPress WooCommerce Product catalog Order integration
View live site →

AB Traderz — landing page

A premium landing page for a wholesale chicken, Beijing duck & frozen snacks supplier in Chattogram.

React / Vite build, with a live registration form

Built with framer-motion animation and a glassmorphism look, with a Google Sheets-connected registration form for wholesale sign-ups.

React Vite Google Apps Script
View live site →

Smiley Bite — fast-food business

Founded and personally ran a small fast-food shop (Jul 2024 – Jan 2026).

Day to day

Daily operations, customer handling, sales and order management, shop supervision.

What it taught

Practical, hands-on business management — not just theory — including on-the-spot problem solving.

Skills

Spreadsheets

  • Advanced Excel & Google Sheets
  • Formula-driven dashboards
  • Data validation & conditional logic

Automation

  • Python (openpyxl, fundamentals)
  • Node.js document generation
  • Webhook & API integration

Business

  • Double-entry bookkeeping & payroll
  • Process & systems design
  • WordPress / WooCommerce

HR & Operations

  • Employee records & attendance systems
  • Shop / business supervision
  • Customer & order handling