Accounting Imports
Stage, validate, reconcile and approve opening balances and master data before cutover, with a QuickBooks Online pull and journal exports.
Accounting Imports moves data in for cutover through reviewed import runs: upload a file or pull from a connection, see the validation preview, reconcile it and approve it before anything posts. It also exports posted journals in ERP import formats. Open it from the company app launcher under Accounting > Accounting Imports; it appears when your accounting access includes it.
- Who uses it
- Implementation leads and controllers with integration rights.
- When
- Before go-live, and for ongoing journal exports.
- What it holds
- Connections and their health, sync runs, import runs with previews and results, and the integration error inbox.
Key workflow
- Upload or pull. Upload CSV or XLSX for the chart of accounts, vendors, customers, cost codes, opening trial balance, journals, open AP and AR, and employee year-to-date. A QuickBooks Online connection stages accounts, vendors and open bills. File connections are available for Viewpoint Spectrum, Sage 300 CRE, Sage Intacct and Foundation exports.
- Review the preview. Each run stores a validation preview. Map unmatched values and fix errors before approval. Large imports run in resumable chunks.
- Reconcile and approve. Reconcile the run to the source totals, then a second person approves and applies it. An applied entry can be reversed.
- Prove the cut-over. The Cut-over reconciliation report checks the opening entries against the source trial balance account by account, each open AP and AR document and its retainage against the aging, the subledgers against their control accounts, fixed assets, opening job cost and payroll YTD on the W-2 data. The go-live checklist waits until it passes. A parallel-run comparison of a later source trial balance is available through the API.
- Watch the error inbox. The integration error inbox lists failed sync runs and blocked or failed import runs.
- Export journals. Export posted journals for a date range as a debit/credit, signed-amount or QuickBooks journal file.
Controls
- Nothing posts from a pull or upload until a reviewed run is approved.
- Connections need integration-management rights.
Current boundaries
For the full procedure, exceptions and examples, read the Imports and integrations workflow guide.
API operations
11 operations · 6 read · 5 write · base path /rest/v1.0/companies/{company_id}/accounting
- GET
/integrations/connectionsList ERP connections with health and recent sync runs - POST
/integrations/connectionsCreate an ERP connection (manageIntegrations) - POST
/integrations/connections/{id}/syncQueue a sync pull (live API connections); it stages coa, vendors and open_ap import runs - GET
/integrations/exports/journalsExport posted journals as an ERP import file - GET
/integrations/importsList imports - POST
/integrations/importsUpload CSV and persist validation preview - GET
/integrations/imports/{id}Read preview, results and history - POST
/integrations/imports/{id}Map, reconcile, approve/apply or reverse an imported entry - GET
/integrations/inboxIntegration error inbox: sync run errors and blocked or failed import runs - POST
/integrations/parallel_runParallel run: compare a source system trial balance with the posted trial balance on the same date - GET
/integrations/sync_runs/{id}Get a sync run
Parameters, request and response fields, errors and a generated example for each operation are in the REST reference for this app. Read scopes, step-up and permissions in the Accounting API guide.
Keep exploring
Related across os.construction
- DocsAccounting imports and integrationsImport opening balances, open AP/AR, journals, master data and payroll YTD, and connect QuickBooks Online, through one reviewed company accounting workflow.
- GlossaryTrial balanceA list of every account's debit or credit balance at a date; total debits equal total credits.
- DocsImporting from your current stackBring project records into Migration and establish company books through reviewed Accounting imports for master data, open AP/AR, opening balances, journals and payroll YTD.
- GlossaryGeneral ledgerThe complete record of every financial transaction a company posts, organized by account, from which the trial balance and financial statements are built.
- BlogYour first accounting cycle: setup, transactions and closeA practical learning path through the Accounting module's apps, with the people, evidence and review gates needed from opening balances to month-end.
- BlogHow to close the month in construction accounting: a step list from cutoff to lockA construction month-end close gets every cost and every billing into the right month, proves cash and the subledgers against the ledger, updates the WIP schedule from current cost-to-complete, has someone else review it, and then locks the period. Here is the step list, an example close calendar and a worked example of what one late invoice does to WIP.
Was this helpful?
Run it on your own project.
Start a 14-day free trial. Want a say in what ships next? Join the founding program.
14-day free trial. Pricing for paid plans isn't set yet. Talk to us. Already have an account? Sign in →