Earmark CPE

Earn CPE Anytime, Anywhere

David Leary

Mastering Multi-Channel Mayhem: A CPA’s Guide to Modern E-commerce

· ·

Struggling to reconcile thousands of daily e-commerce transactions from platforms like Shopify, Amazon, and Square? You’re not alone. For CPAs, the surge in e-commerce has transformed accounting into a complex maze. Gross sales don’t match bank deposits, fees are vaguely labeled, and sales tax spans multiple states and cities.

“Everything has moved to net deposits,” explains Jason Richelson, CEO of Bookkeep, in a recent Earmark Expo. “It used to be that gross sales plus sales tax equaled your deposit the next day. Now, everything is net of fees, and it’s becoming increasingly complicated.”

As e-commerce continues to dominate retail, CPAs face an evolving ecosystem of platforms and payment systems. To navigate this complexity and deliver value to clients, they must embrace cutting-edge accounting technologies that offer automated reconciliation, real-time reporting, and multi-channel integration.

This article explores the key challenges of modern e-commerce accounting and how innovative technologies are revolutionizing the field, transforming CPAs into strategic advisors.

The Complex Landscape of E-Commerce Accounting

Gone are the days when retail accounting meant simply reconciling a cash register with a bank statement. The rise of e-commerce has introduced new challenges for CPAs.

“We had about 50 clients,” Jason recalls. “We started developing software, thinking people could handle it manually. They do it manually, but I’m surprised that six years later, they just can’t find people to do this.”

The core problem lies in the shift to net deposits. “It used to be that in your POS, your gross sales plus sales tax equaled the credit card deposits you received the next day,” Jason explains. “But now, businesses receive net deposits—the gross amount minus various fees and adjustments.”

Consider a client using Shopify for online sales, Square for in-person transactions, and selling on Amazon as well. Each platform has its reporting system, fee structure, and payout schedule. Amazon pays out every two weeks, so Christmas sales might not hit the bank account until January.

The complexity compounds with cross-platform sales. A business using Shopify might also sell through Facebook and Instagram. While Shopify shows total sales, including sales tax, the actual deposit might not include that sales tax if Facebook pays it directly. Without specialized tools, a CPA might mistakenly think the business failed to collect sales tax.

“A lot of people just record deposits as income,” Jason notes, “because they’re overwhelmed or don’t have access to detailed data. But we book your sales summary and then your payout deposits separately.”

Innovative Solutions in E-Commerce Accounting

As the e-commerce landscape grows more complex, innovative technologies are emerging to meet the challenge. Specialized accounting software revolutionizes how CPAs manage multi-channel sales, reconciliations, and reporting.

One key feature of Bookkeep is automated reconciliation. “We post summary sales information daily, typically on an accrual basis when the transaction occurs or when it is fulfilled,” Jason explains. This approach allows for accurate, real-time sales tracking across multiple platforms, regardless of when the actual payout occurs. It solves the Amazon payout delay by recording sales when they happen, not when the deposit is received weeks later.

Another crucial aspect is the separation of sales data from payout deposits. This separation allows for clearer tracking of actual sales versus received funds, solving the net deposit problem that plagues many e-commerce businesses. CPAs can now easily reconcile gross sales with net deposits, identifying fees and adjustments.

These systems also offer detailed breakdowns of fees and adjustments. “All the data we post to your accounting platform, we also provide spreadsheets with all the backup data,” Jason says. This level of detail allows CPAs to quickly identify and resolve discrepancies, saving countless hours of manual reconciliation work.

Multi-channel integration is another key feature. Bookkeep handles data from Square, Shopify, PayPal, Amazon, and more, consolidating information from multiple sales channels into a single, coherent financial picture. This integration extends to sales tax management as well. “We will file and pay your sales tax for you, and we do it through Avalara,” Jason explains, addressing the complex issue of multi-jurisdictional sales tax compliance.

These tools are adaptable to the rapidly changing e-commerce landscape. When e-commerce platforms introduce new features or payment methods, the software updates to accommodate them, ensuring CPAs always have accurate, up-to-date information.

The Evolving Role of CPAs in E-Commerce

