RKG
← Back to Portfolio
06
Data / AI · Founders

QuickBooks into a dashboard the business can actually use

Turned QuickBooks Online data into cash, margin, and trend views so owners and accountants stopped rebuilding the same spreadsheets.

Business version

For founders: see your QuickBooks numbers without hiring an analyst

Before. Cash and margin lived in QuickBooks exports and a spreadsheet someone rebuilt every month.

After. A dashboard on the same QuickBooks data, in plain language, that an owner or accountant can open without a data team.

If your books are in QuickBooks and you cannot answer how the business is doing without a spreadsheet, this is the engagement.

The problem

The numbers that run the business lived in QuickBooks. Owners and accountants could not see cash, margins, or trends without exporting and rebuilding spreadsheets.

The role and approach

Synced QuickBooks into an analytics store so historical questions stayed fast and cheap. The screens speak in cash, margins, and trends, not accounting object names. The same clean layer can host anomaly flags and short written summaries later.

The outcome

Non-technical stakeholders could read performance from the system they already trusted, with less manual reporting.

Hard decisions

  • 01Columnar store and an embedded engine so history stayed cheap to query.
  • 02Business language on the surface — cash, margins, trends — accounting objects stay in the pipeline.
  • 03AI features deferred until the data layer was clean, so summaries would not invent numbers.

Lesson for future clients

Same build, two buyers. A CTO hears analytics layer over QuickBooks. A founder hears see your numbers without an analyst. Lead with the second when the buyer is not technical.

QBO
System of record
No analyst
Required to read it
AI-ready
Clean data layer
QuickBooks APIDuckDBParquetNode.js