Accountants Law Podā„¢

The Side Spreadsheet Trap

29 min Ā· 11 jun 2026
aflevering The Side Spreadsheet Trap artwork

Beschrijving

Why do law firms still rely on side spreadsheets? In this episode, Lynda Artesani, Sarah Prevost, and Steven Libhart dig into the real reasons attorneys lean on manual spreadsheets for trust accounting, compensation tracking, and client costs, and what can go wrong when those spreadsheets are riddled with broken formulas, missing data, and no audit trail. The team also gets into data migrations gone wrong, the power of Google Sheets over Excel, MyFirmData as a reporting game-changer, and why asking the right questions at onboarding can save you weeks of cleanup work. 00:52 Why Spreadsheets Persist 02:15 Common Spreadsheet Uses 04:06 Empathy and Client Habits 09:44 Audit Trails and Google Sheets 12:40 When Spreadsheets Help 13:42 Parsing Costs and MyFirmData 17:06 Setup Data and Migration Risks 22:35 Banks Security and Vulnerabilities 25:37 Grid Paper Throwback 26:36 AI Restaurant Story šŸ”” Subscribe for weekly episodes covering law firm bookkeeping, legal tech, and accounting practice tips. šŸ“© Have a question or topic idea? Email us at info@accountantslawpod.com [info@accountantslawpod.com] šŸ§‘ā€šŸ’¼ Join the Accountants Law Lab Mastermind: accountantslawlab.com 🌐 Visit us at accountantslawpod.com Have a spreadsheet story of your own? Drop it in the comments. We would love to hear it. Accountants Law Pod is hosted by Lynda Artesani, Sarah Prevost, and Steve Libhart and directed/produced by Teaira Burge and The Proper Trust. Music by ComaStudio from Pixabay - Edited by audiovideo_uk Disclaimer: The content presented in this podcast is for informational purposes only and should not be considered as legal, financial, or professional advice.

Reacties

0

Wees de eerste die een reactie plaatst

Meld je nu aan en word lid van de Accountants Law Podā„¢ community!

Probeer gratis

Probeer 14 dagen gratis

€ 9,99 / maand na proefperiode. Ā· Elk moment opzegbaar.

  • Podcasts die je alleen op Podimo hoort
  • 20 uur luisterboeken / maand
  • Gratis podcasts

Alle afleveringen

162 afleveringen

aflevering Advisory Services 101 artwork

Advisory Services 101

Advisory services are no longer optional for accountants and bookkeepers. They are the future of the profession. In this episode, Sarah Prevost and Steven Libhart dig into what it really means to be a trusted financial partner to your law firm clients in the age of AI. From beverage machines that diagnose themselves to bank transitions handled with a single phone call to a senior vice president, the conversation covers what AI can and cannot do, why human relationships and institutional knowledge are irreplaceable, and how bookkeepers and accountants can step confidently into the advisory role without being overwhelmed. Practical, honest, and genuinely fun, this one is for every accountant who has ever wondered what being a trusted advisor actually looks like in practice. 05:17 Advisory Services 101 06:55 Follow Up and Add Value 08:26 Apps and Adoption Pitfalls 11:34 KPIs Need Human Coaching 15:13 Be Included in Decisions 17:12 Bank Switch Success Story 20:53 Guiding Firm Transitions 25:22 Tool Risks and Confidentiality 28:32 Practical Steps for Advisors šŸ”” Subscribe for weekly episodes covering law firm bookkeeping, legal tech, and accounting practice tips. šŸ“© Have a question or topic idea? Email us at info@accountantslawpod.com [info@accountantslawpod.com] šŸ§‘ā€šŸ’¼ Join the Accountants Law Lab Mastermind: accountantslawlab.com 🌐 Visit us at accountantslawpod.com What does being a trusted advisor look like in your practice? Drop it in the comments! Accountants Law Pod is hosted by Lynda Artesani, Sarah Prevost, and Steve Libhart and directed/produced by Teaira Burge and The Proper Trust. Music by ComaStudio from Pixabay - Edited by audiovideo_uk Disclaimer: The content presented in this podcast is for informational purposes only and should not be considered as legal, financial, or professional advice. The stories we share from the field are meant to educate, never to shame. We have deep respect for attorneys and the complexity of running a firm, and we recognize that many of the mistakes we discuss happen simply because no one ever explained the rules.

2 jul 202631 min
aflevering If You Hate Numbers, That’s Exactly Why You Need Them artwork

If You Hate Numbers, That’s Exactly Why You Need Them

If you hate numbers, this episode is exactly for you. Sarah Prevost and Steven Libhart make the case that the attorneys and firm owners who avoid their financial reports are the ones who end up in the biggest messes, and that understanding your numbers does not require loving them. The conversation covers KPIs, AI as a financial tool and its very real limitations, partner compensation planning, labor costs, and why your firm administrator is probably making you more money than you realize. 00:31 Why Numbers Matter 01:45 Entrepreneur Mindset Shift 02:28 AI Needs Context 05:14 Garbage In Garbage Out 07:39 KPI Case Study 10:04 Finding the Real Issues 12:55 Hidden Admin Money Leaks Accountants Law Pod is hosted by Lynda Artesani, Sarah Prevost, and Steve Libhart and directed/produced by Teaira Burge and The Proper Trust. Music by ComaStudio from Pixabay - Edited by audiovideo_uk Disclaimer: The content presented in this podcast is for informational purposes only and should not be considered as legal, financial, or professional advice.

