How Do I Export Payments Data to CSV?

Last Updated:
March 27, 2017

Your payment history can be exported as a CSV for reporting and payment reconciliation. At the bottom of the "Payments" page just tap the “Export to CSV” button:

To generate a payment report for a single contractor, select the contractor in the filter first and then click the "Export to CSV" button:

When exporting we'll ask you if you only want to export the specific Payments Page you were viewing or All Payments:

Tap on "Generate CSV" so we can start generating your Payments CSV file. When your download is ready, we will provide you with the link, or in a notification at the bottom of your screen. We will also email a secure link to you, so feel free to leave the app while we are generating your payments export.

Payments CSV Format

Here is a sample file of the generated CSV: Payable Payments Sample CSV.

The format of the CSV is straightforward. The header consists of the following columns:

  • Payment ID
    The ID of the payment in the Payable system.
  • Payable Worker ID 
    The ID of the worker in the Payable system.                                                                       
  • External Worker ID 
    The unique ID of the worker in your system.                                                                                     
  • Contractor 
    The worker's first and last name.
  • Email 
    The worker's first and last name.
  • Payment Amount (USD)
    The total amount of the payment, excluding any transaction fees.
  • Payor Fee (USD)
    The portion of the transaction fee paid by you, the company.      
  • Withdrawal Amount (USD)
    The amount that will appear on your company's bank statement for the transaction.   
  • Payee Processing Fee (USD)
    The portion of the transaction fee paid by the worker.
  • Deposit/Check Amount (USD)
    The amount that was paid to your worker.                 
  • Work Type Breakdown Amounts 
    The amounts for each work type on the payment.  Eg: Hours, Expenses.
  • Flat Rate Amount 
    The sum of all flat rate amounts on the payment.    
  • Status
    The status of the payment. Eg: Paid, Draft Ready.
  • Period Start Date
    The beginning of the pay period, or the date of the oldest work entry on the payment. Does not apply to Flat Rate Payments.
  • Period End Date
    The end of the pay period, or the date of the most recent work entry on the payment. Does not apply to Flat Rate Payments.
  • Date Sent 
    Date when the payment was sent to your worker.         
  • Date Debited
    Date the payment was debited from your company bank account. Only applies to ACH transactions.
  • Date Paid
    Date when the payment was sent to your contractor's bank account, or the expected arrival date of a mailed check.
  • Payment Method 
    The payment method used to pay your worker. Eg: ACH, Check.
  • Check Number 
    The number of the check that was mailed to your worker. Only applies to Mailed Check transactions.
  • Notes
    Freeform notes associated with the payment.

If you have any further questions about the information in the Payments export, feel free to reach out to support@payable.com.

Pay your contractors with Payable!

$0.99 per payment

Start paying now!