Skip to main content

Detox Your Small‑Business Finances — the Beancount Way

· 10 min read
Mike Thrift
Mike Thrift
Marketing Manager

Turn one messy ledger into a calm, cash‑confident business in 30 days—using plain‑text accounting.


2025-09-04-detox-your-small-business-finances

TL;DR

  • Separate, simplify, and lock your books with a lean chart of accounts, consistent imports, and automated balance checks.
  • Surface what matters—COGS, overhead, cash runway—via quick bean-query reports.
  • Cut the noise (unused subscriptions, duplicate tools) and codify good habits (weekly reconcile, monthly close, receipts attached).
  • Make tax season boring by keeping statements, receipts, and balances verifiable in one place.

Why a “Detox”?

Financial clutter in a small business isn't just messy—it's expensive. It hides wasteful spending, obscures your true profitability, and turns tax season into a frantic scavenger hunt. A financial detox is a focused, 30-day reset: you identify what moves (and leaks) money, remove the complexity, and then institutionalize simple, repeatable routines to keep it clean.

Beancount is the perfect tool for this because it’s transparent, scriptable, and verifiable. Unlike black-box software, a plain-text ledger means every number is explainable. Every check and balance can be automated with directives and queries, creating a self-auditing system that forces clarity. This guide will walk you through a four-week plan to achieve just that.


Week 0 — Set Your Baseline

Before you can clean up, you need a solid foundation. This week is about defining the structure of your financial world.

Create a Lean Chart of Accounts

Your chart of accounts is the skeleton of your financial system. The goal here is minimalism. Don't create an account for every possible expense you might have. Start with the essentials you use today; you can always add more later. A cluttered chart of accounts encourages miscategorization and makes high-level analysis difficult.

Here’s a simple, effective starting point:

; Core entities
2025-01-01 open Assets:Bank:Checking USD
2025-01-01 open Assets:Bank:Savings USD
2025-01-01 open Liabilities:CreditCard:Business USD
2025-01-01 open Income:Sales
2025-01-01 open Expenses:COGS
2025-01-01 open Expenses:Overhead:Rent
2025-01-01 open Expenses:Overhead:Utilities
2025-01-01 open Expenses:SaaS
2025-01-01 open Equity:Opening-Balances

Lock Balances You Can Verify

The most powerful feature in plain-text accounting is the ability to assert reality. A balance directive tells Beancount: "On this date, this account had exactly this much money." If it doesn't, Beancount will raise an error. This is your primary safety net.

When starting out, use pad in combination with balance to initialize your accounts from a bank statement. The pad directive creates a transaction that forces the account to the correct starting balance, booking the difference to an equity account.

; Initialize from statements
2025-01-01 pad Assets:Bank:Checking Equity:Opening-Balances
2025-01-01 balance Assets:Bank:Checking 12345.67 USD

A word of caution: Use pad sparingly. It's for getting started cleanly, not for papering over recurring reconciliation mistakes.


Week 1 — Separate and Simplify Flows

With a structure in place, it's time to clarify how money moves through your business.

Keep Business ≠ Personal

This is the golden rule of small-business finance. Co-mingling funds is a recipe for confusion and tax-time headaches.

  • Maintain one dedicated business bank account and one business credit card.
  • Mirror this separation in your ledger: Assets:Bank:Business:Checking, Liabilities:CreditCard:Business.
  • If you pay yourself, book it as a distribution to Equity:Owner-Draws. Never categorize personal expenses directly from business accounts.

Standardize Vendor Categories

Do you pay for AWS, Google Cloud, and Vercel? Don't create three separate accounts. Map them all to a single, logical category like Expenses:Cloud. Avoid creating micro-accounts you won't actually analyze. The goal is to see patterns, not to track every single vendor with its own account.


Week 2 — Automate Inputs and Receipts

Manual data entry is slow, error-prone, and unsustainable. This week is about building a machine to feed your ledger reliably.

Build a No-Drama Import Path

Beancount's import framework lets you teach it how to read CSV or OFX files from your bank and automatically generate transactions. Invest the time to set this up once, and you'll save hundreds of hours down the line. Keep your importer rules in version control (like Git) so your system is repeatable and backed up.

  • Start with Beancount’s official Importing External Data guide.
  • For a more interactive workflow, consider a tool like beancount-import, which provides a web UI for semi-automatic matching.
  • Many users rely on the built-in ingest or newer beangulp frameworks to build their custom importers. Pick one and stick with it for consistency.

Attach Documents Where They Belong

A transaction without a receipt is an unsubstantiated claim. Beancount and its web interface, Fava, make it trivial to link source documents to entries, creating an unshakeable audit trail.

You have two great options:

  1. Documents Folder + Directive: Store all your receipts and statements in a dedicated folder. Then, link a file to a transaction using the document directive.
  2. Drag-and-Drop in Fava: Simply drag a PDF or image file onto a transaction in the Fava UI. Fava automatically stores the file and inserts the correct document directive into your ledger file for you.
; In your main ledger file, tell Fava where your documents live
option "documents" "/home/acme/docs"

