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.