Skip to Content
AuditAccounting data intakeImport accounting data

Import accounting data

Intake accepts accounting exports as CSV, XLS, or XLSX files. Review the transformed data and quality checks before using those balances in your audit.

Supply trial balances

  1. Open Trial Balance in Intake.
  2. Supply Prior-Year Closing Trial Balance and Current-Year Trial Balance in the corresponding upload areas. With a connected QuickBooks company, use the synchronization shown instead.
  3. Select the worksheet when a spreadsheet contains multiple sheets.
  4. Wait for processing, then open the file’s Preview Files action.
  5. Compare Original Data with Transformed Data and review the quality checks.
  6. Resolve any flags, then click Approve when reviewing a pending client file, or Reject if a replacement is needed.
  7. Click Complete & Continue when the step is ready.

Supply general ledger detail

When Include General Ledger Detail is on, complete General Ledger in the same way. Upload the ledger export or use the connected company data. Confirm the period and review the transformed records before continuing.

Inspect transformed values

The preview shows Net = Debit − Credit. Where editing is available, click an editable transformed value and confirm the correction. Recheck the resulting quality flags before proceeding.

The file menu provides preview and download actions. For a completed step, these actions remain available even though editing and approval are locked.

Handle data-quality warnings

A flagged check requires investigation; it is not automatically an audit finding. Open the flag, inspect affected rows, and record your conclusion. Follow Review data quality and reconciliation before completing the step.

Next

Map accounts after the required files are ready.

Last updated on