| Period | Account | USALI dept | Subcategory | Lines | Gross $ ▼ | Net $ | First | Last |
|---|---|---|---|---|---|---|---|---|
| 2026-01 | FOOD COST607100 | F&B | Cost of Sales | 1 | $506 | $506 | 2026-01-13 | 2026-01-13 |
| 2026-02 | FOOD COST607100 | F&B | Cost of Sales | 3 | $380 | $380 | 2026-02-02 | 2026-02-02 |
| 2026-03 | LOSS EXCHANGE RATE663100 | Undistributed | FX Gain/Loss | 1 | $8 | $8 | 2026-03-16 | 2026-03-16 |
| 2026-02 | PURCHASING EXPENSES606150 | Undistributed | Other Operating Expenses | 1 | $6 | $6 | 2026-02-02 | 2026-02-02 |
| Account | Gross $ | % of vendor spend ▼ |
|---|---|---|
| LOSS EXCHANGE RATE663100 | $8 | 1% |
| PURCHASING EXPENSES606150 | $6 | 1% |
| Date ▼ | Type | QB # | Account | USALI | Memo | Native | USD |
|---|---|---|---|---|---|---|---|
| 2026-03-16 | Bill Payment (Cheque) | 824 | LOSS EXCHANGE RATE663100 | FX Gain/Loss | Exchange Gain Or Loss | — | $8 |
| 2026-02-02 | Bill | 1174 | FOOD COST607100 | Cost of Sales | 2.018kg DOP Cheese | — | $175 |
| 2026-02-02 | Bill | 1174 | FOOD COST607100 | Cost of Sales | 2.122kg Brie Cheese | — | $118 |
| 2026-02-02 | Bill | 1174 | FOOD COST607100 | Cost of Sales | 2kg Goat Cheese | — | $87 |
| 2026-02-02 | Bill | 1174 | PURCHASING EXPENSES606150 | Other Operating Expenses | 1Foam box | — | $6 |
| 2026-01-13 | Expense | 1147 | FOOD COST607100 | Cost of Sales | Groceries Item | — | $506 |
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.