Not Every PM Tool Can Do Your Books

The Insight

Once Asana won the project-management decision, the next question showed up on its own: why keep a second tool running instead of folding everything into the one that already won. Fewer tools, one source of truth, less to keep straight in my own head. I almost defaulted to that.

So I checked. No native cross-task formulas, no rollups — no way to say “sum every actual expense tied to this budget line” and have the number update itself when a new expense lands. Monday.com has formula columns; Asana doesn’t. A tool built to track who’s doing what and by when was never built to answer what something actually cost.

The Fix

Airtable took the finance side instead, and the split held up under real weight, not just a hunch. I built a Trifold model inside it: a General Ledger that’s 100% history, never touched by a forecast, the only thing a CPA sees at year-end. An Income Statement that blends past months with forecasted ones, to hold the business accountable to a 1–3 month target. A Cash Flow Statement built as a scenario matrix, so “$0 revenue” and “aggressive growth” can both run through the model without touching a single real transaction — the matrix runs seventeen months out, so both scenarios get pressure-tested well before either one actually happens.

The rollups are doing real work, not just organizing rows. Every field that performs math says so in its own name — Actual Expenses Rollup, Transactions Relation — so a glance at the column says whether it’s holding two tables together or computing a number. Owner Contribution and Owner Draw are deliberately unlinked from the P&L rollups, so pulling money out of the business never quietly inflates what the business actually earned — the first real contribution, a $1,000 transfer, sits in the ledger without ever touching that number.

None of that runs inside Asana. It was never going to — Asana was built to track work getting done, not to compute what it cost.

The Hard Truth

Running two tools isn’t the cost people think it is. The real cost is picking a tool without checking what it can actually do. Since I wrote this, I’ve moved my tasks over too — not because fewer logins wins, but because the tool that could do the math turned out to be the tool that could do the rest of it too.