Security Transaction reports

Mac | iPhone
| iPad

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
Calculator

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.

Report Settings

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

Select Accounts

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

Select Securities

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

Select Transaction Types

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

Select Tags

Tip 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 Note: The "No Tags" option can be used to capture the transactions that are not listed with any tags.