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:
| Bank Account (Shown) | Currency (Shown) | Currency Balance (Shown) | Converted AUD Balance (Not Shown) |
|---|---|---|---|
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.
| Column | Explanation |
|---|---|
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 |
