New KPMG Agentic ERP, now available with KPMG in 140+ countries Read the announcement

Google Sheets

Spreadsheets, without the exports

The Google Sheets plugin pulls live ledger data straight into your spreadsheet. Build the analysis your way, refresh with one click, and never email a stale export again.

The world's most demanding finance teams run on Light.

Adaptyv Bio All Gravy BeZero Carbon Biofire Casavo causaLens ComplyAdvantage ControlPlane deepset Ellidore Flowbox fonio.ai Formalize Fuse Energy GetWhy HICX KeyShot Legora Lovable Noda Officeguru Omnea Omnio Oper Paebbl pawaPay Pentimenti Perlego SEON Smarkets Stravito Superb Taktile Tandem Health Tillo Wawa Fertility WeDoBooks Xaver
  1. 01

    Live ledger data

    Balances, transactions, and report lines flow into Sheets directly from Light — always the current numbers, never last Tuesday's CSV.

  2. 02

    Any entity, any book

    Query across entities, currencies, and books in one sheet — consolidation-grade data in the tool your team already models in.

  3. 03

    One-click refresh

    Reopen the model, hit refresh, and every figure updates from the ledger — board packs and budget models stay current.

Your models, powered by the ledger

Finance teams live in spreadsheets. Light makes sure the spreadsheet isn't lying.

Report once, reuse forever

Point a sheet at any Light report — P&L by entity, spend by vendor, AR aging — and it becomes a living model. Layer your own formulas, charts, and scenarios on top; the source data stays wired to the ledger.

Safe by design

The plugin reads through Light's permission model, so analysts see exactly what their role allows — and nothing leaves the ledger unaudited.

Prefer Excel? The same live data is available through Light's reporting API.

Unify your
financial data

The Google Sheets plugin is amplified by the Light platform. Experience the agentic ERP.

100x faster

A powerhouse for processing data. Up to 100x faster than NetSuite.

Automated

Slash 80% of manual finance tasks.

Integrated ledger

Single source of truth for all your global finance data.

AI native

Let Light streamline finance and deliver effortless insights.

Real-time reporting

Quickly build any report, iterate on it together, and engage everyone.

Advanced auditing

Track every interaction, every document, every detail all in one place.