Budget to actual reporting for QuickBooks Online, and everything a controller checks around it.
Eight pieces working on top of the QuickBooks company file you already have. No migration, no new chart of accounts, no second login, and DrillFi only reads from QuickBooks.
Custom GL mapping that reconciles itself every close.
Most budgets use categories a board understands: trade spend, logistics, marketing. QuickBooks books into GL accounts that rarely match them one to one. Setup is where you draw that line once.
Bring the budget you already have
Upload your spreadsheet, build it from your QuickBooks accounts, or fill in a template. A guided setup maps it to your GL accounts once, with nothing to re-upload when QuickBooks changes.
Many accounts, one line
Map many GL accounts to one budget category. Each account rolls into exactly one line, so nothing is counted twice.
Re-map any time
Re-mapping an account doesn't need a resync from scratch. The change applies going forward and DrillFi re-derives history where it can.
Three comparisons
Budget, forecast or last year, side by side at every level. Switch on the full-year budget and Budget left to see what remains of the year next to year to date, in the dashboard, the Excel export and the monthly package.
Nothing added to QuickBooks
It works on your existing chart of accounts and only reads from QuickBooks, so there is nothing to clean up if you disconnect.
From a board line item to the invoice, without opening QuickBooks.
Every number on the P&L is connected, live, to the accounting under it. To find out what moved a line, you click the line instead of exporting a GL report.
Budget, actual and last year at every level
Each level shows all three side by side, not just the bottom line.
Filter by class or location
Slice any level without rebuilding the report.
Every alert links to its evidence
A flag is one click from the exact row that triggered it.
One source, many views
The same data powers the dashboard, the KPI engine, the monthly package and the Excel export.
Fifteen automated checks that run every time your books sync.
No dashboard to remember to check and no monthly audit to schedule. Every sync runs your enabled checks and shows the results on the account they touch.
Set per company
Thresholds and account lists are configured per company. A few checks, such as capitalization threshold, personal expense keywords and suspense accounts, start off until you tell DrillFi which accounts or vendors to watch.
Close checklist
Optional sign-off turns the list into a checklist you can work through. How sign-off works.
Explain the variances that matter, and skip the rest.
Budget vs. actual shows where you missed a plan. Flux analysis asks whether each group behaved the way the earlier months said it would, and lists only the groups that did not.
Groups you control
Every budget line starts as its own group. Combine lines that behave alike, or pull one GL account out of a line to give it its own expectation.
Choose the expectation
The average of recent months, last month, the same month last year, the budget, or a rate times a driver: net revenue, units sold, another line, or a driver you keep yourself, like headcount.
Set the threshold once
A group is listed when it is off by at least a percent of its expected amount and at least a dollar amount.
Drill to the cause
Open a flagged group to see which vendors and GL accounts changed, then go to the transactions.
Notes that reopen
Write what happened next to the number. If a later sync changes the difference, the item opens again with your earlier note attached.
An Excel workpaper
Download the month with the differences and subtotals as live formulas.
Turn the lists into a close checklist.
Alerts and flux items only help if someone looks at them. Sign-off gives each one a status and a note, so the team can see what has been reviewed and what has not.
Reviewed, or not an issue
Mark an alert reviewed or dismiss it. In flux analysis, mark a group Explained or Not an issue. Each takes a note: what happened, in your words.
Who and when
DrillFi records who signed it off and when.
Reopens when the number changes
If a later sync finds the same item at a different amount, it opens again with your earlier note attached, so a note never sits under a number it no longer fits.
On or off
Sign-off for alerts is optional and set per company. Flux analysis always has it.
In the package
The monthly package's last page shows how many items are still open, marks the reviewed ones, and leaves out the dismissed ones.
Build the metric your board actually asks for.
Most tools hand you the accounts QuickBooks already has. The KPI builder combines them into the number your board tracks, and twelve working-capital KPIs come built in.
Left-to-right formulas
Terms read in order, with no hidden operator precedence to reverse-engineer.
Reach anything
Any P&L line, GL account or unit-sales figure, over any time window.
Filter by class or location
The same dimensions your GL already carries.
Dollars, percent or per unit
Track a KPI against a quantity like units sold. The format follows your formula.
Live preview, ready-made starts
See the result while you build, or start from gross margin %, marketing % of revenue or revenue per unit.
Budget and last year underneath
Every KPI shows both, on the dashboard and in the monthly package.
Number, chart or full calculation
DSO, DPO, cash conversion cycle and inventory turnover work the same way, with every input visible.
The rest of the financial picture, from the same synced data.
The P&L is only part of a close. DrillFi builds the other statements from the same QuickBooks sync, so nothing has to be reconciled across separate tools.
Balance sheet
By month, from your synced QuickBooks history.
Statement of cash flows
Indirect method, computed from month-end balance sheets. Reclassify any account between Operating, Investing and Financing, and the choice is saved for that company.
AR and AP aging
With totals, alongside payment-timing checks for slow-paying customers and early-paid vendors.
Item sales
Top items by revenue with units and revenue per unit, plus an all-other line so the table always foots to the total.
A board-ready package with your name on it, generated each period.
Not a screenshot of a dashboard. A PDF built from the same mapped data, with your firm's name, logo and color, that you can hand to a client or a board as-is.
You choose the sections
One or several P&L views (for example L1 vs budget and L2 vs last year), balance sheet, cash flow, KPIs, subledgers, saved reports, and items needing attention.
KPIs as you built them
Printed as the number, chart or calculation, sized the way you laid them out.
Your brand, set once per client
Accent color, firm name and logo, so every deliverable carries your brand, not ours.
Open issues go last
As a summary by type or with the individual transactions. With sign-off on, the page shows how many are still open and leaves out the dismissed ones.
Excel with live formulas
Summary and detail tabs, with the detail linked back to the summary. Variances and subtotals are real formulas, so the sheet still recalculates.
See it before you connect anything.
The live demo runs on a fictional sample company: drill to the invoice, open the alerts, walk through a flux example, check the KPIs. When you're ready to see your own file, create a free account, or apply for partner access if you serve multiple clients.