Purchase Order Balance

This report summarizes the status of purchase orders on one or more projects, displaying committed and actual amounts as well as associated contractual changes. 

How to Use This Report

1. Select the language in which the report is displayed.
2. Select between  displaying results with or without taxes.
3. If you select "With taxes", a pop-up box will appear, allowing you to select the tax group that will be applied to the amounts displayed in the report. 
4. Once selected, the tax group will be displayed in the appropriate box, and amounts are automatically calculated with tax.
5. To modify the tax group, click on the Calculate taxes button. The pop-up box for selecting the tax group appears, and you can select another tax group.

6. Report data is sorted by project. You can also hide projects to group the display by suppliers.
7. If you use payment requests, you can include them in the report.
8. You can also display details of holdbacks. 

Column Details

A: Project title in Aidi, click on the - sign in front of the title to hide the lines related to this project and click on the + to display them again.

B: Name of suppliers for whom a purchase order with approved status and an invoice exist.

C: Purchase order reference: this number is displayed on the purchase order, payment request and invoice.

D: Purchase order date, as indicated on the purchase order.

E: Purchase order amount excluding billable contractual changes.

F: Purchase order amount including billable contractual changes, if any.

G: Remaining amount to be paid per purchase order (amount in column F - amount paid (column L)).

H: (If “payment request” section is displayed). Sum of approved payment requests associated with the purchase order.

I: (If “payment request” section is displayed). Difference between payment requests and invoices: Sum of payment requests (column H) - invoice amount excluding deductions (column M). 

J:  Invoice date

K: Invoice reference as indicated in Aidi

L: Amount paid = Amount invoiced - Contractual deductions - Internal deductions + Payment of contractual deductions + Payment of internal deductions. The total amount per supplier per project is displayed in bold.

M: Invoice amount without consideration of holdbacks

If the holdback details section is displayed :

N: Internal holdbacks amount

O: Contractual holdbacks amount paid

P: Internal holdbacks amount paid

Q: Contractual holdbacks amount

✏️Note: Operating expenses are now included in this report. They are grouped under a fake purchase order and grouped under the relevant supplier (when supplier is defined). Data such as the date or amount of the operating cost are indicated in the “Invoice” columns. The columns that are not relevant (such as Payment request or holdbacks) are left empty.