Multi-Currency Cash Balance
The Cash sheet tracks your cash balances across different accounts and currencies. This data integrates with your overall portfolio value, ensuring accurate snapshots and Dashboard metrics.
Overview
Each row holds the balance for one account-and-currency pair, calculated automatically by a built-in formula from the deposits, withdrawals, and trading activity in your Transactions sheet. You can add as many rows as you need, and if you prefer to track a balance yourself, simply overwrite its formula with a manual value.
Do not delete the "total" cell at the bottom — it carries the cash_balance named range the add-on reads your total from, for snapshots and Dashboard calculations.
Columns
| Column | Description |
|---|---|
| Account | The account holding the cash, selected from your Accounts configuration. This is used by the formula to match transactions. |
| Label | A descriptive name or note for the cash holding (e.g., "Brokerage EUR", "Savings"). |
| Amount | The cash amount. Contains an automated formula by default to calculate the balance, but you can enter a manual value to override it. |
| Currency | The currency of the cash balance (e.g., "USD", "EUR"). |
| Conversion Rate | The exchange rate to convert to your base currency. Use the helper formula =CURR_RATE(D<rowNumber>) to fetch automatically based on the currency. |
| Amount (Base Currency) | The converted amount in your base currency (calculated automatically). |
Example: For a USD account with $1,000 at a USD/EUR rate of 0.85, the base currency amount would be €850.
Adding and Managing Cash Balances
- Insert Rows: Right-click and insert rows above the "Total cash balance" cell.
- Enter Account Details: Select your account from the dropdown menu, provide a descriptive label (e.g., "Savings"), and specify the currency ticker (e.g., "USD").
- Amount Calculation:
- Automated: Drag down the formula in the Amount column from the row above. It calculates the balance by summing deposits/withdrawals and net trading activity (buys and sells) for that specific Account and Currency.
- Manual Override: If you prefer, type your cash value directly into the Amount cell to overwrite the formula.
Note: Ensure your base currency is set in the ⚙️ Settings dialog for accurate conversions.
Troubleshooting
- Named Range Missing: If "cash_balance" isn't applied, reapply it to the total cash balance (value) cell.
- Conversion Errors: Check that your base currency is set in the ⚙️ Settings dialog and ensure
=CURR_RATE()formulas are correct. - Totals Not Updating: Verify no hidden rows or errors in formulas.