QuickBooks Online
The QuickBooks Online integration is available today.
QuickBooks Online is the most widely used SMB accounting platform, and for many borrowers it is where the financial statements a lender needs actually live. LORIQ syncs the balance sheet, income statement, and trial balance directly from Intuit's API.
Synced statements arrive as drafts with a mapping review step, so your team confirms how accounts map to LORIQ's financial model before anything affects covenant calculations or portfolio analytics.
Supported data
Core financial reporting data, imported on your schedule.
Every sync lands as a reviewable draft with account-mapping controls — nothing posts to your credit metrics without confirmation.
Statements are aligned to your fiscal calendar so period-over-period trends and covenant tests stay accurate.
Security
Every LORIQ integration — including QuickBooks Online — runs on one shared, hardened connectivity framework rather than per-integration plumbing:
- Credentials are stored in an encrypted, per-connection vault and are never exposed to browser sessions or logs.
- Every synced record is scoped to your organization — tenant isolation is enforced at the query layer and verified by automated guard tests.
- All incoming files pass malware scanning before storage; unscanned bytes are never persisted (fail-closed by design).
- Imports land as drafts for review — synced data never silently overwrites your records.
- Every sync, import, and connection change is captured in the platform audit trail.
Authentication
LORIQ connects to QuickBooks Online using Native API (OAuth 2.0). An administrator on your team authorizes the connection directly with QuickBooks Online — LORIQ never sees or stores your QuickBooks Online password. Access tokens are held in LORIQ's encrypted credential vault and refreshed automatically.
Disconnecting removes the stored credentials immediately; where the provider supports token revocation, LORIQ revokes access as part of disconnect.
Setup guide
- 1Connect
From Settings → Integrations, choose QuickBooks Online and authorize the connection using your QuickBooks Online administrator credentials.
- 2Choose scope
Select the company, entity, or subsidiary whose financials LORIQ should sync.
- 3Preview & map
Run a preview to see exactly what will be imported, and review how accounts map to LORIQ's statement model. Previews never write data.
- 4Schedule
Enable the sync schedule. Each subsequent import arrives as a draft for review, and sync health is monitored with alerts if anything stalls.
Frequently asked questions
Will syncing overwrite the financials already in LORIQ?
No. All imports are draft-only. Your team reviews and accepts each import before it becomes part of your financial record.
Can LORIQ write data back to QuickBooks Online?
No. The integration is read-only — LORIQ pulls reporting data from QuickBooks Online and never modifies your books.
What happens if the connection breaks?
Syncs retry automatically with backoff. If a sync stalls, administrators are alerted so the connection can be repaired before reporting deadlines.
What if we use a system other than QuickBooks Online for part of the business?
Connectivity spans ERP platforms plus CSV and Excel import paths, and the platform's REST API — talk to our team about the best route for a mixed-system portfolio.
Expanding capabilities
- Broader statement coverage (for example AR/AP aging detail) as the canonical financial model expands.
- Deeper entity and dimension support for multi-entity organizations.
See QuickBooks Online + LORIQ in action
Walk through the integration with our team and see how your data flows into a single commercial credit workspace.
Request a demo