blog + practical missions
Field Notes
Short, useful, finance-friendly analytics lessons with a little personality
The blog is PANDAUDIT’s field notebook: quick lessons, mini-challenges, and workflow stories for people across finance — accounting, audit, FP&A, operations, billing, revenue, treasury, and anyone else wrestling with business data. The analytics fundamentals are still here; now they share the notebook with the AI era — skills, agents, and knowledge bases, always in finance language.
Blog missions
Spreadsheet Rescue
Take one recurring workbook headache and turn it into a cleaner route.
Exception Hunt
Find the rows that actually need review instead of staring at all of them.
Control Total Checkpoint
Prove the workflow ties back before trusting the output.
Agent Delegation
Hand a documented skill to an AI agent, then review its work with control totals.
Start with the Analytics Map, grab a skill from the Skills Library, or jump into the latest field notes below.
-
For years, this site shared Python scripts you could copy into your own finance work: clean the export, match the files, flag the duplicates, tie the totals. [Read More]
-
What an AI Knowledge Base Means for Accountants
Your mapping tables and policy memos are about to become your most valuable files
Every finance team already has a knowledge base. It’s just scattered: classification rules in someone’s head, the close checklist in a workbook nobody else opens, the fiscal-calendar logic rebuilt in every file. [Read More] -
Build a Finance Knowledge Vault (the Obsidian Way)
Why one folder of markdown files beats every knowledge tool you've abandoned
Every finance team has tried a knowledge tool — the wiki nobody updates, the SharePoint nobody can find anything in, the OneNote from three reorgs ago. The tools failed for the same reason: the knowledge was locked in someone else’s format, somewhere off to the side of the actual work. [Read More] -
When a Spreadsheet Task Deserves an Analytics Workflow
A simple test for deciding what to standardize
Not every spreadsheet needs to become a formal workflow. Some tasks are one-time analyses. Others repeat often enough that they deserve structure. [Read More] -
A Better Reconciliation Workflow Starts With Exception Buckets
Matched, source-only, target-only, and review-needed
A reconciliation should not just tell you whether two totals agree. It should tell you what needs review. [Read More] -
Before the Dashboard: The Finance Data Cleanup Checklist
Most analytics problems start before the chart
A dashboard is only as useful as the data behind it. Before building reports, finance teams should run a short cleanup checklist. [Read More]