Esc

↑↓ move↵ openIndex · Pagefind
Accounting apps / Accounting Imports

Accounting Imports

Stage, validate, reconcile and approve opening balances and master data before cutover, with a QuickBooks Online pull and journal exports.

On this page

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

  1. 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.
  2. Review the preview. Each run stores a validation preview. Map unmatched values and fix errors before approval. Large imports run in resumable chunks.
  3. Reconcile and approve. Reconcile the run to the source totals, then a second person approves and applies it. An applied entry can be reversed.
  4. 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.
  5. Watch the error inbox. The integration error inbox lists failed sync runs and blocked or failed import runs.
  6. 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

Keep exploring

Related across os.construction

Run it on your own project.

Start a 14-day free trial. Want a say in what ships next? Join the founding program.

Your role (optional)

14-day free trial. Pricing for paid plans isn't set yet. Talk to us. Already have an account? Sign in →

Ask the OS

Reading this page

Ask anything about this page. Answers use what you're reading as context.

Suggested

    AI · may be imperfect · sample data where shown

    Open file