WhatsApp: +92 315 8852311

English|اردو|پښتو|بلوچی

JahaSoft logoJahaSoftSoftware built in Quetta
Last updated:
TRADING & LOGISTICS ERP CASE STUDY

Arabi Global — From Excel Sheets and Paper Registers to One Online ERP

Arabi Global LTD is an international trading and logistics business that buys goods abroad, moves them by sea and road through ports, borders and customs, and sells them on to customers. Its whole workflow ran on Excel sheets and paper registers. We built an offline-first ERP that now runs all of it online, from the supplier invoice to the final delivery and payment.
IndustryInternational trading & logistics
PlatformWeb, offline-first
CurrenciesUSD, AFN, IRR, PKR, AED
DeploymentClient’s own server
🚢

Container TrackingLoading to Sale
🛃

Landed CostDuty & Charges per Batch

Multi-CurrencyUSD, AFN, IRR, PKR, AED

100% Offline-FirstSyncs When Online
The Spreadsheet Problem

A business in transit, tracked on paper

A single shipment passes through many hands: the supplier, the shipping line, the port, the border, customs, the warehouse, the transporter and finally the customer. Arabi Global kept each step in a separate Excel sheet or paper register, and money moved through exchange dealers in several currencies.

Answering a simple question, such as what a container really cost once duty and freight were added, or how much a customer still owed, meant opening several sheets and adding them up by hand.

  • Scattered registers: Purchases, containers, transit, customs, stock, sales and cash each lived in a different sheet or book.
  • Hidden landed cost: Duty, port charges and freight were not tied back to the stock they belonged to.
  • Multi-currency balances: Payments in USD, AFN, IRR and other currencies through exchange dealers made party balances slow and error-prone to work out.
Custom ERP

What we built

An offline-first web ERP with fifteen modules, running on Arabi Global’s own server. Each register keeps the same columns, in the same order and with the same names, as the Excel sheet it replaced, then adds what Excel could not: live status, running balances and the full history of every document.

International purchases

Supplier invoices with currency and rate, and loaded-versus-contract tracking with an overload guard.

🚢 Bills of lading & containers

One invoice to many BLs to many containers, with a full timeline for every container from loading to sale.

🛃 Transit & customs

Port, border and demurrage charges, and customs duty landed into the cost of the right stock.

Transport

Truck loads split across several vehicles, short deliveries recorded, and fares charged to the right party.

Stock & warehouses

Every quantity traced to its batch and container, with transfers, repacking, FIFO issue and live balances by warehouse.

Sales & deliveries

USD invoices, partial deliveries over several truck loads, and printable sheets in the client’s own layout.

Money in many currencies

Payments and exchanges in USD, AFN, IRR, PKR, AED and more, party ledgers and balances, and automatic exchange gain or loss.

Thirteen reports

Landed cost, stock by location, container register, receivables, payables, profit and loss, with Excel and CSV export.

📥 Import from Excel

Every register can be loaded from the client’s own workbooks, matched to his column headings automatically.

Offline-first

Every data-entry screen works without internet and syncs when the connection returns, with a sync centre for conflicts.

Users & roles

Admin, operator and viewer roles, document numbering, exchange rates and business rules set in one place.

Nightly backups

Automatic server backups, plus back up, download and restore from inside the app.

Tested Before Handover

Testing: 29 automated server tests with 423 checks, a browser walk-through of one shipment through every form, and a load test with 10,000 containers. Backups run nightly and a full restore was rehearsed.

Inside the software

Screens from Arabi Global’s system

Taken from the system in daily use. Click any screen to see it full size.

Dashboard: shipments by stage from origin to warehouse, with purchases, sales, receivables, payables and profit
Dashboard: shipments by stage from origin to warehouse, with purchases, sales, receivables, payables and profit
New bill of lading: containers added in one step and linked to the purchase invoice
New bill of lading: containers added in one step and linked to the purchase invoice
Exchange rates: each transaction keeps the rate it used, so old entries never change
Exchange rates: each transaction keeps the rate it used, so old entries never change

The result

Arabi Global’s entire workflow, which used to live in Excel sheets and paper registers, now runs online in one system. Usama tested it with his own records before taking it over. Every container can be followed from the supplier’s invoice to the customer’s delivery, with its true landed cost and every party’s balance in each currency available at any time.

Why this one matters

Trading and logistics businesses rarely fit a ready-made ERP. This system was shaped around the client’s own registers, so the team recognised every screen on day one, and it keeps working when the internet doesn’t.

System Overview & Deployment

Offline-first web application with a background sync engine, REST API on the client’s dedicated server, multi-currency ledgers, batch-level stock and landed cost, Excel import, role-based access, nightly backups with in-app restore.

Running Your Trading Business on Spreadsheets?

JahaSoft builds offline-first ERPs that follow your own registers, so purchases, shipments, stock, sales and money finally live in one place.