Ibtisamul Hassan 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.

Open to Admin & Operations· Business Systems· E-commerce / Website Management
Full-time · Hybrid · Remote
Portrait of Ibtisamul Hassan Khalid
Formulas verified11,000+ · 0 errors
Assets = Liabilities + EquityBooks balance ✓
0
Linked spreadsheet systems built, from task tracking to double-entry accounting
0
Formulas verified across all systems — zero calculation errors
0
Product profiles generated automatically from one spreadsheet
0
Command to regenerate a month of order sheets, or a full product catalog
About

From the shop floor to the systems behind it.

I started out as a waiter and assistant cook, then worked as an assistant accountant, teacher and sales assistant. I ran my own fast-food shop, Smiley Bites, from July 2024 to January 2026, handling daily operations, staff, cash and customers. Today I handle admin and the website/online side at AB Agro Mart, where I built the spreadsheets, accounting, order flow and online store the business runs on. I like turning messy manual work into simple systems that people actually use.

At a glance

Based inChattogram, Bangladesh
NowAdmin + Website/Online, AB Agro Mart
StudyingAssociate Degree in Business Administration, University of the People (in progress)
LanguagesBengali (native), English (working), Hindi, Urdu
EducationHSC (Commerce) GPA 4.33, SSC GPA 4.89
Download CV
Problem → Solution → Result

Case study — a business operating system, built from a blank sheet.

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

My role: Admin + Website/Online, AB Agro Mart
01 · Problem

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.

02 · Solution

The solution

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

03 · Result

The result

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.

Module 01 · Core

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.

Executive dashboard · liveSYNCED
Tracked tasks96
SuppliersLive DB
Budget roll-upAuto
Dashboard reads live from 96 tracked tasks
Module 02 · Finance

Double-Entry Accounting

24-account Chart of Accounts, voucher-based General Journal, automatic Trial Balance, P&L, Balance Sheet, and Receivable/Payable tracking.

Step 1
Journal entry
Step 2
Trial Balance
Step 3
P&L
Step 4
Balance Sheet
  • Voucher check: Debit = Credit
  • Assets = Liabilities + Equity
  • 24-account Chart of Accounts
  • Receivable & Payable tracking
  • Automatic straight-line depreciation
Verified: Assets = Liabilities + Equity
Module 03 · Operations

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.

11,000+ formulas · 0 errors across a full month
Module 04 · Automation

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 every policy page the store needs: About, Privacy, Terms, Shipping, Return & Refund, Cancellation, FAQs.

Excel → script → finished catalog, no manual formatting
Module 05 · Integration

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.

Source
WooCommerce order
Trigger
Webhook fires
Logic
Apps Script parses
Result
Live spreadsheet row
WooCommerce → Apps Script → live spreadsheet row
Module 06 · Admin & HR

HR & Admin Systems

Employee records, attendance and payroll in linked spreadsheets, plus the documents staff use every day.

Employee Database In/Out Attendance Sheet Employee ID Cards Monthly Payroll Fixed Asset Register · auto depreciation Bilingual (English + Bangla) Appointment Letters Printable Order Slips Rider Fuel Logs
Live on the internet

websites & Business I built and run.

Real, working properties — the previews scroll by themselves. Hover to pause and look closer.

E-commerce · Storefront

AB Agro Mart

abagromart.com — fresh fish, meat, snacks, dairy & groceries

The retail store's public face: a full product catalog generated from the same spreadsheet that runs the back office, plus every policy page a real store needs.

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.

146+product pages
7policy pages
1command rebuild
Wholesale · Landing Page Site

AB TRADERZ

wholesale.abagromart.com — bulk ordering for business buyers

Designed and built the landing page for AB Traderz, a wholesale chicken and frozen-snacks supplier in Chattogram.

Also prepared the business's SOP, product catalog and wholesale pricing behind it. Buyers register through a Google Sheets-connected form (Google Apps Script).

ReactViteFramer Motion Google Apps ScriptSOPCatalog & Pricing
Fast-Food Shop · Former Owner

Smiley Bite

Mirpur, Dhaka, Bangladesh

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

Daily operations, customer handling, sales and order management, shop supervision — practical, hands-on business management with on-the-spot problem solving.

Facebook page run with the same systematic approach: product posts, updates, and customer communication kept consistent and current.

Operations
Sales & Marketing
Customer service
Toolkit

The tools behind the systems.

Spreadsheets & Data

Microsoft ExcelGoogle Sheets Google Apps ScriptPivot & lookups Data verification

Automation

Python (basic)Node.jsReact / Vite WebhooksWooCommerce One-command pipelines

Accounting

Double-entry bookkeepingChart of Accounts Trial BalanceP&L · Balance Sheet Payroll & HR recordsFixed asset depreciation

Documents & Web

WordPressPolicy pagesProduct catalogs Order documentsSOPs staff actually use
How I work

From blank sheet to system the business runs on.

Step 01

Map the operation

Walk the whole business — orders, inventory, money, people — and write down every process that happens on paper or in someone's head.

Step 02

Design the spreadsheet architecture

Decide what lives in which sheet, how the sheets link, and where every number comes from — before writing a single formula.

Step 03

Build & verify by hand

Write the formulas and scripts, then test every total against hand calculations until the system agrees with reality — 11,000+ formulas, zero errors.

Step 04

Automate the repetitive parts

Turn anything done twice into a script: catalog rebuilds, monthly order sheets, order sync from the storefront into the tracker.

Step 05

Hand over documents people actually use

Policy pages, SOPs, and a bookkeeping system stress-tested with real transactions until assets equal liabilities plus equity.