Discuss a project

DL-051 · Case study

Marketplace settlement reconciliation with Oracle NetSuite

A Colombian retail group needed reliable financial data from online marketplaces inside its central ERP.

Client
Name withheld
Location
Colombia
Industry
Multi-brand retail
Capabilities
01Audit03Build
01

Challenge

  • Marketplace payouts combined sales, fees, adjustments and refunds into complex settlement records.
  • Finance teams relied on manual spreadsheets to explain differences between orders and deposits.
02

Environment

  • Mercado Libre, Shopify and regional payment providers.
  • Oracle NetSuite, bank statement feeds and internal accounting dimensions.
03

Intervention

  • Designed ingestion processes for orders, settlements and payment records.
  • Created matching logic for transaction references, fees, refunds and payout batches.
  • Built exception reporting and controlled journal export files for finance approval.
04

Outcome

  • Financial reconciliation becomes a repeatable process with auditable exceptions.
  • Accountants can distinguish timing differences from genuine transaction discrepancies.
Orders and payment events matched to payouts before reviewed accounting exports enter NetSuite.MERCADO LIBREOrders / payoutsPAYMENTSProviders / bankMATCHINGFees / refundsEXCEPTIONSFinance reviewNETSUITEJournals
  1. 01MERCADO LIBREOrders / payoutsPAYMENTSProviders / bank
  2. 02PAYMENTSProviders / bankMATCHINGFees / refunds
  3. 03MATCHINGFees / refundsEXCEPTIONSFinance review
  4. 04EXCEPTIONSFinance reviewNETSUITEJournals
Fig. 01Settlement reconciliationOrders and payment events matched to payouts before reviewed accounting exports enter NetSuite.Scale NTS

Stack and services.

Stack03

  • Oracle NetSuite
  • Shopify
  • Mercado Libre

Services used01

Tell us what has to work.

A senior engineer reads every brief. Describe the system, what it runs on today and what happens when it fails.

Discuss a project