Excel
Dylan Barthole
Lemars,Iowa
Summary
Competent and detail-oriented Accounting Intern well-versed in accounts payable and receivable management, financial forecasting, budgets, and payroll. Talented in identifying and correcting errors for impeccable accuracy. Committed to achieving team objectives and driving company development. Proactive communicator with solid foundation of trustworthy and dependable performance.
Overview
3
3
years of professional experience
3
3
Certification
4
4
years of post-secondary education
Work History
Internal Accounting Intern
People and Profit
Iowa City, Iowa
05.2024 - 09.2024
- Prepared bank reconciliations and journal entries to record transactions in the general ledger.
- Assisted with month-end closing process, including preparation of accruals, prepaids, and other adjusting entries, as well as updating customers' financial models.
- Generated reports using Microsoft Excel to track budget expenditures versus actual costs for specific clients' financial models.
- Analyzed income statements and balance sheets for mistakes and inaccuracies.
- Worked independently, through a remote setting, and was able to solve my own problems.
Construction Worker
OH Livermore Construction
Lemars, IA
05.2023 - 08.2023
- Monitored progress of construction activities making sure deadlines were met.
- Logged inventory to track supply counts, organize equipment, and gather important materials.
- Gained independent working skills and guided and mentored less experienced team members.
- Displayed good time management by showing up on time and making sure projects were completed by the due dates.
Marketing and Communications Intern
Wells Blue Bunny
Lemars, Iowa
06.2022 - 08.2022
- Assist product managers in completing tasks, such as creating product orders.
- Updated spreadsheets daily in order to keep product information up to date.
- Communicated with peers in multiple departments to keep project progress moving.
- Summarized raw data and analyses and made recommendations based on findings.
Education
Bachelor of Arts in Accounting And Finance -
University of Northern Iowa
Cedar Falls, IA 08.2021 - 05.2025
Skills
Data Analytics
Audit and tax research
Internal Auditing
Proficient in Excel, Tableau, and Power BI
Detail Oriented
Time management and Organizational
Affiliations
- Apart of the UNI Accounting, Finance, and Fishing Clubs.
Certification
- Series Industries Essentials (SIE)
- Advanced and Expert Level Excel Certifications
- Pursuing CPA and CMA
Software
Tableau
Power BI
Quickbooks
Oracle
Accomplishments
Received the Lazer award in a business simulation competition for sticking to a precise business strategy throughout the course of the year.
Used tableau to create inventory models to track how much inventory we were holding and if this excess inventory was hurting our profitability.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
Even if you are on the right track, you’ll get run over if you just sit there.
Will Rodgers
Interests
Golf
Working out
Watching sports
Fishing
Being outdoors
Hanging with freinds
Languages
English
Native language
Spanish
Beginner (A1)
A1
Timeline
Internal Accounting Intern
People and Profit
05.2024 - 09.2024
Construction Worker
OH Livermore Construction
05.2023 - 08.2023
Marketing and Communications Intern
Wells Blue Bunny
06.2022 - 08.2022
Bachelor of Arts in Accounting And Finance -
University of Northern Iowa
08.2021 - 05.2025
Similar Profiles
Hannah RayHannah Ray
Program Manager at People Over ProfitProgram Manager at People Over Profit
Nicolette StewartNicolette Stewart
Child Safety & Disability Support Practitioner at Family Contact Supervisor (Profit & Not for Profit Organisations)Child Safety & Disability Support Practitioner at Family Contact Supervisor (Profit & Not for Profit Organisations)
Sarah LillieSarah Lillie
Volunteer at People For PeopleVolunteer at People For People
Ashley WhiteAshley White
RN, Fusion Medical Staffing/Avera at Floyd Valley and Creighton, Critical AccessRN, Fusion Medical Staffing/Avera at Floyd Valley and Creighton, Critical Access
Jessica Ortega-UrbanJessica Ortega-Urban
Dayhab specialist at Life skills training CenterDayhab specialist at Life skills training Center