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:
Completed:
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) |
How to export your payments report CSV:
1. Sign in to your Melio account.
2. Go to Settings.
3. Click Company settings.
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.
6. Click Download report.
And that's it!