Softwr

APIs · head to head

Formance vs Metabase

Formance logo

Formance

APIs

Open source double-entry ledger and payment orchestration for money-moving software

From
Free
Rated
-
Full reviewWebsite
Metabase logo

Metabase

Spreadsheets

Fast analytics with the friendly UX

From
Free
Rated
-
Full reviewWebsite

The short version

  • Each has a real cost: Formance formance holds no money and provides no regulatory cover, so it must be paired with a payments provider or bank, and buyers occasionally mistake a ledger for a treasury system and discover the gap late.; Metabase aI Service charges $3.75 per 1 million tokens (after 1M free tokens included)
  • They diverge on capability: Formance covers Double-entry ledger, Metabase covers No-code Query Builder.
  • Prices and features above were last checked on 31 August 2026.

Where they differ

Only the attributes on which Formance and Metabase actually diverge.

Attributes where Formance and Metabase differ
AttributeFormanceMetabase
Pricing modelOpen source, no licence feefreemium
PlatformsLinux, Docker, Kubernetes, Web, APIWeb, Self-hosted cloud
CategoryAPIsSpreadsheets
FoundedUnknown2014

Identical on both: starting price (Free), free tier (Yes), user rating (Not yet rated).

What each one covers

Drawn from each product's published feature list. An absence here means we hold no record of it - not that the product lacks it.

Only in Formance

  • Double-entry ledger
  • Numscript transaction DSL
  • Multi-currency
  • Payments connectivity
  • Reconciliation
  • Self-hosted deployment
  • Cloud offering
  • API and SDKs

Only in Metabase

  • No-code Query Builder
  • SQL Editor
  • Interactive Dashboards
  • Alerts
  • Embedding
  • PostgreSQL
  • MySQL
  • MongoDB

What people use each for

The jobs each tool is most often brought in to do.

Formance

  • A marketplace splitting a single customer payment between seller, platform fee and tax that needs the split to be atomic and auditablenot Metabase
  • A fintech whose homegrown balances table produced numbers finance could not reconcile and now needs proper double-entry before an auditnot Metabase
  • A payments team that wants one normalised model across several PSPs so reconciliation is not written separately for eachnot Metabase
  • A company that wants its ledger under a licence it can keep running even if the vendor disappearsnot Metabase

Metabase

  • Business intelligence and data exploration for non-technical usersnot Formance
  • Embedded analytics for SaaS applicationsnot Formance
  • Self-service reporting and dashboard creationnot Formance
  • Integration with 40+ data sources including cloud warehousesnot Formance

Where each one falls short

Documented limitations, not opinions. Every one is a constraint you would hit in normal use.

Formance

  • Formance holds no money and provides no regulatory cover, so it must be paired with a payments provider or bank, and buyers occasionally mistake a ledger for a treasury system and discover the gap late.
  • Numscript is a domain-specific language your team must learn, and while it makes complex splits expressible it also means transaction logic sits outside the languages your engineers already debug well.
  • Self-hosting a ledger that must never lose or duplicate a transaction is a serious operational commitment covering backups, upgrades and Postgres tuning, which is real cost the zero licence fee hides.
  • Enterprise pricing is not published, so the difference between the free path and the supported path cannot be evaluated without a sales conversation.
  • The company is much smaller than the incumbent alternatives, and while the MIT licence protects the code it does not protect the roadmap, so features on the hosted side may arrive slowly or change direction.

Metabase

  • AI Service charges $3.75 per 1 million tokens (after 1M free tokens included)
  • Transforms cost $0.01 per run after 1,000 included runs per month
  • Advanced Transforms cost $0.02 per run after included allocation
  • Storage overages start at $2 per 1M rows (1M rows free)
  • All yearly plans offer 10% discount versus monthly, incentivizing annual commitment

Pricing, plan by plan

Formance

