Ty-Van Shop

← Back to vendors

$2.2k

Gross spend

$2.2k

Net amount

Lines

Accounts

Classes

Active periods

Activity window

First txn

2026-02-28

Last txn

2026-04-27

Span

58d

Currency (guess)

USD

Account split · 16 period × account combos

Period	Account	USALI dept	Subcategory	Lines	Gross $ ▼	Net $	First	Last
2026-02	MAINTENANCE - ELECTRICAL SYSTEM614102	Undistributed	POM	1	$535	$535	2026-02-28	2026-02-28
2026-04	MAINTENANCE - ELECTRICAL SYSTEM614102	Undistributed	POM	2	$383	$383	2026-04-06	2026-04-22
2026-03	MAINTENANCE - PLUMBING & HEATING614114	Undistributed	POM	6	$343	$343	2026-03-03	2026-03-15
2026-03	MAINTENANCE - ELECTRICAL SYSTEM614102	Undistributed	POM	9	$268	$268	2026-03-03	2026-03-14
2026-04	MAINTENANCE - FURNITURE / FIXTURE614107	Undistributed	POM	5	$251	$251	2026-04-20	2026-04-20
2026-03	MAINTENANCE - GROUND & LANDSCAPING614108	Undistributed	POM	1	$127	$127	2026-03-19	2026-03-19
2026-02	MAINTENANCE - PAINTING614113	Undistributed	POM	1	$72	$72	2026-02-28	2026-02-28
2026-02	MAINTENANCE - GROUND & LANDSCAPING614108	Undistributed	POM	1	$65	$65	2026-02-28	2026-02-28
2026-04	MAINTENANCE - PAINTING614113	Undistributed	POM	3	$52	$52	2026-04-20	2026-04-27
2026-04	MAINTENANCE - GROUND & LANDSCAPING614108	Undistributed	POM	2	$44	$44	2026-04-22	2026-04-27
2026-03	MAINTENANCE - FURNITURE / FIXTURE614107	Undistributed	POM	3	$21	$21	2026-03-04	2026-03-26
2026-03	MAINTENANCE - DOOR & LOCK614111	Undistributed	POM	1	$18	$18	2026-03-18	2026-03-18
2026-04	MAINTENANCE - BUILDING614101	Undistributed	POM	1	$17	$17	2026-04-10	2026-04-10
2026-04	LOSS EXCHANGE RATE663100	Undistributed	FX Gain/Loss	1	$16	−$16	2026-04-15	2026-04-15
2026-04	HOUSING EXPENCES638101	Undistributed	Payroll & Related	1	$3	$3	2026-04-06	2026-04-06
2026-03	LOSS EXCHANGE RATE663100	Undistributed	FX Gain/Loss	1	$0	−$0	2026-03-14	2026-03-14

Anomalies · 4 flagged

Account	Gross $	% of vendor spend ▼
MAINTENANCE - DOOR & LOCK614111	$18	1%
MAINTENANCE - BUILDING614101	$17	1%
LOSS EXCHANGE RATE663100	$16	1%
HOUSING EXPENCES638101	$3	0%

Transactions · last 39 (cap 500)

