Selected work04 / 04

All work
Dark concrete building lit at night

Finance · Integration

Ledger Sync

Year
2024
Status
In production
Timeline
17 weeks
Role
Systems architecture, backend engineering, cloud infrastructure

Overview

Ledger Sync sits between a finance team’s payment providers, bank feeds and ERP. It matches transactions and flags what doesn’t add up.

Challenge

Reconciliation was a monthly export-and-compare job. Mismatches showed up late, and every provider had its own format and schedule.

Server racks with network cables in a data center

Solution

Reliable connectors for each source, a matching engine with rules you can actually read, and an exceptions queue, so people only handle what needs a person.

Product

  • 01Connectors for providers, banks and ERP
  • 02Readable matching rules
  • 03Exceptions queue with owners
  • 04Audit log and exports
Close-up of a dark circuit board
Fig. A: Infrastructure layout
Dark concrete building lit at night
Fig. B: Exceptions view

Technology

  • Python
  • Django
  • PostgreSQL
  • AWS
  • Docker

System architecture

  1. 01Sources

    • Payment providers
    • Bank feeds
    • ERP

  2. 02Ingest

    • Connectors
    • Scheduler

  3. 03Services

    • Matching engine
    • Exceptions API

  4. 04Data

    • PostgreSQL
    • Archive storage

Timeline: 17 weeks

  1. Discovery

    2 wks

  2. Architecture

    3 wks

  3. Build

    10 wks

  4. Launch

    2 wks

Outcome

Reconciliation runs daily instead of monthly. The finance team works from a short list of exceptions, not a spreadsheet.