| Period | Account | USALI dept | Subcategory | Lines | Gross $ ▼ | Net $ | First | Last |
|---|---|---|---|---|---|---|---|---|
| 2026-02 | BEVERAGE COST607200 | F&B | Cost of Sales | 4 | $540 | $540 | 2026-02-02 | 2026-02-23 |
| 2026-01 | BEVERAGE COST607200 | F&B | Cost of Sales | 1 | $368 | $368 | 2026-01-20 | 2026-01-20 |
| 2026-03 | FOOD COST607100 | F&B | Cost of Sales | 2 | $35 | $35 | 2026-03-14 | 2026-03-14 |
| 2026-03 | LOSS EXCHANGE RATE663100 | Undistributed | FX Gain/Loss | 1 | $4 | $4 | 2026-03-12 | 2026-03-12 |
| 2026-04 | LOSS EXCHANGE RATE663100 | Undistributed | FX Gain/Loss | 1 | $1 | −$1 | 2026-04-15 | 2026-04-15 |
| Account | Gross $ | % of vendor spend ▼ |
|---|---|---|
| FOOD COST607100 | $35 | 4% |
| LOSS EXCHANGE RATE663100 | $4 | 0% |
| Date ▼ | Type | QB # | Account | USALI | Memo | Native | USD |
|---|---|---|---|---|---|---|---|
| 2026-04-15 | Bill Payment (Cheque) | 2604017 | LOSS EXCHANGE RATE663100 | FX Gain/Loss | Exchange Gain Or Loss | — | −$1 |
| 2026-03-14 | Bill | CO246 | FOOD COST607100 | Cost of Sales | 1Box White wine for KC | — | $19 |
| 2026-03-14 | Bill | CO246 | FOOD COST607100 | Cost of Sales | 1Box Red wine for KC | — | $16 |
| 2026-03-12 | Bill Payment (Cheque) | 838 | LOSS EXCHANGE RATE663100 | FX Gain/Loss | Exchange Gain Or Loss | — | $4 |
| 2026-02-23 | Bill | CO241 | BEVERAGE COST607200 | Cost of Sales | 4Pack Perrier Water 330ml | — | $235 |
| 2026-02-23 | Bill | CO241 | BEVERAGE COST607200 | Cost of Sales | 8Pack Soda Thai | — | $124 |
| 2026-02-14 | Bill | CO237 | BEVERAGE COST607200 | Cost of Sales | 1Pack Soda Thai | — | $16 |
| 2026-02-02 | Bill | CO234 | BEVERAGE COST607200 | Cost of Sales | 3Case Evian Water 750ml | — | $166 |
| 2026-01-20 | Expense | — | BEVERAGE COST607200 | Cost of Sales | 5Case Evian Water 330mml | — | $368 |
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.