ERPNext Implementation in Colombo
ERPNext Implementation in Colombo
Your cost does not begin at the supplier’s invoice. It begins there and keeps moving, through freight, duty, levies and clearing, and through an exchange rate that changes between the day you order and the day you pay.
Merchandise imports of US dollars 18,841 million, a trade deficit of US dollars 6,069 million and the year-end exchange rate from the Central Bank of Sri Lanka’s External Sector Performance, December 2024 (released 31 January 2025). National figures. Source checked July 2026.
The Central Bank of Sri Lanka records US dollars 18,841 million of merchandise imports in 2024 against US dollars 12,772 million of exports, a trade deficit of US dollars 6,069 million. Colombo is where most of that lands and clears. The point that decides the ERP is quieter than the deficit: the country’s largest export, textiles and garments at US dollars 5,061 million, is built on US dollars 2,847 million of imported fabric and yarn. For a great many businesses here the export order is an import order first, and landed cost and the exchange rate sit upstream of every price you quote.
What an ERPNext implementation in Colombo has to solve
Start with landed cost, because it is the number most systems get wrong. The price on the supplier’s invoice is a fraction of what the goods actually cost you on the shelf. Freight, insurance, customs duty, CESS, the Ports and Airports Development Levy, other para-tariffs, clearing, transport and any demurrage all belong to that receipt, and they have to be apportioned across the items in it on a sensible basis, usually value or weight. Until that is done, your margin on an imported line is a guess, and it is almost always a flattering one.
The second is foreign exchange, and it is not an accounting footnote here. The rate moves between the day you raise the order, the day you settle the letter of credit or the supplier invoice, and the day the goods arrive. In 2024 alone the rupee went from Rs 323.92 to Rs 292.58 against the dollar and then reversed into 2025. The system has to purchase in the supplier’s currency, hold the payable in that currency, and recognise the exchange gain or loss on settlement as its own figure, not smear it into the cost of the goods where it quietly distorts every margin that follows.
The third is documentation and credit. Imports run on letters of credit, on documents against payment or acceptance, and on supplier credit denominated in foreign currency. The customs declaration, the supplier invoice and the goods received have to reconcile to each other, and you need to see your foreign-currency exposure and your import pipeline before the next payment falls due, not after the rate has already moved against you.
Landed cost, built up not guessed
Freight, duty, CESS, PAL, clearing and transport apportioned across the items on each import receipt, so the cost you value and price against is what the goods actually cost you, not the invoice line.
The rate moves three times
Purchase in the supplier’s currency, hold the payable in it, and recognise the exchange gain or loss between order, payment and receipt as a distinct figure rather than hiding it inside item cost.
Duty and levies are cost, not overhead
Import duty, para-tariffs and clearing charges attach to the goods that bore them. Dropped into a general expense account, they vanish from the product margin that is supposed to carry them.
Foreign-currency payables you can see
Letters of credit, supplier credit and the customs declaration tied to the purchase and the receipt, with exposure by currency visible before the next settlement, not reconstructed afterwards.
How we deliver in Colombo
We start with the item master and the landed-cost model, because everything downstream depends on it. Purchase currencies, the charges that make up landed cost and the basis on which they are apportioned, and the accounts that carry duty, levies and exchange differences. This looks like configuration housekeeping and it is the whole project: get the cost build-up wrong and every valuation, margin and price report afterwards is quietly incorrect.
Then the import cycle itself: multi-currency purchase orders, the letter of credit and payment terms, customs and clearing charges captured against the shipment, and reconciliation of the customs declaration, the supplier invoice and the goods received. Reporting on exposure, on the import pipeline and on true landed margin comes last, once the transactions underneath it are honest.
Typical delivery phases for a Colombo implementation
| Phase | What happens | Why it comes here |
|---|---|---|
| 1. Discovery | Map your import currencies, the full set of charges that make up landed cost, your LC and credit terms, and how customs clearing reaches your books. | Charge structures and para-tariffs differ by product and by trade. Assuming a standard build-up would misstate every cost. |
| 2. Items and costing | Item master with purchase currencies, the landed-cost template and apportionment basis, and the accounts for duty, levies and exchange differences. | The entire margin picture rests on this, so it is agreed and built before transactions start. |
| 3. Import cycle | Multi-currency purchase orders, LC and payment terms, customs and clearing charges against the shipment, and CusDec to invoice to receipt reconciliation. | Needs a trustworthy cost model underneath before the numbers it produces mean anything. |
| 4. Exposure and margin | Foreign-currency payables and exposure, import pipeline, and true landed margin by product and by shipment. | Reporting is only worth trusting once landed cost and exchange handling underneath it are correct. |
We avoid go-live in a peak import or LC-settlement window, and around a financial year end. A new system, a shipment clearing and a payment falling due in the same week is a risk with no upside, and the peak is exactly when the old spreadsheet’s gaps are least visible.
Are you ready? A short readiness check
- Do you know the true landed cost of an imported line, or only the supplier’s invoice price plus a rule of thumb?
- Are duty, CESS, PAL and clearing apportioned to the goods that bore them, or booked to a general expense account?
- Do you hold your supplier payables in the currency you owe, or converted to rupees on day one?
- Can you see your foreign-currency exposure before the next payment falls due?
- Do the customs declaration, the supplier invoice and the goods received reconcile to each other in one place?
Four or five clear answers means you mostly need a system that keeps a discipline you already have. Two or fewer means the first phase is agreeing your landed-cost build-up and your currency handling, and doing that properly is the difference between a margin you trust and one the exchange rate quietly rewrites.
Frequently asked questions
Can ERPNext calculate landed cost on imports?
Yes. Additional charges such as freight, insurance, duty, CESS, PAL and clearing are added to a receipt and apportioned across its items by value or quantity, so the goods are valued and priced at what they actually cost you rather than at the invoice line.
How does it handle foreign-currency purchasing?
Purchase orders and invoices are raised in the supplier’s currency, the payable is held in that currency, and the exchange gain or loss is recognised on settlement as its own entry. The rate on the day of the transaction and the day of payment are both kept, so the difference is a figure you can see.
Can it deal with letters of credit and import documentation?
The payment terms, the supplier credit and the charges tied to a shipment are held against the purchase, so the letter of credit, the customs declaration and the goods received can be reconciled in one place. The bank instrument itself stays with your bank; the ERP keeps the numbers that must match it.
Does it show my foreign-currency exposure?
Payables can be reported by currency, so you can see what you owe in dollars or euros before the next settlement rather than discovering the effect of a rate move after it has landed in your accounts.
How long does an ERPNext implementation take for an importer in Colombo?
Ten to sixteen weeks for a single importing and distribution business with a settled landed-cost model. Longer where manufacturing from imported material is also in scope, or where charge structures differ widely across product lines, which is common and is time well spent.
Key takeaways for Colombo businesses
- Landed cost, not the invoice, is what an imported line actually cost you. Apportion freight, duty and levies onto the receipt or your margin is fiction.
- The exchange rate moves between order, payment and receipt. Hold the payable in its currency and recognise the difference as its own figure.
- Duty, CESS, PAL and clearing belong to the goods that bore them. Booked to overhead, they disappear from the product margin that should carry them.
- For many Colombo businesses the export order is an import order first. Landed cost and forex sit upstream of every price you quote.
Planning ERPNext for an importer or distributor in Colombo?
Start your ERPNext implementation with a team that will settle landed cost and currency handling before it prints a margin report. KlyONIX Tech™ is a Frappe Certified Partner with offices in Pollachi and Chennai, delivering, onboarding and supporting clients in Sri Lanka remotely.
Merchandise imports, exports and the trade deficit for 2024, the textiles and garments export and imported textile figures, and the year-end US dollar exchange rate are all from the Central Bank of Sri Lanka’s External Sector Performance, December 2024, released 31 January 2025: imports US dollars 18,841 million, exports US dollars 12,772 million, deficit US dollars 6,069 million, textiles and garments exports US dollars 5,061 million against imported textiles of US dollars 2,847 million, and the rupee at Rs 292.58 per US dollar at end 2024 from Rs 323.92 a year earlier. These are national figures; Colombo is where the great majority of the country’s import trade clears rather than the whole of it. Source checked July 2026.
ERPNext in Chennai · ERPNext in Kandy · ERPNext in Jaffna · ERPNext implementation cost