Odoo ERP for Import-Export Businesses — How PinnacleArc Moved from 47 Excel Files to One System with Real-Time Profit Visibility

PinnacleArc International — Business Overview

PinnacleArc International Co., Ltd. (pseudonym used to protect client confidentiality) is an import-export company established more than 12 years ago. The business has its headquarters in Bangkok, three warehouse locations (Laem Chabang, Bangna, and a Sukhumvit showroom), 52 employees, and annual revenue of approximately 350 million THB.

Its core business is importing industrial parts from China, Japan, and Taiwan, then reselling them to manufacturers in Thailand and exporting to CLMV markets (Cambodia, Laos, Myanmar, and Vietnam). Main product categories include bearings, hydraulic parts, linear motion guides, and CNC machine spare parts.

Mr. Wichai (pseudonym), Managing Director: "We started with just two people in a small shophouse 12 years ago. Back then, Excel could handle everything. But once revenue passed 200 million baht, I started feeling like I was driving by looking only in the rearview mirror — I never really knew what our actual profit was at that moment."

Pain Points — Problems That Built Up to a Breaking Point

1. Excel Hell — 47 Files No One Dared Touch

PinnacleArc was using 47 Excel spreadsheets to run everything, from purchase orders, invoices, and packing lists to stock cards and daily exchange rates.

The problems were clear:

• The master file containing data for more than 4,200 SKUs lived on only one employee’s computer. If she was out sick, no one could update it.
• The costing file had 8–10 layers of nested Excel formulas, and no one wanted to touch it for fear of breaking it.
• Data was not synchronized. Sales created quotations using price files that were already two weeks outdated because they didn’t know purchasing had updated supplier prices.
• Version conflicts happened regularly. In one month alone, the February PO file was accidentally overwritten with an older January version, and the team spent three days recovering the data.

Ms. Mam, Accounting: "At the end of every month, I had to consolidate data from 12 different files. It took 4–5 days just to find out whether we made a profit or a loss — and even then, I still wasn’t sure the numbers were accurate."

2. Multi-Currency Nightmare — Five Currencies Changing Every Day

PinnacleArc’s import-export operation had to manage five currencies at the same time:

A real incident: In November 2025, PinnacleArc placed a large bearing order from Japan worth 8.2 million JPY. At PO issuance, the rate used was 0.235 THB/JPY. But when payment was made 45 days later, the rate had risen to 0.248 THB/JPY — increasing cost by 106,600 THB with no prior provision.

Mr. Wichai: "That month I thought we made 2.1 million baht in profit. Once accounting closed the books, it turned out to be only 1.4 million. We lost 700,000 baht to exchange losses that no one had flagged."

3. Inventory Chaos — Three Warehouses, Never Matching

PinnacleArc’s inventory was spread across three locations:

• Laem Chabang warehouse — goods just cleared through customs, waiting to be transported to Bangkok
• Bangna warehouse — main warehouse with ready-to-ship stock
• Sukhumvit showroom — samples and fast-moving items for walk-in customers

The issue was that the stock card at Laem Chabang was still paper-based, while Bangna and the showroom each used separate Excel files.

• Sales would call the warehouse asking, "Do we have model 6205-2RS bearings in stock?" The warehouse would say "200 units," but when preparing shipment, they discovered 80 had already been reserved for another order.
• Goods in transit from Laem Chabang to Bangna had no system status at all — they effectively "disappeared" for 3–5 days.
• During the December 2025 cycle count, inventory in the system (Excel) differed from actual stock by 23%, with more than 2.8 million THB in missing inventory value.

Mr. Ek, Warehouse Manager: "I knew where the items were, but that knowledge existed only in my head. If I wasn’t around, the team had to call me every hour."

4. Customs & Compliance — Government Documents Prepared Manually

As a BOI-promoted company, PinnacleArc had to handle a large volume of compliance documents:

• Form E (Certificate of Origin for ASEAN-China FTA) — every form required manual entry of product details, HS codes, and FOB value
• Customs declarations — had to match the invoice, packing list, and bill of lading exactly
• BOI reports — monthly and annual import-export reporting
• Import VAT — required monthly reconciliation against purchase records

All of these documents were created manually. Every time, staff had to copy data from Excel into Word templates field by field.

A real incident: In October 2025, the documentation team entered an HS code incorrectly by one digit on a customs declaration (8482.10 instead of 8482.01), causing the shipment to be held at the port for five days. The combined penalty, demurrage, and opportunity cost came to 180,000 THB.

