Account Table

Overview

The Account table defines the accounts that hold your investments.

Each row usually represents one investment or brokerage account. This table is important because transactions, cash behavior, and reporting context all depend on accounts being defined correctly.

Table Columns

  • Account - A short account name used throughout the workbook. Keep it concise and unique enough that it remains easy to read in reports and slicers.
  • Currency - The account currency. This is one of the most important fields in the table because transaction amounts and conversions depend on it. The value should match a valid entry in the Report Currency table.
  • Active - Yes/No value that specifies whether the account is treated as active for reporting purposes. Inactive accounts can be hidden from some summary views.
  • Portfolio - Groupping column.
  • Tax - Groupping column.
  • Account Group 1 - Groupping column.
  • Account Group 2 - Groupping column.
  • Account Group 3 - Groupping column.
  • Calc WHT - Not Used Column, for backward compatibility
  • Drip - Not Used Column, for backward compatibility

Practical Advice

  • keep account names short and consistent
  • make sure the account currency is correct before entering many transactions
  • use grouping columns only when they help your workflow
  • review active/inactive status periodically if you close accounts over time