D&T Supper Market

← Back to vendors

$1.3k

Gross spend

$1.3k

Net amount

Lines

Accounts

Classes

Active periods

Activity window

First txn

2026-03-09

Last txn

2026-04-17

Span

39d

Currency (guess)

USD

Account split · 16 period × account combos

Period	Account	USALI dept	Subcategory	Lines	Gross $ ▼	Net $	First	Last
2026-03	BEVERAGE COST607200	F&B	Cost of Sales	2	$401	$401	2026-03-09	2026-03-14
2026-04	FOOD COST607100	F&B	Cost of Sales	6	$286	$286	2026-04-03	2026-04-17
2026-04	BEVERAGE COST607200	F&B	Cost of Sales	1	$196	$196	2026-04-10	2026-04-10
2026-03	FOOD COST607100	F&B	Cost of Sales	3	$111	$111	2026-03-19	2026-03-26
2026-04	CLEANING SUPPLIES606126	Rooms	Other Operating Expenses	3	$92	$92	2026-04-03	2026-04-03
2026-03	CLEANING SUPPLIES606126	F&B	Other Operating Expenses	1	$55	$55	2026-03-09	2026-03-09
2026-03	CLEANING SUPPLIES606126	Rooms	Other Operating Expenses	2	$38	$38	2026-03-09	2026-03-26
2026-04	UTENSIL - EQUIPMENT658101	F&B	Other Operating Expenses	5	$26	$26	2026-04-03	2026-04-03
2026-03	Guest Supply606137	Rooms	Other Operating Expenses	1	$24	$24	2026-03-09	2026-03-09
2026-04	GUEST LINEN LAUNDRY & CLEANING628513	Rooms	Other Operating Expenses	2	$20	$20	2026-04-03	2026-04-03
2026-04	LOSS EXCHANGE RATE663100	Undistributed	FX Gain/Loss	2	$13	−$13	2026-04-06	2026-04-17
2026-04	COST OF SPA TREATMENT606103	Spa	Cost of Sales	3	$12	$12	2026-04-06	2026-04-06
2026-04	Guest Supply606137	Rooms	Other Operating Expenses	1	$5	$5	2026-04-03	2026-04-03
2026-04	OPERATING SUPPLIES606123	F&B	Other Operating Expenses	1	$3	$3	2026-04-03	2026-04-03
2026-04	PRINTING & STATIONERY SUPPLIES606122	Spa	Other Operating Expenses	1	$3	$3	2026-04-06	2026-04-06
2026-03	LOSS EXCHANGE RATE663100	Undistributed	FX Gain/Loss	1	$0	−$0	2026-03-09	2026-03-09

Anomalies · 7 flagged

Account	Gross $	% of vendor spend ▼
Guest Supply606137	$29	2%
UTENSIL - EQUIPMENT658101	$26	2%
GUEST LINEN LAUNDRY & CLEANING628513	$20	2%
LOSS EXCHANGE RATE663100	$13	1%
COST OF SPA TREATMENT606103	$12	1%
OPERATING SUPPLIES606123	$3	0%
PRINTING & STATIONERY SUPPLIES606122	$3	0%

Transactions · last 35 (cap 500)

