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 ...

Google Docs is better suited for creating printable forms. Google Forms is ideal for gathering data from a large number of respondents.

You can create automated document workflows in most Google Workspace apps, including Google Docs, Sheets, Gmail, and Forms. How to automate document workflow: Apps Script vs. add-ons ...