GPT Genies

Track your cashouts for the 2017-18 tax year

Things to do before you start:

Sign in to Google.  You’ll be copying some documents to your Google Drive and it’s slightly simpler if you sign in first.

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.Screen Shot 2017-09-28 at 17.36.43

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

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

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

Screen Shot 2017-09-28 at 18.19.26

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

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

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.

Screen Shot 2017-09-28 at 17.03.38

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.

Screen Shot 2017-09-28 at 17.03.57


Click here to give me some feedback on how the form/sheet is working for you


Hannah’s helping hand:


Want to learn more about Swagbucks?  Click here.

Join our Facebook group to get support & advice that will help you earn.


Join Swagbucks now!

Swagbucks is one of my favourite GPT sites.  You can do all kinds of things to earn points, called SB, on there, including: surveys; videos; searching the web; and more.

I make at least £100 a month on Swagbucks alone by spending less than an hour a day completing tasks.

Leave a Reply

Your email address will not be published.