Innovative technologies are not just making CPAs’ jobs easier—they’re reshaping the role of accountants in the e-commerce era. The focus is shifting from data entry to strategic advisory.

“We’re here to help you understand the data coming through,” Jason explains. “That’s really where accounting is going—it’s about data flows and proper categorization.” This shift means CPAs need to develop new skills and knowledge to thrive.

Understanding the intricacies of various e-commerce platforms is essential. “Shopify moves very fast. Square is also providing great tools. TikTok is coming onto Shopify as well,” Jason notes. CPAs need to stay current with these developments to provide accurate advice and ensure proper accounting treatment.

Sales tax complexity presents another opportunity. With Bookkeep’s integration with Avalara, CPAs can offer comprehensive sales tax management services. “Nobody inside these e-commerce businesses wants to learn that stuff,” Jason says. By mastering these tools, CPAs become indispensable advisors, helping clients navigate multi-jurisdictional sales tax requirements.

Some CPAs might worry that these technologies could replace their roles. However, the reality is that these tools free CPAs from tedious tasks, allowing them to focus on higher-value activities. CPAs can offer strategic insights into cash flow management, profitability analysis, and growth strategies by interpreting the detailed data these systems provide.

Embracing the Future of E-Commerce Accounting

E-commerce accounting is evolving rapidly, but CPAs can turn these challenges into opportunities with the right tools and mindset. You can stay ahead in this digital era by embracing innovative technologies and focusing on strategic advisory.

To better understand these cutting-edge solutions and how they can transform your practice, we encourage you to watch the on-demand webinar featuring Jason Richelson’s insights on the evolution of e-commerce accounting. You’ll learn about the latest trends in e-commerce platforms, discover how to leverage automated reconciliation tools, and gain strategies for positioning yourself as a valuable advisor to e-commerce clients.

The End of Late-Night Spreadsheets: Live Flow’s Game-Changing Solution for CPAs

· ·

Imagine it’s 2 a.m., and you’re still wrestling with spreadsheets because a client made last-minute changes. If you’re a CPA, this scenario might sound all too familiar. The endless cycle of manual updates highlights a persistent challenge in financial analysis: balancing customization with automation.

But what if you could have both? At the recent Earmark Expo, a solution emerged that promises to revolutionize how CPAs handle financial data. Enter LiveFlow, a groundbreaking tool catching accountants’ attention everywhere.

“The solution that LiveFlow offers allows you to create live reports of your QuickBooks information directly in Google Sheets or Excel,” explains Josh Thomas, Senior Product Owner at LiveFlow. For CPAs looking to modernize their financial analysis without sacrificing customization, LiveFlow combines the familiarity of spreadsheets with automated data integration and advanced reporting features.

In this article, we’ll explore how LiveFlow bridges the gap between customization and automation in financial analysis. From seamless integration with existing tools to advanced consolidation capabilities and robust forecasting, discover why LiveFlow might be the game-changer CPAs have been waiting for.

Seamless Integration with Accounting Software

At the heart of LiveFlow’s innovation is its ability to integrate seamlessly with the accounting software and spreadsheets CPAs already use. Gone are the days of endless copy-pasting and manual data entry. LiveFlow directly bridges QuickBooks or Xero and your Google Sheets or Excel workbooks.

Blake Oliver, co-host of the Earmark Expo, shared a painfully familiar memory: “I have a very distinct memory of one time doing it seven times in a row until about two in the morning because I kept having to make changes.” This tedious process of exporting, pasting, and reformatting becomes obsolete with LiveFlow.

Instead, LiveFlow allows you to create live reports that update automatically. “By default, LiveFlow is refreshing your QuickBooks data every single hour,” Josh explains. This means your spreadsheets are always up-to-date without any manual effort.

What about customization? LiveFlow doesn’t sacrifice flexibility for automation. You can add custom formulas, insert new columns, and tailor your reports to your needs. The app allows you to filter data by customer, class, vendor, or location, giving you granular control over your reports. Impressively, LiveFlow retains these customizations even when the underlying data refreshes.

