Live data from Hacker News

Plain Text Accounting (PTA)

plaintextaccounting.org

31–40 of 123 posts

Re: Plain Text Accounting (PTA)

#31
post #27
post #25

Systems that use immediate strict categorization don’t work for some people. At a company I worked at we went with a two-phase approach. A person would write notes (literally iphone notes) in the following format: Apr 5 24 -50 Alice tools -220 Bob home project Apr 2 24 +20 Bob returned loan Note that time goes “up” to avoid scrolling too much on open. Later we loaded it into a script which would parse dates, detect k…

It sounds like what you are doing is plain text accounting! > Later we loaded it into a script which would... I too do not manually enter things in the ledger file (well, rarely). I actually enter it into KMyMoney, and have a script to convert to a ledger file. Overall, your comment is coming across as a fairly weird complaint. It's a tool, and given that its in text, you're free to build whatever workflow you wish a…

It’s not a complaint, just an observation that anything non-natural language simply didn’t work for almost 100% of my “patients”, including myself. This format isn’t even a format. It’s how they write notes for themselves with a little agreement on regularity to simplify the parser.

Btw, we tried everything: appstore apps, web forms, our own app. Everything sucks irl except just text. I still use this entry despite not having a database anymore for a script to load my data into.

Re: Plain Text Accounting (PTA)

#32
I’d appreciate hearing how others have used the various plain text accounting tools for their own use. Are you legitimately using it to inform yourself of your spending habits and taking corrective action? Is it simply for tracking your expenses, revenues, net worth, etc? Or is it simply about the process? I can certainly see the appeal of such an orderly, structured process.

Every time I’m reminded of plain text accounting, I have either an irresistible urge to immerse myself fully into the process, or feelings of guilt for not staying committed to my previous attempts. Right now, it’s mainly guilt, since I’ve not updated my personal ledger in a month and a half. Ultimately, I think I’m unsure about why I’m using it, and eventually feel like I’m logging transactions just for the sake of it.

Re: Plain Text Accounting (PTA)

#33
post #32

I’d appreciate hearing how others have used the various plain text accounting tools for their own use. Are you legitimately using it to inform yourself of your spending habits and taking corrective action? Is it simply for tracking your expenses, revenues, net worth, etc? Or is it simply about the process? I can certainly see the appeal of such an orderly, structured process. Every time I’m reminded of plain text acc…

I'm self employed and use it (Beancount, as I like the more strict approach) for my business accounts and also for my stock portfolio. Fava, the web UI, is very handy for reporting and visualising things, though I also have a few scripts to automate certain processes like importing transactions from Wise and tracking exchange rates. I really don't have the discipline to use it for daily personal expenses or budgeting though.

Re: Plain Text Accounting (PTA)

#34
post #32

I’d appreciate hearing how others have used the various plain text accounting tools for their own use. Are you legitimately using it to inform yourself of your spending habits and taking corrective action? Is it simply for tracking your expenses, revenues, net worth, etc? Or is it simply about the process? I can certainly see the appeal of such an orderly, structured process. Every time I’m reminded of plain text acc…

I use it for many things (i use hledger)

- Tracking pending payment from clients

- Keeping track of my expenses in various sectors, food (groceries, eatout), books, magazine subscriptions, etc

- Keeping track of my current balance accounts across various currency deposits

- Loans I give to people, and gifts I give to people

- Creating virtual envelops to segregate my savings account money for my goals like travelling, buying gifts for someone, investment goals, etc

This has helped me tremendously

- for reducing my eatout habits and eating more at home by realising just how much I was wasting money by eating out daily, and inputting the saved amount into compound interest calculator to realize potential lost income and wealth from putting those into an index fund account

- to keep track of pending payments from clients and calculating my real cashflow against cashflow based on expected income

- reduce my impulsive spending, by tracking my savings account money with virtual envelops aka 40% for investment goals, 1% for gifts, etc, it helps me to not just see a big balance on my account and start spending it away seeing that money as segregated chunks in my mind helps me stay in my lane.

- I have a program that generates all sorts of charts to track my wealth growth over time, expense growth and decline across categories, which I then dump into a webpage with my notes on how the changes were a net positive or negative outcome on my life, I do it annually to decide what i’ll do next

- I also have a python script that takes my ledger file and converts it into an excel sheet to send it to my chartered accountant to file my annual taxes

I also maintain a separate ledger file for my business (I dont maintain that one manually, I just export the data from accountant’s software, to do my own calculations at home)

- I use it to calculate cashflow projections to predict how my expenses might potentially grow with rise in revenue

- Track categories of spending to spot anomalies in spend across departments

- Calculate whether I should hire more or raise marketing spend, calculate metrics like ROIC (Return on Invested Capital)

The double entry helps me catch discrepancies in accounting if any, by importing bank statements and generating a ledger from that, I have accounts separated by usecase (discretionary spends, employee perks, business inputs) , with each one getting deposit from main account weekly. I use that to calculate if somethings odd and books are all cool.

I have had trouble before with an accountant running pseudo expenses on my books without telling me, just to impress me by showing a high taxes saved, without being transparent, landed me in court once, with a huge fine with late penalties.

Now I dont trust accountants and make sure I double check no matter what.

Plus I have a lot of automation scripts and stuff, imports from stripe account, imports from bank statements, accountant’s own ledger, etc

I match them all with python scripts and try to look for discrepancies.

I love plain text accounting, as a programmer it works for me, I automated a ton of it, and I have tons of my own macros and shortcuts in my code editor(vim) to make things very easy and simple,

I love it overall, I built out my own system on top of hledger across the years.

Re: Plain Text Accounting (PTA)

#35
Not entirely related to this but, I always wanted to download my transaction information from the banks and keep it locally on a periodic basis so that I can keep track of the transfers I have done to a sepefici account. From a business perspective this is very much helpful, but not able to find any free and opensource solution for it. Have done something using Python , but updating it in a periodic basis is difficult considering there is no API there to provide this data.

Re: Plain Text Accounting (PTA)

#38

I've been using Beancount, really enjoyed learning it, writing tools for data import and having a hands-on experience with accounting. But it's been almost a year since I last imported data, I planned to do it monthly but it's a bit of a chore (it takes 30 to 60 mins despite a lot of it being automated).

Use teller.io, it’s super easy to setup imo (compared to Plaid). I use it to sync my chase bank + credit card statements on a gsheet.

Re: Plain Text Accounting (PTA)

#39
Is there an text editor that is able to autocomplete the categories in hledger format ? It would be great to type Assets:: and then get a list of the possible categories, but I haven't found any editor or extension that does it.

Re: Plain Text Accounting (PTA)

#40
post #23

I'd embrace plain text accounting more if it had a better schema. Ledger's is absolutely atrocious, and it drives my OCD nuts trying to use vim to "write" accounting entries. I think my ideal PTA would be some kind of jsonnet-based system where I can create/call functions to generate journal entries.

GNU recutils should become the standard backend. Plain text db which has a powerful albeit simple records format, proper ids, enforces constraints, removes need of silly type conventions better defined in fields with %type, built in encryption. Foreign keys. Auto generated fields. Regex. No one in their right of mind will want to manually edit the data store holding critical accounting data. 99% of the times should b…

A recutils clone in Go would be pleasantly hackable for whipping up some double-entry.
Post reply on HN