Spreadsheets

Spreadsheet CSV — data contract (open spreadsheet / CSV transactions export)

Name: Spreadsheet CSV data contract
Creator: DataContractGate
License: https://opensource.org/licenses/MIT

Generic transactions / ledger CSV for spreadsheet, bank, and bookkeeping exports. Open column set (date, description, amount, currency) documented with the project; file syntax follows RFC 4180. Not a vendor schema.

Validate a client's Spreadsheet CSV export at ingest into your warehouse, or with POST /egress before sending the same shape to a partner, reverse ETL, or an AI agent.

Download YAML

Also available: ODCS v3.1.0 YAML. “Use this contract” forks it into your org, then opens the validation playground so you can upload the client file.

Fields

Name	Type	Required	Rule	Description
date	date	required	—	Transaction date (YYYY-MM-DD). Column meanings are this project's open spreadsheet set; the file syntax follows RFC 4180.
description	string	required	min length 1	—
amount	number	required	—	Signed transaction amount; negative for debits, positive for credits.
currency	string	required	pattern /^[A-Z]{3}$/	Three-letter ISO currency code, uppercase.
category	string	optional	—	—
account	string	optional	—	—
reference	string	optional	—	—
balance	number	optional	—	Running account balance after this transaction, if provided.

Sample rows

Three synthetic rows we wrote. They validate against this contract with zero violations. No real customer data.

[
  {
    "account": "Operating",
    "amount": 2500,
    "balance": 2500,
    "category": "Income",
    "currency": "USD",
    "date": "2026-01-03",
    "description": "Client retainer - January",
    "reference": "INV-1001"
  },
  {
    "account": "Operating",
    "amount": -49,
    "balance": 2451,
    "category": "Software",
    "currency": "USD",
    "date": "2026-01-05",
    "description": "SaaS subscription",
    "reference": "sub_0001"
  },
  {
    "account": "Operating",
    "amount": -12.5,
    "balance": 2438.5,
    "category": "Fees",
    "currency": "USD",
    "date": "2026-01-08",
    "description": "Bank fee"
  }
]

Provenance

Verified against: https://www.rfc-editor.org/rfc/rfc4180
Checked: 2026-11-06
Version: v1.0
Author: DataContractGate
License: MIT

Spotted a mismatch with the vendor’s current schema? Report an issue.

Stripe, Shopify, QuickBooks, Xero, HubSpot, Salesforce, Google Analytics and Square are trademarks of their respective owners. DataContractGate is not affiliated with or endorsed by them. These contracts describe data shaped like these vendors’ documented schemas; they are not official and are not certified by any vendor.