Cash - CompiledSanity Personal Finance Sheets

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
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
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.
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.
​
​
​

Getting Started - Previous

Recording a Month

Next - Investments

ETFs & Shares

Last modified 1yr ago

Copy link

Outline

Bank Account Section

EOY Predicted Cash Balance Section

Cash Goal Section

Savings Rate Section

House Savings Target/Year