Handle your wash sales and generator your Schedule D

Run Reports


TradeMax offers a simple and clean solution to run report for your tax and analyzing your trading performance purpose.

Before you run a report, you need do the following step:

Enter Your SSN and Name

  1. Click the Main Button on the upper left concern of the Trade window and press the Option Button
  2. A dialog box will pop up:
  3. Enter your name and SSN and your name will appear on your upper left section in the running report
  4. You can click the checkboxes to:
    • Make the Exercised/ Assigned securities’ Buy/Sell price same as the strike price of option.
    • Auto-Expire unexercised/ unassigned options at 0 price on expiration date
    • Auto scan the trade errors.
    • Update your TradeMax software when running TradeMax each time.
  5. If you want to upback TradeMax data, click to view the directory of the database.
  6. You can also change the SSN by redoing the above step 1 & step 2

The following will show you how to Add a Report to Account List

Many investors trade security in other currencies such as EUR, CAD, AUD, JPY, HKD, GBP, CHF, TradeMax now supports running report in your base currency and in USD currency for tax purpose.

The Base Currency is the first currency quoted in a currency pair.  The base currency is referred to as the parent currency and exchange rates are quoted in per unit of the base currency.  The base currency is the more valuable currency.  Therefore in the HKD/USD currency pair, the HKD is more valuable than the dollar, so it is the base currency.  The base currency is also known as the accounting currency or domestic currency. TradeMax supports running reports on the following base currencies such as EUR, CAD, AUD, JPY, HKD, GBP, CHF.

The Tax Currency is the default currency USD.

TradeMax provides two options to generate the report:

Option 1 : Click the Report Button in Trade Panel.

Option 2 : Select the specific report from the right menu of Trade Data.

Option 1 : In order to simplify the process of generating reports, you can click the Report Button (shortcut button) in Trade Panel. the following will tell you how to generate the report by clicking the shortcut button.

  1. Click the Report Button in Trade Panel.
  2. The Report Wizard dialog box pops up:
    • Select the specific account that you want to generate the reports from dropdown list.
    • Select the specific Finance Year that you want to generate the reports from dropdown list
    • Select the specific report you want to run from the dropdown list. After you select the specifc report, the specific report icon will be auto-generated under Trade Data diretory.
    • Select the currency type from the dropdown list.
    • Note: Please use End of Tax Year function to generate baseline position or Enter Your Year End Baseline Position before generating the reports, otherwise the results will be inaccurate!

Option 2 : You also can generate your reports by clicking the specific report icon under Trade Data direcoty after you select it from the right menu of the Trade Data

  1. Right-click the Trade Data view in the Account List and select the specific report.
    1. Cost Basis Transaction Report -This report is for those users who track the cost basis in stocks, bonds and mutual funds to report a cost basis when an investment is sold.
    2. Daily Market Value Report - This report is for those users who track the performance and market value of the securities on daily basis in specific finance year. The report will show the portfolio of every transaction on daily basis.
    3. IRS Schedule D-1 - This report is for those users who require a more exact replica of the IRS form.
    4. Mark to Market
      Detail Report
      - This report is for those users  want to record the price or value of a security, portfolio on a daily basis to calculate gains and losses or to confirm that margin requirement are met.
    5. Mark to Market For Form 4797 - -This report is for traders in stocks, options and single-stock futures who elect mark-to-market accounting to report their trading activity on Form 4797
    6. Realized Gain/Loss Report - This report is for those users who require trade transaction detail. Such as Security, Quality, open price, Open date, Open Commission, close price, close commission, sales price, cost basic, Actual gain &lose for each transaction. Moreover, it can be grouped by ID, Symbol, or TradeDate.
    7. G& L Report - This is the default report created by TradeMax for filing with Taxes.
    8. SummaryReport - Display or print a trade summary report. This valuable summary or aggregation of an entire ID or Symbol allows a user to see how one Symbol performed versus another
    9. Transaction Detail Report - A report display all trade detail. This report lists each and every transaction as displayed in the grid. Additionally, the profit or loss can be summed by Trade Number, Ticker, or Date.
    10. Unrealized Gain/Loss Report - This report is for those users who  want to get the information of Gain/Loss when the price of the securities decrease or increase after buying, but he or she has yet to sell it.
    11. Wash Sale Detail Report- This report allows you to analyze your disallowed wash sale losses that have been deferred to next year
    12. Section 1256 Report - This report is for those users who want to get the information of Unrealized Gain/Loss amount and 60% long term amount and 40% short term amount auto-calculated by TradeMax as an attachment to Section 1256 contract.
  2. As you see, there are a dozen reports:.

  3. You will see the selected report under the Trade Data view like this:
    • You can register your TradeMax by entering the Registration Name and Registration Code and press the Register button
    • You can also click Buy Now to buy the Registration Code
    • A free trial version can only generate report from a data range 1/1 to 6/30 and can’t export to pdf and excel.
  4. If you run the report in Base Currency, on the left side of your selected report title will dispaly your base currency. As the pricture showed above, HKD appears on the left side of IRS Schedule D report . If you run the report in Tax Currency (the default currency is USD), as you can see from the aboved picture, USD appears on the left side of the report title.

    Notes:

    Unregister edition will pop a register remind dialog box when you run the report:

