Skip to content
/Templates and Exports

Templates and Exports

Download the CSV upload template and export entries, lines, schedules and waterfall entries as CSV.

Operations

Download the CSV upload template

Request

Purpose

Downloads the combined CSV template for POST /journal-entries (multipart). Row 1 holds the header column titles; fill row 2 with the header values, keep the blank line, then add one row per line under the line column titles. Column titles are matched case-insensitively ignoring spaces and punctuation; both friendly titles (for example Account Code, Debit) and legacy codes (for example DR_SEGMENTS, AMOUNT) are accepted. Reference columns show your tenant's labels; rename them to Reference1 ... Reference15 before uploading.

When to use

  • Before preparing a CSV upload: get the exact column layout expected by POST /journal-entries (multipart).
Security
OneIdOAuth
cURL
curl -i -X GET \
  https://one.zuora.com/revenue/services/v1/journal-entries/template \
  -H 'Authorization: Bearer <YOUR_TOKEN_HERE>'

Responses

CSV template (je-template.csv)

Headers
traceIdstring

Identifier of the request. Quote it when you contact Zuora Support.

Content-Dispositionstring

Attachment file name, for example attachment; filename="je-list.csv".

Bodytext/csv
string
Response
Name,Description,Category Code,Ex Rate Type,Period Name,Reversal Period Name,SOB Name,SOB ID,Functional Currency,Book Id,Org Id,GL Transfer,Rev Rec Type,Account Method,Approval Currency


Set No,Account Type,Account Code,Currency,Debit,Credit,Ex Rate Date,Functional Ex Rate,Global Ex Rate,Start Date,End Date,So Line Id,Unbill Flag,Description,Rc Id,Rc Line Id,SO Number,Type Name,Cost Or Vc Type,Reference 1,...,Reference 15,Comments