Cash
The Cash tab, as the name suggests is a history of balances and also Cash goals. Most parts of this tab are automated except for the 3 fields mentioned below.
Manual User Cells:
• Bank Names
• Bank Currency
• Bank Balance
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 |
An example of EUR, USD and AUD Bank accounts in a GBP Sheet
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.
Last modified 1yr ago