Not really, I don't do much in excel anymore, And I probably should not be giving advice as I have no classical training in accounting. But the ledger docs have a pretty great introduction to basic accounting theory. It is not too difficult to apply this theory into whatever data storage engine you are using.
That simple schema fails to represent split transactions. I went the superstore and bought groceries, computer gear, and a new battery for the car. Oh and my spouse handed me a $100 bill to cover some of the cost.
Yes, a simplified schema like that fails to capture the entire semantics of a transaction. However, I find for personal finance I never need full transaction semantics and simplified two party semantics are much easier to enter and calculate.
I will be honest, I use ledger and I like how it can express the complex transaction, however I also have to admit that I have never used them. If I were storing my finance data in a relational database or a spreadsheet, I would be very tempted to use the simplified two party model. I probably would not actually do it, but when I am elbow deep in code making sure to handle N-Party transactions correctly, I would be tempted.
The author of the plain text accounting system(PTA) went with this simplified model and made a good case for it, one line per transaction is much easier to parse, for both the human reading them and the machine. note that PTA does support split transactions but they are the special case.
The main problem is that I don't want to give a third party access to my bank accounts, so importing into gnucash is (1) download pdf statements from bank (2) use python scripts I wrote to convert to csv (3) use gnucash importer to import.
This is fairly painful stuff, more so because my bank statements are all generated on different days of the month. So I can't form a habit of doing this regularly enough to make the data useful.
Welcome to Canada. The checking/saving account statement is in csv. The credit card statements are only provided as pdf by my bank. That's where most transactions are.
Just started using it last month. Used Mint until a year or two after Intuit bought it, then basically did no real budgeting until my recent GnuCash use.
A few YouTube vids made the interface less daunting and I read a few Reddit comments on how people use it themselves, and I'm applying what I can to my own setup.
If there's anything a new GnuCash user should read or learn, please let me know!