Date ▼	Type	QB #	Account	USALI	Memo	Native	USD
2026-04-27	Bill	27/4/26	MAINTENANCE - PAINTING614113	POM	Paint for Pool	—	$8
2026-04-27	Bill	27/4/26	MAINTENANCE - GROUND & LANDSCAPING614108	POM	10pcs Springler for Garden	—	$5
2026-04-22	Bill	22/4/26	MAINTENANCE - ELECTRICAL SYSTEM614102	POM	—	—	$174
2026-04-22	Bill	22/4/26	MAINTENANCE - GROUND & LANDSCAPING614108	POM	—	—	$40
2026-04-20	Bill	20/4/26	MAINTENANCE - FURNITURE / FIXTURE614107	POM	3box Max F50	—	$4
2026-04-20	Bill	20/4/26	MAINTENANCE - FURNITURE / FIXTURE614107	POM	15Box Max F30	—	$19
2026-04-20	Bill	20/4/26	MAINTENANCE - PAINTING614113	POM	Termite Paint	—	$17
2026-04-20	Bill	20/4/26	MAINTENANCE - PAINTING614113	POM	Paint u90-409	—	$27
2026-04-20	Bill	20/4/26	MAINTENANCE - FURNITURE / FIXTURE614107	POM	Paint DD99-102	—	$61
2026-04-20	Bill	20/4/26	MAINTENANCE - FURNITURE / FIXTURE614107	POM	Paint BL	—	$15
2026-04-20	Bill	20/4/26	MAINTENANCE - FURNITURE / FIXTURE614107	POM	Paint	—	$152
2026-04-15	Bill Payment (Cheque)	2604016	LOSS EXCHANGE RATE663100	FX Gain/Loss	Exchange Gain Or Loss	—	−$16
2026-04-10	Bill	10/4/2026	MAINTENANCE - BUILDING614101	POM	Termite Paint for Restaurant	—	$17
2026-04-06	Bill	6/4/26	MAINTENANCE - ELECTRICAL SYSTEM614102	POM	Billl 6/4/26	—	$209
2026-04-06	Bill	6/4/26	HOUSING EXPENCES638101	Payroll & Related	Paint for Pool	—	$3
2026-03-26	Bill	26/3/26	MAINTENANCE - FURNITURE / FIXTURE614107	POM	Window mosquito net & Door rubber	—	$9
2026-03-19	Bill	19/3/26	MAINTENANCE - GROUND & LANDSCAPING614108	POM	2Roll Water Pipe for Gardener	—	$127
2026-03-18	Bill	18/3/26	MAINTENANCE - DOOR & LOCK614111	POM	Material Door net for ACC office	—	$18
2026-03-15	Bill	15/3/26	MAINTENANCE - PLUMBING & HEATING614114	POM	Material for fix water	—	$151
2026-03-14	Bill	14/3/26	MAINTENANCE - ELECTRICAL SYSTEM614102	POM	8pcs LED 18W	—	$26
2026-03-14	Bill	14/3/26	MAINTENANCE - ELECTRICAL SYSTEM614102	POM	5pcs Electric Pipe	—	$4
2026-03-14	Bill	14/3/26	MAINTENANCE - ELECTRICAL SYSTEM614102	POM	3pcs LED 10w	—	$17
2026-03-14	Bill	14/3/26	MAINTENANCE - ELECTRICAL SYSTEM614102	POM	3pcs Electric tape	—	$4
2026-03-14	Bill	14/3/26	LOSS EXCHANGE RATE663100	FX Gain/Loss	Exchange Gain Or Loss	—	−$0
2026-03-14	Bill	14/3/26	MAINTENANCE - ELECTRICAL SYSTEM614102	POM	Black Srew	—	$2
2026-03-14	Bill	14/3/26	MAINTENANCE - ELECTRICAL SYSTEM614102	POM	Plastic anchor	—	$1
2026-03-09	Bill	9/3/26	MAINTENANCE - PLUMBING & HEATING614114	POM	Bill no 9/3/26 Pipe, PVC Join	—	$150
2026-03-09	Bill	9/3/26	MAINTENANCE - PLUMBING & HEATING614114	POM	Bill no 9/3/26 Pipe, PVC Join	—	$13
2026-03-07	Bill	7/3/26	MAINTENANCE - ELECTRICAL SYSTEM614102	POM	Switch for Xaona Room	—	$5
2026-03-04	Bill	4/3/26	MAINTENANCE - FURNITURE / FIXTURE614107	POM	Window lock for acc office	—	$5
2026-03-04	Bill	4/3/26	MAINTENANCE - PLUMBING & HEATING614114	POM	Water Valve	—	$11
2026-03-04	Bill	4/3/26	MAINTENANCE - FURNITURE / FIXTURE614107	POM	Door handle	—	$8
2026-03-03	Bill	3/3/26	MAINTENANCE - PLUMBING & HEATING614114	POM	3way PVC Join	—	$3
2026-03-03	Bill	3/3/26	MAINTENANCE - ELECTRICAL SYSTEM614102	POM	Bulb 8w	—	$23
2026-03-03	Bill	3/3/26	MAINTENANCE - ELECTRICAL SYSTEM614102	POM	VCT Cable	—	$187
2026-03-03	Bill	3/3/26	MAINTENANCE - PLUMBING & HEATING614114	POM	Floating ball for Water tank	—	$15
2026-02-28	Bill	Bill Feb.2026	MAINTENANCE - GROUND & LANDSCAPING614108	POM	Bill No 23/2/2026 (Water Pipe for Gardener	—	$65
2026-02-28	Bill	Bill Feb.2026	MAINTENANCE - ELECTRICAL SYSTEM614102	POM	Bill No. 132/2026	—	$535
2026-02-28	Bill	Bill Feb.2026	MAINTENANCE - PAINTING614113	POM	Bill No 25/2/2026	—	$72

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.