Analytics
Analysis on the live ledger, not a copy of last month's export.
Trends, mix, margin and movement read directly from posted data. Filter by any dimension, then drill through to the journal line that created the figure.
- Category
- Data
- Status
- Available
- Depends on
- 2
- Connectors
- 10
What it does
Analytics, in practice
The parts that matter day to day, not a feature matrix.
Contribution
€430,000
Illustrative product screen — sample data, not a measured result.
Works with
Analytics needs the ledger underneath it
Modules write through one engine, so what this one needs is a dependency rather than an integration project.
Required
Accounting
A general ledger that drills back to the document behind every number.
AvailableRequired
Reporting
Statements that tie back, every time, without a reconciliation ritual.
Available
Often switched on together
- AvailableExplore
Accounting
A general ledger that drills back to the document behind every number.
- AvailableExplore
Reporting
Statements that tie back, every time, without a reconciliation ritual.
- AvailableExplore
Dashboards
The few numbers you check first, in one place.
- In developmentExplore
KPIs
Measures defined once, so nobody argues about the denominator.
Industries
Where this does the most work
Problems it removes
What people come to us with
Connects to
Connect what you already use
Connector status is stated honestly. Only file import and export are live today; the rest are planned or built on request.
- AvailableExplore
Spreadsheet import & export
CSV and Excel in and out, everywhere. Live today.
- PlannedExplore
Power BI
Report on G1 data in the tool your team knows.
- PlannedExplore
Looker Studio
Lightweight reporting on the same definitions.
- PlannedExplore
Google BigQuery
Push G1 data into the warehouse you already run.
- On requestExplore
SAP
Read from SAP and add the layers it does not give you.
- On requestExplore
Oracle NetSuite
Connect NetSuite as a source, not a rival.
- On requestExplore
Microsoft Dynamics 365
Bridge Dynamics into a single group view.
- PlannedExplore
Odoo
Connect an Odoo estate without replacing it.
- PlannedExplore
Snowflake
G1 as a governed source in your data platform.
- PlannedExplore
REST API
A documented way in and out for anything else.
The layer on top
What G1 notices in this data
Analysis reads the same records the ledger writes, under the same permissions.
Agents that read it
Example observations
Gross margin has drifted for four periods
trendGross margin has fallen in each of the last four months, from 34.0% to 31.6%. Volume and mix are close to plan, so this is price and input cost rather than demand. One product line accounts for most of the movement.
Revenue is growing, but the mix is moving to lower margin
trendRevenue is up 9% year on year. Within that, the lower-margin category has grown 31% and the higher-margin one has fallen 4%. On current mix, gross profit grows by 2% rather than 9%.
Scenarios
Where this module changes the day
Illustrative situations, not clients. There are no measured results here because there is nothing to measure yet.
- Illustrative scenarioExplore
A professional services firm
Knowing project margin while the project is still open
Time sits in one system, expenses in another, subcontractor invoices in the accounts, and the fee schedule in the contract. Project margin is calculated quarterly by hand. Work in progress is an estimate. Partners find out that an engagement went wrong when it is too late to renegotiate.
- Illustrative scenarioExplore
A distribution business
Five systems, one customer, no agreement
Orders come from a web store and a sales team, stock is managed in a warehouse system, invoicing happens in the accounts package and credit control runs on a spreadsheet. Every week someone exports and re-keys. Customer names differ across systems, so credit exposure is a manual exercise and margin by customer is an estimate.
- Illustrative scenarioExplore
A specialist retail chain
Thirty-four stores reconciled before opening
Three card providers settle in batches on different days, net of fees. The till system exports takings in one format, the bank statement arrives in another, and someone matches them by eye. Differences are written off as timing until the month is closed, at which point nobody can say which store they came from.
- Illustrative scenarioExplore
A subscription software business
Revenue that ties to the contract and to the cash
Contracts are signed in one system, invoiced from another and recognised in a spreadsheet that releases deferred revenue monthly. Annual prepayments make cash look better than trading. Renewals are tracked by whoever remembers, and the figures in the board pack are rebuilt each quarter from three exports that never quite reconcile.
Data
Analytics is running today. See it on your own numbers.
We will walk through it with your chart of accounts and your documents, not a demo company.