Trading Company: Migrating from Spreadsheets & Legacy Accounting to ERPNext

Business Challenge

A wholesale trading and distribution company was running on a combination of spreadsheets and an aging desktop accounting package. Sales quotes and orders were prepared in spreadsheets, stock across warehouses was tracked in separate workbooks, and only invoices and payments reached the accounting system. Imports in foreign currencies and landed costs were calculated by hand.

The business had grown its product range and customer base, and the old setup was struggling. Stock figures disagreed between warehouses and the accounts, customer credit was hard to control, and management had no timely view of margins by product or customer.

Pain Points

• Stock tracked in spreadsheets per warehouse with frequent mismatches
• Landed costs on imports calculated manually
• No control of customer credit limits at order entry
• Price lists maintained in several versions
• Legacy accounting package with limited reporting
• Margins by product and customer not visible
• Duplicate data entry between sales, stores and accounts

Requirement Analysis

I mapped the core trading flows with the sales, purchasing, warehouse and accounts teams: quotation to order to delivery to invoice to collection, and supplier quotation to purchase order to import receipt to payment. I documented pricing rules, discount approvals, credit control practices and how landed costs were allocated.

Requirements centered on accurate multi-warehouse stock, item and price list management, landed cost allocation on imports, multi-currency purchasing, customer credit limits, VAT-compliant invoicing and margin reporting. Because data quality in the existing spreadsheets was uneven, a thorough migration and cleanup plan was a requirement in its own right.

Recommended Solution

After comparing options on fit, flexibility and total cost of ownership, I recommended ERPNext. Its standard selling, buying, stock and accounting modules covered most trading requirements out of the box, including multi-warehouse inventory, price lists, landed cost vouchers, multi-currency transactions and credit limits. As an open-source platform, it also gave the company control over hosting and future extensions.

The solution focused on standard features first, with light customization for print formats, approval rules and a few management reports. The migration plan was treated as a project stream of its own, covering items, customers, suppliers, open orders, stock balances and opening ledger balances.

Technology

• ERPNext Selling, Buying and Stock
• ERPNext Accounting with multi-currency
• Landed cost vouchers for imports
• Price lists and pricing rules
• Custom print formats and reports
• Data import tools for migration

Implementation Approach

1. Mapped order-to-cash and procure-to-pay flows and documented pricing, credit and landed cost rules.
2. Audited existing spreadsheets and accounting data, then defined cleanup rules for items, customers and suppliers.
3. Configured company, warehouses, chart of accounts, taxes, price lists and approval workflows in ERPNext.
4. Ran trial migrations of master data, open transactions and balances, reconciling each against legacy records.
5. Tested full trading cycles, including imports with landed costs, with the actual team.
6. Completed a stock count at cutover, loaded final balances and trained users by role.
7. Supported the first month-end close and refined reports based on management feedback.

Automation

• Pricing rules apply customer-specific prices and discounts automatically
• Credit limit checks block or flag orders for approval at entry
• Reorder levels generate material requests per warehouse
• Landed costs are allocated to item valuation on import receipts
• Overdue invoice reminders are emailed to customers on a schedule

Integrations

• Email for quotations, orders and invoices
• Bank statement import for reconciliation
• Barcode scanning for receiving and dispatch
• Spreadsheet export for management reporting

Business Outcome

Sales, purchasing, warehouses and accounts now work from the same data. Stock by warehouse matches the books, imports carry their true landed cost, and price lists are maintained in one place. Credit control happens at order entry rather than after goods have left the warehouse.

Management can see margins by product, customer and salesperson without rebuilding spreadsheets, and the accounts team no longer re-enters transactions from other teams. Retiring the legacy accounting package and the scattered workbooks gave the company a cleaner, more controlled foundation to expand its product range and customer base.