Skip to content

cynco-labs/ai-accounting-skills / accounting-engagement/skills/export-beancount

export-beancount

Verified

Export balanced journals to Beancount ledger SoR (prove job). Use when beancount or export ledger.

/export-beancount

Purpose

Push final (or draft-marked) books into Beancount — the ledger system of record.

workpapers/journals*.json + COA → ledger/main.beancount → Fava

Excel remains human working papers. Beancount is where the ledger lives for agents and git.

Load: references/beancount_integration.md

When

SituationOutput
QC passed / finalise doneledger/main.beancount
User wants mid-engagement previewledger/draft.beancount (label provisional)
Unbalanced journalsRefuse until fixed

Preconditions

  1. workpapers/journals.json exists (and journals_ye.json if YE posted)
  2. Prefer workpapers/coa.json or entity COA template
  3. Each JE: sum(debit) = sum(credit)
  4. pip install beancount recommended for --bean-check

Command

python3 scripts/export_to_beancount.py \
 --client-dir "<client_workspace>" \
 --output "<client_workspace>/ledger/main.beancount" \
 --bean-check

Or explicit paths:

python3 scripts/export_to_beancount.py \
 --journals workpapers/journals.json \
 --journals-ye workpapers/journals_ye.json \
 --coa references/coa_templates/coa_sdn_bhd.json \
 --currency MYR \
 --title "LEGAL NAME SDN. BHD." \
 --output ledger/main.beancount \
 --bean-check

What the exporter does

  1. Map COA codes → Beancount accounts (Assets:…, Liabilities:…, Equity:…, Income:…, Expenses:…)
  2. Emit open directives
  3. Emit one Beancount transaction per journal entry (DR +, CR −)
  4. Write *.account_map.json sidecar
  5. Optional bean-check

Completion

Done when: ledger/main.beancount written from balanced journals; refuse if any JE unbalanced.

Outputs

  • ledger/main.beancount (or draft path)
  • ledger/main.beancount.account_map.json
  • Update engagement_state.json: artifact beancount_ledger, stage note

Next

  • validate-beancount if check not run
  • open-fava to show the user

Failure modes

IssueAction
Unbalanced JEStop; fix journals
bean-check failShow stderr; fix mapping/dates
Missing beancount installpip install beancount fava once
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 198kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 194kUpdated Claude CodeCodexVerifiedInstall