IRS Schedule D-1


IRS Schedule D-1 - This report is for those users who require a more exact replica of the IRS form.

Schedule D-1 of Form 1040 provides additional space to list short and long-term capital gains and losses. Schedule D requires taxpayers to list their short and long-term capital gains and losses. However, it may not provide enough space to list all applicable transactions. This schedule allows taxpayers to include all qualifying transactions. The date of each transaction and the purchase and sale price of each security should be included.

Now, we will show you how to run an IRS Schedule D-1:

Note: Please enter your Name and SSN before run the report with the Option button in the Main Button.

    Click the item IRS Schedule D-1 and you will get a report just like the IRS form.

Mark to Market Detail Report


Mark to Market Detail Report -This report is for those users  want to record the price or value of a security, portfolio on a daily basis to calculate gains and losses or to confirm that margin requirement are met.

Mark-to-market (MTM) accounting enables a trading business to change the tax status of their earnings from capital gains/losses to ordinary income/losses, thereby avoiding the $3,000 capital loss limitation and the wash sale rule.

The following will tell you how to run a Mark to Market Detail Report

  1. Click the item Mark to Market Detail Report, you will get the following window:
  2. After you press Download button, the price of the holding securities at the end of specific finance year will be downloaded. (For example: we choose the transaction data in FY2007, TradeMax downloads the price of the holding securities on last day of FY2007.)

  3. After downloading the price of the holding security, Mark to Market Detail Report is generated as below:
    Basic Function
    1 Report data information including Data Source, Create Date, Tax Payer and Page of Total
    2

    Display the detailed information for all transactions in the current account and current period under Mark to Market Accounting method.

    3 Display the Mark to Market Detail Report Actual Gain & Loss Amount

    The following grid give a detailed introduction about the report .

    Function

    Description
    1.Symbol

    The security name

    2.Open Date The purchase date of the security
    3.Action Action name in TradeMax
    4.Quantity The shares of security you purchase
    5.Open Price The original security price
    6.Close Date The date when you sold the security, if you haven’t sold the security before the end of specific year, Trademax will treated it as the last day of the year for the transaction is under Mark-to-Market method.
    7.Close Price The security price on Close Date
    8.Acquired Amount The Amount auto-calculated by Quantity of the security* Open Price
    9.Sold Amount The Amount auto-calculated by Quantity of the security* Close Price
    10.Gain & Lose
    The Amount auto-calculated by Sold Amount – Acquired Amount

Trade DetailReport


Trade DetailReport - A report display all trade detail. This report lists each and every transaction as displayed in the grid. Additionally, the profit or loss can be grouped by ID, Symbol, or TradeDate.

Now, we will show you how to run a Trade DetailReport:

  1. Click the item Trade DetailReport, you will get the following
  2. You can group it buy different column header by choosing specific one in the Subtotel Field.

Daily Market Value Report


Daily Market Value Report - This report is for those users who track the performance and market value of the securities on daily basis in specific finance year. The report will show the portfolio of every transaction on daily basis.  Before you run this report, you should download the price history of the securities in specific finance year. Otherwise, the data in this report isn’t accurate enough.

Daily Market Value is the relative market value of a security is simply equal to the aggregate market value of the security divided by the sum of the aggregate market values of all securities.

The following will tell you how to run a Daily Market Value Report

    Click the item Daily Market Value Report, you will get the following report window: 

    Basic Function
    1 Report data information including Data Source, Create Date, Tax Payer and Page of Total
    2

    Display market value details for all transactions in the current account on daily basis

    3 The chart display the day balance and cash balance

    The following grid give a detailed introduction about the report .

    Function
    Description
    1.Trade Time

    The transaction date of the security

    2.Portfolio Value Portfolio Value is a portfolio consisting of all securities where the proportion invested in each security correspons to its relative market value
    3. Available Funds Funds that are available to an account holder for withdrawal or other use.
    4.Total Market Value The Amount auto-calculated by Portfolio Value + Available funds

Black List


In order to simplify the process to run reports, TradeMax provides you with Black List to filter some information of various reports. With this feature, you can choose to display the information you want by selecting transaction type or Security Ticker to generate the specific report.

 The following wizard will tell you how to build a Black List.

  1. Click main button , and a main menu opens:
  2.  

  3. Click Options button, and then select Black List tab,  the following dialog box displays:

 

Function
Description
1.Black List Tab After clicking Options button, you should select Black List tab.
2.Filter Field You can select the report you will run from the dropdown list.
3. Type Security type. For instance, stocks and mutual funds, options on stocks, Single-Stock-Futures, futures, currencies etc.
4. Ticker Security Ticker Symbol. You can click Ticker Tab to select the symbol you want to be displayed or disappeared in the generated report.
5.Ticker Tpye List The ticker types for you to select to display in the reports you want to run . Note : If you click Ticker Tab, the list box is called Ticker List.
6.Black List Filed Tthe ticker types you want to omit in your report.
7.Condition Filed Click to move the selected items to Ticker Type List or Black list alternatively.

Click to move all items to Ticker Type List or Black List.

Page 1 of 11

Copyright © 2009 Neutral Trend Inc. All Rights Reserved.