| Period | Account | USALI dept | Subcategory | Lines | Gross $ ▼ | Net $ | First | Last |
|---|---|---|---|---|---|---|---|---|
| 2026-03 | WATER - WATER SUPPLIES HOTEL606110 | Undistributed | Utilities | 1 | $487 | $487 | 2026-03-10 | 2026-03-10 |
| 2026-04 | WATER - WATER SUPPLIES HOTEL606110 | Undistributed | Utilities | 1 | $481 | $481 | 2026-04-14 | 2026-04-14 |
| 2026-02 | WATER - WATER SUPPLIES HOTEL606110 | Undistributed | Utilities | 1 | $455 | $455 | 2026-02-10 | 2026-02-10 |
| 2026-01 | WATER - WATER SUPPLIES HOTEL606110 | F&B | Utilities | 1 | $311 | $311 | 2026-01-20 | 2026-01-20 |
| 2026-02 | LOSS EXCHANGE RATE663100 | Undistributed | FX Gain/Loss | 1 | $0 | −$0 | 2026-02-10 | 2026-02-10 |
| Account | Gross $ | % of vendor spend ▼ |
|---|---|---|
| LOSS EXCHANGE RATE663100 | $0 | 0% |
| Date ▼ | Type | QB # | Account | USALI | Memo | Native | USD |
|---|---|---|---|---|---|---|---|
| 2026-04-14 | Bill | April.2026 | WATER - WATER SUPPLIES HOTEL606110 | Utilities | Numpapa April.2026 | — | $481 |
| 2026-03-10 | Bill | March.2026 | WATER - WATER SUPPLIES HOTEL606110 | Utilities | Numpapa March.2026 | — | $487 |
| 2026-02-10 | Bill | 010380161 Feb.2026 | LOSS EXCHANGE RATE663100 | FX Gain/Loss | Exchange Gain Or Loss | — | −$0 |
| 2026-02-10 | Bill | 010380161 Feb.2026 | WATER - WATER SUPPLIES HOTEL606110 | Utilities | Numpapa Feb.2026 | — | $455 |
| 2026-01-20 | Bill | Jan.2026 | WATER - WATER SUPPLIES HOTEL606110 | Utilities | Numpapa Jan.2026 | — | $311 |
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.