90% convinced accounting should be a programming role. Accumulating data from multiple sources into your chart of accounts almost always requires code of some kind. I’m guessing this is never done properly and accounts are just inaccurate because of this.

With ledger-cli + sql and parsing zap data I can have very accurate balance sheet of zap donations, total zaps broken down by posts, merch sales, even cln routing fees earned, sats lost due to channel close fees, etc. couldn’t have done it without code.

also gm nostr

Reply to this note

Please Login to reply.

Discussion

gm. Was this stream of consciousness before or after coffee?

This is my brain immediately after waking. Its part of the boot process or something. Some kind of power-on-self-test

Right on. That little space between being awake and dreaming.

Keep napping! 😂 and gm ☕️

Hopefully without errors.

GM☕️🫂

totally agree and big for ai

gm brov

I used AI to build the boilerplate code for converting some of the source data to ledger-cli postings. Was thinking LLMs would also be good at building the chart of accounts and categorizing transactions as well… not sure i want to send this data to openai though :/

We need #edgeai

You don't have to share with OpenAI using LLaMA.

It's already possible to run it in a browser environment🤯(currently only the new chrome afaik):

https://mlc.ai/web-llm/

I plan to integrate it into https://autobtc.ai very soon, so I'll be able to share how good it is.

In the new AI podcast from @Guy Swann @Jeff Booth mentioned a self hosted GPT that was very comparable. Might want to check it out if you think #edgeai could be useful for this.

Great morning sir, thank you for your hard work

GM! 🤙🏽☕️☀️

GM.

But accounts aren’t there to ensure the numbers are right.

They are there to make them look right.

😉🤫

Last year I started learning accounting for the first time. I found hledger with text-based journals to work well. I don’t know to what degree it differs from ledger-cli. https://hledger.org/

Agreed that accounting is probably best done as a programming job. 😅

afaik hledger is just a haskell reimplementation of ledger-cli. Highly recommend the cli version. Its really good once you learn the commands. Docs are really good as well.

Python Pandas and Numpy modules are really handy.

I’m 90% convinced every role should be a programming role.

It is, just that its all excel macros 😱!

GM!

Yeah, I told my brother to avoid accounting as a major and instead focus on computer science and/or math in college. AI is a part of every industry now, including art and entertainment.

Advanced Excel is programming.

GM

Agree it should be automated where possible, but either way is why reconciling cash at bank is so key.

Gm, are you using QuickBooks or what?

Very cool never heard of this before. Whenever you need a full erp hit me up i sell netsuite in the fiat mines

In the meantime I’d settle for an accountant that can read a block explorer.

I worked on enterprise fiat accounting software for about a decade and one of the toughest parts is reconciling things like checks that may or may not clear, and data is always delayed and often comes from archaic format text files. Bitcoin and lightning and nostr plus fedi and cashu and all the rest will fix this. Live async comms and instant final settlement means instant reconciliation. Added bonus of much less toxic PII, ie don’t need vendor /customer id or bank info to pay or get payed.

Accountants need the drive for automation that some have latched onto in software. I’ve seen programmers who fail to automate so they struggle as well with speed and correctness.

All to say that making an accountant a programmer doesn’t imply they we’ll have the desired outcome.

GM

Worked in investment fund accounting for a large custodian. It was a sysadmin role with a layer of input data quality checks. Computers did all of the “accounting”

🤯 💯

you do know this has been a thing for decades. enterprise grade ERP subledgers do this, and yes about 98.6+% automated