Building a Loan Tracker That Lives in CSV Instead of a Spreadsheet

I track several private loans — money I owe, money owed to me, money owed to family. The default tool for this is a Google Sheet with formulas. I tried that for three months and it didn't work, because every loan payment required me to open the sheet...