0
Wed 13 May
SnapshotStaffF&BSpaActivitiesEventsInventorySuppliersCatalog cleanup

Mr Somphone (I-Mekong)

← Back to vendors
$193
Gross spend
$185
Net amount
2
Lines
2
Accounts
2
Classes
2
Active periods

Activity window

First txn
2026-01-31
Last txn
2026-03-25
Span
53d
Currency (guess)
USD

Account split · 2 period × account combos

PeriodAccountUSALI deptSubcategoryLinesGross $Net $FirstLast
2026-01I-MEKONG SUPPLY606138Mekong CruiseOther Operating Expenses1$189$1892026-01-312026-01-31
2026-03LOSS EXCHANGE RATE663100UndistributedFX Gain/Loss1$4−$42026-03-252026-03-25

Anomalies · 1 flagged

AccountGross $% of vendor spend
LOSS EXCHANGE RATE663100$42%

Transactions · last 2 (cap 500)

DateTypeQB #AccountUSALIMemoNativeUSD
2026-03-25Bill Payment (Cheque)810LOSS EXCHANGE RATE663100FX Gain/LossExchange Gain Or Loss−$4
2026-01-31BillAug.25 - Jan.2026I-MEKONG SUPPLY606138Other Operating ExpensesExpenses Aug.2025 - jan.2026$189
Data lineage
Vendor name = raw gl.gl_entries.customer_name (QB transaction Name field). Aggregates: gl.v_supplier_overview. Splits: gl.v_supplier_vendor_account. Anomalies: gl.v_supplier_account_anomalies. Lines: gl.v_supplier_transactions (last 500 by date). No gl.vendors master join (it's empty). Curated attributes (contacts/terms/lead time) → suppliers.* Phase 2.5b.