0
Wed 13 May
SnapshotStaffF&BSpaActivitiesEventsInventorySuppliersCatalog cleanup

Phinkham Shop

← Back to vendors
$1.1k
Gross spend
$1.1k
Net amount
15
Lines
4
Accounts
2
Classes
4
Active periods

Activity window

First txn
2026-01-03
Last txn
2026-04-24
Span
111d
Currency (guess)
USD

Account split · 10 period × account combos

PeriodAccountUSALI deptSubcategoryLinesGross $Net $FirstLast
2026-03EMPLOYEE MEAL638105UndistributedPayroll & Related3$458$4582026-03-312026-03-31
2026-01EMPLOYEE MEAL638105F&BPayroll & Related3$266$2662026-01-032026-01-28
2026-02EMPLOYEE MEAL638105F&BPayroll & Related2$217$2172026-02-282026-02-28
2026-02ANIMAL FOOD606127F&BOther Operating Expenses1$56$562026-02-282026-02-28
2026-04ANIMAL FOOD606127UndistributedOther Operating Expenses1$55$552026-04-242026-04-24
2026-01ANIMAL FOOD606127F&BOther Operating Expenses1$46$462026-01-282026-01-28
2026-02EMPLOYEE RELOCATION658114F&BPayroll & Related1$8$82026-02-282026-02-28
2026-03ANIMAL FOOD606127UndistributedOther Operating Expenses1$7$72026-03-312026-03-31
2026-02LOSS EXCHANGE RATE663100UndistributedFX Gain/Loss1$5$52026-02-182026-02-18
2026-01LOSS EXCHANGE RATE663100UndistributedFX Gain/Loss1$4$42026-01-242026-01-24

Anomalies · 2 flagged

AccountGross $% of vendor spend
LOSS EXCHANGE RATE663100$101%
EMPLOYEE RELOCATION658114$81%

Transactions · last 15 (cap 500)

DateTypeQB #AccountUSALIMemoNativeUSD
2026-04-24Bill24/04/2026ANIMAL FOOD606127Other Operating Expenses1Sack Stream rice for dog$55
2026-03-31BillMarch.2026EMPLOYEE MEAL638105Payroll & RelatedBill 4/3/26 "5Sack Sticky rice$207
2026-03-31BillMarch.2026EMPLOYEE MEAL638105Payroll & RelatedBill 4/3/26 "5Sack Sticky rice$196
2026-03-31BillMarch.2026ANIMAL FOOD606127Other Operating ExpensesBill 20/3/26 "10Kg Rice for Animal$7
2026-03-31BillMarch.2026EMPLOYEE MEAL638105Payroll & RelatedBill 26/3/26 "1Sacke Steam rice"$55
2026-02-28BillFeb.2026ANIMAL FOOD606127Other Operating ExpensesBill Date 24/2/2026 (50Kg Stream rice for Dog$56
2026-02-28BillFeb.2026EMPLOYEE MEAL638105Payroll & RelatedBill Date 14/2/2026 (250Kg Sticky rice & 7Kg Stream rice for Staff$207
2026-02-28BillFeb.2026EMPLOYEE MEAL638105Payroll & RelatedBill Date 20/2/2026 (2 Sack Charcoal$10
2026-02-28BillFeb.2026EMPLOYEE RELOCATION658114Payroll & RelatedBill Date 20/2/2026 (Soft drink for Staff during Chinses new year)$8
2026-02-18Bill Payment (Cheque)2602012LOSS EXCHANGE RATE663100FX Gain/LossExchange Gain Or Loss$5
2026-01-28Bill26-28 Jan.2026EMPLOYEE MEAL638105Payroll & Related250Kg Sticky rice for Staff$196
2026-01-28Bill26-28 Jan.2026ANIMAL FOOD606127Other Operating Expenses50Kg Stream rice for Dog$46
2026-01-28Bill26-28 Jan.2026EMPLOYEE MEAL638105Payroll & Related2Sack Charcoal$10
2026-01-24Bill Payment (Cheque)144LOSS EXCHANGE RATE663100FX Gain/LossExchange Gain Or Loss$4
2026-01-03ExpenseEMPLOYEE MEAL638105Payroll & Related$60
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.