Overview

Upwork's own transaction export is hard to trust: fee rows are paired with income rows, connects and subscription purchases show up as phantom "payment" income, and none of it is grouped by client or period. The client wanted a private tool that turns that export into an honest picture of what he's actually earning, without sending his financial data anywhere near the cloud.

What It Does

• Imports Upwork's CSV export and de-duplicates it safely, so re-importing the same file never double-counts a transaction.
• Separates real income from the phantom entries Upwork's export creates for connects and subscription charges.
• Calculates gross earnings, net profit, effective fee rate, connects ROI, and per-client breakdowns.
• Tracks the Upwork proposal funnel: proposals, views, interviews, hires, and cost per hire.
• Ships as a native desktop app with its own icon and splash screen, not a browser tab someone has to remember to open.

Why Local-First

This was built for one person's own numbers, so it runs entirely on his machine: no accounts, no server, no monthly bill. All figures are stored as exact cents rather than floating-point dollars, so nothing drifts, and every metric formula is covered by tests anchored to a real export rather than made-up sample data.

The app is packaged with Electron on top of a Next.js backend and a local SQLite database, and installs like any other desktop app, icon on the desktop, no setup beyond a double-click.

Outcome

A tool scoped tightly to what one freelancer needed to see about his own income, with no infrastructure to maintain and no data leaving his laptop.