If you’re earning money online, it’s important to track how much you’re earning. In some countries (maybe all), you have to declare your earnings for tax purposes as it’s considered income so it’s very important to keep accurate records.
So, to help you, I’ve created a spreadsheet to keep track of what you’re earning. It’s hosted on Google Drive so you will need a google account to use it. The advantage of using an online spreadsheet is that you can access it from anywhere and it’s automatically saved and backed up.
See which sites I recommend for earning extra cash online!
Read on to see how to copy the spreadsheet to your own Drive and how to use it.
Things to do before you start:
Sign in to Google. You’ll be copying some documents to your Google Drive and it’s 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.
Click on the image to copy the spreadsheet to your Drive.
Once copied, the spreadsheet will open.
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.
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.
You can now enter your data into the form. Every cashout must be recorded separately.
PLEASE NOTE: If you prefer to do so, you can input data directly into the spreadsheet rather than using the form.
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
- Site – I’ve included some of the most popular sites. They are numbered for the same reason the months are.
- 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.
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.
Click on the 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. You can also see them either horizontally or vertically. If you use a lot of sites, the vertical layout will probably be best for you.
Click here to give me some feedback on how the form/sheet is working for you
Recommended sites to earn money online.
Do I have to declare my earnings for tax purposes?
Join our Facebook group to get support & advice that will help you earn.