Onaro™ONARO
OverviewImplementationExtraction guides

← All systems

Sage Intacct — Data Extraction Guide

Zero-Access pack. Follow each section, export the file, and return it to Onaro or upload it in the Meridian profile wizard. Verified as of 2026-09-13; vendor menus change.

Download Sage Intacct PDF

GL journal entry import template

Verified as of 2026-09-13

Steps

  1. Sign in to Sage Intacct with a Business user who can open Company Setup.
  2. Go to Company → Setup → Configuration → Import data (Company Setup Checklist).
  3. Find the section Set up General Ledger transactions.
  4. On the General Ledger journal entries line, select Template and download the file.
  5. Alternative: Go to General Ledger → All → Journal entries → Import (or Import transactions) → Download template.
  6. Keep the downloaded company-specific template — do not invent columns. Upload this file into Meridian’s Export Profile wizard.

What you should have

Company-customized CSV/XLSX with header row, description row, then data columns including JOURNAL, DATE, DESCRIPTION, LINE_NO, ACCT_NO, DEBIT/CREDIT, plus your dimensions.

Gotchas

  • Templates are customized per company (dimensions). Always download a fresh template before mapping.
  • Save as plain CSV (not UTF CSV) when Intacct will re-import the file later.
  • Data typically starts on row 3 after header and description rows.
  • If you cannot open Import data, ask your Intacct administrator for the template.

Source documentation

Trial balance export

Verified as of 2026-09-13

Steps

  1. Ask your Intacct administrator which trial balance report your firm uses (often General Ledger → Reports → Trial balance, or a memorized report).
  2. Open that report for the closed month Meridian is reconciling.
  3. Set the As of / period date to the last day of that month.
  4. Export or download as CSV or Excel.
  5. Upload the file into Meridian’s Import Profile wizard (artifact: trial balance).

What you should have

CSV/Excel with account identifiers and debit/credit or balance columns for the period.

Gotchas

  • Exact menu labels vary by permissions and custom report packs — use your firm’s standard TB if different.
  • Include enough columns to identify account and amount (and department/dimension if you allocate by dept).
  • This cell ships with a generic administrator ask when a single canonical path is not universal across Intacct configurations.

Source documentation

AP / vendor bill export

Verified as of 2026-09-13

Steps

  1. Ask your controller which AP report or bill register your firm exports for vendor spend analysis.
  2. Typical path: Accounts Payable → All → Bills (or Reports) for the assessment date range.
  3. Filter to Posted bills for the period; include vendor name, bill date, amount, and GL account when available.
  4. Export to CSV or Excel.
  5. Upload into Meridian’s Import Profile wizard (artifact: AP / vendor bills).

What you should have

CSV/Excel of vendor bills or AP detail for the period.

Gotchas

  • Menu names vary; prefer the export your CAS firm already uses for AP analytics.
  • Do not send bank account numbers or full payment instrument data — bill register / expense detail is enough.

Source documentation

Chart of accounts / dimensions extract

Verified as of 2026-09-13

Steps

  1. Go to Company → Setup → Configuration → Import data.
  2. Locate Chart of accounts (and dimension / department lists your company uses) and download Template links, or export the live lists from General Ledger / Company dimension setup if your admin prefers a live export.
  3. For dimensions (department, location, etc.): export each active dimension list your firm posts AI spend against.
  4. Upload CoA and dimension files into Meridian’s Import Profile wizard.

What you should have

CSV templates or list exports of accounts and dimension values.

Gotchas

  • Intacct dimensions are company-specific — export what you actually use for reporting.
  • If Template downloads are empty lists, export from the live dimension / account list screens instead.

Source documentation

Budget export

Verified as of 2026-09-13

Steps

  1. Ask your Intacct administrator (or CAS firm) which budget report or Excel budget your company files.
  2. Export that budget for the fiscal year / months Meridian will variance against (CSV or Excel).
  3. If budgets live only outside Intacct, export the filed Excel workbook and note the source in the filename.
  4. Upload into Meridian’s Import Profile wizard (artifact: budget).

What you should have

CSV/Excel budget by period and department (or your firm’s budget shape).

Gotchas

  • Budget menu paths vary widely — prefer the file your controller already files for board reporting.
  • Include department/dimension columns when those drive variance reviews.

Source documentation