Source ERP · QuickBooks

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

K-Phi imports QuickBooks general ledger exports directly. Export your General Ledger report from QuickBooks Online or QuickBooks Desktop to CSV or Excel, drop it into K-Phi, and get a working FP&A and treasury platform. No app marketplace install, no consultants.

Why QuickBooks is tricky for FP&A

QuickBooks is built for bookkeeping, not analysis. The GL report is simple — a flat list of transactions — but the analytical structure lives in Class, Location, and Customer:Job tracking, which most FP&A tools ignore. QBO and Desktop also export with slightly different column labels, and account hierarchy flattens into dotted names like "Expenses:Office:Supplies".

K-Phi's 7-pass Smart Mapper was built specifically for this. It recognizes both QBO and Desktop column formats, unflattens the dotted account hierarchy, and preserves Class / Location as OLAP dimensions.

What K-Phi auto-maps

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

QuickBooks Field (QBO / Desktop)	K-Phi Field
Account / Account Full Name	`account`
Company (from file header)	`entity`
Date / Trans Date	`doc_date`
(derived from Date)	`post_date`
(derived from Date + FY start)	`period`
(derived from Date + FY start)	`fiscal_year`
Amount / Debit / Credit	`amount_lc`
Currency (Home Currency)	`ccy`
Type / Transaction Type	`doc_type`
Num / Doc Num	`doc_id`
Class / Location	`cost_center`
Memo / Description	`memo`

Dotted hierarchy: QuickBooks exports accounts as "Parent:Child:Grandchild". K-Phi unflattens these into a proper tree so your P&L rolls up correctly, and preserves the leaf for detail reporting.

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
Account hierarchy depth — how many levels of the dotted path to expose in reports
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 have outgrown QuickBooks reporting 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 QuickBooks export →