Financial datasets from NetSuite and QuickBooks Online

By PipeLedger · Published September 17, 2026 · Updated September 19, 2026

The data is yours. PipeLedger extracts it, reconstructs the ledger, applies your account classifications and business dimensions, checks it, and publishes it after approval. The same datasets serve AI agents through the MCP server, automation through the REST API and the CLI, and BI tools.

Core datasets

Every organization starts with these three, prepared from your ERP. Together they hold the activity, the balances, and the account structure behind the financial statements.

Core datasets
Dataset	What it contains	Use it to answer
General Ledger Lines `gl_lines`	Accounting lines, normally debits and credits, with their account, business segments, customer or vendor, and source reference.	What made up this figure? Which transactions moved this account?
Trial Balance `trial_balance`	Account balances by reporting period.	What was the position at a date? Does the Balance Sheet tie to the ledger?
Chart of Accounts `chart_of_accounts`	Accounts with their native names and numbers, and how each is classified for reporting.	How is this account treated in the statements?

General Ledger Lines holds activity and Trial Balance holds positions. A balance is a value at a date, so it is read for one period and never added across periods. To explain why a balance changed, read the activity in General Ledger Lines.

Cash flow

Cash flow dataset
Dataset	What it contains	Use it to answer
Cash Flow Components `cash_flow_components`	The components behind the Cash Flow Statement, for the indirect and the direct method.	What drove the change in cash? Which accounts make up investing activity?

This is the evidence behind the Cash Flow Statement. Accounts are classified as operating, investing, or financing under rules your controller reviews.

Projects

Project datasets
Dataset	What it contains	Use it to answer
Project Overview `project_overview`	Project financial activity and performance by period, separating recognized Income Statement activity from Balance Sheet exposure.	How is this project doing? What has it recognized, and what is still on the Balance Sheet?
Project Financial Position `project_financial_position`	Project balances by period, such as capitalized costs, work in progress, deposits, and financing.	What is capitalized, in progress, deposited, or financed on this project?

Project Overview is the first stop for a question about project health. Its presentation follows the industry set for your organization.

Units

Units are the quantities your business counts beside its money, such as projects in progress or units sold. Your team maintains them in the Unit Register, so this data does not come from the ERP. It is reported next to the financial figures.

Unit datasets
Dataset	What it contains	Use it to answer
Unit Movements `unit_movements`	Quantity movements by type. It carries quantities, not amounts.	What moved this month, and how much?
Unit Roll-forward `unit_rollforward`	Opening quantities, movements, and closing quantities by period.	How did the count change from opening to closing?

Datasets for BI tools

These are shaped for dashboards and delivered to BI tools such as Google Data Studio, Power BI, and Tableau. Identities follow your BI privacy settings. An organization receives the sources it has requested and configured. In a BI tool each appears under the table name shown.

Datasets for BI tools
Dataset	What it contains	Use it to answer
Income Statement Lines `mart_income_statement_lines`	Income Statement lines, with the sign a reader expects.	An Income Statement in a BI tool.
Balance Sheet Lines `mart_balance_sheet_lines`	Balance Sheet lines.	A Balance Sheet in a BI tool.
Cash Flow Statement Lines (Indirect) `mart_cash_flow_statement_lines`	Lines of the indirect-method Cash Flow Statement.	A Cash Flow Statement in a BI tool.
Reporting Entity Metrics `mart_reporting_entity_metrics`	Governed metrics by month-end, for each Legal Entity or for the combined organization before eliminations.	Monthly metric trends by Legal Entity in a BI tool.

Reports built from the datasets

A report is a calculation over a dataset, prepared by PipeLedger and returned with its evidence. Three are financial statements. A Metrics Report is an ordered selection of governed metrics that you choose, one line per metric, and is not a financial statement.

Reports, their periods, and their sources
Report	Period	Comparison	Built from
Income Statement	A fiscal year	Another fiscal year	General Ledger Lines
Balance Sheet	A month-end	Another month-end	Trial Balance
Cash Flow Statement	A fiscal year	Another fiscal year	Cash Flow Components
Metrics Report	Set by the metrics selected	Set by the metrics selected	The source of each selected metric

A question about a single month or quarter is answered by querying General Ledger Lines or Trial Balance.

Business Object Directory

The directory lists the customers, vendors, employees, projects, and Legal Entities in your published data. An AI agent uses it to turn a name in a question into the governed record it refers to. Where identities are private, the directory returns stable privacy tokens.

What every dataset carries

A Legal Entity. Every published General Ledger line carries a Reporting Legal Entity ID and name, so reporting can cover one Legal Entity or every authorized entity.
A source reference. Ledger lines keep a reference to the ERP record they came from.
A publication. Each result names the approved publication it was served from. Raw and unpublished data are never served.
Your access rules. Dataset access, Legal Entity and segment scope, account confidentiality, and identity privacy are applied before a result is returned.

Availability

The core datasets are the foundation. Cash flow, projects, units, and BI datasets are data products that are enabled for each organization. Within an organization, each connection sees only the datasets its Owner or Admin has granted. See pricing for current plans.