This method of using Google Forms with Google Sheets was ostensibly designed to gather and analyze survey data, but with a few tweaks it works just as well to record your financial transactions ...

You can use Google Forms to create online surveys, quizzes, and feedback pages. Here’s how.

As a creator, you can view respondents' answers on Google Forms in three different ways: as a summary, by question, or by individual respondent.