Creditor Payments Due Report
Creditor Pre-Payments Due report
This report generates a list of the Payments due to creditors.
These are the field headings in the report:
Provider Name, Trip Code, Tour Description, Number of PAX, Date at, Payment Terms, Total Value, Paid, Balance Due, Balance Due Date, PrePay Total, Paid Deposit, Paid Balance, Method
Defining your report
Users have a large amount of control over what information the report contains,
-
From the Main Menu | Finance | Reports | select Creditor Pre Payments Due
- Select the season this report relates to
- Tick the tickbox if only released departures should be included in this report
- Select the due date from and due date to required for this report
- Select any specific trails
- Select any specific masters, if required, to narrow down your findings
- Alternatively enter the Trip Code of a specific trip, to report on only that trip
Sorting the Data
- The report can be sorted by Provider Name, Date at, or Balance Due date.
- when sorting by Provider or Tour Code, there will be a line break separating each Provider or Tour Code - to help make the screen easier to read
Exporting the data
- Click the export button to export the report into .tsv format, so rthat you can manipulate the data yourself. Learn more about .tsv here
This report is based on
- the Provider | Finance/Prices settings, prepayment % required and # days prior date due?
- plus the date range and L1's selected when running the report
- + any Trip level values which are on that Provider Payments Trip tab
Any payment details must be recorded on the Provider Info | Payments tab of the Trip / Accommodation record, in order for this report to present accurate and meaningful results.

Note; that there is some suggested data needed for this report to work:
- Supplier | Finance Prices Tab - Your supplier prices, including the W/S (Wholesale) prices will need to be entered into Odyssey.
Note: Values can be manually entering into the Departure record - but it would be more efficient if these rates were entered 'once' against the Supplier, so this could auto calculate for you.
-
Supplier | Finance Prices Tab - Supplier prepayment % (This is optional, however)
- Supplier | Finance Prices Tab - Balance Due # days prior date due (This, also is optional)