; Link a receipt to a specific transaction posting
2025-08-07 * "Figma" "Monthly Subscription"
Assets:CreditCard:Business -12.00 USD
Expenses:SaaS 12.00 USD
document: "receipts/figma-2025-08-07.pdf"

Week 3 — See the Truth (Fast Queries You’ll Reuse)

Your ledger is now clean and fed with data. It's time to ask it important questions. Fire up the bean-query command-line tool to get instant answers.

1) Where’s My Cash?

Get a quick snapshot of your liquid assets.

bean-query business.beancount 'BALANCES FROM year = 2025 AND (account ~ "Assets:Bank" OR account ~ "Liabilities:CreditCard")'

This gives you an immediate, real-time view of your cash position without logging into multiple bank portals.

2) What Am I Spending On Overhead vs. COGS?

Understand where your money is really going. Are you spending more on non-essential overhead or on the costs directly tied to delivering your product (Cost of Goods Sold)?

SELECT
account,
units(sum(position))
WHERE
account ~ "^Expenses:(Overhead|COGS)" AND year = 2025
GROUP BY
account
ORDER BY
account

This query separates your core operational costs from your administrative burden, a critical insight for profitability.

3) Which Subscriptions Look “Zombie”?

Find recurring, small-dollar expenses that often fly under the radar. These "zombie" subscriptions can bleed your cash flow dry.

SELECT
payee,
COUNT(*) AS num_transactions,
SUM(number) AS total_spent
WHERE
account ~ "^Expenses:SaaS" AND date >= '2025-01-01'
GROUP BY
payee
ORDER BY
num_transactions DESC,
total_spent DESC

This query instantly reveals vendors you pay frequently. If you see one you don't recognize or no longer need, it's time to cancel.


Week 4 — Tidy and Lock the System

The final week is about building the habits and guardrails that keep your finances clean for good.

Put Simple Budgets in Place

Fava can read budget directives from your ledger and display helpful progress bars in its reports, showing you if you're on track. This provides a gentle, constant reminder of your spending goals.

; Cap SaaS spending at $100 per month
2025-01-01 custom "budget" Expenses:SaaS "monthly" 100.00 USD

Set these for key variable expense categories like software, advertising, or contractors to notice drift before it becomes a problem.

Close the Month, Every Time

Establish a simple, non-negotiable monthly closing process:

  1. Reconcile: For every bank and credit card account, add a balance assertion matching the final number on your monthly statement.
  2. Attach: Attach the PDF statement itself to the balance entry using the document directive.
  3. Report: Run your three saved queries (cash, overhead/COGS, subscriptions) and paste the outputs into a short monthly review note.

The balance assertion is an automatic tripwire. If your ledger doesn't match the bank statement, Beancount will throw an error, telling you exactly where to look for the discrepancy.


Make Tax Season Boring (In a Good Way)

By following this system, you transform tax preparation from a crisis into a simple reporting exercise.

  • Receipts are attached to transactions, so there’s no frantic search. In Fava, you’re one click away from the source document for any expense.
  • Tax-relevant items can be tagged (e.g., #tax-deductible), allowing you to pull a clean report with bean-query for your accountant.
  • Year-end balances are locked and verified with balance assertions, giving you and your preparer confidence in the numbers.

A 30-Day Checklist (Print This)

  • Day 1–3
    • Create a minimal chart of accounts.
    • Add pad + balance for each bank/card using the latest statements.
  • Day 4–10
    • Set up one importer pipeline and commit your rules to version control.
    • Backfill 90 days of transactions; run a first BALANCES snapshot.
  • Day 11–15
    • Standardize vendors to their respective accounts (SaaS, Cloud, Shipping, etc.).
    • Attach statement PDFs for the reconciled periods; confirm they appear in Fava.
  • Day 16–20
    • Run the overhead vs. COGS query; fix any miscategorized items.
    • Run the subscription frequency query; cancel or consolidate unused services.
  • Day 21–25
    • Add one or two budget caps for key variable expenses via custom "budget".
    • Save your three most important bean-query commands to a script for easy reuse.
  • Day 26–30
    • Reconcile all accounts with month-end balance assertions.
    • Write a short "monthly close" note summarizing key numbers and linking to documents.

Common Snippets You’ll Reuse

A Clean Expense Posting

2025-08-05 * "Figma" "Pro plan"
Expenses:SaaS 12.00 USD
Assets:Bank:Checking -12.00 USD

Balance Assertion from a Statement

2025-09-01 balance Assets:Bank:Checking  8423.17 USD

Budget Guardrail for Rent

2025-01-01 custom "budget" Expenses:Overhead:Rent "monthly" 2500.00 USD

Keep It Simple, Keep It Scripted

The philosophy of a Beancount-powered financial detox is simple:

  • Script what you repeat: Automate imports and reporting.
  • Let assertions fail loudly: They are your safety rails, not an inconvenience.
  • Prefer fewer, clearer accounts over perfect, granular categorization.

Adopt these habits, and your business will run on tight feedback loops: cash visibility daily, spending drift visible weekly, and a truly boring year-end. That's the clarity and control this detox is designed to deliver.


References & Further Reading

This post is for educational purposes only and is not tax or legal advice.