Skip to main content
Glama
gl-importer

gl-importer

Official

gl-importer (Claude Code plugin)

Import CSV/XLSX accounting data into QuickBooks Online or Xero from inside Claude Code, using the Synder Importer API.

This plugin bundles:

  • An MCP server wrapping the Synder Importer REST API (/api/v1) — full read + write, 19 tools covering account, companies, settings, entities, fields, mappings, imports, status polling, results, cancel, revert, plus two composite "happy path" tools.

  • The gl-importer agent skill with natural-language guidance for the two-step import flow (dry-run → confirm).

Requirements

  • Node.js 18 or newer

  • Claude Code with plugin support (/plugin command available)

  • A Synder Importer API token — set as IMPORTER_API_TOKEN in your shell env. Generate at importer.synder.com → Account → API Keys.

Related MCP server: qb-mcp

Install

/plugin marketplace add SynderAccounting/gl-importer-plugin
/plugin install gl-importer

Then set your token in the shell that launches Claude Code:

export IMPORTER_API_TOKEN="your_token_here"

Claude Desktop (one-click MCP install)

Download the latest .mcpb bundle from Releases and double-click it. Claude Desktop will prompt you for the API token.

From source (development)

git clone https://github.com/SynderAccounting/gl-importer-plugin
cd gl-importer-plugin
npm install
npm run build
# Point Claude Code at this directory:
claude --plugin-dir .

Configuration

Env var

Required

Default

Purpose

IMPORTER_API_TOKEN

yes

—

Bearer token for the Synder Importer API

IMPORTER_BASE_URL

no

https://importer.synder.com/api/v1

Override for staging/test

Example prompts

Once installed, talk to Claude Code naturally:

  • "Import ~/Downloads/march-bills.csv as Bills into my QuickBooks company."

  • "What entities can I import into Xero?"

  • "Show me the saved mapping called 'Stripe payouts' and update it to map Date → TxnDate."

  • "List my last 10 imports and tell me which ones failed."

  • "Revert import 12345 — I uploaded the wrong file."

  • "What's the status of import 12345? Wait for it to finish and tell me how many warnings."

The skill will walk Claude Code through a safe two-step flow: a dry-run that shows the proposed field mapping, then a confirmed call that actually creates the import and polls until it terminates.

Tools

The MCP server exposes 19 tools. The ones an LLM will hit most often:

Tool

Purpose

import_csv

Happy path. Auto-resolves company, uploads file, runs dry-run, then (on confirm) executes + waits.

wait_for_import

Polls a running import to a terminal state with exponential backoff (2s → 1.5× → 30s cap).

list_companies / list_entities / get_fields

Discover what you can import where.

list_mappings / create_mapping / update_mapping / delete_mapping

Saved-mapping CRUD.

auto_import / execute_import

Lower-level: create an import with auto-mapping or an explicit mapping.

get_import_status / get_import_results / cancel_import / revert_import

Lifecycle.

get_settings / update_settings

Per-company import settings.

get_account

Whoami / token check.

Full schemas are emitted at MCP startup — the agent skill (skills/gl-importer/SKILL.md) also documents the conventions.

Development

npm install
npm run build       # tsc → dist/
npm test            # vitest, 60+ unit tests, virtual-clock polling tests
npm run watch       # tsc --watch for iterative dev

CI runs on every push and PR (.github/workflows/ci.yml).

Release process

  1. Bump version in package.json and .claude-plugin/plugin.json (keep them in sync).

  2. Commit and tag: git tag v0.x.y && git push --tags.

  3. The publish.yml workflow publishes to npm on the tag push (uses NPM_TOKEN secret).

  4. The marketplace install path resolves through this GitHub repo, so the tag is the release.

License

MIT — see LICENSE.

Support

Available Tools

19 tools
auto_importA

Uploads a file and asks the server to auto-map columns to the target entity. Set dryRun=true to get the proposed mapping back without creating an import — useful for showing the user what will happen and asking 'does this look right?' before committing. Set dryRun=false (default) to auto-map and import in one call.

