Purchase Orders List

Displays the bills list, sorted by supplier, with the total invoiced, due, and paid amounts.

4 widgets present similar data:

• Purchase orders list is the larger widget, presenting the paid, due, and invoiced amounts for each customer.
• Paid purchase orders displays only amounts paid to each supplier.
• Due purchase orders displays only the amounts due to each supplier.
• All purchase orders displays only the amounts invoiced by each supplier.
  

By hovering the supplier's name, a tooltip will appear and display the list of invoices issued by this supplier.

Calculation

Only bills at statuses PAID, AUTHORISED, SUBMITTED, and DRAFT will be taken into account.

A bill is considered as paid when its balance is equal to $0.0, due when its balance is equal to its balance is equal to the invoiced gross amount, and partially paid when its balance is between $0.00 and the invoiced gross amount.

Settings

The number of suppliers displayed can be limited by selecting a number of entries on the top of the widget.

By selecting a different time period in the settings section (top-right cogwheel), only the bills issued between the two dates will be taken into account.

In Xero menu: Reports > All reports > Detail Reports > Supplier Invoice Report.

“Sort by” should be set as “Contact”. Make sure the time range matches the current year. 

Noticeable differences with the Impac! widget

Impac! does not deduct the Credit Notes from the total, and the credit notes do not appear in the tooltip.

QBO proposes 2 different reports: “Unpaid Bills” and “Bill Payments List”. You will need both of them to match the Impac! widget. Be careful with the “Bill Payments List” which displays Bill Payments and not Bills.

Set the QBO date parameter to “All dates”.

Customize the QBO reports: click on “Customize”, select “Vendor” in the field “Group By” then run the report.

Noticeable differences with the Impac! widget

The QBO report “Bill Payments List” displays “Bill Payments”, not “Bills”. This means that the signs are different and the vendor credits are included in the QBO report.

MYOB Suppliers Purchases report is located under Reports > Index to Reports > Sales > Supplier > Purchases.

The MYOB report dates range must match the dates picked in the Impac! settings section.