Declarations and discharges

This report allows you to extract declarations and discharges related to one or more projects. The goal of this report is to allow the user to consolidate declaration data in order to compare the declarations/discharges of direct subcontractors (level 2) with those of the subcontractors’ suppliers (level 3 and above). These amounts can also be compared against the remaining amount payable on the contract awarded to the main supplier (level 1) to determine whether upcoming invoices can be paid in accordance with your policies for managing declarations and discharges from your suppliers.

Report Description

The report is essentially made up of a pivot table whose displayed data can be filtered in the left panel (see point 4):

1. The rows and totals of the pivot table are sorted by project and then by supplier.
2. Direct (level 2) and indirect (level 3) subcontractors are distinguished in two ways in the table:
   1. By an additional indent for each subcontractor level.
   2. The amounts shown in the first 3 columns are for direct level 2 subcontractors, while the last 3 columns are reserved for the subcontractors’ suppliers (level 3 and above).

Example: Dufault is a direct subcontractor (level 2) and Atmosphare is a supplier of Dufault (level 3).

3. The purchase order balance due represents the sum of the revised amounts of the level 1 supplier’s purchase orders, minus the sum of the approved invoices associated with the suppliers on this specific project.

4. It is possible to filter the table entries by project and by supplier to limit the data displayed in the main table.

5. If the expected discharge from a subcontractor’s supplier is negative (declared amount lower than received discharges), the amount and the subcontractor will be shown in red to highlight a potentially abnormal situation to the user.

   

6. It is possible to show/hide the initial declared amount as well as the adjustment amount. By default, these columns are hidden.

7. Percentage of Discharge Received : Represent the Total Amount of Discharge Received / Total Declared Amount . The number is rounded to 0 decimal.

   1. For example : 28,235.35$ / 193,623.48$ = 15%

8. Purchase Order Balance Due : Represent the sum of the revised amounts of the level 1 supplier’s purchase orders