[dorfsmay]

This is really interesting. I've had ideas about accounting as a specialized spreadsheet for a while, both because most people grok spreadsheets naturally and because accountants only want csv files.

In fact I wrote a small script to extract GnuCash transactions into a csv file that can be used as a spreadsheet as a starter point:

https://github.com/dorfsmay/gnucash_general_journal

(There are still issues with this, especially with the way GnuCash converts currencies)

I'll definitely take a look at WeKeep, it might solve some of my issues, and I might just stop my efforts if you got where I was hoping to get.

[nadima]

Couldn't catch the reason behind the "one column per account" layout – you mention it's to show splits, can you elaborate on this?

In WeKeep all general ledger transactions can be looked up under Reports > Account Transactions, laid out in as a spreadsheet https://www.wekeep.co/c/dashboard/account-transactions/ Here's a screenshot: https://imgur.com/a/6eKNgKr

[dorfsmay]

So that somebody who has access to the CSV file only has a per account view, they can look at all the transactions for a specific account, the same way they'd look at the account in GnuCash.

One column per account is what enables at looking at splits on a given line.

For liabilities account, it also allows to do a quick verification that the total is zero.