John E Tanks Email and Phone Number

Sales and Use Tax SME for a multinational energy company, tasked with transitioning to Vertex O Series software from Vertex Q Series and Vertex Returns Software to be fully functional to provide benefit to the tax filing process; and for conducting State-specific sales tax laws research for a $1 Billion Company.Managed vendor process for more than 15 personal property renditions using annual fixed assets for warehousing and office space locations.Accountable for filing all sales/use tax, GST/HST, PST, business license, Gross Receipts Returns, and foreign financial disclosure returns. Assisted EU operation VAT Recon process for technical accounts, EU VAT Refunds, and VAT exemption Statements.Addressed customer account manager concerns across the US, Puerto Rico and Canada and sales tax compliance with merchandise sales and service.Verified compliance with local U.S. laws including Canada, Puerto Rico and the U.S. Virgin Islands with energy storage contracts.Created journal entries for sales tax, use tax, GST/HST, PST for reconciliation process and tax clearing process from accrual accounts.Successfully reconciled $20M in sales tax, use tax, prepaid sales tax, and GST/HST (Canada) accounts; charged with reviewing/adjusting returns for refunded sales, sales tax, prepayments, GST payments and deposits; and filed returns using the States EFT online filing system. Minimized tax liability through the timely filing of all returns with the advantage of sales tax discounts. Managed sales tax audits and provided audit information as/when requested by auditors; sales/use tax exemption certificates for sales tax exempt customers; company sales tax permits and business licenses.Revised tax response systems and invoicing process to be based on ship-to address.Recreated the sales tax reconciliation process to adequately account for numerous sales tax credits due to out of period credit memos.

 Responsible for preparing motor fuel tax for all 50 states and federal government. Research issues surrounding motor fuels tax registration and filing requirements. Analyze client data for to ensure data provided to me has necessary components for filing returns. Create check points throughout the return process to ensure accuracy of return.  Implement tax automation software, IGEN and Avalara, that facilitates motor fuels tax return preparation and filing. Developed client and state specific excel work-papers for analyzing client data format isolating anomalies for further analysis. Document return process and anomalies for filing future returns. Reconciled tax dollars and gallons received/exported to zero.  Dedicated to meeting and exceeding client expectations with care, respect and responsibility by taking advantage of self-improvement courses and in-house motor fuel tax seminars. Communicate professionally with team and team leaders about intricacies of each return, its process and potential solutions.

▪ Responsible for preparing motor fuel, sales tax, and Federal foreign entity interest withholding payments and returns including Forms 720 & 1042; for reconciling motor fuel tax accounts and sales tax accounts; and for helping with supporting documentation for transfer pricing.▪ Prepare annual motor fuel license schedules of registration for customers and vendors.▪ Manage the entire sales tax exemption certificate process in conjunction with the Purchase and A/P department.▪ Research sales and use tax laws related to purchases and product sales with subsidiaries and customers; and motor fuel codes for all crude products/derivatives shipped, delivered, and sold for appropriate licensure and optimized trading locations. ▪ Maintain current code and legislation changes for Federal/State motor fuel licenses, permits, bonds, and sales/use taxes. ▪ Travel off-site to verify property and inventory counts; manage/conduct property tax preparation, property tax consultants, filings, and payments (150+ property tax accounts); and manage, maintain, and create appropriate tax calendars, payment trackers, and paper files.

▪ Meet, assist and track progress for the implementation of Avalara Certcapture, a tax exemption collection and recordkeeping system; responsible for processing/completing the upload of valid sales and use tax exemption and resale certificates into the exemption certificate management system for audit support retrieval, and for other recordkeeping requirements in accordance with relevant department policies for the implementation of Avalara Certcapture.▪ Accountable for monitoring/reviewing the exemption certificate management system to ensure the database of valid certificates are maintained/valid, aligned with relevant tax rules for each State and audit authority. ▪ Produced reports on sales/use tax estimates for untaxed sales not covered by valid exemption certificates. ▪ During urgent audit modes, obtained missing exemption and resale certificates.▪ Wrote procedures and processes focused on obtaining exemption certificates from business unit personnel.▪ Researched taxability issues related to product sales, service fees, rentals, and exemption certificate requirements. ▪ Oversaw the business and sales tax license renewal processes, registrations, and corrections. ▪ Managed/maintained Vertex Tax software and process related to invoice crediting and rebilling.

•Serve as subject (Sales and Use Tax) matter expert for a multinational distribution company.•Research state specific sales tax laws that pertain to company.•File all sales/use tax, GST/HST, PST, personal property renditions, business license, Secretary of State, and foreign financial disclosure returns. •Address all concerns with new customers (across the U.S and Canada) and sales tax compliance with sales of merchandise.•Ensure compliance with local law for 40 of the 44 locations including Canada (remaining locations in Mexico).•Review and maintain accurate electronic records of sales tax returns, file dates, check numbers.•Create journal entries for payments of sales tax, use tax, GST/HST, PST property tax, business licenses, Secretary of State, and personal property tax.•Upload sales tax file, use tax, Prepaid GST and sales tax credits into Vertex Returns Software.•Reconciliation of $20 Million sales tax, use tax, prepaid sales tax, GST/HST (Canada) accounts.•Review and adjust returns for refunded sales, sales tax, prepayments, GST payments and deposits.•File returns using the states’ EFT online filing system.•Minimize tax liability by timely filing all returns with the advantage of sales tax discounts.•Expert in Vertex Software, pivot tables, electronic filing, electronic file management and penalty abatement.•Manage sales tax audits and provide audit information requested by auditors and hold firm to company position on issues at hand.•Manage and maintain sales/use tax exemption certificates for sales tax exempt customers, company sales tax permits, Secretary of State Registrations and updates, and business licenses.

•Perform Payroll Functions: 940, 941, W-2, W-3, 1099, TWC Employer Report and Status Report.•Perform Data Entry, Expense Coding and prepare Necessary Documents for Income Tax Returns Clients inside and outside Texas.•Perform Bank Reconciliations, General Ledger, Balance Sheet, Record Beginning Balances, Income Statement, Fixed Assets, and Asset Capitalization.

•Work as a self starter, minimal or no supervision during field audits.•Schedule and conduct audits of Sales Tax, Income Tax, Use Tax, Excise Tax, Withholding Tax; Corporate Tax and Franchise Tax.•Communicate written disclosures of audit performed.•Ability to conduct an audit and provide appropriate recommendations in accordance with GAAS.•Work effectively within a team.•Effectively communicate orally and in writing.•Document findings to incorporate in audit report.•Use analytical procedures to evaluate costs and financial information.•Develop methods and techniques to conduct a variety of different audits.•Identify deficiencies, violations, and non-compliances in audit subject to provide basis for recommendations.•Apply cost accounting theories to distinguish fixed and variable costs.•Analyze cost variances in different environments and/or different products and/or various rates.•Determine accuracy of cost proposals in order to verify reasonableness.•Use data retrieval software to retrieve financial information.•Apply Generally Accepted Accounting Principles to interpret financial accounting information.•Use spreadsheet or word processing programs to analyze financial data.•Apply performance criteria or standards to evaluate effectiveness of functions or programs.•Contact auditee orally to obtain financial information.•Make oral presentations to present audit findings.•Contact auditee in writing to obtain financial information.•Prepare written reports which present audit findings.