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:
On Payments, open the Unposted or Posted tab and appy your filters.
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.