GruntWorx Trades

Take the monotony out of tax preparation. Transform scanned Consolidated Brokerage Statements into an Excel® spreadsheet – no more keying in tens, hundreds, or thousands of individual trade details. Unprecedented accuracy with GruntWorx’s patented Data validation services.

Automatically transform trade details on scanned 1099 Consolidated Brokerage Statements into a standard Microsoft Excel file

GruntWorx Trades allows you to quickly and easily manipulate trade data, perform calculations within the spreadsheet, and import the data into your tax compliance software.

The GruntWorx Trades spreadsheet file extracts the following trade details, as listed on the Consolidated Brokerage Statements:

  • Quantity
  • Security Description
  • Purchase Date
  • Sale Date
  • Sale Amount
  • Purchase Amount
  • Gain/Loss
  • Box 6 Data – Cost Basis provided/not provided to the IRS

Benefits

  • Eliminates manual data entry of trade details to save hours—even days. No more keying in tens, hundreds, or thousands of individual trade details.
  • Quickly calculate short-term and long-term capital gains and losses. GruntWorx Trades produces a standard Microsoft Excel spreadsheet for fast and easy manipulation of data—including the ability to perform calculations within the spreadsheet.
  • Easily import trade details into the leading tax preparation software packages.  Choose from three spreadsheet formatting options for seamless import into your tax preparation software. Tax preparation software packages that support import of trade details include: Drake Software, GoSystem Tax RS, Lacerte®, UltraTax CS™, and Prosystem fx® Tax.
  • Instantly identify any trade missing a cost basis. Trades listed without a cost basis are flagged for review, so you can immediately identify missing data.

Search GruntWorx

Product Hightlights

  • Patent-pending biometric technology accurately identifies all variations of Consolidated Brokerage Statements and extracts trade details from the scanned documents.
  • Software-as-a-Service interface and standard spreadsheet output require no set-up or training to get started.
  • Absolute security: our hosted solution offers the same advanced data encryption found in the most rigorous online banking applications.
  • IRC Section 7216 compliant.

Compatibility

Choose from three spreadsheet formatting options for easy import into your tax preparation software. Tax preparation software packages that support import of trade details include:

  • Drake Software
  • GoSystem Tax RS
  • Lacerte®
  • UltraTax CS
  • Prosystem fx® Tax

System Requirements

  • Operating System: Windows 10 or newer
  • Processor: 2.0 Ghz or faster multi-core processor
  • RAM: 4.0 GB or more
  • Microsoft .Net Framework: 2.0.50727
  • Browser: Latest versions of Chrome, Firefox, and MS Edge
  • Adobe Reader: Adobe Acrobat Standard or DC required for PDF editing
  • Additional Programs: Microsoft Excel ver. 2003 or higher
  • Microsoft 365 Apps not supported at this time
Paste your AdWords Remarketing code here
Browse GruntWorx

GruntWorx, LLC.

Font Resize
Contrast