| Period | Account | USALI dept | Subcategory | Lines | Gross $ ▼ | Net $ | First | Last |
|---|---|---|---|---|---|---|---|---|
| 2026-02 | BEVERAGE COST607200 | F&B | Cost of Sales | 3 | $137 | $137 | 2026-02-24 | 2026-02-24 |
| 2026-03 | CLEANING SUPPLIES606126 | Rooms | Other Operating Expenses | 1 | $31 | $31 | 2026-03-03 | 2026-03-03 |
| 2026-02 | FOOD COST607100 | F&B | Cost of Sales | 2 | $30 | $30 | 2026-02-24 | 2026-02-24 |
| 2026-03 | FOOD COST607100 | F&B | Cost of Sales | 1 | $13 | $13 | 2026-03-03 | 2026-03-03 |
| 2026-03 | LOSS EXCHANGE RATE663100 | Undistributed | FX Gain/Loss | 1 | $1 | −$1 | 2026-03-09 | 2026-03-09 |
| Account | Gross $ | % of vendor spend ▼ |
|---|---|---|
| LOSS EXCHANGE RATE663100 | $1 | 0% |
| Date ▼ | Type | QB # | Account | USALI | Memo | Native | USD |
|---|---|---|---|---|---|---|---|
| 2026-03-09 | Bill Payment (Cheque) | 846 | LOSS EXCHANGE RATE663100 | FX Gain/Loss | Exchange Gain Or Loss | — | −$1 |
| 2026-03-03 | Bill | 260032185 | CLEANING SUPPLIES606126 | Other Operating Expenses | 12Can mosquitos Spray | — | $31 |
| 2026-03-03 | Bill | 260032185 | FOOD COST607100 | Cost of Sales | 3bag Chia seed | — | $13 |
| 2026-02-24 | Bill | 260028682 | BEVERAGE COST607200 | Cost of Sales | 3Btl Jose Cuervo Siler 1L/Btl | — | $61 |
| 2026-02-24 | Bill | 260028682 | BEVERAGE COST607200 | Cost of Sales | 1Case Somersby Beer | — | $24 |
| 2026-02-24 | Bill | 260028680 | FOOD COST607100 | Cost of Sales | 10Kg Red Lotus Flour | — | $20 |
| 2026-02-24 | Bill | 260028682 | BEVERAGE COST607200 | Cost of Sales | 3Btl Bacardi Bianca 750ml/Btl | — | $52 |
| 2026-02-24 | Bill | 260028680 | FOOD COST607100 | Cost of Sales | 5Kg Wheat Flour Royal | — | $10 |
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.