For CPAs managing multiple clients, this is transformative. As David Leary pointed out, “I could see Blake’s problem is magnified if you have 50 clients. Now, you’re doing this over and over across 50 clients.” With LiveFlow, you set up customized reports for each client once and let the software handle the updates.

Simplifying Complex Consolidations

Consolidating financial data from multiple entities or standardizing a complex chart of accounts can be daunting. Traditional methods involve intricate Excel formulas that are prone to errors and time-consuming to maintain. LiveFlow’s consolidation feature tackles this challenge head-on.

“No more formulas,” Josh emphasizes. “You’ve distilled it down to the consolidated accounts you want in your end report.” This approach saves time and significantly reduces the risk of errors.

LiveFlow uses a visual mapping process. You can click and drag to map accounts from different QuickBooks files to a unified chart of accounts. It even handles intercompany eliminations, a notoriously tricky aspect of consolidation.

Perhaps most impressively, the consolidation feature updates automatically when new accounts are added, or changes occur in the underlying QuickBooks files. No more scrambling to update complex spreadsheets every time a client tweaks their chart of accounts.

Transforming Data into Actionable Insights

CPAs need to do more than crunch numbers—they also need to tell compelling financial stories. LiveFlow Dashboards transform complex financial data into visually appealing, easy-to-understand visualizations that resonate with clients.

“We’re really excited about it because, for some people, coding is not their bread and butter,” Josh explains. LiveFlow Dashboards allow CPAs to create professional, customizable dashboards without coding skills. You can select from components like bar charts, line graphs, and KPI indicators, arranging them to build a dashboard that suits each client’s needs. Advanced settings like filtering by vendor or displaying data by quarter provide a level of customization that rivals custom-coded solutions.

One standout feature is the ability to create “snapshots” for static reporting. This addresses a common concern voiced by Blake: “I don’t want it refreshing automatically throughout the month because the period isn’t closed yet.” With snapshots, you control exactly what data your clients see and when, balancing real-time updates with carefully curated financial presentations.

But LiveFlow doesn’t stop at visuals. Its forecasting capabilities take financial analysis to the next level, combining automation with the flexibility to model various scenarios. The cash flow forecasting templates include features like income vs. burn rate charts and runway models. You can input different growth rates and starting financial positions to model various scenarios for a startup client.

“If you’re advising software or startups, then their burn rate and runway are the two most important things to keep tabs on,” Blake points out. “If you can do that for them with live data from their QuickBooks file, you become really valuable as an advisor.”

These tools allow CPAs to offer high-value services like scenario analysis and strategic financial planning. By combining live data with powerful, customizable forecasting tools, you can help clients make informed decisions about their financial future.

Embracing a New Era of Financial Analysis

LiveFlow represents a significant leap forward in financial analysis technology, seamlessly bridging the gap between customization and automation. As Josh aptly puts it, “The beauty of it is sometimes the simplicity of it.” By integrating live data with familiar spreadsheet interfaces, simplifying complex consolidations, and offering powerful visualization and forecasting tools, LiveFlow empowers CPAs to work smarter, not harder.

The implications for the accounting profession are profound. With LiveFlow, CPAs can significantly increase their efficiency, freeing up time to focus on high-value tasks like strategic advising. As Blake noted, “If you can do that for them with live data from their QuickBooks file, you become really valuable as an advisor.” This ability to quickly generate customized, visually appealing reports and forecasts enhances the services CPAs can offer to their clients.

Perhaps most importantly, LiveFlow allows CPAs to modernize their practice without abandoning their hard-earned expertise and customized approaches. It’s not about replacing the CPA’s skillset but augmenting it with powerful tools that make financial analysis more efficient and insightful.

Experience LiveFlow for Yourself

To see how LiveFlow can revolutionize your financial analysis processes, watch the Earmark Expo. Discover firsthand how you can harness the power of automation while maintaining the flexibility your clients depend on. Don’t just adapt to the future of financial analysis—shape it with LiveFlow.

From Zero to CPA in 18 Months

· ·

Consider this: Kenyth Holdefer, who once worked in the mortgage industry, obtained both his bachelor’s and master’s degrees and successfully passed all four CPA exams, all within just 18 months. His extraordinary journey challenges traditional pathways to CPA certification and offers a potential solution to the accounting industry’s talent shortage.