Inputs: companyId (required), filePath (required), entityName (required), dryRun. Returns: Either an import object (dryRun=false) or a proposed mapping with detected colu…

cancel_importA
DestructiveIdempotent

Cancels a SCHEDULED or IN_PROGRESS import. Already-imported rows are NOT rolled back — use revert_import for that. Returns the updated import status.

Inputs: companyId (required), importId (required). Returns: id, status, entityName, fileName, +3 more

create_mappingA

Creates a new field mapping for an entity (e.g. 'Journal Entry', 'Bill', 'Invoice'). Look up valid target fields with get_fields first. Returns the created mapping including its id.

Inputs: companyId (required), title (required), entityName (required), fields (required). Returns: id, title, entityName, fields, +2 more

delete_mappingA
DestructiveIdempotent

Deletes a saved mapping. Irreversible. Imports that referenced this mapping keep their historical record but new imports can no longer pick it.

Inputs: companyId (required), mappingId (required). Returns: deleted, mappingId

execute_importA

Uploads a CSV/XLSX file and starts an import using an existing mapping. The MCP server reads the file from disk — pass an absolute path. Returns the created import object including importId. Status starts as SCHEDULED — poll get_import_status or use wait_for_import. Limits: .csv/.xlsx/.xls only, 50MB max.

Inputs: companyId (required), filePath (required), entityName (required), mappingId (required). Returns: id, status, entityName, fileName, +3 more

get_accountA
Read-only

Returns the current Synder Importer account: email, name, status, subscription, and connected-company count. Call this first to verify the IMPORTER_API_TOKEN is valid.

Inputs: no named parameters. Returns: id, email, name, status, +2 more

get_fieldsA
Read-only

Returns the field schema for an entity in a company: every field with its type, required flag, alternativeTitles, and predefinedValues. Use to build or verify a mapping before running an import.

Inputs: companyId (required), entityName (required). Returns: fields

get_import_resultsA
Read-only

Returns per-row results for a finished import. Filter by 'type' (INFO / WARNING / ERROR) to surface only failures. Paginated — defaults to 20 rows per page, max 100.

Inputs: companyId (required), importId (required), type, page, +1 more. Returns: rows, page, perPage, total, +1 more

get_import_statusA
Read-only

Returns a single import's current status and summary (total / succeeded / failed / warnings). Status lifecycle: SCHEDULED → IN_PROGRESS → FINISHED | FINISHED_WITH_WARNINGS | FAILED | CANCELED. FINISHED can transition to REVERTING → REVERTED.

Inputs: companyId (required), importId (required). Returns: id, status, entityName, fileName, +3 more

get_settingsA
Read-only

Returns per-company import settings (dateFormat, document-number behavior, product/account auto-creation, duplicate-skip). Check dateFormat before importing — CSV date columns must match.

Inputs: companyId (required). Returns: dateFormat, incrementDocNumber, createMissingProducts, createMissingAccounts, +…

import_csvA

Happy-path CSV/XLSX importer. Two-step: first call (without confirmed) auto-resolves the company, uploads the file, and returns the server's proposed mapping plus any missingRequired fields — show this to the user. Re-call with confirmed=true (and the same filePath) to run the real import and poll until it terminates. Returns { stage: 'DRY_RUN' | 'DONE', importId?, status, summary?, proposedMapping?, missingRequired? }.

Inputs: filePath (required), entityName (required), companyId, confirmed, +1 more. Returns: stage, companyId, entityName, importId, +5 more

list_companiesA
Read-only

Lists all accounting companies connected to the Importer account (QuickBooks Online via 'intuit', Xero via 'xero'). Use the returned 'id' as companyId for downstream tools.

Inputs: no named parameters. Returns: companies

list_entitiesA
Read-only

Lists importable entity types for a company (Invoice, Bill, JournalEntry, Customer, Vendor, etc.). Use the returned 'name' as entityName for get_fields and import tools.

Inputs: companyId (required). Returns: entities