Free
  • Open SourceFree
    • MIT licensed core ledger
    • Numscript transaction DSL
    • Multi-currency tracking
  • Enterprise$undefined/year
    • Managed or private deployment
    • Payments connectivity and reconciliation
    • Support with response commitments

Metabase

Free
  • Open SourceFree
    • Unlimited users
    • Unlimited questions and dashboards
    • AI-powered query generation
  • Starter$90/month
    • Email and chat support
    • $100/month standard monthly billing
    • 20+ data connectors
  • Pro$517.5/month
    • $575/month standard monthly
    • Row/column-level permissions
    • SSO
  • Enterprise$20000/year
    • Dedicated success engineer
    • 1-day support response SLA
    • Air-gapped deployment

Which should you pick?

Choose Formance if

  • You need double-entry ledger.
  • You want to start without paying.
  • You work on Linux, Docker, Kubernetes, Web, API.
  • You also want numscript transaction dsl.
Formance review

Choose Metabase if

  • You need no-code query builder.
  • You want to start without paying.
  • You work on Web, Self-hosted cloud.
  • You also want sql editor.
Metabase review

Questions people ask

Is Formance or Metabase better?
Neither clearly leads. Formance starts at Free and Metabase at Free, and user ratings are close enough to be indistinguishable. Choose on capability and platform support.
Which is cheaper, Formance or Metabase?
Formance starts at Free and Metabase at Free.
Does Formance or Metabase run on more platforms?
Formance runs on Linux, Docker, Kubernetes, Web, API. Metabase runs on Web, Self-hosted cloud.
Can I use Formance for free?
Both have a free tier, so you can try either at no cost before committing.
What is Formance best used for?
Formance is most often used for a marketplace splitting a single customer payment between seller, platform fee and tax that needs the split to be atomic and auditable, a fintech whose homegrown balances table produced numbers finance could not reconcile and now needs proper double-entry before an audit, a payments team that wants one normalised model across several psps so reconciliation is not written separately for each, a company that wants its ledger under a licence it can keep running even if the vendor disappears. Of those, a marketplace splitting a single customer payment between seller, platform fee and tax that needs the split to be atomic and auditable and a fintech whose homegrown balances table produced numbers finance could not reconcile and now needs proper double-entry before an audit are not what Metabase is typically brought in for.
What can Formance do that Metabase cannot?
Formance covers Double-entry ledger, Numscript transaction DSL, Multi-currency, Payments connectivity. Metabase covers No-code Query Builder, SQL Editor, Interactive Dashboards, Alerts.

Answered from the vendors’ own pages

Formance: Is Formance really open source?

Yes. The core ledger is MIT licensed with full source access and no deployment restrictions.

Metabase: How much does Metabase cost?

Metabase Open Source is free for self-hosted deployments with unlimited users and dashboards. Cloud-hosted Starter tier costs $90/month annually ($100/month monthly) with Pro at $517.50/month annually ($575/month monthly). Enterprise plans start at $20,000 per year.

Source
Formance: Does Formance move money?

No. It records and orchestrates movements; the actual payments happen at a PSP or bank you connect.

Metabase: Does Metabase charge for additional users?

Yes, Metabase charges per-user fees beyond included users. Starter includes 5 users at $6 per additional user per month. Pro includes 10 users at $12 per additional user per month. Enterprise pricing is custom.

Source
Formance: What does the enterprise version cost?

Not published. It is an annual subscription quoted per customer.

Metabase: What usage-based fees does Metabase charge?

Metabase charges $3.75 per 1 million tokens for AI services (after 1M free tokens), $0.01 per transform run after 1,000 included per month, $0.02 for advanced transforms, and storage overages at $2 per 1M rows beyond the included 1M rows.

Source
Formance: Do I have to use Numscript?

Yes for anything beyond the simplest transfers. It is how multi-party transactions are expressed atomically.

Share

Related pages

More on Formance

More on Metabase

Keep looking

Other head to heads