5. Cash Flow Blind Spot — No Visibility into Which Lots Made or Lost Money

This was the most serious issue. The cost of a single import lot included:

• Product cost (FOB)
• Sea freight
• Insurance
• Import duty + import VAT
• Customs broker fees
• Inland transportation (Laem Chabang → Bangna)
• Exchange rate on the actual payment date

But this information was spread across six different sources: purchasing Excel files, accounting Excel files, shipping receipts, customs broker receipts, bank statements, and tax invoices. No one could calculate the true total cost of a lot.

Mr. Wichai: "We had 350 million baht in annual revenue, but if you asked me what our net profit was, I had to wait 2–3 months after period close to find out. That means I was making daily decisions without knowing our real financial position."

6. Late Delivery — Lead Times Nobody Was Tracking

Some of PinnacleArc’s suppliers were reliable, while others were repeatedly late. But there was no system to track:

• Where each issued PO currently stood
• Which suppliers were late most often
• Whether ordered goods had shipped, boarded the vessel, or arrived at port

The purchasing team had to search email thread by thread for updates. If a supplier didn’t reply, nobody knew when goods would arrive. When customers called, all they could say was, "We’ll check and get back to you."

Business impact: In 2025, three customers worth a combined 28 million THB/year switched to competitors because "deliveries were late and no one kept us informed."

Analysis — Root Cause Assessment

When PinnacleArc engaged the Enersys team, we spent three weeks in discovery workshops with every department. We identified four core root causes:

Root Cause 1: No Single Source of Truth

Data was scattered across dozens of Excel files, different people, and different computers. There was no single version of the truth that everyone could trust. Once people stopped trusting the system, they fell back on personal experience and memory — which lived in the heads of only a few key employees.

Root Cause 2: Disconnected Processes

The process from Inquiry → Quotation → PO → Shipping → Receipt → Invoice → Payment was a broken conveyor belt, split into isolated steps. Each department completed its part and then passed information to the next via printouts, email, or phone calls. There was no system automatically carrying data forward.

Root Cause 3: No Real-Time Visibility

Management could only see "snapshots of the past" in month-end reports. They never had a live view of the business, which led to slow decisions, wrong decisions, or hesitation to make decisions at all.

Root Cause 4: Risk Concentrated in Individuals

If Ms. Mam was sick, accounting close stalled. If Mr. Ek went on vacation, the warehouse couldn’t answer basic stock questions. If someone in purchasing resigned, no one knew which POs were pending follow-up.

Enersys team: "PinnacleArc’s problem wasn’t that its people lacked capability — the team was highly capable and worked extremely hard. The issue was that the tools weren’t supporting them. It was like asking skilled craftsmen to build a high-rise using only hammers and nails in an era when cranes already exist."

Tradeoffs — A Serious Comparison of the Options

PinnacleArc did not choose Odoo from the start. We guided management through four options, evaluated across six criteria:

Option 1: Enterprise ERP (Leading Global Brand)

Pros:

• Strong global reputation and customer confidence
• Comprehensive modules for trading companies
• Excellent multi-currency support
• Thai localization available (tax, invoicing)

Cons:

• High license cost: approximately 3.5–5 million THB (52 users)
• Implementation cost: 4–8 million THB, taking 8–14 months
• Annual maintenance: 18–22% of license cost
• Separate consultants required for customization
• Expensive post-go-live changes

Assessment: Over PinnacleArc’s budget (set at 3 million THB) and too slow to implement.

Option 2: Cloud Subscription ERP (Global Vendor)

Pros:

• Cloud-native, no server maintenance required
• Built-in multi-subsidiary and multi-currency capabilities
• Powerful dashboards and analytics
• Well suited for trading and distribution

Cons:

• Subscription cost: approximately 2.8–4 million THB/year (per-user pricing)
• Implementation: 3–6 million THB, taking 6–10 months
• Data hosted overseas, which may raise compliance concerns
• Costs rise linearly as user count increases
• Limited Thai-language support

Assessment: Annual cost was too high for a 52-person company.

Option 3: Keep Excel and Add Point Solutions

Pros:

• Minimal change to existing workflows
• Lower cost (buy software only where needed)
• Can be used immediately without waiting for a long implementation

Cons:

• Treats symptoms, not root causes
• Data remains fragmented across systems
• Integrations between tools must be built manually
• Likely to return to the same problems in 2–3 years
• No single source of truth

Assessment: Mr. Wichai rejected this option himself — "I don’t want to patch the same problem and wait for it to explode again."