JOHNICORN CUSTOM BUSINESS SYSTEMS
Open navigation menu Close navigation menu
STILL RUNNING ON SPREADSHEETS?

I turn your spreadsheets into one system.

I build custom dashboards and automation systems for small businesses still running on spreadsheets and guesswork. Days, not months, from first call to a live system — and you own every line of code.

2019

BUILDING SINCE

A DAY

FOR A SINGLE-PURPOSE TOOL

€0

/MO HOSTING · YOU OWN THE REPO

YOUR DATA. YOUR RULES. YOUR SYSTEM.

— HOW I BUILD

PROFILES

LIVE DEMO — FREELANCER

INTERACTIVE

YOUR CURRENT SETUP

THE WORK YOU DO TWICE

Every business already has a system. Yours might be a spreadsheet, a WhatsApp thread, a folder of invoices, and one person who remembers how it all connects. It works — until the remembering becomes the job.

Look at a normal week:

  • The same number gets typed twice — once where it happened, once where it's counted.
  • Checking whether a client paid means opening three different things.
  • The month-end report gets assembled by hand, from files that disagree.
  • Nothing tells you anything. You go and look.

None of that is a mistake. It is what happens when a business grows faster than the tools it started with.

A system does that part for you — the typing twice, the checking, the assembling, the remembering. Same work, minus the person in the middle.

SEE WHAT THAT LOOKS LIKE →

CHOOSE YOUR PROFILE

Every system starts as one of four shapes. Pick the one closest to how you actually work — scope and price adjust from there.

FREELANCER

Every client, invoice and deadline in one place — so "did I send that?" stops being a question.

  • Pipeline
  • Invoicing
  • Reporting

FIXED QUOTE · SCOPED UPFRONT

SCOPE THIS ONE →

TEAM

One dashboard your team checks themselves — so you stop being the status update.

  • Pipeline
  • Financials
  • Team

FIXED QUOTE · SCOPED UPFRONT

SCOPE THIS ONE →

OPERATIONS

Bookings, stock and schedules in one place — so you see a clash before the customer does.

  • Bookings
  • Inventory
  • Scheduling

FIXED QUOTE · SCOPED UPFRONT

SCOPE THIS ONE →

FINANCE

What's invoiced, what's owed, what's actually in the account — without opening four things.

  • Invoicing
  • Receivables
  • Cash flow

FIXED QUOTE · SCOPED UPFRONT

SCOPE THIS ONE →

THE WORK

Two systems running in production. One belongs to a rental company I've worked with for years; the other is the one I run my own business on.

Rental company booking and operations dashboard with calendar and inventory views

Rental company · Booking & operations system

Interactive booking calendar, digital invoicing and contracts, and live inventory — replacing spreadsheet-and-phone coordination for a rental business.

STACK
React · Supabase · Cloudflare
STATUS
IN PRODUCTION
Freelancer command center dashboard with pipeline and invoicing

Johnicorn (myself) · Freelancer command center

The system I run my own freelance business on, every day — pipeline, invoices and time tracking in one place. I use what I sell.

STACK
React · Cloudflare
STATUS
IN PRODUCTION · DAILY USE

WHY IT'S FAST

NO LAYERS

One person decides and builds. No account manager, no handoff, no week lost to "syncing with the team". AI does the repetitive parts; I review everything before it ships. A single-purpose tool can be done in a day. A CRM or a full application takes weeks. You get the actual number when we scope it — not "it depends".

HOW I BUILD

01 — CHECK THE FACTS

Before I design anything, I verify the numbers against your actual data — not assumptions, not what the old spreadsheet says. If a figure doesn't hold up, it doesn't go in the system.

02 — MAKE IT USABLE

Then I turn it into something you'll actually open — an interactive system, not a static report. You should understand your own business faster than you can explain it to someone else.

I use AI to cross-check facts and speed up the build — every output is reviewed and decided by me before it ships. And where a number can't be checked against a source, your system says so instead of quietly showing it anyway.

HOW PRICING WORKS

QUOTE Fixed price, agreed before I start — it doesn't move
DELIVERY A day for a small tool · weeks for a CRM or app · exact date at scoping
PAYMENT 50% to start · 50% on delivery
HOSTING €0/month — it runs on your own accounts
OWNERSHIP Code + platform access — handover agreed in the scope
CURRENCY EUR, GBP or yours
INVOICED BY UK sole trader — Jānis Patmalnieks

WHO BUILDS IT

BASED IN
BRIGHTON, UK
CLIENTS IN
LATVIA · UK
FREELANCE SINCE
2019
LANGUAGES
EN · LV

I'm Jānis — Latvian, working from Brighton. I turn messy business data into systems people actually open. No agency, no account managers — you work directly with the person writing the code, in English or Latvian. And I don't disappear at handover: with my longest-running client that has meant everything from their first website to the systems they run on today, over the years.

FAQ

How long does a system take to build?

A small single-purpose tool can be done in a day. A CRM or a full application takes weeks. You get an exact number when we scope the project — not a generic 'it depends'.

Who owns the code once it's built?

You do. You get the code and access to the platforms it runs on — the exact handover (repos, accounts, documentation) is fixed in the scope we agree before I start.

Can I get updates or new features later?

Yes — as follow-on work, scoped and priced separately. Nothing here is subscription-based; you decide project by project.

What happens if something breaks?

You email me. I reply within 24 hours, and because you have the code and platform access, nothing is locked in a black box.

Why not just use Excel or Notion?

For a lot of businesses, you should — if it still fits in your head, it's the right tool and it's free. It stops fitting when the sheet only records what happened, when nothing moves unless someone remembers to move it, and when you're the thing connecting two sheets. A system does that part for you. That's the only reason to replace something that works.

Why not just use an off-the-shelf SaaS dashboard tool?

Off-the-shelf tools are built for an imagined average user. Yours is built around your actual data and workflow, costs nothing monthly, and you own it — a SaaS subscription never becomes yours.

How do you handle data security and GDPR?

Your system runs on your own accounts — hosting and database live with you, not on my infrastructure. The contact form on this site is the only thing that touches mine; see the privacy page.

What do you need from me to get started?

Your actual data (or a representative sample), a short call to confirm the brief, and answers to a few scoping questions. No design brief or spec document required — that's my job.

What are the payment terms?

50% deposit to start, 50% on delivery. Invoiced from the UK (sole trader) — in EUR, GBP or your currency. One project, one price, agreed before I start building.

TELL ME WHAT'S BROKEN

Describe what's breaking in your current setup — a paragraph is enough. I reply within 24 hours, in writing. No call unless you want one.

janis@patmalnieks.lv