Dearman Systems, Inc.
Dearman Systems, Inc. - 6137 E. Grant Road - Tucson, AZ  85712 - 520.298.1677
Contact DEARMAN™

     

TAS.net logo
TERMINAL AUTOMATION
Unity Logo
ENTERPRISE MANAGEMENT
Contracts and Invoicing Logo
CONTRACTS AND INVOICING
ExSTARS Logo
ExSTARS AND TAX REPORTING

RIN / EPARIN MANAGEMENT AND EPA COMPLIANCE

grayline
grayline
Stockbyte / Stockbyte Photography / Getty Images
grayline
0
grayline


Printer FriendlyPrinter Friendly Version
(pdf format 57 KB)
DSI ExSTARS Product logo

ExSTARS and Tax Reporting


DEARMAN Systems, Inc. is an IRS approved transmitter. Our friendly and experienced staff can assist you with your entire reporting process, from your initial Letter of Application through EDI testing to ongoing customer support.

Dearman Systems, Inc.'s robust 4030 approved ExSTARS reporting solution is a fully functional tax inventory system for your 720-Terminal Operator and 720-Carrier Summary reporting needs. Signers using Dearman’s ExSTARS Reporting System use an inventory based front-end application to balance their monthly Terminal Operator or Carrier Data. Once users are satisfied that all data is correct, they may convert their inventory data to the required EDI (Electronic Data Interchange) format for upload to the IRS ExSTARS 4030 Excise Tax System with the push of a button.

Inventory Data can be automatically collected from a DEARMAN™ Terminal Automation or Inventory System or manually rolled into the database from a wide variety of source systems. Transaction data may be displayed in detail or as a terminal product balance sheet. The versatile DEARMAN™ ExSTARS Reporting System front-end application allows for transactions to be added, deleted or modified directly to the system database. Transactions may also be sorted and isolated by attributes such as a carrier FEIN, transportation mode, product code, etc.

When linked to a Dearman TAS.net™ or RTG™ system, book adjustment calculations are generated automatically from terminal data, however a manual book adjustment option is available in all systems. Signers are also provided with fully formatted printable IRS forms (in Microsoft™ Excel®) which contain the same data contained in the EDI file generated by the DEARMAN™ ExSTARS Reporting System application. Implementation options include stand-alone software license or monthly/annual service agreement for reporting services.

Key Features and Benefits

Manual Data Collection,

  • Clients choosing manual data entry provide position holder, exchanger/consignor, destination state/TCN, and carrier data. This data is automatically reformatted by the DEARMAN™ ExSTARS Reporting System application into the required format for EDI transmission
  • User friendly Excel-based data entry forms provide an easy and convenient structure to record and track all receipt and disbursement transaction data.
  • Our ExSTARS staff works with terminal staff to ensure that all terminal level product codes are accurately converted to standard IRS product codes.

Automatic Data Collection

  • Our ExSTARS Reporting System coupled with our TAS.net™ or RTG™ terminal automation system provides a simple and accurate solution to monthly terminal reporting needs.
  • Terminal automation systems that provide an ODBC interface can upload all IRS required transaction data directly to our raw data table.
  • Our knowledgeable staff can assist DEARMAN™’s ExSTARS Reporting System customers in compiling and augmenting data from client inventory systems which do not capture all elements required for Federal and State tax reporting.
  • Microsoft™ Excel® or flat database sources can be easily rolled into the raw data table for quick EDI conversion.
  • Entity data can be collected from the existing automation system, other source system, and/or from other EDI tax system data.

Accounting, Balancing and Data Checking

  • Extensive automatic data checking -- format and consistency --- while data is imported. Changes/modifications of data provided are automatically incorporated into the data set and checked for format and consistency.
  • Balances of data from import sources are compared to final tax inventory balances to ensure accuracy of data transfer and consistency of balance data throughout processing.

Modifications and Adjustments

  • Easy to read balance sheets display product inventory values of beginning inventory, receipt total, book adjustment total, disbursement total, ending book, ending physical inventory, and gain/loss by product group.
  • Flexible application front-end and/or Microsoft™ Excel® data entry forms allow users to add, delete or modify transaction data as needed.
  • Manual Book Adjustment override and validation check features ensure accurate reporting of product re-grades and transfers.

Reports

  • Product balance sheets for terminal provided on screen for balancing or in a Microsoft™ Excel® report.
  • Complete log report and error events provided on screen and in Microsoft™ Excel®.
  • Comprehensive summary report provides detailed analysis, and comparison with inplace accounting reports.
  • Transaction detail and EDI return provided in Microsoft™ Excel® (data check workbook).
  • Data is stored in the Microsoft™ SQL Database and reported in Microsoft™ Excel® so all reports include the save/send options available to Microsoft™ Excel®. Partner terminal and carrier reports available upon request.

State EDI Reporting

  • Fully vetted and approved modules and/or scripts are available for many states now requiring EDI TOR submissions. Please contact us for information on the compliance status for your particular state(s). We are continually adding additional states on an ad-hoc basis.

Expert Staff

  • DEARMAN™’s expert staff has extensive experience in all aspects of the ExSTARS reporting process and is able to assist terminal and/or accounting personnel with everything from LOA (Letter of Application) generation to monthly filing support and error correction.
  • Optional 8 x 5 remote software support is available.





Privacy Policy | Legal | Terms of Use
Copyright © Dearman Systems, Inc.