Exporting your payment history data

  • Updated

You can export a payment report in the form of a CSV file, which contains all the details of processed payments (scheduled, in progress, completed, or failed) performed over a specific set of dates.

When you export a payment report, you’ll be provided with the following information:

Field Name

Description / Example

Melio payment ID

Unique payment identifier

Vendor name

Vendor name

Bill number

Vendor’s bill ID (as entered when bill was created)

Payment amount

The payment amount

Note to self

Any user-entered notes

Collection date

Date when the payment was first processed

Delivery date

For ACH bank transfers - the date the payment was received by the vendor

For paper checks - the date the check was sent to the vendor

Payment method

Available options are ACH bank transfer, debit card, or credit card

Delivery method

Available options are ACH bank transfer and check

Check serial number

Relevant for payments made by paper checks

Check status

Relevant for payments made by paper check

Available options are: sent, delivered, and deposited

Scheduled by

First and last name of the user who scheduled the payment

Approved by

First and last name of the user who approved the payment (for payments that require approval)

Memo to vendor

Notes left for the vendor

Payment status

Available options are:

In progress:

  • For payments delivered by ACH bank transfer, money was collected but not yet delivered
  • For paper checks, the check was sent but has yet to be deposited


  • ACH bank transfer was successfully delivered
  • Check was deposited
  • Funds were delivered to the vendor’s debit card


We failed to collect or deliver


For failed payments, the failure reason

Associated fees amount

The total amount of associated fees (i.e. credit card or fast payment fees)


How to export your payments report CSV:

1. Sign in to your Melio account.

2. Go to Settings.

3. Click Company settings.

settings-company settings.png


4. Under Payments report, click Create report.



5. In Download paid payments report, select a date range.

Notes: Maximize your report.

a. Check the box if you want to include scheduled payments.

b. The max range to choose from is 12 months in the past.

Download report.png


6. Click Download report


And that's it!

Was this article helpful?

0 out of 2 found this helpful

Have more questions? Submit a request