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 |
| pay business bills 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 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 check |
| Check status |
Relevant for payments made by 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) |
To export your payments report CSV:
1. Go to Settings.
2. Click Company settings.
3. Scroll down to Payments report, click Create report.
4. In Download paid payments report, select a date range.
NOTES:
- Check the box if you want to include scheduled payments.
- The max range to choose from is 12 months in the past.
5. Click Download report.
And that’s it!