Problem: Freelance Chaos Across Spreadsheets and Chat
Managing freelance work across platforms like Fiverr and Upwork quickly became overwhelming for me. Initially, I tracked leads, orders, outsourcing, expenses, and payments in Excel sheets and chat threads. As my projects and clients grew, this approach made it nearly impossible to trust net profit calculations, conversion rates, or maintain a consistent growth routine. I needed a single, reliable system to unify all these moving parts.
Stack Choices: Next.js, TypeScript, Prisma, PostgreSQL, and More
I chose Next.js 14 with the App Router and React 18 for the frontend because I wanted a modern, server-rendered React framework that supports API routes and seamless integration. TypeScript helped catch bugs early and improved maintainability.
For the database, I picked PostgreSQL hosted on Neon for its reliability and support for complex queries. Prisma was my ORM choice because it simplified schema migrations and type-safe database access.
Authentication is handled with JWT access and refresh tokens, which fit well since EarnDesk is a private, single-user app. I also added Redis as an optional API cache to improve performance for some queries.
Cloudinary manages media uploads, especially review images, and Tailwind CSS combined with shadcn UI components allowed me to build a clean, responsive interface quickly. For data visualization, I used Recharts to show lead KPIs and finance charts.
I rejected heavier authentication methods like Laravel Sanctum or Passport since I didn't need multi-user roles or social login. I also avoided more complex microservice architectures because this is a personal tool, not a public SaaS.
Architecture and Workflow
EarnDesk is a private, authenticated Next.js app that I access via a shortcut on my desktop and mobile. The workflow looks like this:
- Sign in with JWT tokens
- Use the Daily Work checklist timed to Karachi timezone, which includes ready-to-copy LLM prompt packs for brand outreach
- Track Fiverr leads, orders, milestones, and withdrawals with detailed data on fees and FX rates
- Log direct clients and personal expenses separately
- Manage dues to keep track of outstanding payments
- Review KPIs, source charts, and monthly financial reports
Domain rules like Fiverr fees and frozen FX rates are encoded directly in the Prisma data model to ensure accuracy.
Building EarnDesk: Challenges and Iterations
I spent about 4 to 5 months building EarnDesk, iteratively adding features as new freelance workflow challenges arose. Instead of switching back to Excel or adding new tools, I expanded EarnDesk.
One tricky part was handling outsourcing payments. I needed to track which projects I outsourced, who worked on them, and calculate the exact amounts owed to each freelancer based on percentages or fixed fees. Encoding this logic in the database and UI took multiple revisions.
Another challenge was syncing financial data across Fiverr, Upwork, and personal expenses while accounting for platform fees, currency conversions, and withdrawals. I implemented FX-aware finance rules that freeze exchange rates per ledger row to maintain historical accuracy.
The JWT auth setup was straightforward but required careful token refresh handling to keep the app secure without interrupting my workflow.
I also built a monthly reporting system that generates detailed finance reports, which helped me track business performance over time.
What Worked Well and What I'd Improve
EarnDesk successfully unified all aspects of my freelance operations into one private dashboard. The combination of Next.js and Prisma made schema changes and frontend integration smooth.
Using Tailwind CSS with shadcn components allowed rapid UI iteration. The Daily Work board with LLM prompt packs helped maintain consistent brand outreach.
However, I found that adding Redis caching was only marginally beneficial given the app’s single-user nature. If I were to build this again, I might skip Redis initially.
Also, while the JWT auth works fine, implementing a more robust session management with refresh token rotation could improve security.
When This Approach Is a Poor Fit / When to Hire a Specialist
EarnDesk is designed for a solo freelancer or founder managing multiple platforms and personal finances who wants a private, customized system. It is not a public SaaS, so it lacks multi-user roles, team permissions, or onboarding features.
If you need a multi-user platform with complex access control, or plan to scale to many users, hiring a specialist to architect a SaaS-grade system with OAuth, RBAC, and more robust security is advisable.
Similarly, if your freelance business involves complex accounting compliance or tax reporting, a dedicated finance expert or accountant should be consulted.
FAQ
How does EarnDesk handle currency conversions and fees?
EarnDesk encodes FX rates and Fiverr fees directly into the database schema. Each ledger row freezes the FX rate at the transaction time to preserve historical accuracy. This allows precise calculation of net earnings after platform fees and currency conversions.
Can EarnDesk manage multiple freelance platforms?
Yes. Currently, I track Fiverr and Upwork workflows independently within EarnDesk but unified under one dashboard. Adding more platforms would require extending the data model and UI.
Is EarnDesk available as a public SaaS?
No. EarnDesk is a private, single-user app built for my personal freelance operations. However, the source code is available for customization or purchase if you want a similar system.
What were the main reasons to build EarnDesk instead of using existing tools?
Existing tools didn’t unify leads, orders, outsourcing, expenses, and daily tasks in one place tailored to my workflow. Excel sheets became error-prone and time-consuming as projects grew. EarnDesk solves these by centralizing all data with domain-specific rules.
What technologies would you recommend for someone building a similar freelance dashboard?
Next.js with TypeScript and Prisma over PostgreSQL is a solid choice for full-stack web apps. Tailwind CSS speeds up UI development. JWT auth suffices for private apps, but consider more advanced auth for multi-user systems. Use Recharts or similar for data visualization.
If you want to explore EarnDesk’s source or discuss a custom version, please reach out via my contact page.
