Get documents about "Sales and Use Tax Spreadsheets Calculator - PDF
W
Description
Sales and Use Tax Spreadsheets Calculator document sample
Document Sample
Sales and Use Tax Software:
Comparing the Leading Platforms
presents Candid Evaluations for Your Next Investment in a Compliance System
A Live 110-Minute Teleconference/Webinar with Interactive Q&A
Today's panel features:
Mike Hayes, Director, The Gagnon Group, Boston
Michael Figueroa, Tax Systems Manager, Citadel Investment Group, Chicago
Tony Chavez, Director of Tax Technology, Ryan, Burlington, Mass.
Tuesday, September 29, 2009
The conference begins at:
1 pm Eastern
12 pm Central
11 am Mountain
10 am Pacific
The audio portion of this conference will be accessible by telephone only. Please refer to the dial in instructions emailed to registrants
to access the audio portion of the conference.
Sales And Use Tax Software:
Comparing The Leading Platforms
Webinar
Sept. 29, 2009
Mike Hayes Tony Chavez
The Gagnon Group Ryan
mhayes@thegagnongroup.com tony.chavez@ryanco.com
Michael Figueroa
Citadel Investment Group
michael.figueroa@citadelgroup.com
Sabrix
• Global transaction tax engine that supports more than 170 countries
• Single tax engine that will support sales, use, value-added and other
indirect taxes
• Web-based interface with simple navigation
• The ability to apply company/division relationships to nexus and other
taxability drivers
• Mapping of ERP products/SKUs to product categories
• Exemption and direct-pay certificates, customer exemptions, product
taxability and allocations can be applied against transactions
• Ability to apply additional fee-based taxes in addition to standard
taxability rules
• Address validation is based upon ZIP+4
Michael Hayes 2
Sabrix (Cont.)
• Ability to extract audit data that can be loaded into a tax compliance
system
• TransEditor provides the tools for creating logic using any
combination of inputs to drive specific taxability results
– Don’t go crazy with the number of TransEditor rules
• WorkBench provides the ability to test taxability rules configured in
Sabrix
• Integration (Sabrix connectors) with all leading ERP systems including
SAP, Oracle, PeopleSoft and Ariba
• Ability to apply additional taxability drivers in Pre Calc and Post Calc
• Sabrix retail point-of-sale solution
Michael Hayes 3
Vertex L Series
• COBOL/RPG-based product
• Supports sales, use and consumer use transactions
• Supports simple VAT transactions
• GeoCodes (nine-digit code) for each specific taxing location
• Tax Decision Maker (TDM) used to support and maintain nexus,
exemption certificates and product taxability
• Ability to extraction data (TAX2000 file) from register database that
can be loaded into Vertex Sales Tax Returns
• Latest release 4.3 (March 2009)
• Enhancements
– Version 5.0 (due to be released September/October 2009)
• Major enhancement is ability to process ZIP+4 validation
• Upgrade to Q or O Series
Michael Hayes 4
Vertex Q Series
• Supports sales, use and consumer use transactions
• Supports simple VAT transactions
• Client/server-based program with a light footprint
• User interface (UI) easy to navigate and configure
• Tax Decision Maker (TDM) used to support and maintain nexus,
exemption certificates, customer exemptions, product taxability
• TDM Importer/Exporter provides the flexibility to mass-load TDM
rules
• GeoCodes (nine-digit code) for each specific taxing location
• Ability to extract data (TAX2000 file) from register database that can
be loaded into Vertex Sales Tax Returns
Michael Hayes 5
Vertex Q Series (Cont.)
• Integration with all leading ERP systems including SAP, Oracle,
PeopleSoft and JD Edwards
• Common interface issues
– Sales tax vs. seller use tax
– Product code mappings
– Nexus settings for receivables and payables
• Current releases
– Version 3.2 and below
– Version 3.3 and higher
• Enhancements
– Version 5.0 (Q4 - 2009)
• ZIP+4 validation
• Conversion program is available that will convert your TDM rules into
O Series for easy migration
Michael Hayes 6
Vertex O Series
• Global transaction tax engine that supports more than 240 countries
• Browser-based user interface
• Expanded tax rule set
• The ability to apply company/division/department relationships to
nexus and other taxability drivers
• Mapping of ERP products/SKUs and other data drivers to tax
categories
• Transaction Tester provides the ability to test taxability rules
configured in the Taxability Manager
• Security and Audit Log offers controlled access through role-based
security, to ensure your tax management processes are in SOX
compliance
Michael Hayes, 7
Tony Chavez
Vertex O Series
• Tax area IDs are NOT the same as GeoCodes (Vertex L and Q Series)
• Vertex O Series modules (each module requires a separate license)
– Sales tax (U.S. and Canada)
– Consumer use (U.S. and Canada)
– VAT purchases
– VAT supplies
– Leasing
– POS (available as a light footprint or as data extraction for rates and rules)
• Tax Assist provides the tools for creating logic, using any combination
of inputs to drive specific taxability results
• Integration with all leading ERP systems including SAP, Oracle,
PeopleSoft and JD Edwards
Michael Hayes 8
Vertex O Series
• Built-in tax rate look-up
• Hierarchical entity structure
• Exemption certificate tracking
• Integration with Vertex Sales Tax Returns
• Future integration with Vertex ECM
• Expanded reporting capabilities
Tony Chavez 9
ADP Taxware – Taxware Enterprise
• Front-end global transaction tax calculation engine that supports more than
250 jurisdictions
• Single tax engine for global sales, use, VAT and other consumption taxes
• User-friendly, browser-based interface with intuitive workflow
• Multi-entity support with the ability to copy or share nexus or other
attributes between business units
• Comprehensive off-the-shelf global content: Goods, service, entity and use-
based rules, rates with the ability to build custom content
• Easy mapping of source (i.e., ERP) item categories to goods/service codes
• Content certified by the Streamlined Sales Tax Project governing board
• Street-level address validation
• Tax rule customization gives users flexibility to accommodate almost any
business need
Mike Figueroa 10
ADP Taxware – Taxware Enterprise
(Cont.)
• Robust, online tax calculator allows for easy transaction testing
• Calculation results may be fed into TaxSolver (ADP’s filing solution), for
automated tax returns and reporting
• A tax department can easily manage an internally hosted system or opt for
the ASP model
• Security that allows for tight restrictions on data access privileges, for the
appropriate users
• Automatic or manual tax research update
• Integrates easily with client-created systems as well as leading enterprise
resource planning (ERP) systems
• Ability to be run on multiple application server/database platforms
• Hosted environment resides in a Tier 4 data center
• Excellent customer support for both software and environment variables
Mike Figueroa 11
CorpSystem Sales Tax Office
• Supports sales, use and consumer use transactions for U.S. and Canada
• Ability to set nexus configuration down to the local and district levels,
per business unit
• Product group and item database based upon CCH industry leading
research
• Specialized product group and item databases: Add-on databases for
food, restaurant and durable medical equipment databases, available as
annual subscriptions
• Easy mapping of ERP products/SKUs to STO product groups and
items
• Data configuration module allows custom data transformation, per
business units
• Flexible to configure almost any business requirement
Michael Hayes 12
CorpSystem Sales Tax Office (Cont.)
• The ability to define and configure address-sourcing requirements
based upon ship-to, ship-from, order placement and order approval
• STO GeoCode (12-character code) that uniquely identifies jurisdiction
– Format -> Country – State – County FIPS – GeoBlock (e.g. US-25-025-07090)
• Sales tax address validation API - Ensure reliable address information
by integrating address scrubbing and validation
• Integration with the accounts receivable and accounts payable modules
for SAP, Oracle and Microsoft Dynamics AX, Dynamics GP and
Dynamics NAV
• The ability to produce an export file based upon audit history tables
that can be imported into CorpSystem Sales Tax Returns online
• Runs on MS SQL server platform
Michael Hayes 13
Second Decimal - Pinpoint
• Centralize tax decisions on purchases only for the U.S., Canada and
Puerto Rico
• Unobtrusive process to acquire a robust data set for tax decisions
without the need for development of an interface
• No default tax system
• Uses algorithmic approach to examine the quality of data for a rule set
– not quantity
• Ability to correct and adjust already processed transactions
• Reports differences between amount calculated by Pinpoint to amounts
charged by the vendor
• Data retention and storage
Tony Chavez 14
Second Decimal - Pinpoint
AP Data Extraction
is Created
File Tax Returns PinPointTM User
Loads Data File
PinPointTM User Data File is
Runs Post Accrual Processed Against
Reports for PinPointTM
Compliance Matrices
PinPointTM User
General Ledger Runs Suspended
Extraction from and Processed
PinPointTM Reports
PinPointTM User PinPointTM User
Runs Pre-Accrual Reviews/
Report to Analyze Processes
Reasonableness Transactions in
PinPointTM
Tony Chavez 15
Vertex Sales Tax Returns
• Tax compliance software that supports U.S., Canada and Puerto Rico
• Can easily import tax data from Vertex L, Q or O Series
• Easily create custom imports from other sources (GL, other tax
calculation software, Excel spreadsheets, delimited file)
• The ability to manually enter data, either on the form or through an
adjustment form
• Identifies, tracks and stores credits
• Supports EDI filing in 18 states
• Enhanced reporting ability through management toolkit
– Tax Calendar
– Report Writer
– Document Manager
Michael Hayes 16
®
CORPTAX - CORPSales
• Legacy CORPTAX user interface
• Excellent import functionality with reformatting capability that allows
flexibility to work with multiple front-end systems
• Gross-up or calc-down sales/use tax, sales and purchases
• Minimal system requirements
• Ability to create pre-return processing calculations that post-calculate
amounts to the database
• Ability to customize return calculations
• Quick and easy data querying from amount database
• Good security and audit trail
• Online return review with true drill-down capability
• Return batch processing
• Updates available via the Internet
Mike Figueroa 17
®
ADP Taxware - TaxSolver
• Return preparation software supporting 1,200-plus U.S. state/local and
Canadian forms
• Simple import of Taxware Sales and Use Tax System and Taxware
Enterprise data
• Exception reporting for unconverted or mismatched data
• User-friendly interface with logical workflow
• Schedules filing frequency, estimated payments, default filings and more
• Updates automatically or manually each month with correct rates/forms
• Ability to adjust rates and data on all lines and fields in the return
• Ability to generate soft- or hard-copy check requests
• MS SQL Server-based; allows for easy back-end reporting and
troubleshooting
• Allocations and adjustments can be exported into Excel for further analysis
Mike Figueroa 18
CCH - CorpSystem ®
Sales Tax Returns Online
• Software as a service
• Web-based ASP sales and use tax return preparation
• Initial set-up source file(s), then FTP monthly to vendor
• Gross-up or calc-down sales/use tax, sales and purchases
• Review returns online
• Ability to override amounts on return with audit trail
• Export to Excel for check request processing
• Seamless updates available via the Internet
Mike Figueroa 19
