Welcome to Zuora Product Documentation

Explore our rich library of product information

Payment export

Export all payments that match your current tab and filters to a CSV file, and review key columns and formatting considerations.

Export downloads every payment matching your current tab and filters as one CSV file, across all pages.

No setting is needed. The Export button is available on the new Payments List to Cash Application Agents, Admins and Global Admins. If you do not see it, contact Zuora Global Support.

Export payment

To export payment:

  1. On Payments, open the Unposted or Posted tab and appy your filters.

  2. Click Export.

    The file downloads automatically when ready. You also get a notification with a download link, valid for 24 hours.

What is in the file?

Every payment, your tab, filters, and column search return at the moment you click Export.

Split payments appear as their child payments only.

Bank account numbers appear as display names only, for example JPMorganChase ending with 0823.

Column reference

The following table lists all columns in the payment export file and describes the data in each one:

Column

Description

Payment ID

Zuora payment identifier

Customer Name

assigned customer; "Unknown" when unassigned

Customer Number

customer's ERP number; blank when unassigned

Payment Date

date the payment was received

Payment Reference #

bank or check reference

Payment Description

full bank narrative or memo

Payment Mode

ACH, Wire, Check, Card, etc.

Payment Source

Bank Sync, Lockbox, Manual Import, etc.

Bank Account No.

receiving bank account, display name only

Lockbox

lockbox number (lockbox payments only)

Batch

lockbox or deposit batch number (lockbox payments only)

Remittance Source

Email, Portal, Bank Statement, Lockbox or None

Payment Currency

ISO currency code, for example USD

Payment Amount

amount in payment currency

Payment Amount (Base)

amount in your base currency

Applied Amount

amount applied to invoices

Unapplied Amount

amount not yet applied

Payment Status

Posted or Unposted

Payment Adjustment

total write-offs, discounts and custom adjustments

Apply Status

Unapplied, Partially Applied, Applied, etc.

SmartMatch AI Status

match status, including Processing

Sync Status

Synced or Not Synced

Source Payment ID

ERP internal ID; blank on Unposted

Source Payment #

ERP payment number; blank on Unposted

ERP Posted Date

when the payment last posted successfully

Auto-Posted

Yes when posted automatically

Applied Invoices

invoice numbers, separated by;

Applied Credit Memos

credit memo numbers, separated by;

Chart of Account

deposit or undeposited funds account

Subsidiary

subsidiary name

Parent Payment ID

original payment a split payment came from

Import Date

when the payment entered Zuora

Applied Date

when the payment was last applied

Applied By

user who applied it; "System" for auto-apply

Last Activity Date

last update to the payment

Custom fields

one column per active payment custom field

Key considerations

Keep the following in mind when working with the payment export file:

  • Dates are YYYY-MM-DD and amounts are plain numbers with 2 decimals, in your account timezone.

  • In Excel, open the file via Data > From Text/CSV and set reference and ID columns to Text to keep leading zeros.

  • Columns are fixed and can't be chosen. To export fewer rows, narrow your filters.

  • You can run one Payments export at a time. If an export fails, click Retry.