Ditch QuickBooks: A Practical Guide to Open-Source Bookkeeping

Ditch QuickBooks: A Practical Guide to Open-Source Bookkeeping

Table of Contents

QuickBooks is a common choice for small-business books. It is convenient, but QuickBooks Online is a subscription you rent, and getting your history out takes work because its export is limited.

If you want your books on software you control, there are free and open-source options. This guide covers which ones fit which size of business, what actually moves over from QuickBooks, and how to switch without putting your records at risk. It is based on each project’s documentation and on QuickBooks’ own export help, not on a tested migration of your data, so treat it as a plan to check against your own books.


Why people look at alternatives

  1. Lock-in. Leaving QuickBooks Online means exporting your reports and lists, and what the export includes is limited (postings from transactions and attachments come out separately). Plan on rebuilding your books in the new tool, not carrying a file across.
  2. Ongoing cost. QuickBooks Online is a monthly subscription. Free software has no license fee, but you pay for hosting, backups and your time or someone else’s. It is cheaper only if you count those honestly.
  3. Where your data lives. With self-hosted or desktop software your books sit on hardware you choose. That is also your job to protect: backups and updates are now yours.

There are trade-offs too. Support usually comes from community forums or paid third-party providers, depending on the tool. Bank-feed options differ by tool and by bank, so check that yours is supported before you commit. Your accountant or tax preparer may also expect QuickBooks. Ask them before you switch.


Pick the smallest tool that does the job

For bookkeeping alone, start smaller than a full ERP. Start with what you actually do each month, then choose.

If you are…Look atLicense
A sole proprietor or very small business with one or a few peopleGnuCash*GPL
Comfortable with text files and a command linehledger*, Beancount* or Ledger* (plain-text accounting)hledger: GPLv3. Beancount: GPLv2. Ledger: BSD
A small team that wants a browser-based app on its own serverFrappe Books*AGPL-3.0
A business that also needs manufacturing, HR or a full back officeERPNext* (with Frappe HR for payroll)ERPNext: GPLv3
Tracking personal money onlyFirefly III*Not for business bookkeeping

GnuCash

GnuCash is free desktop software built on double-entry accounting. Its business features include an accounts receivable system for customers and invoices, and it imports QIF, OFX/QFX and CSV files. It has no built-in QuickBooks importer, which matters for the migration steps below. Its documentation notes that accounts receivable are kept per currency, so businesses billing in several currencies should read that part of the manual first.

Plain-text accounting: hledger, Beancount and Ledger

If you are comfortable with text files and a terminal, plain-text accounting is a different way to keep double-entry books. You record transactions in a text file and the program turns that file into reports. Three tools in this family are Ledger, hledger and Beancount. hledger’s website says the text format was invented by the Ledger project (begun in 2003, BSD license), and its documentation says hledger is inspired by Ledger and largely compatible with it. hledger is licensed under the GPLv3 and Beancount under the GPLv2, according to their repositories.

  • hledger runs from one binary and also has a terminal interface and a web interface. It can read CSV files using rules you write for each bank or export.
  • Beancount describes itself as a double-entry bookkeeping language that reads transactions from a text file and generates reports from them.
  • Ledger is accessed from the Unix command line.

The trade-off is that your books are a text file you edit yourself, and your accountant may not want to work this way. hledger’s FAQ suggests having them use hledger-web or giving them CSV or HTML reports.

If you bill customers, hledger’s documentation shows how to record invoices and payments as receivables and list what is still unpaid, and the Plain Text Accounting site has an invoicing page with the same approach. That is bookkeeping entries, not invoice documents. Making and sending the invoice itself takes a separate tool, such as kairos, which that site lists. We checked invoicing in hledger’s documentation only, not in Beancount’s or Ledger’s. For payroll we found nothing in hledger’s documentation beyond entering the figures yourself, so if you run payroll, plan on a separate payroll service or process and have your accountant confirm how it will feed the books.

The Plain Text Accounting site lists community converters from QuickBooks exports to this format, such as qb2ledger and outofit. We have not tried them, so treat them as starting points to check against your own books.

Frappe Books

