Cash
The Cash tab tracks your cash accounts and savings goals.
Last updated
The Cash tab tracks your cash accounts and savings goals.
Last updated
The Bank accounts section is where you can list and input all your bank accounts. You can list the name, currency and balance of each account. This is then combined and converted into a total balance below.
The currency column refers to what currency that account is based in. For example in an AUD Sheet:
ING
AUD
200
200
HSBC
GBP
200
111
Bank of America
USD
200
153
Total AUD
464
The conversion of all the accounts to AUD is hidden, but the logic works according to the table above. The balance shown in the above situation will therefore be $464.
The EOY Predicted Balance section provides statistics on how you're progressing towards your EOY Cash Goal. This goal is set in the SheetOptions tab.
The Cash Goal section provides statistics on how you're progressing towards an open ended Cash Goal. This is different to the above goal in that it can exist years in the future. This goal is set in the SheetOptions tab.
This is a summary of the average savings rates across different time periods. "3-Month Saving Rate ±%/Month" refers to how much your savings rate has gone up or down over the last 3 months.
For example, if your average went from 45% to 50% this cell would show 5%. This is to help give you a sense of progression in your savings rate as time goes on.
The House Savings section provides statistics on how you're progressing towards your House Deposit Target. Inputs for these calculations are set in the SheetOptions tab.
The Cash History table contains a number of helpful statistics to help you track progress over time.
Date
The month of the values shown
Total Cash
This is your total cash balance at this point in time
Cash Gain (Currency)
The amount your cash grew as compared to the month prior
Cash Gain (%)
The amount your cash grew as compared to the month prior, as a % of your total cash balance
Added Investments
What investments that were added since the last month. These include: Stocks, ETFs, Crypto, Voluntary Retirement Contributions, Managed Funds, Other Assets
Savings Rate
Your total savings rate for the month. This is calculated by: (Total Cash Gain + Added Investments) / ( Total Income - Salary, Side Income, Dividends)
Monthly Savings
Monthly Cash Gain + Added investments
Projected Cash
Your projected cash for this month
Monthly Spend
Your spend for the month so far
Notes
Any notes you want to include for noteworthy purchases or balance movements for this month
