Through this report, you receive for all open and arrived contracts within the selection of pools that entirely or partially overlap with the reporting period (by default set to today +/- 2 weeks) an overview of the payments to be made by the customer and the payments already made by the customer. Here, both the already invoiced amount and the total amount to be paid on the respective contract are considered. The deposit and the already executed refunds to the customer are also taken into account. Therefore, this report provides a clear overview of the amounts we may still expect from the customer, but also of the amounts that still need to be refunded to the customer.
Via the filter bar on the left side of the screen, you can further refine the report and:
- Adjust the reporting period
- Adjust the selection of pools for which you wish to see the contracts in the report
- Adjust which contract statuses you want to see in the report
- Set that you want to limit the report to contracts with a specific payment preference (both for regular payments and deposit payments)
- Indicate that you want to see only those contracts for which the balance is positive, negative or equal to 0 (or a combination)
The report shows the following information:
| FIELD NAME | CONTENT |
|---|---|
Contract | ID of the respective contract. |
Customer name | Name of the main client on the contract. |
License plate | License plate of the respective resource. |
Resource | Description of the respective resource. |
Contract status | Status of the respective contract. |
Planned start | Date and time of the planned start of the respective resource on the respective contract. |
Actual start | Date and time when the respective resource effectively departed under the respective contract. |
Payment preference deposit | Shows the payment preference for the deposit as indicated on the respective contract. |
Deposit to be paid | The deposit to be paid as indicated on the respective contract. This is the calculated deposit, unless it was manually overridden. |
Deposit paid | Sum of the deposit that was actually paid on the contract and the authorizations given for deposit payment. |
Deposit balance | The difference between, on the one hand, the deposit to be paid and, on the other, the deposit paid. |
Outstanding deposit | This is the total amount of deposit already paid that must still be returned to the customer. The way this amount is calculated depends on the setting for the deposit settlement. Through the information icon in the column title of the report, you can find out how this amount is calculated in your situation. |
Payment preference contract | Shows the payment preference for the amount to be paid on the contract as indicated on the respective contract. |
Price incl. VAT | Sum of the price incl. VAT for the different price lines on the contract. |
Already paid | Sum of all payments on the contract. This means:
|
Balance on contract | This is the difference between, on the one hand, the amount due on the contract (see "Price incl. VAT") and, on the other, the sum of payments already made. Here too, the calculation depends on the setting for the deposit settlement. If the deposit is settled on the final invoice, the payments of the deposit will be included in the sum of the payments on the contract, otherwise not. Again, you can find out behind the information icon in the column title how the calculation is done in your situation. |
Invoiced | Here the total amount already invoiced is shown. As long as no final invoice has been created for the contract, the shown amount matches the sum of the invoiced price lines on the contract. Once the final invoice is created, however, the calculation will depend on the setting regarding the deposit settlement. If the deposit is settled on the final invoice, the paid and refunded deposit will be included in the calculation of the already invoiced amount, otherwise not. Again, the information icon shows you how this calculation is done in your situation. |
Balance on invoiced | The difference between the total invoiced amount (see "Invoiced") and the amount already paid (see "Already paid"). |
Refunded | Sum of the refunds already executed on the contract. This includes:
|
Amount owed to customer | Here the amount you still owe the customer for the respective contract is shown. This can be a refund of the deposit or an excess amount the customer has paid. When calculating this amount, the setting for the deposit settlement is again taken into account. The amount owed to the customer = the amount effectively paid by the customer - the amount owed by the customer - any refunds made
|