Onaro™ONARO
OverviewImplementationExtraction guides

← All systems

Generic CSV / Excel — 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 Generic CSV / Excel PDF

Balanced journal entry CSV (any GL)

Verified as of 2026-09-13

Steps

  1. Export or create a sample balanced journal CSV from your GL/ERP with clear headers for account, debit, credit, date, memo, and department/dimension if used.
  2. Alternatively, download a Meridian Generic CSV export from a locked chargeback run once available, and use that as the shape.
  3. Upload your header sample into Meridian’s Export Profile wizard and map columns.

What you should have

CSV/Excel with at least account, debit, credit (balanced), and preferably date, memo, department.

Gotchas

  • Keep accounts as text to preserve leading zeros.
  • One of debit or credit per line; entry must zero-sum.

Source documentation

Trial balance CSV

Verified as of 2026-09-13

Steps

  1. Export a trial balance or account balance file from your GL for the closed month.
  2. Include account identifier and debit/credit or balance columns.
  3. Upload into Meridian’s Import Profile wizard (artifact: trial balance).

What you should have

CSV/Excel TB for the period.

Gotchas

  • Match the period end date to the Meridian chargeback month.

Source documentation

Vendor / AP spend CSV

Verified as of 2026-09-13

Steps

  1. Export vendor bills or AP detail for the assessment period from your AP system or Excel AP register.
  2. Include vendor name, date, amount, and account/department when available.
  3. Upload into Meridian’s Import Profile wizard.

What you should have

CSV/Excel vendor spend detail.

Gotchas

  • Do not include bank account or payment card numbers.

Source documentation

Chart of accounts / department list

Verified as of 2026-09-13

Steps

  1. Export your chart of accounts and any department/dimension lists used for allocation.
  2. Upload into Meridian’s Import Profile wizard.

What you should have

CSV/Excel CoA and dimension lists.

Gotchas

  • Preserve leading zeros on account codes (text columns).

Source documentation

Budget CSV / Excel

Verified as of 2026-09-13

Steps

  1. Export the budget your company actually filed (period × department × amount is ideal).
  2. Upload into Meridian’s Import Profile wizard (artifact: budget).

What you should have

CSV/Excel budget workbook.

Gotchas

  • Name the file with source and date for provenance (Meridian labels imported budgets).

Source documentation