@glideco/spend-export

npm install @glideco/spend-export

import { parseSpendReceipt, type SpendReceipt } from '@glideco/spend-export';

const receipt = parseSpendReceipt({
  schemaVersion: '0.1.0',
  id: 'a1b2c3d4-e5f6-7890-abcd-ef1234567890',
  occurredAt: '2026-04-30T14:22:00Z',
  amountCents: 4999,
  currency: 'USD',
  rail: 'x402',
  counterparty: {
    name: 'Anthropic API',
    country: 'US',
    taxIdType: 'ein',
    taxIdValue: '12-3456789',
  },
  statementDescriptor: 'ANTHROPIC*API',
  correlationId: 'mcp_audit_7f8e9d2a',
  agentId: 'c1a2b3d4-e5f6-7890-abcd-ef1234567890',
  grantId: 'd4e5f6a7-b8c9-0123-abcd-ef1234567890',
  taxJurisdiction: 'US-CA',
  realizedGainUsdCents: 0,
});

import { exportCsv } from '@glideco/spend-export';

const csv = exportCsv(receipts);
// → RFC 4180 CSV with 16 canonical columns:
//   id, occurredAt, amountCents, currency, rail, counterpartyName,
//   counterpartyCountry, statementDescriptor, mcc, correlationId,
//   agentId, grantId, taxJurisdiction, realizedGainUsdCents, txHash, memo

import { exportQboIif } from '@glideco/spend-export';

const iif = exportQboIif(receipts);
// TRNS/SPL/ENDTRNS format. Imports under Banking → File →
// Utilities → Import → IIF Files.
// Glide-augmentation fields (correlationId, agentId, grantId)
// carried in the MEMO column so they survive a plain-QBO import.

import { exportXeroCsv } from '@glideco/spend-export';

const xero = exportXeroCsv(receipts);
// Xero's column layout (*Date, *Amount, Payee, Description,
// Reference, Cheque No.) — different from the canonical CSV.

import {
  exportJsonLines,
  aggregateBy,
  summarizeRealizedGains,
} from '@glideco/spend-export';

// One JSON receipt per line — for warehouse ingestion.
const jsonl = exportJsonLines(receipts);

// Group by agent, get count + total spend per agent.
const byAgent = aggregateBy(receipts, (r) => r.agentId);

// Crypto rail realized gain summary.
const gains = summarizeRealizedGains(receipts);
// → { totalCents: number, byRail: Map<string, number> }