Function normalize

apps/operation/finance/lib/normalize.mjs:17–48

(rawRows, vendorsMap)

 * user and re-running normalize with an updated map).
 */
export function normalize(rawRows, vendorsMap) {
    const canonical = [];
    const unknownSet = new Set();
    const stats = new Map();
    for (const r of rawRows) {
        const key = r.counterparty;
        const entry = vendorsMap[key];
        if (!entry) {
            unknownSet.add(key);
            const s = stats.get(key) ?? { count: 0, sumEur: 0 };
            s.count += 1;
            s.sumEur += r.amount_eur ?? 0;
            stats.set(key, s);
            continue;
        }
        canonical.push({
            date: r.date,
            month: r.date.slice(0, 7),
            vendor: entry.canonical,
            category: entry.category,
            amount: r.amount_eur,
        });
    }
    const unknownStats = [...stats.entries()]
        .map(([counterparty, s]) => ({
            counterparty,
            count: s.count,
            sumEur: Number(s.sumEur.toFixed(2)),
        }))
        .sort((a, b) => Math.abs(b.sumEur) - Math.abs(a.sumEur));
    return { canonical, unknown: [...unknownSet], unknownStats };
}