| Period | Account | USALI dept | Subcategory | Lines | Gross $ ▼ | Net $ | First | Last |
|---|---|---|---|---|---|---|---|---|
| 2026-04 | MAINTENANCE - ELECTRICAL SYSTEM614102 | Undistributed | POM | 2 | $3,053 | $3,053 | 2026-04-03 | 2026-04-03 |
| 2026-04 | LOSS EXCHANGE RATE663100 | Undistributed | FX Gain/Loss | 1 | $66 | −$66 | 2026-04-07 | 2026-04-07 |
| 2026-03 | MAINTENANCE - REFRIGERATOR / FREEZER614115 | Undistributed | POM | 1 | $19 | $19 | 2026-03-10 | 2026-03-10 |
| 2026-03 | LOSS EXCHANGE RATE663100 | Undistributed | FX Gain/Loss | 1 | $9 | −$9 | 2026-03-25 | 2026-03-25 |
| Account | Gross $ | % of vendor spend ▼ |
|---|---|---|
| LOSS EXCHANGE RATE663100 | $76 | 2% |
| MAINTENANCE - REFRIGERATOR / FREEZER614115 | $19 | 1% |
| Date ▼ | Type | QB # | Account | USALI | Memo | Native | USD |
|---|---|---|---|---|---|---|---|
| 2026-04-07 | Bill Payment (Cheque) | 786 | LOSS EXCHANGE RATE663100 | FX Gain/Loss | Exchange Gain Or Loss | — | −$66 |
| 2026-04-03 | Bill | 3/4/26 | MAINTENANCE - ELECTRICAL SYSTEM614102 | POM | 135m NYY Electric cable 4x25 | — | $2,639 |
| 2026-04-03 | Bill | 3/4/26 | MAINTENANCE - ELECTRICAL SYSTEM614102 | POM | 50m Electric cable NYY 2x16 | — | $414 |
| 2026-03-25 | Bill Payment (Cheque) | 804 | LOSS EXCHANGE RATE663100 | FX Gain/Loss | Exchange Gain Or Loss | — | −$9 |
| 2026-03-10 | Bill | 10/3/2026 | MAINTENANCE - REFRIGERATOR / FREEZER614115 | POM | Refill Gas for AC Room. | — | $19 |
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.