Head over to the signups tab in your Google Spreadsheet, if the tab doesn't exist yet is because no one has signed up for your event. Go ahead and signup to your event just to get some data in this tab.
The first couple of columns contains the basics, such as a unique id that each signup receive, the timestamp when they signed up, their name and email.
Please note that you should not delete any rows in the signups tab because invoice numbers are automatically generated. Instead, set the Active value to FALSE and apply a filter to hide all inactive rows.
💡To create a filter click on any column in the first row then up in the menu bar click data -> filter
The next couple of columns will be the fields that you have added to your registration form, then the columns that start with Ticket: is the tickets that you sold.
This makes it really easy for you to see the total amount owed by person
✅ A best practice would be that whenever you receive a payment you add two new columns called "Paid" and "Paid at", where the first would contain the amount paid and the other the date on which the payment was received.
By doing so it will enable you to track payments properly, but also make it possible for you to create another tab that you can use for reporting, like building charts to track invoiced amounts vs paid, number of signups per week and so on. We will add a guide about this later on so for now you can simply Google "how to create charts with Google Sheets" which should give you the basics.
That's it for now