I need to do bookkeeping for multiple accounts (several bank and cash accounts).
I would like to be able to record transactions “Bought stuff -100$”, “Got paid +1000$” but also states “Checked wallet: =35.50$”.
My idea was to structure it like this:
but I’m not sure if this is a good idea and how to handle several accounts in this way. I could do a separate sheet for each account. That seems easier to implement but with at least 8 accounts it will be annoying.
Any suggestions?
In my opinion it depends on that what is your goal with this spreadsheet. For example: If you need filter one type of transactions of the Accounts, then better to use only one sheet. If the Account are independent account (there are not any cross-calculations between them), them it is better to handle them on different sheets.
And it depends on that you want store more data of more than one years in a single sheet/file or only one year data. Too much data on one sheet has some disandvantages.
You must decide it.
I would prefer having all the transactions in one place because it is easier to audit and get an overview but I couldn’t figure out how to adjust the balance. For a single account I want something like this which immediately highlights when the balance is off:
(Sheet 2)
example.ods (18.8 KB)
But doing the same for multiple accounts in a single sheet seems really hard.
Another option with:
=SUMIFS(D$2:D3;C$2:C3;$C3)
As a spreadsheet developer, I use GnuCash for accounting…
Alternatives could be MoneyManager Ex or KMyMoney.
I agree that there are probably better solutions but the people who will be auditing this should all be fairly comfortable with spreadsheets. Maybe I should try GNUcash again and see if I can print something nice with it.
I really like how your example formats calendar dates in ISO 8601 format. I’m unable to set LibreOffice to format dates in ISO format. How did you manage this?
It’s under Date Formats you just have to scroll down a bit. 
It might depend on your locale setting what you see there.
Thanks, that works, but I thought it would automatically start out reflecting my locale, but it doesn’t. I have to manually format the cells each time. It also shows “December” as “Tevet”, which appears to be Jewish. That seems to carry formatting a bit too far since I’m nowhere near Israel.
Perhaps you should start a new question as this has nothing to do with the original question.
