The payment allocation report provides full visibility of payments and adjustments that have been recorded against your agreements in the Finance app.
This article will guide you through:
- Accessing the payment allocation report
- Filtering the payment allocation report
- Displaying the payment allocation report results
Looking for something else?
- Looking to generate a different report in the Finance app? Learn more about the Finance app here.
- Alternatively, see our Help Center for more on Trading Programs.
Accessing the payment allocation report
To access the payment allocation report:
Step 1: Click on Finance in the green banner at the top of the page.
Step 2: Click on Payment allocation in the drop-down menu.
Note: If the Finance menu is not available, a channel admin user at your organization will need to provide you with the correct user permissions.
Here, you can search for an overview of earnings, payments, adjustments and resulting balance per payment line. Learn more about the filters available below.
Filtering the payment allocation report
In the panel on the right side of the page, you can filter the search results using the following criteria:
- Search by program line or trading program: Type a program line or trading program name or reference to only display specific agreements.
- Trading partner: Click on the hamburger icon to select one or more trading partners from the All trading partners tab; this includes all trading partners you have access to read. The second tab will allow you to select multiple trading partners at once based on their attributes. Alternatively, use the My trading partners tab to only display and select from trading partners where you are the lead cash collector or the account contact.
- Program line types: Choose from the list of program line types configured for your channel.
- Agreement types: Choose from the list of trading program types configured for your channel.
- Agreement start date from: Select a date to only include trading programs with a start date on or after the selected date. If left blank, the report results will include trading programs with start dates for all dates.
- Agreement start date to: Select a date to only include trading programs with an end date on or before the selected date. If left blank, the report results will include trading programs with end dates for all dates.
- Due date from: Select a date to only include trading programs that contain at least one payment line with a due date on or after the selected date.
- Due date to: Select a date to only include trading programs that contain at least one payment line with a due date on or before the selected date.
- Program month: Choose a month to filter program lines with payment lines ending in that month. This will only display the payment lines that end in that month, even if there are additional payment lines for the program line.
- Payment frequency: Choose a payment frequency to filter program lines by.
- Manually maintained earnings only: Set the checkbox to only display program lines which use manually maintained earnings mechanisms.
- Show fully signed only: Set the checkbox to only display trading programs which are fully signed.
- Show archived: Set the checkbox to include trading programs which have been archived and are no longer active.
- Only show final lines with external earnings: Set the checkbox to only display program lines which have been marked as final.
Once you have selected your search filters, click the Search button in the lower right of the page to display the payment allocation report results.
Tip: Your search criteria will be persisted for the duration of your session. Click the Reset button to clear the criteria.
Displaying the payment allocation report results
The payment allocation report displays details of each program line’s earnings, allocated payments, and adjustments.
Scroll to the right of the report to view additional columns including earnings, amount paid, and balance due.
You can also view these details at the payment line level by clicking on a program line in the report. This displays the payment lines panel associated with the selected program line and includes further payment details about each line.
Click the Download button at the bottom of the screen to save a CSV file of the report results. This file will be at the payment line level and will contain all the columns displayed in the payment allocation report, as well as the details displayed when clicking into a program line to view the associated payment lines.
What’s next?
Ready to record a payment or receipt? Learn how to manage payments and more in the Finance app here.
Interested in viewing your payment history? Learn how to view the payment history report here.