Skip to main content

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​

  • Purpose: Monitor cash holdings automatically or manually across multiple accounts and currencies.
  • Formula-Driven: The template includes a built-in formula that automatically calculates your cash balance based on the Transactions sheet. It aggregates your deposits, withdrawals, and trading activity (buys and sells) for each specific Account and Currency pair.
  • Flexibility: You can add any number of account and currency rows. If you prefer not to use the automated calculation, simply overwrite the formula with your manual cash balance.
  • Important: Do not delete the "total" cell at the bottom—it has the "cash_balance" named range. Confirm by selecting the cell and checking the named range in the formula bar.

Tip: The total cash balance is used in snapshots and Dashboard calculations.

Columns​

ColumnDescription
AccountThe account holding the cash, selected from your Accounts configuration. This is used by the formula to match transactions.
LabelA descriptive name or note for the cash holding (e.g., "Brokerage EUR", "Savings").
AmountThe cash amount. Contains an automated formula by default to calculate the balance, but you can enter a manual value to override it.
CurrencyThe currency of the cash balance (e.g., "USD", "EUR").
Conversion RateThe 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​

  1. Insert Rows: Right-click and insert rows above the "Total cash balance" cell.
  2. 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").
  3. 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.