Earmark CPE

Earn CPE Anytime, Anywhere

Blake Oliver

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.

Mastering Prompt Chaining: Unlocking AI’s Full Potential in Content Creation

· ·

As a CPA passionate about tech, I’m always looking for apps that simplify work and boost productivity. The arrival of AI tools like ChatGPT and Claude felt like stepping into a new era, especially for content creation. However, I quickly learned that to truly harness their power, it’s not about tossing out a prompt and crossing your fingers.

Recently, I had the opportunity to discuss this and more on the Amplify! podcast, where we delved into how AI is revolutionizing marketing strategies, particularly in the accounting profession. As I shared on the pod, the real game-changer when using AI for content creation is mastering prompt chaining—a method that’s transformed how I work.

The Limitations of One-Shot Prompts

Consider a common scenario. Suppose you need a 1,000-word blog post on a specific tax deduction for your firm’s website. The straightforward approach might be to type into ChatGPT: “Write a 1,000-word blog post about this tax deduction.” Seconds later, the AI generates an article. Convenient. But here’s the catch.

The content is likely to be generic, lacking depth, and similar to countless other articles online. It’s like expecting a gourmet meal but receiving fast food. The issue? One-shot prompts give the AI minimal direction, resulting in superficial content that fails to engage or inform readers effectively.

Breaking It Down: The Power of Prompt Chaining

To achieve high-quality content, you have to interact with the AI more deliberately. Enter prompt chaining—guiding the AI through a series of targeted prompts to produce superior results. Here’s my step-by-step approach:

  1. Start with Rich Source Material: I kick things off with a transcript from a podcast, an interview, or even a voice memo where I explore the topic in depth. This provides the AI with substantial, authentic content to draw from.
  2. Analyze the Content: I ask the AI to examine the transcript and identify key themes, insights, and potential angles. For example: “Analyze this transcript and summarize the main points discussed.”
  3. Develop a Thesis and Outline: Based on the analysis, we craft a strong thesis statement (the key point or takeaway). Then, I prompt the AI: “Create a detailed outline for an article based on this thesis, including an introduction, key sections, and a conclusion.”
  4. Draft Section by Section: Instead of having the AI write the entire article in one go, I focus on one section at a time. I might say: “Write an engaging introduction based on this outline,” and then proceed through each section individually.
  5. Review and Refine: After each section is drafted, I review it, make edits, and ensure it aligns with my voice and the message I want to convey.

Why Prompt Chaining Works

By collaborating with the AI step by step, prompt chaining offers several benefits:

  • Enhanced Depth and Clarity: The content becomes more nuanced and informative.
  • Authentic Voice Capture: The AI better reflects my tone and style.
  • Improved Efficiency: It saves time by minimizing the need for extensive revisions.

Making AI Your Collaborative Partner

The key is to view the AI as a collaborator, not just a tool. By guiding it through the process—much like mentoring a junior colleague—you tap into its full potential. It’s about providing context, setting clear expectations, and engaging in an iterative process to refine the output.

Ready to Transform Your Content Creation?

Next time you sit down to create content, don’t settle for surface-level results. Break down your prompts, guide the AI through each step, and experience firsthand how prompt chaining can revolutionize your workflow. Not only will you produce higher-quality content, but you might also find the process more rewarding.

For a comprehensive look at how I use prompt chaining and other AI strategies to enhance productivity, tune into the full podcast episode here. We delve into the nuances of prompt chaining, discuss practical applications, and explore how AI can transform your work and personal life.

Blake Oliver, CPA, is the founder and CEO of Earmark, a platform transforming how professionals earn their CPE credits. Passionate about accounting and technology, Blake is dedicated to helping others leverage AI to work smarter, not harder.

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.

The Human Element: The Key to Successful Accounting Firm Mergers

· ·

When Craig and Lynnette Connell decided to merge their boutique accounting practice with Sweeney Conrad, they weren’t just selling a business—they were navigating a complex web of relationships, emotions, and expectations. In an industry where mergers and acquisitions are increasingly common, the human element often gets lost amid balance sheets and valuations. Yet, as Craig and Lynnette’s story reveals, this human element can make or break a transition.

On a recent Earmark Podcast episode, Craig and Lynnette shared their journey of merging their boutique Client Accounting Services (CAS) practice with Sweeney Conrad, a larger regional firm. Their experience offers a masterclass in the oft-overlooked aspects of accounting firm transitions. Despite merging during busy season and managing parallel systems, they achieved 150% revenue growth post-acquisition. How? By prioritizing the human side of the equation.

The key to a smooth accounting firm transition lies in maintaining strong relationships, fostering open communication, and addressing the emotional aspects of change for both clients and staff. These human elements determine whether clients stay, staff thrive, and the new entity flourishes.

The Power of Relationships in Finding the Right Buyer

Your network is your net worth in accounting, especially when finding the right buyer for your firm. Craig and Lynnette’s story is a testament to the power of nurturing professional relationships over time.