Ken shared his story on The Accounting Podcast, revealing how he started his accounting journey with just 12 college credits. “I googled ‘quick bachelor’s degree,'” he said, highlighting his unconventional approach.

Fast-Tracking Degrees Through Competency-Based Education

Ken needed a swift career change. With its competency-based education model, Western Governors University (WGU) offered a solution.

“They have a different education model,” Ken explained. “If you know the material, there’s no reason to do a bunch of assignments and papers on stuff you already know. If you can prove you know the material by passing the test—basically, there’s a final exam—and if you pass it, you pass the class.”

This model allowed Ken to complete his bachelor’s degree in just three months—a process that usually takes four years. After a short break, he completed his master’s degree in 30 to 35 days.

Balancing this intense study schedule with a full-time job and family responsibilities, Ken often studied from 7 p.m. to midnight after putting his kids to bed. Remarkably, the total cost for both degrees was under $10,000—a fraction of what students typically spend on a single degree.

But can such an accelerated program prepare someone for the CPA exam and the accounting profession? Ken’s success suggests that it can, but it requires tremendous self-discipline and motivation. “You have to be very self-motivated to do this,” he emphasized.

Ken’s Intensive CPA Exam Preparation

With his degrees completed, Ken faced the CPA exams. He approached this challenge with the same intensity as his education.

Ken quit his job in January and dedicated six months to full-time study before starting at an accounting firm in June. He scheduled all four CPA exams at one-month intervals, aiming to take them all before receiving any scores.

“I took it extremely seriously,” Ken said. “I documented everything I was doing, how many hours I was studying because I wanted to pass them all on the first try.” His routine was grueling: studying 8 a.m. to 5 p.m., Monday through Friday, treating preparation like a full-time job.

He explained, “I glanced over all the material, learned a little about everything, and then really focused on the multiple-choice questions and task-based simulations within two weeks of taking the exam.”

Compared to traditional CPA exam preparation over 12–18 months of part-time study, Ken’s method was revolutionary but challenging. “It was a lot of four-hour nights of sleep,” he admitted.

However, the benefits are clear: a dramatically shortened timeline and total focus on exam preparation. Ken’s success proves this approach can yield impressive results for highly motivated individuals.

Implications for the Accounting Profession

Ken’s rapid journey to CPA challenges the accounting industry. With 75% of CPAs nearing retirement, the profession faces a talent shortage. Could accelerated pathways be the solution?

Faster, more affordable routes could attract a diverse pool, including career changers like Ken. However, the profession must ensure that speed doesn’t compromise quality. The CPA license carries weight due to its rigorous standards. Any changes must maintain the high level of expertise expected from CPAs.

Ken’s success suggests it’s time to think creatively about educating and certifying CPAs. By embracing innovation while maintaining excellence, we can ensure a bright future for the profession.

Want to dive deeper into Ken’s extraordinary journey and join the conversation about revolutionizing the path to CPA certification? Listen to the full The Accounting Podcast episode.

California’s Bold Move to Solve the CPA Crisis: A Blueprint for Public Protection

· ·

Is your financial security at risk due to a shortage of accountants? It might be. The CPA profession faces a talent crisis that threatens both balance sheets and public safety. With fewer than 1% of accounting firms saying they can find enough staff, we’re seeing the fallout in the form of financial misstatements and eroded public trust.

But there’s hope on the horizon. The California Board of Accountancy is taking bold steps to address this crisis, authorizing the staff to draft potentially groundbreaking legislation to streamline licensure requirements and grant automatic mobility for CPAs.

In a recent episode of The Accounting Podcast, we discussed this development with Amber Setter, Chief Enlightenment Officer for Conscious Public Accountants.

The CPA Shortage: A Looming Threat to Public Safety

The CPA shortage isn’t just an industry problem—it’s a public safety crisis. Amber argues that this talent drought directly threatens the core mission of the accounting profession: protecting the public interest.

“We are living in an era where it’s not like this pipeline issue is going to happen. We’re living it,” Setter emphasizes. The consequences are already visible and alarming. With insufficient staff, firms struggle to maintain adequate levels of review, a crucial safeguard against errors and fraud. This shortage compromises the very foundation of financial integrity that the public relies on.