Frappe Books is free, AGPL-licensed accounting software from the same project family as ERPNext, with double-entry books, invoicing, inventory and reports. The current version runs on a server you set up and is used in a web browser. Its website says the older desktop app is no longer supported, so you will be running a server. If you would rather not run one, GnuCash is the desktop option with a graphical interface.

ERPNext

ERPNext is a full ERP. It covers accounting, invoicing, customers and suppliers, and inventory, under the GNU GPLv3. Payroll and HR live in a separate companion app, Frappe HR, which requires ERPNext. It makes sense when you need that wider system and have someone to run the server, keep it updated and learn its setup. For books alone, a smaller tool may be enough.

Watch the license on any tool you consider

Some software marketed as “open source accounting” is not. Akaunting, for example, is released under the Business Source License 1.1, which limits free production use and converts to GPLv3 only after four years. We do not recommend it here. Read the license before you build your books on any tool.

Firefly III

Firefly III is a good self-hosted tool for tracking your own money. Its documentation says its features are geared toward personal finance and that it does not cover small-business accounting or payroll, so it is not a QuickBooks replacement for a business.


A careful migration plan

QuickBooks Online exports are not a ready-to-import replacement for your books. Expect to reshape the data for the tool you choose.

Step 1: Export everything you can

  • In QuickBooks Online, an admin can export reports and lists to Excel from the Export data option in settings. Postings from transactions, attachments and some other data are separate, so check what the export leaves out.
  • Export your chart of accounts, customer and vendor lists, the general ledger for all dates, and the year-end reports your accountant uses.
  • Keep the original QuickBooks data and exports. Do not cancel the subscription yet.

Step 2: Choose a tool and test with a copy

Install your chosen software and practice with a sample or a small slice of your data. Confirm it handles what you actually do: invoicing, sales tax, multiple currencies, payroll, several users.

Step 3: Rebuild the chart of accounts

Recreate your accounts in the new system, tidying as you go. If you work with an accountant, have them review the structure.

Step 4: Bring in your history

  • GnuCash cannot read QuickBooks files directly. Its own FAQ says the usual route is to get your data into CSV (or QIF) and import that, and the project says it has no plans for a QuickBooks importer. Expect to map columns and fix some entries by hand.
  • hledger can import CSV using a rules file you write for the columns in your export. For Beancount and Ledger, look into the converters mentioned above, or write your own conversion.
  • ERPNext has a Data Import tool that accepts CSV or Excel files. Its documentation says to import masters (such as customers, items and accounts) before opening balances and transactions, and to start from the template it generates for each record type. Frappe Books has an Import Wizard that takes .csv files. With either, you will need to reshape your QuickBooks exports to match.
  • One option is to skip a full history import: bring in opening balances as of a clean cutover date (such as the start of a fiscal year) and keep the old QuickBooks export as an archive. Ask your accountant to review the cutover.

Step 5: Reconcile before you trust it

Compare the new system’s balance sheet and profit and loss against QuickBooks for the same date. Totals should agree, and any difference should be explained, not ignored.

Step 6: Run both for a period

Keep entering transactions in both systems for at least one full accounting period. Switch off the old one only after the reports match and your accountant is comfortable.


Is it worth it?

For a sole proprietor with straightforward books, GnuCash is a solid, low-cost choice. If you like working in text files, hledger is worth a look. For a small team that wants a browser app, Frappe Books is worth a look. ERPNext is for businesses that need an ERP, not just books. For a business with payroll, sales tax across states, or an accountant who works only in QuickBooks, the honest answer may be to stay put.

Looking for more free and open-source tools? Browse FOSS Index for other projects to explore and support.

If you would like a second pair of eyes on your options or your migration plan, send us a message.

Related Posts

Getting Started with Home Assistant: Automate Your Smart Home Without Big Tech

Escape the Google and Apple ecosystems. Here's how to set up Home Assistant and take back control of your smart home from Big Tech.

Read More

Is self-hosting a good fit?

Running a service yourself means taking responsibility for it. The question is whether that responsibility suits your needs.

Read More

How to Set Up a Self-Hosted Cloud with Nextcloud: A Beginner's Guide

Stop renting your data to Big Tech. Here's how to set up your own private cloud with Nextcloud and actually own your files again.

Read More

* Links marked with an asterisk go to our FOSS Index, not the project’s own website. Each entry includes official project links and other useful references, including support options where available.