Andrew Elder
Phoenix,AZ
Summary
Detail-oriented and adaptable accounting professional with over six years of experience specializing in payroll administration, indirect tax accounting, and inventory accounting. Demonstrated expertise in managing complex payroll systems, tax compliance, and audits for multi-state operations, as well as handling high-volume supplier invoicing and inventory management. Proven ability to reconcile accounts, manage tax filings, and provide strategic tax planning to optimize compliance and financial performance. Adept at collaborating with finance teams to ensure accurate reporting and compliance with local, state, and federal tax laws. Known for being deadline-focused, with a strong commitment to precision, continuous improvement, and delivering results under pressure.
Overview
6
6
years of professional experience
Work History
Tax Accountant
Albertsons
Phoenix, AZ
10.2024 - Current
- Balanced Sales and Use and various tax accounts using Oracle queries, Excel, and internal workbooks to ensure all legal entities in the Southwest division were reconciled by close week deadlines.
- Prepared journal entries for various fee discounts and accruals using detailed workbooks.
- Conducted legal entity reclassifications to allocate balances accurately across divisions, and zero out discrepancies.
- Reconciled indirect tax returns for Colorado and other states using Vertex and ensured account balances aligned with the General Ledger in Oracle.
- Utilized IBM QMF and Avalara to analyze taxability for new product entries, perform SMIC reviews, and complete store-to-host file comparisons to ensure compliance.
Indirect Tax Analyst
Sprouts Farmers Market Inc.
Phoenix, AZ
02.2024 - 10.2024
- Managed multi-state sales & use tax filings, prepayments, and compliance for 1,000+ stores, ensuring timely and accurate reporting.
- Pulled and analyzed trial balances and supplier invoices from Workday for tax reporting and audits.
- Verified gross sales and tax across states using Excel (VLOOKUP, Pivot Tables, SUMIF) for reconciliation and audits.
- Prepared sales tax prepayments based on prior-year returns to ensure compliance with tax regulations.
- Maintained prepaid and accrual property tax records, supporting ongoing compliance.
- Supported unclaimed property audits by running trial balances and retrieving historical financial data.
- Researched tax rate changes and updated Workday to ensure compliance with state and local tax laws.
Payroll Implementation Specialist
ADP
Tempe, AZ
03.2023 - 01.2024
- Managed a diverse portfolio of business clients at ADP, overseeing account implementation, payroll setup, and validation of client information to ensure accurate payroll processing.
- Coordinated meetings using Webex, facilitating project discussions and collaboration, while managing scheduling and communications through Outlook.
- Facilitated seamless employee transfers across departments and locations, ensuring proper payroll allocation, tax withholdings, and departmental coding within the ADP system.
- Conducted year-to-date balance adjustments for unrecorded bonuses and payroll discrepancies, ensuring accurate updates to gross pay, taxes, and deductions.
- Provided client training and support on the ADP system, improving payroll management through guidance on manual checks, employee transfers, and correction of miscoded deductions.
Inventory Accountant
Sunup America
Temple, AZ
01.2021 - 02.2023
- Collaborated with procurement to monitor inventory levels, prepare purchase orders in Sage, and ensure accurate and timely replenishment based on sales trends.
- Managed accounts payable, reconciling vendor invoices and payments to support inventory tracking and procurement processes.
- Prepared and tracked purchase orders, coordinating with vendors for timely and accurate delivery of goods to maintain optimal inventory levels.
- Implemented improved processes for inventory reconciliation and tracking, enhancing accuracy and reducing errors.
Accounts Payable Clerk
Sunup America
Tempe, AZ
06.2020 - 01.2021
- Processed high-volume supplier invoices in Sage, ensuring accuracy in quantities, pricing, and terms for entry, tracking, and approval.
- Scheduled and processed payments to suppliers and contractors via checks, ACH, and wire transfers, utilizing advanced Excel functions for reconciliation and tracking.
- Maintained vendor relationships by negotiating payment terms and ensuring timely invoice payments to prevent service disruptions.
- Resolved discrepancies in vendor invoices and payment records, ensuring accurate and timely disbursements.
- Supported the development of automated workflows in Sage and QuickBooks to streamline invoice processing and payment scheduling.
Dispatch Manager
MyHome Services
Chandler, AZ
09.2019 - 03.2020
- Coordinated daily dispatch operations for a home improvement company, managing a team of 80 sales reps to ensure optimal territory coverage and customer engagement.
- Utilized Salesforce CRM to assign leads, track sales rep activities, and monitor customer interactions, enhancing the efficiency and effectiveness of the sales process.
- Developed and implemented dispatch schedules in Salesforce, balancing workloads to maximize productivity and sales opportunities among sales reps.
- Leveraged Slack for real-time communication with the sales team, facilitating instant updates on scheduling, customer feedback, and operational announcements.
- Liaised with customers to provide logistics for drivers and coordinate appointment times.
Accounting Assistant
Priv Energy
Tempe, AZ
07.2018 - 01.2019
- Managed daily bookkeeping, including accounts receivable, accounts payable, bank reconciliations, and disbursements, using Excel for tracking and reporting.
- Provided financial reports on receivables, payables, and reconciliations, offering cash flow insights for management, utilizing Excel for data analysis.
- Performed regular reconciliations of bank accounts, A/R, A/P, and inventory accounts for accuracy in Zoho Books.
- Tracked and categorized expenses, generating reports to help department heads maintain liquidity.
- Processed customer payments via cash, check, and credit cards, ensuring timely invoicing and accurate revenue tracking.
Education
Bachelor of Arts - English & Liberal Studies
Arizona State University
Tempe12-2021
Skills
- Contract negotiation expertise
- Customer Support
- Client management
- Billing analysis
- Excellent time management
- Microsoft Outlook
- Microsoft Excel
- Analytical
- Calm Under Pressure
- Relationship Building
- Experience working with payroll Multi-state payroll
- GAAP proficiency
- Indirect Tax
- Sales and Use Tax
- Multi-state
- Workday
- Sage Intacct
- SAP
- Zoho
- ADP WFN
- SQL
- Property Taxes
- Accrual Accounting
- Client education needs
- QuickBooks expert
- Salesforce expert
Timeline
Tax Accountant
Albertsons
10.2024 - Current
Indirect Tax Analyst
Sprouts Farmers Market Inc.
02.2024 - 10.2024
Payroll Implementation Specialist
ADP
03.2023 - 01.2024
Inventory Accountant
Sunup America
01.2021 - 02.2023
Accounts Payable Clerk
Sunup America
06.2020 - 01.2021
Dispatch Manager
MyHome Services
09.2019 - 03.2020
Accounting Assistant
Priv Energy
07.2018 - 01.2019
Bachelor of Arts - English & Liberal Studies
Arizona State University