For easier data manipulation and more in-depth analysis, I prefer transferring Google Forms data to a Google Sheets spreadsheet. Here's how I do that.

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.

In Google Sheets: If you inserted a form into a Google Sheets spreadsheet, the summary of responses for your form appears as a new sheet in that spreadsheet. From the Responses tab in Forms, click ...

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