| Period | Account | USALI dept | Subcategory | Lines | Gross $ ▼ | Net $ | First | Last |
|---|---|---|---|---|---|---|---|---|
| 2026-04 | ELECTRICTY EXPENSE - HOTEL606108 | Undistributed | Utilities | 1 | $2,354 | $2,354 | 2026-04-22 | 2026-04-22 |
| 2026-03 | ELECTRICTY EXPENSE - HOTEL606108 | Undistributed | Utilities | 1 | $2,034 | $2,034 | 2026-03-11 | 2026-03-11 |
| 2026-02 | ELECTRICTY EXPENSE - HOTEL606108 | Undistributed | Utilities | 1 | $1,931 | $1,931 | 2026-02-02 | 2026-02-02 |
| 2026-01 | ELECTRICTY EXPENSE - HOTEL606108 | Undistributed | Utilities | 1 | $1,688 | $1,688 | 2026-01-31 | 2026-01-31 |
| 2026-03 | LOSS EXCHANGE RATE663100 | Undistributed | FX Gain/Loss | 1 | $48 | $48 | 2026-03-17 | 2026-03-17 |
| 2026-02 | LOSS EXCHANGE RATE663100 | Undistributed | FX Gain/Loss | 1 | $45 | $45 | 2026-02-23 | 2026-02-23 |
| 2026-01 | LOSS EXCHANGE RATE663100 | Undistributed | FX Gain/Loss | 1 | $39 | −$39 | 2026-01-21 | 2026-01-21 |
| 2026-04 | LOSS EXCHANGE RATE663100 | Undistributed | FX Gain/Loss | 1 | $0 | −$0 | 2026-04-22 | 2026-04-22 |
| Account | Gross $ | % of vendor spend ▼ |
|---|---|---|
| LOSS EXCHANGE RATE663100 | $132 | 2% |
| Date ▼ | Type | QB # | Account | USALI | Memo | Native | USD |
|---|---|---|---|---|---|---|---|
| 2026-04-22 | Bill | April.2026 | ELECTRICTY EXPENSE - HOTEL606108 | Utilities | ELD April.2026 | — | $2,354 |
| 2026-04-22 | Bill | April.2026 | LOSS EXCHANGE RATE663100 | FX Gain/Loss | Exchange Gain Or Loss | — | −$0 |
| 2026-03-17 | Bill Payment (Cheque) | 2604030 | LOSS EXCHANGE RATE663100 | FX Gain/Loss | Exchange Gain Or Loss | — | $48 |
| 2026-03-11 | Bill | March.2026 | ELECTRICTY EXPENSE - HOTEL606108 | Utilities | ELD March.2026 | — | $2,034 |
| 2026-02-23 | Bill Payment (Cheque) | Feb.2026 | LOSS EXCHANGE RATE663100 | FX Gain/Loss | Exchange Gain Or Loss | — | $45 |
| 2026-02-02 | Bill | D10-16299766/2026 | ELECTRICTY EXPENSE - HOTEL606108 | Utilities | ELD Feb.2026 | — | $1,931 |
| 2026-01-31 | Bill | Jan.2026 | ELECTRICTY EXPENSE - HOTEL606108 | Utilities | ELD Jan.2026 | — | $1,688 |
| 2026-01-21 | Bill Payment (Cheque) | 2601009 | LOSS EXCHANGE RATE663100 | FX Gain/Loss | Exchange Gain Or Loss | — | −$39 |
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.