Google Forms is a powerful tool for creating surveys, quizzes, or forms for data collection. When linked to Google Sheets, responses are automatically organized in a spreadsheet for easy analysis.

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

The post mentions, “Smart Fill for Google Sheets, which detects and learns patterns between columns to intelligently autocomplete data entry”.

You can create a custom template in Google Sheets even if you do not have a Google Workspace (G Suite) subscription. Make a blank sheet with all raw information & copy-paste it.