You can export a payment report in the form of a CSV file, which contains all the details of processed payments (completed, in progress, 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 payment - 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 transfer, Debit card or Credit card

Delivery method

Available options are ACH and Check

Check serial number

Relevant for payments made by paper checks

Check status

Relevant for payments made by paper checks.

Available options are: Sent, Delivered (coming soon) 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 required approval)

Memo to vendor

Notes left for the vendor

Payment status

Available options are:

In progress:

  • For payments delivered by ACH, money was collected but not yet delivered

  • For paper checks, the check was sent but has yet to be deposited

Completed:

  • ACH was successfully delivered

  • Check was deposited

  • Funds delivered to the vendor’s debit card

Failed:

We failed to collect or deliver.

Notes

For failed payments, the failure reason

Associated fees amount

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

To export your payments report CSV, go to Settings -> Company settings, and under "Payments report" click “Create report”:

You’ll be asked to select a date range for payments information you’d like to download:

** Note that the max range to choose from is the past 12 months.

And that’s it!

For any other questions, contact support@melio.com.

Did this answer your question?