|
Printable
Version PDF (Requires Adobe Reader)
ExSTARS Reporting Database
4030 Approved ExSTARS Reporting Solution
ExSTARS Reporting Database Minimum System
Requirements
Microsoft Excel
Microsoft SQL Server 2000 (or later version)
OR
Microsoft Windows XP Pro for the manual entry system, only
Dearman Systems, Inc. was the first software developer and
third party transmitter to have successfully completed the IRS 4030 EDI testing
and to be accepted as an Electronic Participant in the ExSTARS electronic
filing program using the new EDI format. Dearman's robust 4030 approved ExSTARS
reporting solution is a fully functional tax basis inventory system. Data can
be automatically collected or manually rolled into the database from a wide
variety of source systems. Data is displayed as a terminal product balance
sheet. Transactions can be added, deleted or modified directly to the system by
drilling down in the balance sheet as needed. Transaction selection can also be
made by attributes such as a carrier FEIN. Automatic or manual book adjustments
can be made, as required. Signers are also provided a full set of reports in
Excel format, for review.
Key Features & Benefits
Automatic Data Collection
The ExSTARS Reporting System coupled with our TAS.netTM and
RTGTM Terminal Automation Systems provides a truly integrated ExSTARS reporting solution.
Terminal Automation Systems that provide an ODBC interface can upload all IRS
required transaction data directly to our raw data table.
Automatic data collection is provided from other electronic
systems that do not provide all the ExSTARS required data elements but do have
some data available.
Excel or flat database sources can be easily rolled into the
raw data table.
Inventory amounts as well as transactions imported and
useable for automatic book adjustments - imported at the same time as
transactions or separately.
Entity data can be collected from the existing automation
system, other source system and/or maintained in a tax inventory system, as
available.
Manual Data Collection
Standardized position holder, exchanger, destination
state/TCN and carrier data entry.
Data entry formats for shipments, receipts, and inventory.
Product code translation to ExSTARS product codes.
Automatic Entity Retention For All Transactions
Position holder, exchanger, carrier, state and terminal data
used in generating the returns are stored in standardized tables. FEINs
returned without error from the IRS are confirmed by the systems and can then
be used accordingly.
Scalability is built in. It works just as well for multiple
terminals as for one terminal.
Internal data stores are automatically updated whenever a
change is detected or updated on a batch basis.
Standard data is rolled forward from prior returns, from a
stored procedure, or from an editable data table.
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.
Comparison trial balances of data from import sources and tax
basis inventory to assure that data is transferring.
Corrections to entity data can be referred back to an
automation system.
Modifications & Adjustments
Onscreen balance display of beginning, ending, and gain/loss
by product group.
Modification of data as needed.
Entry of adjustments as needed.
Reports
Product balance sheets for terminal provided on screen for
balancing or in an Excel report.
Complete log report and error events provided on screen and
in Excel reports.
Comprehensive summary report provides detailed analysis, and
comparison with in-place accounting reports.
Transaction detail and EDI return provided in Excel.
The above are provided in a data check Excel workbook.
Data is stored in the SQL Database and reported in Excel so
all reports include the save/send options available to Excel.
Partner terminal and carrier reports available upon request.
IRS ExSTARS Reporter
Signers transmit the return to the IRS via a password
protected web program using Internet Explorer.
The IRS returns a file receipt acknowledgement within two
days. A file verification acknowledgement follows almost immediately with the
IRS’s error analysis. The IRS error analysis checks for such things as FEIN
validity, non-bulk ship to state not provided, etc.
The user reviews the file sent back by the IRS and would then
choose to make a corrected return if the IRS has listed errors requiring a
response.
For corrected returns the system will only allow editing of
the transactions that are flagged by the IRS. If the user changes the editable
transactions as listed by the IRS it is flagged as corrected, otherwise all
transactions are marked as correct as sent.
The file is then re-transmitted by the signer as a corrected
return.
|