25 jun 202621 min
aflevering Evergreen Retainer Tips artwork

Evergreen Retainer Tips

Evergreen retainers are one of the most powerful tools a law firm can use to protect cash flow and reduce accounts receivable headaches — but only when they are set up and monitored correctly. In this episode, Sarah Prevost and Steven Libhart break down exactly what evergreen retainers are, how they work, and the nuances that attorneys, bookkeepers, and accountants need to understand before putting them in place. From engagement letter requirements and bar rules to dispute management, milestone billing, and the tickler system trick. If you work with law firm clients or are an attorney managing your own billing, this one is worth a listen. 00:39 Episode Topic Evergreen Retainers 01:30 Why Evergreens Help Cashflow 04:00 Definition and Simple Example 06:07 Tracking and Tickler Systems 06:49 Client Communication and Budgets 08:46 Disputes and Reconciliation Risks 11:11 Complex Cases and Outside Costs 13:44 Tools Payments and Transparency 15:31 Wrap Up and Call to Action šŸ”” Subscribe for weekly episodes covering law firm bookkeeping, legal tech, and accounting practice tips. šŸ“© Have a question or topic idea? Email us at info@accountantslawpod.com [info@accountantslawpod.com] šŸ§‘ā€šŸ’¼ Join the Accountants Law Lab Mastermind: accountantslawlab.com 🌐 Visit us at accountantslawpod.com Accountants Law Pod is hosted by Lynda Artesani, Sarah Prevost, and Steve Libhart and directed/produced by Teaira Burge and The Proper Trust. Music by ComaStudio from Pixabay - Edited by audiovideo_uk Disclaimer: The content presented in this podcast is for informational purposes only and should not be considered as legal, financial, or professional advice.

18 jun 202616 min
aflevering The Side Spreadsheet Trap artwork

The Side Spreadsheet Trap

Why do law firms still rely on side spreadsheets? In this episode, Lynda Artesani, Sarah Prevost, and Steven Libhart dig into the real reasons attorneys lean on manual spreadsheets for trust accounting, compensation tracking, and client costs, and what can go wrong when those spreadsheets are riddled with broken formulas, missing data, and no audit trail. The team also gets into data migrations gone wrong, the power of Google Sheets over Excel, MyFirmData as a reporting game-changer, and why asking the right questions at onboarding can save you weeks of cleanup work. 00:52 Why Spreadsheets Persist 02:15 Common Spreadsheet Uses 04:06 Empathy and Client Habits 09:44 Audit Trails and Google Sheets 12:40 When Spreadsheets Help 13:42 Parsing Costs and MyFirmData 17:06 Setup Data and Migration Risks 22:35 Banks Security and Vulnerabilities 25:37 Grid Paper Throwback 26:36 AI Restaurant Story šŸ”” Subscribe for weekly episodes covering law firm bookkeeping, legal tech, and accounting practice tips. šŸ“© Have a question or topic idea? Email us at info@accountantslawpod.com [info@accountantslawpod.com] šŸ§‘ā€šŸ’¼ Join the Accountants Law Lab Mastermind: accountantslawlab.com 🌐 Visit us at accountantslawpod.com Have a spreadsheet story of your own? Drop it in the comments. We would love to hear it. Accountants Law Pod is hosted by Lynda Artesani, Sarah Prevost, and Steve Libhart and directed/produced by Teaira Burge and The Proper Trust. Music by ComaStudio from Pixabay - Edited by audiovideo_uk Disclaimer: The content presented in this podcast is for informational purposes only and should not be considered as legal, financial, or professional advice.

11 jun 202629 min
aflevering It’s Mid-Year: Where Is Your Business? artwork

It’s Mid-Year: Where Is Your Business?

It's our three-year anniversary and we're kicking off Season 4! In this episode, Lynda, Sarah, and Steve celebrate the milestone and dive into one of the most important things every law firm and accounting practice should be doing right now: the mid-year business review. From checking payroll and 1099s to evaluating your tech stack, forecasting cash flow, and setting financial priorities for the second half of the year, this conversation is packed with practical, timely advice. Plus the team gets into AI, the new QuickBooks interface, and why the human touch still matters more than ever. 00:00 Podcast Anniversary Shoutout 00:35 Meet the Producer Teaira 01:22 Season Four Milestones 03:06 Midyear Review Kickoff 03:42 Client Check-Ins and Cleanup 05:38 Payroll and Tax Estimates 06:15 Software Costs and Tool Audit 07:47 AI Hype and Human Touch 11:28 AI Pitfalls and Verification 17:40 Planning Priorities and Vision 20:07 Hiring Interns and Apprentices 21:10 Cash Flow and Economic Risks 22:46 AR Review and Key Takeaways 23:42 Subscribe and Community Links šŸ”” Subscribe for weekly episodes covering law firm bookkeeping, legal tech, and accounting practice tips. šŸ“© Have a question or topic idea? Email us at info@accountantslawpod.com [info@accountantslawpod.com] šŸ§‘ā€šŸ’¼ Join the Accountants Law Lab Mastermind: accountantslawlab.com 🌐 Visit us at accountantslawpod.com Accountants Law Pod is hosted by Lynda Artesani, Sarah Prevost, and Steve Libhart and directed/produced by Teaira Burge and The Proper Trust. Music by ComaStudio from Pixabay - Edited by audiovideo_uk Disclaimer: The content presented in this podcast is for informational purposes only and should not be considered as legal, financial, or professional advice.

4 jun 202624 min