Activity window
Account split · 2 period × account combos
| Period | Account | USALI dept | Subcategory | Lines | Gross $ ▼ | Net $ | First | Last |
|---|
| 2026-01 | FOOD COST607100 | Undistributed | Cost of Sales | 1 | $701 | $701 | 2026-01-28 | 2026-01-28 |
| 2026-04 | FOOD COST607100 | F&B | Cost of Sales | 1 | $156 | $156 | 2026-04-01 | 2026-04-01 |
Anomalies · 0 flagged
No account anomalies — every account split looks normal for this vendor.
Transactions · last 2 (cap 500)
| Date ▼ | Type | QB # | Account | USALI | Memo | Native | USD |
|---|
| 2026-04-01 | Bill | 187687 | FOOD COST607100 | Cost of Sales | SAFFRON COFFEE | — | $156 |
| 2026-01-28 | Expense | — | FOOD COST607100 | Cost of Sales | 40kg Coffee | — | $701 |
Data lineage
Vendor name = raw
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.