Does Valcenra connect directly to QuickBooks Online?

Not yet. A direct, read-only connection is not available today. You can export the General Ledger report from QuickBooks Online and import it into Valcenra, which is what this page describes.

Will Valcenra change anything in QuickBooks Online?

No. Valcenra only reads the file you import. It does not post journals, move money or approve anything, in QuickBooks Online or anywhere else.

What happens if the file does not tie to the report totals?

Valcenra rejects the whole file and says which total disagrees, rather than importing the rows that parsed. A half-imported ledger is the one error a reconciliation cannot find afterwards.

QuickBooks Online and Valcenra

Last reviewed 2026-09-29

Valcenra works with QuickBooks Online data today by file: export the General Ledger report, match its columns to Valcenra's ledger columns, and import it with the report's totals as control totals. A direct connection to QuickBooks Online is not available yet, and this page does not pretend otherwise.

What works today

In QuickBooks Online, open Reports and run the General Ledger report for the period, with the Date, Transaction type, Num, Account, Memo/Description, Debit and Credit columns shown.
Export it to Excel, and save the sheet as CSV.
Rename the columns to Valcenra's ledger columns (table below), add an entity code and the currency, and give each line a stable id: the transaction number plus the line number is enough.
In Valcenra, open Import, choose the ledger, period and source system, paste the CSV, and enter the report totals for debits and credits as the control totals.
Valcenra accepts the file whole or rejects it whole, and a rejection names the row and column to fix.

Menu names can differ between versions of QuickBooks Online. If yours differ, any report that lists each ledger line with its date, account, debit and credit will do.

Column mapping

QuickBooks Online	Valcenra column
Num + line number	`source_line_id`
(your entity code)	`entity_code`
Account	`account_code`
Date	`posting_date`
(your currency, e.g. USD)	`currency`
Debit	`debit`
Credit	`credit`
Memo/Description	`description`

Every column except description is required. Amounts must be plain decimals: no currency symbols and no thousands separators. Dates are written YYYY-MM-DD.

What Valcenra then does with it

Compares gross debits and gross credits with the totals you entered, and refuses a file that does not tie.
Explains the movement between periods by driver, and keeps what it cannot explain as an open item with an owner.
Reads only. Nothing is written back to QuickBooks Online.

Security

The file you import is held in your Valcenra workspace, visible only to people you grant access. Valcenra never asks for your QuickBooks Online password. See the privacy policy and trust centre.

Try Valcenra free

Import a QuickBooks Online ledger into a free workspace and see the movement explained, with the unexplained part kept visible.

The free workspace is one entity, two users and five stored analysis runs a month, with no card and no sales call.

Start free — no card

Common questions

Does Valcenra connect directly to QuickBooks Online?: Not yet. A direct, read-only connection is not available today. You can export the General Ledger report from QuickBooks Online and import it into Valcenra, which is what this page describes.
Will Valcenra change anything in QuickBooks Online?: No. Valcenra only reads the file you import. It does not post journals, move money or approve anything, in QuickBooks Online or anywhere else.
What happens if the file does not tie to the report totals?: Valcenra rejects the whole file and says which total disagrees, rather than importing the rows that parsed. A half-imported ledger is the one error a reconciliation cannot find afterwards.

QuickBooks Online is a trademark of Intuit Inc.. Valcenra, LLC is not affiliated with, endorsed by or sponsored by Intuit Inc..