Security Transaction reports can be used to locate and get totals for investment specific transactions using a wide variety of parameters. Learn more about how to setup Security Transaction reports below.
Security Transaction report setup
Edit the general settings for the report as desired and then select to "Continue" or to be "Finished" setting up the report depending if you have chosen to select specific accounts, payees, transaction types, categories, or tags for the report.
General settings:
- Name: The name to display for the report. Shown for the report's heading and in the list of reports.
- Date Period: The date range for the report. Select "Custom Date Range" to pick a specific date range or use one of the available date ranges such as "Current Year".
- Start: The starting date for the report's date range.
- End: The ending date for the report's date range.
- Date Intervals: The intervals to report within the date range. For example, a "Monthly" date interval for a report starting on the first of the year and ending on the last of the year will display information for every month.
- Format: How the report will be structured. Format options include: "Securities" (totals by security), "Securities with Transactions" (totals by security while listing the transactions for each tag), and "Transactions Only" (a list of all transactions that met the report's parameters).
- Subgrouping: The option to further breakdown security totals by another item. Subgrouping options include: "None", "Account", "Payee", "Transaction Type", "Category", and "Tag". For example, select the "Transaction Type" subgrouping option to get totals for each tag along with subtotals for each transaction type/tag combination.
- Accounts: The accounts that will be included: "Specific Accounts", "All Accounts", or "All Taxable Accounts". You will be presented with the option to select the accounts in an additional step if "Specific Accounts" is chosen.
- Securities: The securities that will be included: "Specific Securities" or "All Securities". You will be presented with the option to select the accounts in an additional step if "Specific Payees" is chosen.
- Types: The transaction types that will be included: "Specific Transaction Types" or "All Transaction Types". You will be presented with the option to select the accounts in an additional step if "Specific Transaction Types" is chosen.
- Tags: The tags that will be included: "Specific Tags" or "All Tags". You will be presented with the option to select the accounts in an additional step if "Specific Tags" is chosen.
- Transfers: Whether or not account transfers are included. Options include: "All Transfers", "Don't Include Transfers" or "Include Transfers with Excluded Accounts". Transactions will be considered a transfer if its category is set to an account category or if it uses the "Transfer" transaction type.
- Status: Limit the transactions that can be included based on their status. For example, exclude transactions marked as "Pending" by using the "Non-Pending" option.
- Currency: The currency for the report's totals.
Note: Transaction amounts will be listed in their account's native currency. All other listed currency amounts will be in the report's currency.
Select specific accounts:
If you chose the option to "Specify Accounts", mark which accounts to "Include" in the report as desired and then select to "Continue" or to be "Finished" setting up the report depending if you have chosen to select specific securities, transaction types, or tags for the report.
Tip: Use multiple selection and press the spacebar to toggle the "Include" checkboxes on/off. Check the "Show Hidden" option to display accounts not marked to be included in reports.
Select specific securities:
If you chose the option to "Specify Securities", mark which securities to "Include" in the report as desired and then select to "Continue" or to be "Finished" setting up the report depending if you have chosen to select transaction types or tags for the report.
Tip: Use multiple selection and press the spacebar to toggle the "Include" checkboxes on/off. Check the "Show Hidden" option to display securities not marked to be included in reports.
Select specific transaction types:
If you chose the option to "Specify Transaction Types", mark which transaction types to "Include" in the report as desired and then select to "Continue" or to be "Finished" setting up the report depending if you have chosen to select specific tags for the report.
Tip: Use multiple selection and press the spacebar to toggle the "Include" checkboxes on/off. Check the "Show Hidden" option to display transaction types not marked to be included in reports.
Select specific tags:
If you chose the option to "Specify Tags", mark which tags to "Include" in the report as desired and then select to be "Finished" setting up the report.
Tip: Use multiple selection and press the spacebar to toggle the "Include" checkboxes on/off. Check the "Show Hidden" option to display tags not marked to be included in reports.
Note: The "No Tags" option can be used to capture the transactions that are not listed with any tags.