Key Outcomes
5+ tools
replaced by one app
$150+/mo
equivalent SaaS stack avoided
$0
subscription cost on Supabase free tier
PKR + USD
finances tracked in both currencies
Minutes
to issue a branded, signed invoice
Overview
- •
Industry: Internal Tooling / Operations / Finance
- •
Platform: Web-based single-page app
- •
Users: Founder, finance, and operations
- •
Stack: Vanilla JS (single file), Supabase (Postgres, Auth, Realtime), Chart.js, row-level security
Background
As Ownex Labs grew across several products, clients, and a small team, the numbers that mattered (revenue per project, monthly costs, payroll, invoices, and personal savings) lived in different spreadsheets and apps that rarely matched.
The team wanted one place to see the full picture: what each project earns and costs, where money goes each month, who gets paid, and how the business and personal finances are doing, without exporting and reconciling files.
Ownex HQ was built for that. It is a single-page dashboard on Supabase that tracks team and projects, monthly income and expenses in PKR and USD, generates invoices and payroll, and includes a personal-finance view next to the business. Access is limited to the owner, and data syncs live across devices.
- •See company and personal finances in one live view
- •Track revenue, cost, and margin for each project
- •Create branded, multi-bank invoices and payroll slips without other tools
- •Plan with monthly goals, operating expenses, and the Upwork pipeline
- •Keep data private: one owner, protected by row-level security
It replaced a set of spreadsheets with one screen the team can open and trust.
The Challenge
Business Challenges
- Revenue, costs, and margins spread across per-project spreadsheets
- No single monthly view of company income versus expenses
- Personal finances tracked separately from the business
- Invoicing and payroll done by hand in separate tools
Operational Pain Points
- PKR salaries and USD revenue with no shared view
- Several bank accounts to quote on invoices, copied by hand each time
- Charity, tax, and savings worked out manually each month
- Numbers out of date as soon as a spreadsheet was shared
Technical Challenges
- A private, owner-only app for financial data
- Live sync across devices without a heavy backend or build step
- A schema that can change month to month without losing history
- Sensitive figures that can be hidden quickly when screen-sharing
The Solution
A single-file dashboard on Supabase provides the data, login, and row-level security with no build step. The business view covers team, projects, financials, invoices, payroll, contracts, goals, monthly operating expenses, and Upwork proposals. The personal view reuses the same data for net worth, savings, FIRE, charity, tax, and family planning. Every table is limited to the owner, edits sync across devices, and a hide-money toggle blurs figures for screen-sharing.
Core Architecture
Implementation Process
Schema and Security
Set up a Postgres schema (months, team, projects, income, expenses, invoices, payroll, charity, personal buckets) with row-level security limiting every table to the owner.
Business View
Built team, projects (revenue, cost, margin), monthly financials, multi-bank invoicing with signatures, payroll slips, contracts, goals, and Upwork proposal tracking.
Personal View
Added a personal-finance view on the same data for net worth, savings rate, FIRE progress, charity, tax, family support, and bonds.
Realtime and Polish
Added a Supabase realtime channel for live sync, PKR and USD display, monthly updates, and a hide-money toggle.
Results & Impact
A live dashboard the team uses daily to run Ownex Labs and track personal finances in one place.Operations
- 1 dashboard for the company
- Real-time sync across devices
- Zero build step (single file)
Finance
- PKR + USD shown together
- Minutes to issue a signed invoice
- Auto charity, tax, and savings math
Impact
- 5+ tools replaced by one app
- $150+/mo equivalent SaaS stack avoided
- Company + personal finances in one view