list_importsA
Read-only

Lists recent imports for a company with status and timestamps. Use to find an importId for status / results / revert / cancel.

Inputs: companyId (required). Returns: imports

list_mappingsA
Read-only

Lists field mappings saved for a company. Each mapping is reusable across imports of the same entity type.

Inputs: companyId (required). Returns: mappings

revert_importA
DestructiveIdempotent

Reverts a FINISHED or FINISHED_WITH_WARNINGS import — deletes the QuickBooks/Xero entries the import created, using their live SyncTokens. Status transitions FINISHED → REVERTING → REVERTED. Confirm with the user before calling — irreversible from their perspective.

Inputs: companyId (required), importId (required). Returns: id, status, entityName, fileName, +3 more

update_mappingA
Idempotent

Replaces an existing mapping in full. Fetch the current mapping with list_mappings first and send the whole desired shape — this is a PUT, not a patch. Returns the updated mapping.

Inputs: companyId (required), mappingId (required), title (required), entityName (required), +1 more. Returns: id, title, entityName, fields, +2 more

update_settingsA
Idempotent

Updates per-company import settings. Pass only the fields you want to change inside 'settings' (e.g. { dateFormat: 'dd/MM/yyyy' }). Fetch current values with get_settings first so you don't clobber unrelated fields. Returns the updated settings.

Inputs: companyId (required), settings (required). Returns: dateFormat, incrementDocNumber, createMissingProducts, createMissingAccounts, +…

wait_for_importA
Read-only

Polls get_import_status until the import reaches a terminal state (FINISHED, FINISHED_WITH_WARNINGS, FAILED, CANCELED, REVERTED). Exponential backoff (2s → 1.5× → cap 30s). Default timeout 600s — if exceeded, returns { status: 'POLLING', importId, lastSeen } so the LLM can re-call. Includes a per-type result count summary on terminal states (INFO / WARNING / ERROR; null if the server didn't return totals).

Inputs: companyId (required), importId (required), timeoutSeconds. Returns: id, status, importId, summary, +1 more

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    A4.3/5.0

    Scored across 19 tools

    Disambiguation4/5

    Most tools have distinct purposes, but there is some overlap between auto_import, import_csv, and execute_import. Detailed descriptions help differentiate them, though an agent might still need to read carefully.

    Naming Consistency5/5

    All tool names follow a consistent verb_noun pattern with underscores, e.g., create_mapping, list_companies. Very predictable and easy to understand.

    Tool Count5/5

    19 tools is appropriate for an import server covering account info, companies, entities, mappings, multiple import workflows, settings, and results. Each tool earns its place.

    Completeness5/5

    The tool set covers the full import lifecycle: mapping CRUD, multiple import methods, status polling, results, cancellation, reversion, and settings management. No obvious gaps.

    Maintenance

    ActivityNo data
    ResponsivenessOutdated data

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      B
      quality
      A
      maintenance
      Enables interaction with the QuickBooks Online Accounting API to manage customers, invoices, expenses, and payments through MCP-compatible clients. It supports comprehensive financial workflows and the generation of reports like Profit and Loss or Balance Sheets.
      138
      2
      Apache 2.0
    • A
      license
      Not graded
      quality
      Not graded
      maintenance
      An MCP server that enables AI agents to interact with QuickBooks Online accounts to manage invoices, customers, payments, and financial reports. It provides 20 tools to automate accounting workflows and retrieve financial data through natural language interfaces.
      -
    • A
      license
      Not graded
      quality
      D
      maintenance
      Provides 55 tools for managing QuickBooks entities like customers, invoices, and bills via any MCP-compatible client, built on Cloudflare Workers with OAuth 2.0 authentication.
      11
      Apache 2.0
    • A
      license
      Not graded
      quality
      D
      maintenance
      A comprehensive MCP server for QuickBooks Online, providing 144 tools for full CRUD operations on 29 entity types and 11 financial reports, with built-in safety guards against unintended writes.
      5
      Apache 2.0