Projects
Dec 5, 2023

dLocal Project Financial Management Platform

Internal financial management platform that transformed dLocal's project cost tracking from scattered Excel reports into a centralized, role-based dashboard.

FintechFinancial ManagementProject AccountingProduct StrategyWorkflow AutomationInternal ToolsDashboardsData-Driven DecisionsFull-Stack ArchitectureNext.jsSpring BootCross-Functional CollaborationB2B SaaS

As part of the Pro Internacional (prointernacional.com) team, I collaborated with dLocal (dlocal.com) on the development of an internal financial management platform to replace a spreadsheet-heavy process for project cost tracking. The goal of the joint team (engineering, product and operations) was to give finance, administration and HR a single, structured tool instead of multiple disconnected Excel files.

dLocal is a fintech company focused on payments in emerging markets, and as the organization grew, it became increasingly difficult for the accounting and administrative teams to determine the true cost of each internal project. Project tracking and resource allocation were done via Excel reports and manual sheets, processing team by team. Understanding how much each project actually cost —and how that cost evolved over time— required weeks of compiling, cleaning and calculating data.

Together with other engineers and stakeholders, we helped design and build a web-based dashboard using dLocal's internal libraries based on Spring Boot on the backend and Next.js (pages router) on the frontend. The platform centralizes the workflow into three main steps, aligned with how the organization already worked:

  • Team Leaders assign a percentage allocation of each team member's time across all internal projects, directly in the system instead of on individual spreadsheets.
  • The administrative and accounting team answer a guided questionnaire per project to determine its typology and how it should be treated and capitalized from an accounting perspective.
  • HR uploads a salary and time report for each employee, including compensation and hours or dedication level for the corresponding period.

With these inputs, the platform calculates automatically:

  • The allocated cost per project, based on salary, time worked and percentage allocation.
  • The amortized cost to date for each project.
  • The progression of projects over time, so finance and leadership can see how costs accumulate and how the active project portfolio evolves.

From a technical perspective, I contributed as a full-stack engineer to the architecture and implementation of the solution: integrating dLocal's internal Spring Boot-based backend libraries with a Next.js (page router) frontend, helping define the data model for projects, allocations and costs, and shaping a workflow that fits how Team Leaders, Administration, Accounting and HR actually operate. The result for the organization is a platform that turns what used to be a manual, error-prone, Excel-based process into a centralized, auditable system for project financial management.

Crafted by Juan Felipe Arellano • © 2025