Knowledge Center

Knowledge Center > Finance > Summary Journal Entries > Download Transaction Details

Download Transaction Details

Overview

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

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 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.

Download from the Journal Run Page

Navigation: Finance > Accounting Periods and select the Journal Run tab. Click the journal run number to access the journal run page. Click [download] from a journal entry. 

Download Transaction Details from a Journal Run View

Download from an Accounting Period

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

Download from Summary Journal Entries tab on Accounting Period or Journal Entry View

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

Download Sort Order

Transactions are downloaded in the order listed.

All Transactions, except for Revenue
  • Account Name
  • Transaction Date
  • Transaction Type
  • Transaction Subtype
  • Transaction Number
Revenue Event Item Transactions
  • Account Name
  • Revenue Schedule Date
  • Transaction Type
  • Transaction Subtype
  • Revenue Schedule Number

Transaction Detail Columns

Transaction Subtypes

Transaction subtypes further qualify transactions. Transaction types for billing, cash, and credit balance transactions have a set of transaction subtypes. For example, an invoice transaction can be a charge, discount, prepayment, or tax.

Transaction Type Transaction Subtype

Invoice Item

  • Charge
  • Discount
  • Prepayment
  • Tax
Taxation Item None.

Invoice Item Adjustment

  • Credit
  • Charge

Invoice Item Adjustment Tax

  • Credit
  • Charge

Invoice Adjustment 

  • Credit
  • Charge

Payment 

  • Electronic
  • External

Refund

  • Electronic
  • External

Credit Balance Refund (electronic or external)

  • Decrease

Credit Balance Payment (electronic or external)

  • Increase

Credit Balance (applied to invoice)

  • Decrease

Credit Balance (transferred from invoice)

  • Increase

Revenue Item

None.

See the table at the end of this article for more information.

Associated Transaction Types

Certain transaction types, such as invoice item adjustments or refunds, have a one-to-one relationship with another transaction type. The following table show how certain transaction types map to an associated transaction type.

Each associated transaction type has a corresponding associated transaction subtype. These subtypes are the same as those documented in the previous Transaction Subtypes table. For example, the associated transaction subtypes for Invoice Item Adjustment are Credit and Charge.

Transaction Type Associated Transaction Type
Invoice Invoice Item Invoice Payment Payment Refund Taxation Item
Credit Balance (applied to invoice) File:Z_Media/checkmarkGreen_xsm.png          
Credit Balance (transferred From invoice) File:Z_Media/checkmarkGreen_xsm.png          
Credit Balance (electronic payment)       File:Z_Media/checkmarkGreen_xsm.png    
Credit Balance (external payment)       File:Z_Media/checkmarkGreen_xsm.png    
Credit Balance (electronic refund)         File:Z_Media/checkmarkGreen_xsm.png  
Credit Balance (external refund)         File:Z_Media/checkmarkGreen_xsm.png  
Invoice Adjustment File:Z_Media/checkmarkGreen_xsm.png          
Invoice Item Adjustment   File:Z_Media/checkmarkGreen_xsm.png        
Invoice Item Adjustment (tax)         File:Z_Media/checkmarkGreen_xsm.png  
Payment (electronic) File:Z_Media/checkmarkGreen_xsm.png          
Payment (external) File:Z_Media/checkmarkGreen_xsm.png          
Refund (electronic)     File:Z_Media/checkmarkGreen_xsm.png      
Refund (external)     File:Z_Media/checkmarkGreen_xsm.png      
Tax   File:Z_Media/checkmarkGreen_xsm.png        

The following table lists the transaction types that are only available if you enable the Advanced AR Settlement feature and Invoice Item Settlement feature. It also shows the corresponding transaction subtype, associated transaction types, and container transaction types. 

Each associated transaction type or container transaction type has a corresponding associated transaction subtype or container transaction subtype. These subtypes are the same as those documented in the previous Transaction Subtypes table.

Transaction Type Transaction Subtype Associated Transaction Type Container Transaction Type

If you enable the Advanced AR Settlement feature, Debit Memo Item, Credit Memo Item, and Credit Memo Application Item are available, Payment and Refund will be replaced by Payment Application and Refund Application.

The Advanced AR Settlement feature is in Limited Availability. This feature includes Unapplied Payments, Credit and Debit Memo, and Invoice Item Settlement. If you wish to have access to the feature, submit a request at Zuora Global Support

Debit Memo Item Charge  None Debit Memo
Tax None Debit Memo
Credit Memo Item Charge None Credit Memo
Tax None Credit Memo
Credit Memo Application Item

On-Account to Invoice Item

Invoice Item Credit Memo
On-Account to Invoice Taxation Item Taxation Item Credit Memo
On-Account to Debit Memo Item Debit Memo Item Credit Memo
On-Account to Debit Memo Taxation Item Debit Memo Item Credit Memo
Invoice Item Reversal Invoice Item Credit Memo
Invoice Taxation Item-Reversal Taxation Item Credit Memo
Debit Memo Item Reversal Debit Memo Item Credit Memo
Debit Memo Taxation Item Reversal Debit Memo Item Credit Memo
Payment Application

Invoice

Invoice Payment
Invoice Reversal Invoice Payment
Unapplied None Payment
Transferred None Payment
Transferred to Unapplied None Payment
Unapplied to Invoice Invoice Payment
Debit Memo Debit Memo Payment
Debit Memo Reversal Debit Memo Payment
Unapplied to Debit Memo Debit Memo Payment
Refund Application

Unapplied Payment

Unapplied Payment Refund
Credit Memo Credit Memo Refund

If you enable both the Advanced AR Settlement feature and the Invoice Item Settlement feature, Payment and Refund will be replaced by Payment Application Item and Refund Application Item.

The Invoice Item Settlement feature is in Limited Availability. If you wish to have access to the feature, submit a request at Zuora Global Support

Payment Application Item Unapplied None Payment
Invoice Item Invoice Item Payment
Taxation Item Taxation Item Payment
Debit Memo Item Debit Memo Item Payment
Invoice Item Reversal Invoice Item Payment
Taxation Item Reversal Taxation Item Payment
Unapplied to Invoice Item Invoice Item Payment
Unapplied to Taxation Item Taxation Item Payment
Debit Memo Item Reversal Debit Memo Item Payment
Debit Memo Taxation Item Reversal Debit Memo Item Payment
Unapplied to Debit Memo Item Debit Memo Item Payment
Unapplied to Debit Memo Taxation Item Debit Memo Item Payment
Refund Application Item Credit Memo Item Credit Memo Item Refund
Unapplied Payment Unapplied Payment Refund

Transaction Details for Revenue Event Items

The set of data exported for a revenue event item differs from all other transaction exports. Key differences include:

Column Revenue Event Item
Transaction Type The transaction that created the revenue event item.
Transaction Subtype The transaction subtype of the transaction that created the revenue event item.

The Revenue event item download includes data related to revenue schedules and additional revenue event details. 

Last modified
22:08, 10 May 2017

Tags

Classifications

(not set)