3 ms·
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 b
by dorfsmay 7y ago
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 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 7y agoCouldn'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/ https://www.wekeep.co/c/dashboard/account-transactions/ Here's a screenshot: https://imgur.com/a/6eKNgKr https://imgur.com/a/6eKNgKr
- dorfsmay 7y agoSo 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.