| Period | Account | USALI dept | Subcategory | Lines | Gross $ ▼ | Net $ | First | Last |
|---|---|---|---|---|---|---|---|---|
| 2026-01 | SECURITY GUARD606129 | Undistributed | Other Operating Expenses | 1 | $385 | $385 | 2026-01-31 | 2026-01-31 |
| 2026-02 | SECURITY GUARD606129 | Undistributed | Other Operating Expenses | 1 | $385 | $385 | 2026-02-17 | 2026-02-17 |
| 2026-03 | SECURITY GUARD606129 | Undistributed | Other Operating Expenses | 1 | $360 | $360 | 2026-03-17 | 2026-03-17 |
| 2026-04 | LOSS EXCHANGE RATE663100 | Undistributed | FX Gain/Loss | 1 | $17 | −$17 | 2026-04-28 | 2026-04-28 |
| Account | Gross $ | % of vendor spend ▼ |
|---|---|---|
| LOSS EXCHANGE RATE663100 | $17 | 2% |
| Date ▼ | Type | QB # | Account | USALI | Memo | Native | USD |
|---|---|---|---|---|---|---|---|
| 2026-04-28 | Bill Payment (Cheque) | 9 | LOSS EXCHANGE RATE663100 | FX Gain/Loss | Exchange Gain Or Loss | — | −$17 |
| 2026-03-17 | Bill | March.2026 | SECURITY GUARD606129 | Other Operating Expenses | Security guard service March.2026 | — | $360 |
| 2026-02-17 | Bill | 482 | SECURITY GUARD606129 | Other Operating Expenses | Security guard service Feb.2026 | — | $385 |
| 2026-01-31 | Bill | 1213 (Jan.2026 | SECURITY GUARD606129 | Other Operating Expenses | Security guard service Jan.2026 | — | $385 |
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.