Track your cashouts for the 2017-18 tax year

Things to do before you start:

Please note: Setup is easiest on a desktop. If you’re using your mobile for the setup it gets much more complicated.

Step 1:

Click on the image to copy the spreadsheet to your Drive.

Once copied, the spreadsheet will open.

Step 2:

Click on Form in the toolbar. From here you can:

Send the form to yourself (via email or get a link)
Go to the live form. This is where you’ll input data. If you want to add it to your mobile homescreen, choose this option and then follow the instructions below.

Step 3:

If you chose to send the form to yourself, follow these instructions. If you’d like to add it to your homescreen scroll down to 3.2.

3.1 – Send the form to yourself or get a link

Click on Send

There are two ways to get the link for the form.

First, email it to yourself. You can even include the form in the email so all you have to do is open the email & enter the info. Make sure you save the email somewhere that you’ll remember so you can access it easily.

Second, copy the link to the form. I’ve used the short link version here. If you go this route, make sure you save the link somewhere safe, or use a service like bitly to create a custom link that you won’t forget.

3.2 – Add the form to your mobile homescreen

Either follow Step 3.1, or open the live form. Copy the URL and send it to yourself so you can open it on your phone.

Open the form on your mobile via the link you sent yourself, then add it to your homescreen.

To add the spreadsheet to your homescreen, follow the same steps.

Step 4:

You can now enter your data into the form. Every cashout must be recorded separately.

Every question with a red star is required. You won’t be able to submit the form if you haven’t answered them.

You will be asked to enter:

Day/Date – the two digit day of the month
Month – These are prefaced with numbers so that the table sorts them correctly
Year
Site – I’ve included some of the most popular sites. They are numbered for the same reason the months are.
Amount
Method – What you cashed out for.
Notes – In case you want to record any other information

When you’ve entered all the info, click submit.

You can now submit another cashout or continue on to the next step.

Step 5:

Once you’ve added in some data, go back to the spreadsheet. You should now see all the data that you submitted via the form.

You can ignore this sheet unless you want to add in more data on the spreadsheet itself.

Column A is the timestamp of when you entered the data in the form. Just leave that column alone.

If you have past data to add in, you can do so in the spreadsheet. You don’t have to use the form every time, just make sure you follow the format for each cell or the tables in Step 6 won’t work correctly.

Step 6:

Click on the Monthly Overview tab at the bottom of the sheet. This is the magic page. It takes all the info from the Input sheet and creates overviews for you.

Using pivot tables (I’ve set these up for you), you can see all your cashouts (that you’ve entered in the form/spreadsheet) combined by Month and separated by Site or Method.