Source ERP · Oracle NetSuite

From SAP GL to a live FP&A platform — in minutes.

K-Phi imports NetSuite GL exports directly from SuiteAnalytics saved searches. No SuiteScript, no custom bundle, no consultants. Export your GL Impact or Transaction Detail saved search to CSV, drop it in, and the platform auto-maps columns, detects your subsidiary structure, and spins up a working FP&A and treasury workspace.

Why SAP exports are painful

NetSuite gives you rich accounting data — but the export path is brutal. Column headers come out in the source language (German or French depending on the client install), sign conventions differ from the French PCG standard, document types are cryptic, and account hierarchies live in a separate table you have to re-join manually. Most FP&A tools ask you to remap every column by hand, every time.

K-Phi's 7-pass Smart Mapper was built specifically for this. It ships with 297 header aliases — including the full SAP DE and FR vocabulary — and handles the sign convention translation in the background.

What K-Phi auto-maps

Drop an NetSuite GL line-item export (transaction FBL3N, FAGLL03, or an SE16 dump of BSEG/BKPF) into the upload field. Here's what gets recognized automatically:

NetSuite Field	K-Phi Field
Account / Account (Number)	`account`
Subsidiary	`entity`
Date	`doc_date`
Posting Period	`period`
Amount (Foreign Currency)	`amount_fc`
Amount (Base Currency)	`amount_lc`
Currency	`ccy`
Transaction Type	`doc_type`
Document Number	`doc_id`
Class	`dim_class`
Department	`cost_center`
Location	`dim_location`
Memo / Memo (Main)	`memo`

Sign convention: SAP stores debits as positive and credits as negative on most account types, while the French PCG inverts this for P&L accounts. K-Phi detects which convention your export uses by sampling known account ranges and normalizes automatically.

What you get, 60 seconds after upload

A classified chart of accounts (assets / liabilities / equity / revenue / expense, with granular sub-types)
A monthly P&L and balance sheet across all periods present in your export
An auto-derived cash flow statement using the indirect method
DSO, DPO, DIO, and working capital KPIs computed from the latest period snapshot
A forecast projection (FC_PROJ) seeded from your historical trend
A scenario library ready to model recession, FX shocks, rate hikes, and AR/AP term changes

What you'll confirm in the wizard

Five fields, all pre-filled from the data:

Functional currency — inferred from the local-currency column
Fiscal year start — inferred from period numbering and document dates
Consolidation method — flagged only if multiple company codes are detected
Consolidation scope — which subsidiaries to include, elimination rules
Opening balance treatment — include the OB carry-forward period or start from period 1

No consultants. No 6-month implementation.

K-Phi is built for finance teams who already have NetSuite and just want an FP&A and treasury layer on top — without the Anaplan or Pigment rollout cost. Upload today, amend the assumptions, and your workspace is live.

Try K-Phi with your NetSuite export →