Cash
The Cash tab tracks your cash accounts and savings goals.
Manual User Cells: • Bank Names • Bank Currency • Bank Balance • Spend Notes
Bank Account Section
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.
International Bank Accounts
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.
EOY Predicted Cash Balance Section
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.
Cash Goal Section
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.
Savings Rate Section
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.
House Savings Target/Year
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 updated