| Period | Account | USALI dept | Subcategory | Lines | Gross $ ▼ | Net $ | First | Last |
|---|---|---|---|---|---|---|---|---|
| 2026-01 | GAS - KITCHEN FUEL606120 | F&B | Utilities | 1 | $277 | $277 | 2026-01-31 | 2026-01-31 |
| 2026-02 | GAS - KITCHEN FUEL606120 | F&B | Utilities | 1 | $175 | $175 | 2026-02-28 | 2026-02-28 |
| 2026-02 | STAFF CANTEEN MATERIALS606119 | F&B | Other Operating Expenses | 2 | $145 | $145 | 2026-02-28 | 2026-02-28 |
| 2026-03 | GAS - KITCHEN FUEL606120 | F&B | Utilities | 1 | $127 | $127 | 2026-03-02 | 2026-03-02 |
| 2026-04 | GAS - KITCHEN FUEL606120 | F&B | Utilities | 2 | $95 | $95 | 2026-04-07 | 2026-04-07 |
| 2026-03 | EMPLOYEE MEAL638105 | Undistributed | Payroll & Related | 1 | $63 | $63 | 2026-03-02 | 2026-03-02 |
| 2026-02 | COST OF ACTIVITIES606102 | Activities | Cost of Sales | 1 | $18 | $18 | 2026-02-28 | 2026-02-28 |
| 2026-01 | OPERATING SUPPLIES606123 | Undistributed | Other Operating Expenses | 1 | $9 | $9 | 2026-01-31 | 2026-01-31 |
| 2026-03 | LOSS EXCHANGE RATE663100 | Undistributed | FX Gain/Loss | 1 | $7 | −$7 | 2026-03-25 | 2026-03-25 |
| 2026-04 | LOSS EXCHANGE RATE663100 | Undistributed | FX Gain/Loss | 1 | $4 | −$4 | 2026-04-15 | 2026-04-15 |
| Account | Gross $ | % of vendor spend ▼ |
|---|---|---|
| COST OF ACTIVITIES606102 | $18 | 2% |
| LOSS EXCHANGE RATE663100 | $11 | 1% |
| OPERATING SUPPLIES606123 | $9 | 1% |
| Date ▼ | Type | QB # | Account | USALI | Memo | Native | USD |
|---|---|---|---|---|---|---|---|
| 2026-04-15 | Bill Payment (Cheque) | 2604010 | LOSS EXCHANGE RATE663100 | FX Gain/Loss | Exchange Gain Or Loss | — | −$4 |
| 2026-04-07 | Bill | 7/4/26 | GAS - KITCHEN FUEL606120 | Utilities | 1Tank Gas for Canteen 15kg | — | $23 |
| 2026-04-07 | Bill | 7/4/26 | GAS - KITCHEN FUEL606120 | Utilities | 1 Tank LPG Gas 48kgkg | — | $72 |
| 2026-03-25 | Bill Payment (Cheque) | 812 | LOSS EXCHANGE RATE663100 | FX Gain/Loss | Exchange Gain Or Loss | — | −$7 |
| 2026-03-02 | Bill | — | GAS - KITCHEN FUEL606120 | Utilities | 2 Tank LPG Gas 48kgkg | — | $127 |
| 2026-03-02 | Bill | — | EMPLOYEE MEAL638105 | Payroll & Related | 1Tank Gas for Canteen 48kg | — | $63 |
| 2026-02-28 | Bill | Feb.2026 | COST OF ACTIVITIES606102 | Cost of Sales | 1Tank LPG Gas 7Kg (for Cooking Class) | — | $18 |
| 2026-02-28 | Bill | Feb.2026 | GAS - KITCHEN FUEL606120 | Utilities | 12 Tank LPG Gas 15kg | — | $175 |
| 2026-02-28 | Bill | Feb.2026 | STAFF CANTEEN MATERIALS606119 | Other Operating Expenses | 2Tank LPG Gas 48Kg | — | $122 |
| 2026-02-28 | Bill | Feb.2026 | STAFF CANTEEN MATERIALS606119 | Other Operating Expenses | Gas Pipe 5m for Canteen | — | $22 |
| 2026-01-31 | Bill | Jan.2026 | OPERATING SUPPLIES606123 | Other Operating Expenses | 1Tank LPG Gas 7Kg (for heater in Lobby | — | $9 |
| 2026-01-31 | Bill | Jan.2026 | GAS - KITCHEN FUEL606120 | Utilities | 19 Tank LPG Gas 15kg | — | $277 |
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.