Welcome to Zuora Product Documentation

Explore our rich library of product information

Download transaction details

Overview

This article explains how to download transaction details of a summary journal entry.

Note:

The Invoice Adjustment transaction is deprecated on Production.

Download transaction details

You can download transaction details from the journal entry page or the journal run page. The download link appears when the journal entry status is "Created".

If there are more are than 1,000 transactions in a journal entry, the download processes the transactions asynchronously and downloads on completion. For journal entry with less the 1,000 transactions, the download occurs in real-time.

Note:

If you want to download or export a large CSV file, Zuora recommends you to use text editors other than Microsoft Excel to open the file. The maximum row number that Excel supports is 1,048,576.

Download from the journal run page

Navigation to Finance > Journal Run. Click the journal run number to access the journal run page. Click [download] from a journal entry.

Download from an accounting period

Navigation to Finance > Accounting Periods and select an accounting period. Select the Summary Journal Entries tab. Click [download] from journal entry.

Export CSV file naming convention

JEExport_[Accounting Period Name]_[Transaction Type Included]_YYYYMMDDHHMMSS.csv

For example, JEExport_Apr14_Revenue-Event-Item_20140731141750.csv represents a journal entry export for the April 2014 accounting period that includes transactions for revenue event items. The CSV file was created on July 31, 2014 at 14:17:50 (military time).

Transaction details export

The following is an excerpt from an exported transaction details CSV file of invoice items for the August 2013 accounting period.

Example of Downloaded Transaction Detail

To know about the download sort order, refer to Download sort order.

Transaction detail columns

For information on transaction detail columns, refer to these topics: