A personal agent with a browser, terminal, files, and work that keeps going built with CopilotKit and AG-UI.
TypeScript
import { z } from "zod";
/** CSV amounts use positive expenses and negative income. No currency conversion is inferred. */
export function analyzeSpending(csv: string) {
if (Buffer.byteLength(csv, "utf8") > 500000)
throw new Error("Import at most 500 KB of transaction CSV");
// Excel and many bank exports start a UTF-8 CSV with a byte order mark. It is not part of the first header.
if (csv.charCodeAt(0) === 0xfeff) csv = csv.slice(1);
const rows: string[][] = [];
let row: string[] = [],
cell = "",
quoted = false;
for (let i = 0; i <= csv.length; i++) {
const c = csv[i];
if (c === '"') {
if (quoted && csv[i + 1] === '"') {
cell += '"';
i++;
} else if (!quoted && cell.length) throw new Error("Invalid quoted CSV field");
else {
quoted = !quoted;
if (!quoted) {
const next = csv[i + 1];
if (next !== undefined && next !== "," && next !== "\n" && next !== "\r")
throw new Error("Invalid quoted CSV field");
}
}
} else if (!quoted && (c === "," || c === "\r" || c === "\n" || c === undefined)) {
row.push(cell);
cell = "";
if (c !== ",") {
if (row.some((v) => v.trim())) rows.push(row);
row = [];
if (c === "\r" && csv[i + 1] === "\n") i++;
}
} else if (c !== undefined) cell += c;
}
if (quoted) throw new Error("CSV has an unclosed quoted field");
const header = rows.shift()?.map((v) => v.trim().toLowerCase());
if (!header || !["date", "description", "amount", "category"].every((v) => header.includes(v)))
throw new Error("CSV needs date,description,amount,category columns");
if (
["date", "description", "amount", "category"].some(
(name) => header.indexOf(name) !== header.lastIndexOf(name),
)
)
throw new Error("CSV has a duplicate required column");
if (!rows.length || rows.length > 5000)
throw new Error("Import between 1 and 5,000 transactions");
const transactions = rows.map((r, index) => {
const get = (name: string) => r[header.indexOf(name)]?.trim() ?? "";
if (r.length !== header.length)
throw new Error(`Row ${index + 2} has the wrong number of columns`);
const date = get("date"),
amount = get("amount");
if (!z.iso.date().safeParse(date).success || !/^[-+]?\d+(?:\.\d{1,2})?$/.test(amount))
throw new Error(
`Row ${index + 2} needs an ISO date and a plain amount with at most two decimal places`,
);
const cents = Math.round(Number(amount) * 100);
if (!Number.isSafeInteger(cents) || Math.abs(cents) > 1e12)
throw new Error("Transaction amount is out of range");
return {
id: `row-${index + 2}`,
date,
description: get("description"),
amount: cents / 100,
category: get("category") || "Uncategorized",
cents,
};
});
const expenses = transactions.filter((t) => t.cents > 0).reduce((n, t) => n + t.cents, 0),
income = -transactions.filter((t) => t.cents < 0).reduce((n, t) => n + t.cents, 0);
const grouped = new Map<string, number>();
for (const t of transactions)
if (t.cents > 0) grouped.set(t.category, (grouped.get(t.category) ?? 0) + t.cents);
const categories = [...grouped]
.map(([name, cents]) => ({ name, amount: cents / 100 }))
.sort((a, b) => b.amount - a.amount);
return {
income: income / 100,
spending: expenses / 100,
saved: (income - expenses) / 100,
count: transactions.length,
categories,
transactions: transactions.map(({ cents, ...t }) => t),
period: {
from: transactions.map((t) => t.date).sort()[0],
to: transactions
.map((t) => t.date)
.sort()
.at(-1),
},
amountConvention:
"Positive expenses; negative income. Values use the source currency; no currency conversion.",
};
}