| Period | Account | USALI dept | Subcategory | Lines | Gross $ ▼ | Net $ | First | Last |
|---|---|---|---|---|---|---|---|---|
| 2026-02 | FOOD COST607100 | F&B | Cost of Sales | 4 | $342 | $342 | 2026-02-12 | 2026-02-21 |
| 2026-03 | FOOD COST607100 | F&B | Cost of Sales | 1 | $128 | $128 | 2026-03-02 | 2026-03-02 |
| 2026-05 | FOOD COST607100 | F&B | Cost of Sales | 1 | $95 | $95 | 2026-05-01 | 2026-05-01 |
| 2026-02 | LOSS EXCHANGE RATE663100 | Undistributed | FX Gain/Loss | 1 | $4 | $4 | 2026-02-13 | 2026-02-13 |
| Account | Gross $ | % of vendor spend ▼ |
|---|---|---|
| LOSS EXCHANGE RATE663100 | $4 | 1% |
| Date ▼ | Type | QB # | Account | USALI | Memo | Native | USD |
|---|---|---|---|---|---|---|---|
| 2026-05-01 | Bill | 1/5/26 | FOOD COST607100 | Cost of Sales | 2.62 Kg Smoke Salmon | — | $95 |
| 2026-03-02 | Bill | 2338 | FOOD COST607100 | Cost of Sales | 2.76 Kg Smoke Salmon | — | $128 |
| 2026-02-21 | Bill | 1666 | FOOD COST607100 | Cost of Sales | 2.275kg Smoke Salmon | — | $131 |
| 2026-02-18 | Bill | 1657 | FOOD COST607100 | Cost of Sales | 3Kg Beef mince for Burgur | — | $28 |
| 2026-02-13 | Bill Payment (Cheque) | 2602028 | LOSS EXCHANGE RATE663100 | FX Gain/Loss | Exchange Gain Or Loss | — | $4 |
| 2026-02-12 | Bill | 2324 | FOOD COST607100 | Cost of Sales | 2.15kg Beef tenderlion | — | $94 |
| 2026-02-12 | Bill | 2324 | FOOD COST607100 | Cost of Sales | 2.43kg Smoke Salmon | — | $89 |
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.