Sheet Tabs
General Information
SheetOptions Tab
The Sheet Options tab is perhaps one of the most critical tabs in the Sheet as it contains settings that are accessed many different parts of the Sheet.
NOTE: The leftmost tables are read-only and will automatically update. Please only update cells that are coloured in yellow.
Setting Title
Explanation
Personal Gmail
This is to email you your end of month summary. This should be autofilled.
Day of Month Paid
What day of the month are you paid? If you're not paid monthly, set this to 1.
Use Budget Tab?
Recommended as yes so the Sheet can understand what your expected expenses are. If set to yes, fill out the Budget category as accurately as possible!
Employment Salary
Used as part of the savings rate calculations.
House Price Target
The target house price that you're saving for. Otherwise set to $0. Note that if you're saving with someone else who is not bundled into your Sheet (ie. partner), please set this number to your own expected contribution.
General Cash Savings Target
Set yourself an open-ended cash goal.
Salary Frequency
How frequently you're paid (ie. weekly, fornightly, monthly).
Net Regular Income
The net pay you regularly receive from your income that is deposited into your bank (ie. after Tax/IRA/HECS). This is an after-tax value.
Job Start Date
This is to help with savings rate calculations, but is largely obsolete as of v2.8.
Include Side Income in Budget Income
If you have irregular or lumpy income reported in Side Income Tab, this will include a rolling 12-month average into your budget. Useful for contractors or those who do not have a fixed or consistent income.
Bank Interest Rate
The interest rate your bank provides on your savings. If you have multiple accounts, make this the minimum of the accounts where you store the bulk of your savings.
Brokerage (buy only)
How much you pay for brokerage (buy only).
Allocation aggressiveness
How aggressively do you want to keep aligning with your Asset Allocations? As part of the rebalancing function of the Sheet, this will tell the Sheet how aggressively you want to rebalance and assign future income.
For example if you are deficient in ETFs by 10% according to your allocations, set to light the Sheet may only recommend 30% of your next paycheck contributed towards ETFs. If set to aggressive, the Sheet may recommend up to 100% of your next pay check.
Please note this only takes effect after the emergency fund threshold has been met. Investing involves risk, make an educated decision (see disclaimer).
Create Calendar/Email reminder?
Do you want email/calendar reminders when your conditions suggest you should invest? Investing involves risk, make an educated decision (see Disclaimer).
Asset Allocations - ETFs
How much of your assets (excluding property) do you want in ETFs? Investing involves risk, make an educated decision (see Disclaimer).
For an explanation of why this setting matters, see the "Allocation aggressiveness" entry.
Asset Allocations - Stocks
How much of your assets (excluding property) do you want in Stocks? Investing involves risk, make an educated decision (see Disclaimer).
For an explanation of why this setting matters, see the "Allocation aggressiveness" entry.
Asset Allocations - Crypto
How much of your assets (excluding property) do you want in Crypto? Investing involves risk, make an educated decision (see Disclaimer).
For an explanation of why this setting matters, see the "Allocation aggressiveness" entry.
Asset Allocations - Cash Drawings
How much of your assets (excluding property) do you want in Cash?
For an explanation of why this setting matters, see the "Allocation aggressiveness" entry.
House Savings Target / Year
If you're saving for a house, how much do you want to save each year as a target? Set to $0 if not saving for a house.
Currency Choice
What currency do you want the sheet to be priced in? This needs to be your currencies 3 letter code.
NOTE: This will not modify the currency symbols in the Sheet. This only effects international assets priced in a different currency by converting them into your chosen currency choice.
Asset Allocations -Managed Funds
How much of your assets (excluding property) do you want in Managed Funds? Investing involves risk, make an educated decision (see Disclaimer). For an explanation of why this setting matters, see the "Allocation aggressiveness" entry.
EOY Cash Goal
How much would you like to aim for at the end of the year to have saved?
Market Investment Return
What is your assumed long-term market return? This is inclusive of inflation.
Tax Bracket
What is your current Tax bracket in %? For Couples - See calculator in the bottom left to calculate averaged tax rate.
House Deposit - % Target
(If Applicable) Of your House price target, how big in % does your House deposit need to be? For example, 10% or 20%.
House Deposit - Investment Contribution %
(If Applicable) How much of your investments will you be using for your House Deposit?
CoinMarketCap API
For Crypto pricing, please signup and enter your CoinMarketCap API key from here - https://pro.coinmarketcap.com/signup/
Emergency Fund Duration
For how many months do you want your Emergency Fund to cover?
Monthly Run Calendar Reminder
Do you want the Sheet to leave a calendar reminder for when to run the sheet next month?
Minor Version Update Notification
If you want to be notified for every minor version release (ie. 2.10.1 -> 2.10.2) set this to yes. You will receive a pop up as well as be notified in the Net Worth tab.
Major version releases will always notify.
Last modified 5mo ago
Copy link