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:
Description / Example
Melio payment Id
Unique payment identifier
Vendor’s Bill ID (as entered when bill was created)
The payment amount
Note to self
Any user-entered notes
Date when the payment was first processed
For ACH payment - the date the payment was received by the vendor
For Paper Checks - the date the check was sent to the vendor
Available options are ACH transfer, Debit card or Credit card
Available options are ACH and Check
Check serial number
Relevant for payments made by paper checks
Relevant for payments made by paper checks.
Available options are: Sent, Delivered (coming soon) and Deposited
First and last name of the user who scheduled the payment
First and last name of the user who approved the payment (for payments that required approval)
Memo to vendor
Notes left for the vendor
Available options are:
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)
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 email@example.com.