Security / The pipeline
The pipeline in detail
This is the technical companion to the plain overview. It covers how a number gets from your accounting system to a tile on the dashboard, and why the same inputs always produce the same figure.
The numbers move one way
Your raw accounting data is copied in untouched. From there it passes through fixed steps: the raw copy is cleaned and typed, then aggregated into the figures the dashboard shows. Each step is plain SQL. Data only ever moves forward through these steps, never back, so a later step cannot reach in and alter the raw record.
No model sits in the calculation path.
Every figure on the dashboard is produced by fixed SQL, not written by an AI. Given the same inputs, the pipeline produces the same outputs every time. There is no model deciding what a number should be, so there is nothing to drift, hallucinate, or vary between runs.
Every figure traces back to its source.
Because each step is inspectable SQL over data you can see, any number on the dashboard can be followed back through the aggregation, to the cleaned record, to the original raw entry from your accounting system. Nothing on the dashboard is a figure you cannot account for.
The raw copy is never modified.
Cleaning and typing happen in a separate layer. The raw copy of your accounting data stays as it arrived, so if a cleaned figure ever looks wrong the original is always there to compare against.
Partial months are excluded by default.
Books are not closed in real time. The current month, and often the month before it, are still incomplete. A month with costs booked but revenue not yet recorded would make a healthy business look like it fell off a cliff. So the dashboard holds back unclosed months and only releases a month once it is confirmed closed.
The dashboard stands on its own.
The figures are computed and cached ahead of time. The dashboard serves those cached numbers and does not call the AI to render a page. It works whether or not anyone ever connects the AI analyst.
Related: how the AI analyst reads these finished numbers without being able to change them, and how revenue is reconciled against your accounting system's own report.