0
Wed 13 May
SnapshotStaffF&BSpaActivitiesEventsInventorySuppliersCatalog cleanup

Lijun Shop

← Back to vendors
$322
Gross spend
$309
Net amount
4
Lines
2
Accounts
1
Classes
2
Active periods

Activity window

First txn
2026-03-17
Last txn
2026-04-03
Span
17d
Currency (guess)
USD

Account split · 2 period × account combos

PeriodAccountUSALI deptSubcategoryLinesGross $ ▼Net $FirstLast
2026-03MAINTENANCE - BUILDING614101UndistributedPOM3$315$3152026-03-172026-03-17
2026-04LOSS EXCHANGE RATE663100UndistributedFX Gain/Loss1$7−$72026-04-032026-04-03

Anomalies · 1 flagged

AccountGross $% of vendor spend ▼
LOSS EXCHANGE RATE663100$72%

Transactions · last 4 (cap 500)

Date ▼TypeQB #AccountUSALIMemoNativeUSD
2026-04-03Bill Payment (Cheque)791LOSS EXCHANGE RATE663100FX Gain/LossExchange Gain Or Loss—−$7
2026-03-17Bill17/3/26MAINTENANCE - BUILDING614101POMMetal for Tent Rails—$10
2026-03-17Bill17/3/26MAINTENANCE - BUILDING614101POMMetal for Office door net & Window—$71
2026-03-17Bill17/3/26MAINTENANCE - BUILDING614101POMMetal for Tent Rails—$235
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.