Pastis, it's a database thing rather than spreadsheet. From the bank account transactions items are posted to various expense/income accounts and are held as separate records. They can then be searched/compared/reported on in various ways.
I've used Excel from the year dot, a bit later started using Access (database program) and I realised that many spreadsheets I had created would have been far better in Access.