State boards of accountancy, tasked with protecting the public, find themselves in a difficult position. How can they fulfill their mandate when there aren’t enough qualified professionals to do the work? As Setter points out, “Right now, the public’s not being protected without an adequate amount of people to do the work.”

California Leads the Charge: A Blueprint for Reform

The California Board of Accountancy (CBA) is taking bold steps that could revolutionize CPA licensure. Their order to draft legislation addresses the shortage head-on while maintaining the profession’s high standards and prioritizing public protection.

The CBA’s proposal includes several potentially groundbreaking changes:

  1. Eliminating the 150-hour education requirement
  2. Streamlining the initial licensure process
  3. Granting automatic mobility for CPAs from other states

These changes represent a significant shift from the status quo. By removing barriers to entry while maintaining rigorous standards, the CBA aims to expand the pool of qualified CPAs without compromising quality.

The action has garnered overwhelming support. A recent CBA survey with over 7,000 responses found that 89% of respondents agreed that a bachelor’s degree in accounting should fully meet the educational requirements for licensure. This level of consensus is rare and speaks to the situation’s urgency.

Commenting on the significance of this move, Amber said, “This is a huge domino. I would hope other states are already calling California up saying, ‘Hey, what are you doing? We want to do this too.'” Her enthusiasm underscores the potential for California’s actions to catalyze nationwide change.

The automatic mobility provision is particularly crucial for public protection. By allowing qualified CPAs from other states to practice in California without additional hurdles, it ensures that businesses and individuals have access to a larger pool of professionals.

Has the AICPA Lost Sight of Public Interest?

While states like California take decisive action, national organizations are dragging their feet. The contrast is stark and concerning, raising questions about whether the profession’s leadership has lost sight of its primary duty: protecting the public interest.

The AICPA’s National Pipeline Advisory Group recently issued a report on addressing the CPA pipeline problem. However, the report lacks specific, immediate recommendations for change, which is troubling. While research and stakeholder input are valuable, the urgency of the current crisis demands immediate, substantive steps.

The consequences of this inaction could be severe. As the shortage persists, the risk of financial misstatements, undetected fraud, and erosion of public trust in financial reporting increases.

The inaction at the national level underscores the importance of state-led initiatives like California’s. State boards of accountancy, being closer to the ground and more directly accountable to the public, seem better positioned to address the crisis effectively.

Rethinking Accounting Education: A Call for Radical Reform

The CPA shortage crisis isn’t just about licensure requirements—it’s also an indictment of our current approach to accounting education. The disconnect between education and practical skills is a major contributor to the current crisis. Many accounting graduates struggle with basic tasks despite excelling in theoretical coursework. This gap between academic success and practical competence directly impacts public protection as new CPAs enter the field ill-equipped to catch errors or identify potential fraud.

We need a radical overhaul of accounting education to address the shortage while maintaining high standards. One bold proposal is to require only a bachelor’s degree in any subject to sit for the CPA exam rather than mandating specific accounting courses or degrees. This approach would force accounting programs to compete for students by offering valuable, practical education that prepares them for the CPA exam and real-world challenges.

Critics may argue this would lower standards, but the opposite could be true. By exposing accounting programs to market forces, we could drive innovation and improvement in curricula, ultimately producing more qualified and practically skilled CPAs.

Implementing such changes would face challenges, particularly from entrenched interests in academia. Many states would need to change legislation to enable these reforms. However, as California’s example shows, bold action is possible when public protection is prioritized.

The CPA profession stands at a critical juncture. The shortage of qualified accountants isn’t just an industry problem—it’s a clear and present danger to public safety and financial integrity. This crisis demands urgent, bold action to fulfill our profession’s core mission: protecting the public interest.

To gain a deeper understanding of these critical issues shaping the future of accounting, listen to the full episode of The Accounting Podcast, then reach out to your state board of accountancy. Express your urgent concern about the CPA shortage and its implications for public protection. Urge them to consider bold reforms like those proposed in California. Let’s act now to ensure a robust, capable, and trusted accounting profession for generations.

