In this article, you will learn how to generate an Invoice Detailed Listing report in Corpay Complete. The Invoice Detailed Listing report provides information about all invoices in a specific date range.
1. Log in to Corpay Complete.
2. Select the Reports menu item from the left-side navigation pane.
NOTE: The visibility of pages and information in Corpay Complete is based on roles and permissions assigned to users by a company as well as company configuration. As a result, the pages in your left-side navigation pane may be different from the pages in the image above.
3. On the Reports page, select the Create New Report button.
4. On the Create New Report page, select Invoice Detailed Listing from the Report Type drop-down.
5. Enter a report title in the Title field.
6. Select an export format for the report from the Export Format drop-down.
- Microsoft® Excel File (XLSX)
- Comma-Separated Values File (CSV)
7. Select a delivery method to receive the report from the Export Destination drop-down.
- Download: Receive the report via download.
- Email: Receive the report via email.
- Secure File Transfer Protocol (SFTP): Receive the report via SFTP.
8. Check the Exclude Header Description checkbox to exclude header descriptions from the report. To include header descriptions, leave the checkbox blank.
9. Select a data filter for the invoices from the Data Filter Type drop-down:
-
Invoice Date: Filter invoices by the actual date of the invoice.
- Submit Date: Filter invoices by the date when the invoice was submitted.
10. Use the date picker to enter a date in the Start Date field.
11. Use the date picker to enter a date in the End Date field. By default, the End Date field populates with the current date.
12. In the Vendor Name field, enter a vendor's name to search for a vendor or leave blank to include all vendors.
13. Select the Status drop-down and choose which invoice statuses should be included in the report:
- All: Include all invoices, regardless of status.
- Draft: Only include invoices that are in a draft state.
- New: Only include invoices that were recently uploaded by a vendor or Admin user.
NOTE: The New status is not pushed to your ERP system.
- Pending: Only include invoices that are in the approval workflow but have not received all necessary approvals.
- Approved: Only include approved invoices.
- Open: Only include invoices that were approved with an open balance and are waiting to be connected to a purchase order (PO) or accrual.
- Paid: Only include paid invoices.
- Closed: Only include invoices that were closed, either because they did not require a payment or were created mistakenly.
- Rejected: Only include invoices that were rejected, either because they do not match the associated PO or are considered fraudulent.
14. Select the Has External ID drop-down and choose one of the following options:
- All: Include all invoices, regardless of external ID.
- True: Only include invoices with an external ID.
- False: Only include invoices without an external ID.
15. Click the Submit Report button.
16. The Report Status table will display.
17. When the Status column changes to Completed, click the Download icon to view and download the report.
Comments
0 comments
Please sign in to leave a comment.