Your P&L Skill Just Got a Full Dashboard — No More Building Reports By Hand (Patreon)

You can now turn a raw transaction list into a fully interactive financial dashboard with one skill, no VBA required.

If you've ever had to rebuild your profit and loss every single month, you know the drill — pull the numbers, format the columns, fix the totals, compare it to last month by hand, and pray you didn't fat-finger a formula along the way. That's the exact grind this update kills. What used to be a static P&L with one date range is now something you can point at any month, quarter, year, or fully custom range and get an instant, accurate comparison against any other period.

The biggest addition is a brand-new dashboard sheet that pulls in KPIs like net profit, net margin, and a trend line for net operating income, so you can see the health of the business at a glance instead of digging through rows. I've also built in a dynamic date range selector with custom "from" and "to" fields for both your current period and your comparison period, along with automatic amount and percentage change calculations between the two — so comparing this month to last month, or this year to last year, takes seconds instead of a spreadsheet rebuild. On top of that, there's a click-to-navigate menu linking every sheet together, real Excel tables on the source data with built-in filtering, and a redesigned drill-down that shows you exactly which transactions are in or out of your selected range, complete with notes and flagged items — like duplicate invoices or expenses that cross a threshold you set, such as a $2,500 capital asset line. And all of it, dashboard included, still runs on a plain XLSX file with zero macros.

Go grab the updated skill file and the expanded sample transaction set below and rebuild your P&L with the new version — you'll see the dashboard and drill-down changes the moment you open it.

This is exactly what your membership is built for — I go back into the tools you already use, make them sharper, and hand you the upgrade at no extra cost.

📥Your updated skill, the new sample data, and the full walkthrough are waiting for you below.