| Period | Account | USALI dept | Subcategory | Lines | Gross $ ▼ | Net $ | First | Last |
|---|---|---|---|---|---|---|---|---|
| 2026-01 | BEVERAGE COST607200 | F&B | Cost of Sales | 1 | $312 | $312 | 2026-01-28 | 2026-01-28 |
| 2026-04 | BEVERAGE COST607200 | F&B | Cost of Sales | 3 | $159 | $159 | 2026-04-18 | 2026-04-18 |
| 2026-04 | LOSS EXCHANGE RATE663100 | Undistributed | FX Gain/Loss | 2 | $3 | −$3 | 2026-04-18 | 2026-04-18 |
| Account | Gross $ | % of vendor spend ▼ |
|---|---|---|
| LOSS EXCHANGE RATE663100 | $3 | 1% |
| Date ▼ | Type | QB # | Account | USALI | Memo | Native | USD |
|---|---|---|---|---|---|---|---|
| 2026-04-18 | Bill | QU26040076 | BEVERAGE COST607200 | Cost of Sales | Beer Corona Extra (CTN) 24x330ml Case | — | $36 |
| 2026-04-18 | Bill | QU26040076 | BEVERAGE COST607200 | Cost of Sales | Memoro Piccini 2019 6x75cl 6Btl | — | $92 |
| 2026-04-18 | Bill | QU26040076 | BEVERAGE COST607200 | Cost of Sales | Smirnoff Vodka Red 12x1L 2Btl | — | $31 |
| 2026-04-18 | Bill | QU26040076 | LOSS EXCHANGE RATE663100 | FX Gain/Loss | Exchange Gain Or Loss | — | $0 |
| 2026-04-18 | Bill Payment (Cheque) | 2604027 | LOSS EXCHANGE RATE663100 | FX Gain/Loss | Exchange Gain Or Loss | — | −$3 |
| 2026-01-28 | Expense | — | BEVERAGE COST607200 | Cost of Sales | Cloud 9 QU26010148 wine x 17 bottles | — | $312 |
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.