The Hidden Cost of Big Four Hiring Bias

· ·

Imagine being told your 20 years of diverse accounting experience don’t qualify you for a job because you never worked at a Big Four firm. This is absurd, and it happens every day in our profession.

In a recent episode of The Accounting Podcast, we examined the hiring bias that is creating an artificial barrier in our field. It’s not just a minor inconvenience – it’s limiting diversity, overlooking valuable talent, and perpetuating a dangerously narrow view of what constitutes “success” in accounting.

A Barrier to Diversity and Talent

Scroll through job postings for corporate accounting roles, and you’ll quickly notice a pattern: “Big Four experience required” or “Big Four experience preferred.” This requirement is so commonplace that many in our profession barely question it. But we should.

Why should one to three years of experience on a resume dictate your entire career trajectory? Demanding Big Four experience in job postings is lazy, and it borders on discrimination and classism.  

This hiring bias creates an artificial barrier that significantly narrows the talent pool. It overlooks the wealth of experience and skills accountants gain in smaller firms, industry roles, or alternative career paths. 

Consider the CPA who wrote to us. (Listen to the episode for details.) They have two decades of diverse experience across multiple industries, including exciting projects with buyouts and public company purchases. Despite this rich background, they are potentially disqualified from roles simply because they never worked at a Big Four firm.

The impact of this bias extends beyond individual careers. It homogenizes our profession, limiting the diversity of thought, background, and experience crucial for innovation and problem-solving. This practice also disproportionately affects professionals from underrepresented groups who may have had fewer opportunities to enter Big Four firms early in their careers.

Big Four Experience vs. Operational Expertise

The emphasis on Big Four experience stems from a perception that it provides a unique skill set essential for success in corporate accounting roles. But does this perception align with reality?

Our listener’s feedback paints a different picture: “I have worked with employees of Big Four firms during audits, and frankly, they are disconnected from the reality of operational accounting.” The listener continues, “They can review the heck out of internal control issues, but none of them ever worked with a badly implemented ERP system with an AR module failing and unable to reconcile cash for eight months because of poor IT support.”

As our listener points out, the skills honed in Big Four firms, while valuable, don’t necessarily translate directly to the day-to-day challenges of operational accounting. Audit experience focuses heavily on reviewing past transactions and assessing controls. But operational accounting requires implementing and managing systems, solving real-time problems, and navigating the complexities of business operations.

If you require experience from the Big Four, you might be overlooking candidates with hands-on experience in favor of a resume line item that may not indicate readiness for the role.

Moving Towards a More Inclusive Hiring Approach

Our profession needs to broaden its definition of what makes a successful accountant. We must move beyond the Big Four checkbox and adopt a more holistic view of professional qualifications that values diverse backgrounds, operational expertise, and adaptability.

What might this look like in practice? We should emphasize problem-solving skills and adaptability over pedigree, value diverse experiences and skill sets, consider candidates’ proficiency with various accounting systems and technologies, and assess their ability to handle operational challenges.

By adopting this more inclusive approach, we’ll tap into a broader talent pool, bring more diverse perspectives into our teams, and build teams better equipped to handle complex, multifaceted challenges.

Professional organizations like the AICPA and state societies could play a crucial role in this shift by discouraging the practice of requiring Big Four experience in job postings and promoting more inclusive hiring practices.

Embracing a New Era in Accounting Recruitment

The Big Four bias in hiring isn’t just a topic for academic debate – it’s a real issue affecting careers and shaping the future of our profession. 

This shift isn’t just about fairness. In a rapidly evolving business landscape, we need accountants with varied experiences and skill sets to drive innovation and tackle new challenges.

The accounting profession must embrace a more inclusive approach that values diverse backgrounds, operational expertise, and adaptability.

Listen to the full episode of The Accounting Podcast, where we explore the hidden costs of hiring biases, share more real-world examples, and discuss practical strategies for implementing more inclusive hiring practices. Whether you’re a hiring manager, a job seeker, or simply passionate about the future of accounting, this episode offers valuable insights to help reshape our profession.

It’s time to redefine what success looks like in accounting – and it starts with how we hire. Join the conversation and be part of the solution.