| Period | Account | USALI dept | Subcategory | Lines | Gross $ ▼ | Net $ | First | Last |
|---|---|---|---|---|---|---|---|---|
| 2026-04 | FOOD COST607100 | F&B | Cost of Sales | 1 | $252 | $252 | 2026-04-08 | 2026-04-08 |
| 2026-02 | FOOD COST607100 | F&B | Cost of Sales | 3 | $238 | $238 | 2026-02-11 | 2026-02-25 |
| 2026-03 | FOOD COST607100 | F&B | Cost of Sales | 3 | $107 | $107 | 2026-03-31 | 2026-03-31 |
| 2026-03 | LOSS EXCHANGE RATE663100 | Undistributed | FX Gain/Loss | 1 | $5 | −$5 | 2026-03-25 | 2026-03-25 |
| Account | Gross $ | % of vendor spend ▼ |
|---|---|---|
| LOSS EXCHANGE RATE663100 | $5 | 1% |
| Date ▼ | Type | QB # | Account | USALI | Memo | Native | USD |
|---|---|---|---|---|---|---|---|
| 2026-04-08 | Bill | INV-26/NAMKA-00007 | FOOD COST607100 | Cost of Sales | INV-26/NAMKA-00007 (8.734 THB) | — | $252 |
| 2026-03-31 | Bill | March.2026 | FOOD COST607100 | Cost of Sales | INV-26/NAMKA-00004 (448.8 THB) | — | $13 |
| 2026-03-31 | Bill | March.2026 | FOOD COST607100 | Cost of Sales | INV-26/NAMKA-00005 (2,832.5 THB) | — | $82 |
| 2026-03-31 | Bill | March.2026 | FOOD COST607100 | Cost of Sales | INV-26/NAMKA-00006 (4,21.3 THB) | — | $12 |
| 2026-03-25 | Bill Payment (Cheque) | 801 | LOSS EXCHANGE RATE663100 | FX Gain/Loss | Exchange Gain Or Loss | — | −$5 |
| 2026-02-25 | Bill | — | FOOD COST607100 | Cost of Sales | 2kg Butter Sheet Croissant) | — | $33 |
| 2026-02-18 | Bill | INV-26/NAMKA-00002 | FOOD COST607100 | Cost of Sales | INV-26/NAMKA-00002 | — | $168 |
| 2026-02-11 | Bill | INV-26/NAMKA-00001 | FOOD COST607100 | Cost of Sales | INV-26/NAMKA-00001 | — | $36 |
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.