Date ▼	Type	QB #	Account	USALI	Memo	Native	USD
2026-04-17	Bill Payment (Cheque)	2604003	LOSS EXCHANGE RATE663100	FX Gain/Loss	Exchange Gain Or Loss	—	−$13
2026-04-17	Bill	03260418397	FOOD COST607100	Cost of Sales	03260418397	—	$25
2026-04-16	Bill	03260417952	FOOD COST607100	Cost of Sales	03260417952	—	$107
2026-04-16	Bill	03260418060	FOOD COST607100	Cost of Sales	03260418060	—	$90
2026-04-10	Bill	03260415445	FOOD COST607100	Cost of Sales	03260415445	—	$4
2026-04-10	Bill	03260415337	BEVERAGE COST607200	Cost of Sales	03260415337	—	$196
2026-04-06	Bill	OL260000026	COST OF SPA TREATMENT606103	Cost of Sales	Face mark	—	$6
2026-04-06	Bill	OL260000026	PRINTING & STATIONERY SUPPLIES606122	Other Operating Expenses	Book	—	$3
2026-04-06	Bill	OL260000026	COST OF SPA TREATMENT606103	Cost of Sales	Face mark	—	$3
2026-04-06	Bill	OL260000026	LOSS EXCHANGE RATE663100	FX Gain/Loss	Exchange Gain Or Loss	—	−$0
2026-04-06	Bill	OL260000026	COST OF SPA TREATMENT606103	Cost of Sales	Face mark	—	$3
2026-04-04	Bill	03260413495	FOOD COST607100	Cost of Sales	03260413495	—	$42
2026-04-03	Bill	03260413207	UTENSIL - EQUIPMENT658101	Other Operating Expenses	1pcs Plastic bow	—	$2
2026-04-03	Bill	03260413206	CLEANING SUPPLIES606126	Other Operating Expenses	12Btl Toilet chemical	—	$17
2026-04-03	Bill	03260413206	CLEANING SUPPLIES606126	Other Operating Expenses	6Can Mosquitos spray	—	$21
2026-04-03	Bill	03260413206	CLEANING SUPPLIES606126	Other Operating Expenses	12Can Mosquito spray	—	$55
2026-04-03	Bill	03260413206	Guest Supply606137	Other Operating Expenses	5bag Sugar for Room	—	$5
2026-04-03	Bill	03260413206	GUEST LINEN LAUNDRY & CLEANING628513	Other Operating Expenses	Detergent for HK	—	$15
2026-04-03	Bill	03260413206	GUEST LINEN LAUNDRY & CLEANING628513	Other Operating Expenses	1Btl Softener for HK	—	$5
2026-04-03	Bill	03260413207	UTENSIL - EQUIPMENT658101	Other Operating Expenses	1pcs Plastic bow	—	$2
2026-04-03	Bill	03260413207	FOOD COST607100	Cost of Sales	2Btl Whipping Cream	—	$18
2026-04-03	Bill	03260413207	OPERATING SUPPLIES606123	Other Operating Expenses	5box Birth day Candle	—	$3
2026-04-03	Bill	03260413207	UTENSIL - EQUIPMENT658101	Other Operating Expenses	1pcs Knife	—	$16
2026-04-03	Bill	03260413207	UTENSIL - EQUIPMENT658101	Other Operating Expenses	5pcs Hand Cloth	—	$6
2026-04-03	Bill	03260413207	UTENSIL - EQUIPMENT658101	Other Operating Expenses	1pcs Plastic bow (Small)	—	$1
2026-03-26	Bill	3206311368	CLEANING SUPPLIES606126	Other Operating Expenses	Bill# 3206311368	—	$8
2026-03-26	Bill	03260311364	FOOD COST607100	Cost of Sales	2Pack Yghhurt	—	$5
2026-03-23	Bill	3260310062	FOOD COST607100	Cost of Sales	Bill# 3260310062	—	$5
2026-03-19	Bill	3260338463	FOOD COST607100	Cost of Sales	Bill# 3260338463	—	$101
2026-03-14	Bill	260028679	BEVERAGE COST607200	Cost of Sales	Bill# 260028679	—	$337
2026-03-09	Bill	326034480	BEVERAGE COST607200	Cost of Sales	5kg Butter Allowie	—	$64
2026-03-09	Bill	326034480	LOSS EXCHANGE RATE663100	FX Gain/Loss	Exchange Gain Or Loss	—	−$0
2026-03-09	Bill	326034480	CLEANING SUPPLIES606126	Other Operating Expenses	Spin Mop	—	$30
2026-03-09	Bill	326034480	CLEANING SUPPLIES606126	Other Operating Expenses	10Gallon Lipon F	—	$55
2026-03-09	Bill	326034480	Guest Supply606137	Other Operating Expenses	7bag Black tea	—	$24

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.