Docerity
All work

Fintech · Dashboard

Ledger

A real-time finance dashboard rebuilt from the ground up for a team drowning in spreadsheet exports.

Next.jsTypeScriptPostgres

Outcome

40% faster close

Role

Full-stack engineer

Timeline

9 weeks

The problem

The finance team's month-end close ran on a chain of spreadsheet exports: pull data from the accounting system, paste it into a workbook, cross-check it against three other workbooks, and hope nobody's version was stale. Reconciliation errors weren't caught until close — sometimes days later — by which point tracing the source meant reopening every export in the chain.

Leadership's only view into the numbers was whatever the last export said, which meant every strategic conversation was working from data that was, at best, a few days old.

Image placeholder

Screenshot of the original spreadsheet-based close process

The old process: a chain of exports, each one a potential point of drift.

The approach

Instead of exporting data out of the accounting system, we built a dashboard that reads from it directly — a live sync layer that pulls transactions, categorizes them against the existing chart of accounts, and flags discrepancies as they appear rather than at month-end.

The close workflow itself became a checklist inside the dashboard: each reconciliation step shows its current state, who last touched it, and whether the underlying numbers have changed since. Nobody has to ask "is this the latest version" again, because there's only ever one version.

The result

Close went from a multi-day scramble to a same-day checklist. Discrepancies get caught as they happen instead of surfacing weeks later buried in a spreadsheet, and leadership can look at the dashboard for a real-time number instead of waiting for the next export.

Results

  • 40% faster month-end close
  • Reconciliation errors caught same-day instead of at month-end
  • Leadership gets a live view instead of a weekly export

Got something like this to build?

Start a project