Craig and Lynnette had both previously worked at Sweeney Conrad, the firm that would eventually acquire their practice. Despite moving on to start their own boutique firm, they maintained good relationships with their former colleagues. As Craig explained, “Throughout our careers, they actually became a source of clients for us because they didn’t have a CAS department. We just made sure to keep good relations with everybody and not burn bridges.”

This relationship maintenance paid off. When Craig was exploring options for the future of their firm, he reached out to his contacts at Sweeney Conrad. He learned that a director at the firm was retiring. Seeing an opportunity, Craig boldly proposed himself as a replacement.

Craig recalled, “I said, ‘Let me throw my name in the hat.'” This moment, born from years of relationship building, set the wheels in motion for the acquisition. Their existing reputation and relationships made the process smoother, as Craig already knew about three-quarters of the partners at the firm.

Communication: The Linchpin of Successful Transitions

Once the deal is struck, the real work begins. For the Connells, this meant navigating a complex transition during the busiest time of the year for accountants. Their experience underscores a crucial lesson: in times of change, there’s no such thing as overcommunication.

The timing of their transition was far from ideal. Lynnette recalled, “Craig started December 1st, 2022. I and our two employees started in January 2023, which in a CAS practice is throwing everybody into busy season—1099s.” This timing created additional stress and challenges for everyone involved.

Adding to the complexity, they had to manage parallel systems temporarily. As Lynnette explained, “We were operating parallel using different systems because they’re using a lot of tax software.” This meant juggling different workflows and technologies while ensuring client needs were met seamlessly.

In the face of these challenges, the Connells’ strategy was clear: communicate. They were transparent with their clients about the changes, explaining the benefits and addressing concerns proactively. This meant frequent check-ins, detailed explanations of new processes, and patiently guiding clients through necessary administrative changes like updating QuickBooks subscriptions.

They also prioritized clear communication with their staff, ensuring everyone understood their roles in the new structure and felt supported through the change. As Craig noted, “It was a testament to my employees, Lynnette, and our intentional relationship building with clients, and the high level of communication we had during the transition.”

This approach paid off—they retained all but one client in the first year. The lesson? Clear, frequent, and honest communication can be the difference between a smooth transition and a chaotic one. It helps manage expectations, allay fears, and build trust during uncertainty.

But communication alone isn’t enough. Successfully navigating a firm transition also requires addressing the emotional aspects of change for both clients and staff.

Addressing the Human Element: Emotions and Cultural Fit

While the numbers may drive the deal, it’s the human element that determines its success. The Connells’ experience highlights the critical importance of addressing emotions and ensuring cultural fit throughout the transition process.

For clients, a firm transition can be unsettling. They’ve built relationships with their accountants, trusting them with sensitive financial information. The prospect of change can trigger anxiety and uncertainty.

Staff face emotional challenges during transitions. The Connells supported their team by being transparent, addressing concerns promptly, and ensuring staff understood their roles in the new structure. This approach helped maintain team morale and productivity during a potentially turbulent time.

Lynnette offered advice: “Don’t take a deal out of fear. Be true to what’s best for you.”

This advice underscores the importance of finding the right cultural fit when choosing a buyer. While financial considerations are important, they shouldn’t be the only factor. Craig emphasized the need for autonomy and alignment of vision. He ensured the freedom to implement new technologies and processes, maintaining the innovative spirit of their boutique firm within a larger organization.

Craig stressed, “You don’t have to do it all yourself. You shouldn’t do it all by yourself. You should have partners in this conversation.”

By addressing the emotional aspects of the transition and ensuring a good cultural fit, the Connells were able to navigate the challenges successfully. Their story serves as a reminder that in the world of accounting, it’s not just about the numbers—it’s about the people behind them.

The Human Touch: Key to Successful Firm Transitions

The Connells’ journey from boutique firm owners to larger regional player offers valuable lessons for accounting professionals contemplating similar transitions. Their story underscores that successful firm transitions hinge on the human element.

Throughout their experience, three key themes emerged:

  1. The power of relationships in finding the right buyer and facilitating a smooth transition
  2. The critical role of clear, frequent communication in managing change
  3. The importance of addressing emotional aspects and ensuring cultural fit

Despite challenges like transitioning during busy season and managing parallel systems, their human-centric approach led to success. They retained all but one client and achieved 150% revenue growth post-acquisition.

These lessons have broader implications for the accounting industry. As consolidation continues to reshape the landscape, firms of all sizes must recognize that mergers and acquisitions are not just financial transactions—they’re complex human processes that require careful navigation.

For small firm owners, their experience offers hope and a roadmap. It shows that with the right approach, you can transition your practice while preserving the relationships and values you’ve built. For larger firms, it highlights the importance of considering the human element in integration strategies.

Ultimately, their story reminds us that accounting is a people business. Numbers are our tools, but relationships are our foundation. As you contemplate your firm’s future, remember: the key to a successful transition lies in the human connections you nurture along the way.

Want to dive deeper into Craig and Lynnette’s journey and gain more practical insights on navigating accounting firm transitions? Listen to the full Earmark Podcast episode here.