Bulk upload transactions to new source account

Authentication

Bearer token authentication. Pass your DayZero API token in the Authorization header and the target business UUID in x-business-id.

Request body

Schema: BulkTransactionUploadRequest

ledger_idstring

Optional: UUID of existing ledger to use. If provided, ledger creation is skipped and ledger_name/ledger fields are ignored.

ledger_namestring

Display name for the new ledger (required if ledger_id not provided, e.g., 'My Old Credit Card XXXX')

source_account_namestring

Optional: Display name for the source account. Defaults to ledger name if not provided.

business_personalstring

Whether the source account is a business or personal account. 'business' (default) for company transactions, 'personal' for owner draws/contributions.

invert_transaction_amountsboolean

If true, transaction amounts are inverted during import. Useful when CSV has opposite sign convention.

s3_keystringrequired

S3 key of the CSV file containing transactions

start_datestring · date

Optional: Only upload transactions on or after this date (YYYY-MM-DD). Filters transactions before upload.

end_datestring · date

Optional: Only upload transactions on or before this date (YYYY-MM-DD). Filters transactions before upload.

check_duplicatesboolean

If true, checks for duplicate transactions before uploading. Duplicates are skipped.

duplicate_match_fieldsarray · string

Fields to use for duplicate detection: 'amount', 'date', 'description'. Defaults to all three.

skip_categorizationboolean

If true, skip post-upload bank rules and AI categorization. Journal entries still post during import — to the mapped category column when provided, otherwise to Uncategorized Expense/Income. Only honored on the local accounting engine.

generate_bank_rulesboolean

If true (default), learn bank rules from the categorized transactions so future transactions auto-categorize. Ignored when skip_categorization is true.

currencystring

Currency for this account (USD, CAD, AUD, EUR, or GBP). Defaults to business default.

editableboolean

If true, journal entries can be manually posted to this account.

typestring

Account type: asset, liability, equity, revenue, expense. Required in Custom Mode.

descriptionstring

Optional description of the account's purpose.

statusstring

Account status: 'active' or 'inactive'. Inactive accounts hidden from dropdowns.

debit_creditstring

Normal balance: 'debit' (assets/expenses) or 'credit' (liabilities/equity/revenue). Required in Custom Mode.

sort_codestring

Sort code for chart ordering (e.g., '1000' for assets, '4000' for revenue). Required in Custom Mode.

sub_typestring

Sub-classification (current_assets, operating_expenses, etc.). Required in Custom Mode.

report_cash_flowboolean

Include in cash flow statement. Required in Custom Mode.

financial_account_typestring

Templated Mode: bank_account, credit_card, payments, payroll, loan, prepaid_card, accounts_receivable, accounts_payable.

parent_idstring

UUID of parent ledger for sub-accounts (e.g., 'Operating Expenses' → 'Office Supplies').

column_mappingobject

User-supplied mapping from DayZero field names to CSV column names. Keys: 'date', 'amount', 'description', and optional 'category' (aliases: ledger, ledger_name, account, account_name, category_name). Values: the CSV header to use. When provided, auto-detection is skipped.

Responses