Add-on Tabs

We wanted to start by saying a big thank you for your purchase and supporting us as a small business. We have created this help desk and instruction guide to hopefully make your setup as quickly and easy as possible. In this guide we will take you through the setup of your spreadsheet, answer the most frequently asked question and share tips and tricks for using Google Sheets so you can make the most out of your spreadsheet. So without further ado, let’s have a better look at your spreadsheet!

Add-on Tabs

As requested by many of our customers we have created add-on tabs that will allow you to upgrade your spreadsheet. We currently offer 3 different add-ons:

  • Annual tab: compatible with our monthly budget and budget by paycheck spreadsheets

  • Debt tracker tab: compatible with our monthly budget and budget by paycheck spreadsheets

  • Savings dashboard tab: compatible with our monthly budget and budget by paycheck spreadsheets

Now without further ado, let’s have a better look at how you can add your add-on tab to your budget spreadsheet!

Disclaimer

As mentioned in the Etsy listing description:

  • Google Sheets: This add-on can only be used on Google Sheets, it is not compatible with Excel. You will need a Google account (which is free) to access this spreadsheet. 

  • Copyright: this design and this spreadsheet is copyrighted by Haye Creatives (formerly known as BoMiMo Designs). Your purchase of this product is for personal use only and commercial/public use of any kind is strictly prohibited. It is prohibited to resell, share, reproduce this product or distribute this product, either in part or in full, with or without modifications.

  • Product: neither this product nor Haye Creatives are affiliated with Google Sheets.

  • Disclaimer: This spreadsheet is for informational use only. Haye Creatives cannot give any financial, tax or legal advice. Please do your own research and if needed contact a licensed financial advisor before making any financial decisions. Under no circumstances can or will Haye Creatives be held responsible for any costs, loss, damage or injuries (may it be direct or including without limitation indirect loss or damage) that result from the use of this spreadsheet.

  • Refunds: as this is an instant digital download all sales are final. We don’t accept returns, exchanges or order cancellations due to the nature of digital purchases.


Regarding the debt add-on:

This tab was created to give you an idea of how you can pay off your debt with the debt snowball or the debt avalanche method. It is important to know that these calculations are based on standardised scenarios and as such the amount of payments and the end balance calculations for each month can differ. Fluctuations in the amount of payments or the end balance can easily be caused by (for example):

  • Making multiple payments a month can cause a difference in the interest calculated and as such the balance

  • Making late payments can cause late fees and differences in the balance and interest calculated

  • Annual fees for credit cards are not included in the calculations

  • Other fees such as (for example) foreign transaction fees, cash advance fees, over-the-limit fees can cause a difference in the balance and such the interest calculated.

For this reason we highly recommend frequently checking the actual balance of your debt, and if needed adjust it on the payments tab. This is especially important for your last payment for each debt to make sure you are paying the full amount and there is no (small) amount left that is now sitting there unnoticed gaining interest and possibly other fees. To adjust the balance simply locate the month and the debt and type over the balance that was pre-calculated. The spreadsheet will know recalculate. 

How to add your add-on tab to your budget spreadsheet

STEP 1 | Open your budget spreadsheet. This will be either your monthly budget or your budget by paycheck.

STEP 2 | In your budget spreadsheet rename the tab (if needed) where you add your categories to START. You can rename your tab by either right clicking on it or clicking on the little arrow in the tab name. The tab name should match the word START exactly.

Now rename the second tab. Rename the tab (if needed) where you add your transactions to Log. The tab name should match the word Log exactly.

STEP 3 | Now that you have prepared your budget spreadsheet it is time to copy over your add-on. To open your add-on select the right PDF and click on the “Add-on Tab” button.

STEP 4 | To add on the tab to your budget spreadsheet right click (or click on the little arrow) on the tab name (for the bill calendar add on be sure to select both tabs) and click “Copy to” and “Existing Spreadsheet”.

STEP 5 | A window will pop up. Underneath the “Files” section select your budget spreadsheet. If you cannot find your budget spreadsheet copy your budget url and paste it in the most bottom option below “Or paste a web address here”.

That is it! Your tab will now be added to your budget. You can find further instructions for each tab here:

Annual Overview Tab - The annual overview tab requires no further set up. It will integrate automatically with your start and log tab. All subcategories and actual expenses will update automatically. The planned sections require manual entry (these have been marked light grey). To update the year you can click on the “2022” title on the top of the sheet and replace it with the year you want to see the data for!

