Careers

On Supporting Efficiency Through Automation

In my experience, the best way to close the books faster is through automation. One way to do that is by building smarter Excel models that reduce the amount of time it takes to process data for journal entry (JE) creation.

In a recent client engagement, I did just that. I helped my client reduce payroll JE processing time from two weeks to one day by building a payroll model that automated the payroll JE process for over 20 countries!

This process improvement can be applied to any accounting process that requires crunching data in Excel to generate a JE. Moving away from laborious processes that are replicated monthly will save time, increase efficiency, maintain calculation standards and continuity and create transparency for both the preparer and the reviewer!

And to further maximize efficiency, including a custom-built data set report from your ERP system will surely save more time!

Get more insights in these related posts!

Careers at 8020 Consulting

We take pride in nurturing long-term relationships with our team members and our clients. If you’re interested in working on our team of accounting and finance professionals, visit the careers section of our website to learn more about life at 8020. You can also put in an application for consideration by following the instructions at the bottom of the page:

8020 consulting careers call to action

About Gabe

Gabriel has more than 20 years of accounting, audit, finance and financial systems experience across the technology, manufacturing, and consumer products industries with both private and public companies. Gabriel started his career with PwC’s audit practice specializing in technology and led several pre-IPO startup audits and S-1 filing reviews during the dot-com boom. In addition to a career at PwC, Gabriel continued his audit experience at KPMG Israel focusing on the technology, consumer products, and defense industries gaining valuable international work experience. In the private sector, Gabriel has significant startup company experience having built and managed accounting operations as a Corporate Controller for several companies including having managed a successful IPO, acquisitions, financial reporting, implementations of ERP and SaaS applications, and led domestic and international accounting teams. Gabriel holds a BA in Business Economics from the University of California, Los Angeles.

Categorized in:

similar articles

Learn to think and approach problems like our financial consultants.

Financial Reporting & Accounting

7 Nuances That Make Insurance Agency Accounting Unique

While insurance brokerage accounting isn’t necessarily more complex, it is unique when it comes to integrating operations and financial reporting. Whether your agency is in the early stages of getting off the ground or you are an established one looking to grow, below are several topics that should be taken into consideration when evaluating if… View Article

September 29, 2022Steve Rochen

Financial Reporting & Accounting

Questions Every CPG Accounting and Finance Team Should Be Asking

Best-in-class consumer packaged goods (CPG) accounting and finance departments are particularly adept at understanding their product-driven companies, integrating themselves into their organizations and pushing finance and accounting insight throughout the company. Companies that want to develop best-in-class departments can take strides by asking the right questions and taking care to work their way to the… View Article

September 14, 2022Bob Clark

Financial Reporting & Accounting

5 Signs Your Accounts Payable Department Could Be More Efficient

The Accounts Payable department is often considered something of a forgotten branch of the Accounting department. While it plays a pivotal role in ensuring that the company stays in good graces with its vendors, it is often considered to possess simple processes and not require modernization. In reality, the Accounts Payable (AP) department is often… View Article

August 18, 2022Ellen Vayner

See All

Back to Insights