July 2026
Intermediate
372 pages
8h 35m
English
Overview
Learn how accountants and finance teams can use AI tools in the real world with practical cases that reduce manual accounting and finance processes, improve reporting accuracy, and build AI-augmented workflows in Excel and Power BI
Key Features
- Automate accounting workflows with AI-powered Excel techniques
- Build Power BI reporting, reconciliation, and validation workflows
- Apply repeatable AI frameworks for safer, audit-ready finance work
- Free with your book: DRM-free PDF version + access to Packt’s next-gen Reader*
Book Description
Finance teams need faster reporting and sharper insight without compromising accuracy, control, or trust. AI-Powered Accounting with Excel and Power BI shows accountants and finance professionals how to apply generative AI to real-world accounting workflows while keeping human judgment at the center.
Drawing on Lance Rubin’s experience as a CFO, financial modeling specialist, and founder of Model Citizn, this book uses tools such as the HACK Framework and Six Pillars to help you structure data, evaluate AI tools, write reliable prompts, and verify outputs. Ten practical modules cover Excel formulas, PDF extraction, reconciliation, financial controls, management accounting, account mapping, workbook restructuring, audit-ready validation, and dashboards in Excel and Power BI.
This book will help you build AI-assisted accounting and financial reporting workflows, turn recurring tasks into reusable Skills, and identify hallucinations before they affect decisions. By the end, you’ll have a practical roadmap for safer finance automation and the confidence to know when to trust AI and when to step in.
*Email sign-up and proof of purchase required
What you will learn
- Extract and structure finance data from PDFs using AI
- Build AI-assisted reconciliation and control workflows
- Automate financial reporting with Excel, Power BI, and AI
- Restructure complex workbooks into reliable data models
- Create validation and audit-ready accounting processes
- Evaluate AI tools for finance and accounting tasks
- Build reusable prompt libraries for recurring workflows
- Apply governance and privacy practices when using AI in finance
Who this book is for
This book is for accountants, finance analysts, management accountants, FP and A professionals, controllers, CFOs, audit professionals, finance transformation teams, practice partners, and finance educators, including candidates working toward CA, CPA, ACCA, or AICPA qualifications. It suits professionals who use Excel and financial reporting and want practical AI automation for reconciliation, controls, validation, and Power BI. Basic Excel knowledge is recommended; prior AI experience is not required.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.