CSV import templates
LedgerSync supports a few CSV template families so teams can import fallback data safely and still use validation, normalization, preview, and reconciliation controls.
Generic orders required columns
- - order_id
- - order_date
- - currency
- - gross_amount
Generic payouts required columns
- - payout_id
- - payout_date
- - currency
- - payout_amount
Marketplace templates
- - Amazon settlement CSV uses flexible mapping for settlement_id, amount, transaction_type, order_id, amount_type, and related payout fields.
- - eBay payout CSV uses flexible mapping for payout_id, transaction_id, order_id, payout_date, fee, net, and type columns.
Related articles
Keep moving through setup with the next most relevant guides.
Import CSV files into LedgerSync
Upload a CSV file, choose a template, map columns, validate rows, normalize valid records, and generate a preview.
Connect Amazon foundation
Review Amazon SP-API setup requirements, settlement-heavy import behavior, and when CSV fallback is the safer path.
Connect eBay foundation
Review eBay connector setup status, payout import behavior, and CSV fallback for payout reconciliation.
Troubleshooting common setup and sync issues
Resolve OAuth, shop-domain, realm ID, tenant selection, missing mappings, blocked previews, webhook failures, and worker issues.
Need help? Contact support
Support is the best next step when OAuth, imports, mappings, or reviewer access are blocked.