Debt Snowball Tab - You can find the guide to our debt snowball spreadsheet here. We will take you through the setup and the functions of this tab.

Savings Dashboard - You can find the full guide to our savings dashboard here. We will take you through the setup and the functions of this tab.

FAQ & Troubleshooting

  • All our spreadsheets are created for and on Google Sheets. As Google Sheets is an online programme we cannot include a direct file that takes you to the spreadsheet, but instead you will need a link. For that reason the file included with your purchase is a PDF. The PDF will contain a link to your spreadsheet as well as a link to the instructions of the spreadsheet.

  • When you click on the link in the PDF a page will open in your internet browser. In the top right corner you will see a button that says “Use Template”. After you click this button a personal copy of this spreadsheet, only accessible by you, should open within seconds.

    Unfortunately, Google Sheets can be a bit glitchy from time to time. If it does not open, or if it opens in a view only mode try the following:

    • View only mode: in the top toolbar, click “File” → “Make a copy”. This will create a copy of the spreadsheet that will provide you with full access. If that does not work try the troubleshooting options down below.

    • Open the spreadsheet from a computer or laptop: We have noticed that when trying to open the spreadsheet for the first time from a phone, tablet or similar devices that it does not always open. For that reason we recommend opening the spreadsheet from a computer or laptop for the first time.

    • Make sure there is enough space on your Google Drive: If your Google Drive is full, or near full, it will not allow you to enter the spreadsheets (it will show view only instead). You can check if you have enough space available by going to drive.google.com, in the left hand side menu you will be able to see how much storage you have left in your Google Drive.

    • Try a different browser: If you still have trouble accessing the spreadsheet make sure to check if your browser is up to date. If your browser is up to date and it is still not working then try a different browser.

    • Make sure you are logged into Google Sheets: The spreadsheet will not open if you are not logged in to your Google Sheets account or if you are trying to open the template in an incognito window. If your spreadsheet is not opening try the following:

      • Close all tabs and windows in which you tried to open the spreadsheet

      • Head to sheets.google.com

      • Log in with the Google account on which you would like to access the spreadsheet

      • Head to the PDF, click on the link and click “Use Template”. The spreadsheet should now open.

    If after you have tried all options above you are still experiencing issues be sure to reach out to us on Etsy so we can assist you further.

  • It could happen that you made the purchase only to realize that you would like to access the spreadsheet with a different email address. Not to worry, our spreadsheets are not tied to the email address of your Etsy account. After you have made your purchase you can open it with any Google account, even if you already accessed it with a different Google Account.

    To access it with the right Google Account:

    • Head to sheets.google.com

    • Log in with the Google Account that you would like to use to access the spreadsheet

    • Head to the PDF, click the link and click “Use Template”

    • Your spreadsheet will now be linked to the right Google Account

  • All our spreadsheets available in our store are specifically designed for Google Sheets and will not function properly on Excel. While Google Sheets and Excel are similar programmes, they have large differences in their formulas and how formulas are set up. When a spreadsheet is exported to an Excel format the formulas won’t translate with it properly and the spreadsheet will not function as designed. For that reason we highly recommend not to export your spreadsheet and to only use the spreadsheet in Google Sheets.

Change Log

If you purchased your spreadsheet after the latest update you should not be experiencing any issues. If you are experiencing issues in the current version of the spreadsheet you are using please contact us on Etsy.

Latest updates:

  • 31 July 2023 - An error was found in the debt add on. Field N53 had a link back to the wrong field causing the date to jump back 15 to 16 months. You can fix this by clicking on the field above (such as N52), right clicking and clicking copy. Now click on the field below, right click and click paste. You can also download the latest version of the spreadsheet where this issue has been fixed.

  • 5th of March 2023 - All add-ons were updated to accommodate the latest versions of the monthly budget and budget by paycheck spreadsheet.

  • 22nd of February 2023 - All formulas in the debt snowball add on have been updated: interest on the balances were calculated after the payment was made instead of before the payment was made. This has now been updated, interest on the balances is now added before the payment is made.

  • 3rd of November 2022 - The savings tab was replaced for a new and updated version of the savings tab that includes a graph for each savings/sinking fund!

  • 13th of November 2022 - The debt snowball tab was updated to include a bunch of new features: you will now be able to see how much you have paid & there is left to pay in the overview, you will be able to add or subtract amounts to your planned payments, you do not have to enter your debts in order from smallest to largest anymore in the start tab as the spreadsheet will now organise it for you. The last addition is that if you pay a larger debt off earlier then planned the amount will now snowball back into the smaller debts!