Frappe Books

Last reviewed Sep 13, 2026 · 784 words

Frappe Books does not have a docker-compose file, and you should stop looking for one. It is an Electron desktop app that writes double-entry books into a single SQLite file on your laptop, and that is the entire deployment story. For a freelancer or a one-person shop that wants invoicing, a general ledger, and basic inventory without paying QuickBooks about $30 a month, it is the least-effort option on this site. For anyone who needs two people in the books at once, it is the wrong tool, and the sections below say what to run instead.

What "self-hosting" means when the app is a desktop program

Frappe Books runs on Windows, macOS, and Linux (an AppImage on Linux), needs about 256 MB of RAM, and stores everything in one .db file per company. There is no server process, no login page, no port to open. The AGPL-3.0 licence and roughly 4,900 GitHub stars mean you get an actively maintained project from the same team that builds ERPNext, without the ERPNext-sized install.

Where it sits in a self-hoster's stack is as a client whose data file lives somewhere you already back up. My arrangement: the company file sits inside a Syncthing folder so it lands on the NAS within seconds of every save, and the NAS snapshot schedule does the rest. A Nextcloud folder works the same way. What you must not do is open the same file from two machines at once. SQLite is a single-writer format, sync tools do not know that, and a conflict copy of a ledger is a bad afternoon.

What it does well: the books of a business with one bookkeeper

Double-entry is real here, not a spreadsheet with a chart-of-accounts sticker. You get customer and supplier ledgers, sales and purchase invoices with payment tracking, journal entries, a stock module with items and quantities, and printable invoice templates you can adjust. Multi-currency is supported. Reports cover the basics an accountant asks for at year end: general ledger, trial balance, profit and loss, balance sheet.

The interface is the strongest argument. It is uncluttered in a way that accounting software almost never is, because it was designed for the owner-operator rather than for an accounting firm. A first invoice takes a few minutes from a fresh install.

What it does not do, and the con list is honest about it

Single user, single machine, no API worth building on. There is no web UI, so you cannot hand your accountant a login; you export reports or send them the file. Bank feeds do not exist; you import statements by CSV or key transactions in. Payroll is absent. Tax handling is strongest for India (GST) because that is where the Frappe team lives; other regions get generic tax rates that work but are not localised.

If any of those is a blocker, the decision is easy. Two or more users editing the books puts you in server territory: Akaunting is the closest PHP web app in spirit, and Invoice Ninja wins if invoicing and client portals matter more than the ledger. If you have outgrown "small business" and want stock, HR, and manufacturing in one system, ERPNext is the same company's full product, and the jump in operational weight is real: expect a Docker stack with MariaDB, Redis, and multiple workers instead of one file.

Backups: the one operational job you actually have

Because the whole business lives in one file, the backup plan is short and unforgivable to skip. Close Frappe Books before any copy runs (or rely on a sync tool that copies after the write completes, which Syncthing does). Keep versioned copies, not a single overwritten one; Syncthing's staggered file versioning or a nightly restic snapshot both do this. Once a quarter, open a backup copy on a different machine and confirm the trial balance matches. That is the whole job.

Migration off it is equally simple: reports export to CSV and the SQLite file itself is readable by any tool that speaks SQLite, so the data is never hostage.

What I'd do

Sole trader, freelancer, or a shop where one person does the books: install Frappe Books, put the company file in a synced folder with versioning, and stop paying a subscription. The moment a second person needs write access, or the accountant wants a login, move to Akaunting for a light web app or ERPNext if the business is growing into one. For most people browsing the finance shelf, the desktop app is the right amount of software.