Power BI purchase order dashboard: spend and status

A Power BI purchase order dashboard should separate approved commitments, received goods, and invoiced spend before comparing suppliers. Its central check is that current approved order value equals invoiced value plus the remaining uninvoiced commitment, using the same cutoff and valuation basis.

Microsoft describes a Power BI dashboard as a single page of highlights, with detail available in related reports. For purchasing, those highlights should reveal what is still due, what awaits an invoice, and which supplier owns the balance. Covirage is not affiliated with Microsoft, the maker of Power BI and Excel.

Define spend and open status before drawing the page

Consider an illustrative Wisconsin manufacturer reviewing purchase orders on October 23, 2026. Its procurement export lists original approved value, approved cancellations, receipts, and posted invoices for each order. This example uses invoiced value as actual spend; it does not treat invoicing as cash payment.

All values use the same order prices and are net of sales tax. There are no foreign currencies, price variances, returns, or invoices before receipt in this example. Those conditions matter because they allow the balances below to divide cleanly into received and unreceived amounts.

Microsoft's purchase-order overview distinguishes received and invoiced statuses and explains that partially received or partially invoiced orders can retain an open-order status. A status label alone therefore cannot tell a reviewer how much value is still outstanding.

The buyer owns expected receipt dates and supplier follow-up. Accounts payable owns the invoice export. Finance confirms how receipts awaiting invoices are reflected in the accounting records. Agree on these responsibilities before asking one owner to explain every open balance.

Start with an order-level worked example

The following table is the complete order population. Receipt and invoice values are cumulative through the cutoff. The due date applies to the order's remaining receipt balance.

The cancellation on PO-403 reduces the authorized commitment, rather than creating a supplier invoice or a receipt. Current approved value is original approved value less approved cancellations.

Uninvoiced commitment = Current approved value − Invoiced value

Unreceived value = Current approved value − Received value

Received, not invoiced = Received value − Invoiced value

PO-401 illustrates why separate balances help. Its $12,000 uninvoiced commitment includes $6,000 of goods still to arrive and $6,000 already received without a posted invoice. Procurement and accounts payable need different follow-up lists even though both amounts belong to the same order.

Reconcile the commitments and supplier comparison

First prove the authorized population: 100,000 original value − 5,000 cancellations = $95,000 current approved value. Then prove its disposition: 63,000 invoiced + 32,000 uninvoiced = $95,000.

The open commitment also reconciles: 26,000 unreceived + 6,000 received but not invoiced = $32,000. Finally, received value ties as 63,000 invoiced + 6,000 received but not invoiced = $69,000. These identities rely on the common valuation basis and no-prebilling assumption stated above.

Group those same rows by supplier:

The supplier totals match the order totals in every value column. Atlas has the largest uninvoiced commitment, but Cedar's entire order remains unreceived. The table supports those observations without assuming either supplier has caused the delay.

Invoiced spend is 63,000 / 95,000 = 66.3% of current approved value. The uninvoiced commitment is 32,000 / 95,000 = 33.7%. Percentages are rounded to one decimal place after division, using current authorized value rather than the original order amount.

For the general purchasing layout, use the purchase order dashboard. The broader Power BI dashboard examples cover other business views without changing these purchasing definitions.

Change one invoice input

Now increase PO-401's posted invoice value from $18,000 to $21,000. Change that input alone. There is no new receipt, cancellation, or order revision.

The invoice difference is 21,000 − 18,000 = $3,000. PO-401's uninvoiced commitment becomes 30,000 − 21,000 = $9,000, and its received-not-invoiced balance becomes 24,000 − 21,000 = $3,000. Total invoiced spend is 63,000 + 3,000 = $66,000, or 66,000 / 95,000 = 69.5% of approved value.

The revised checks are 66,000 + 29,000 = $95,000 and 26,000 + 3,000 = $29,000. Physical receipt exposure does not move when an invoice posts.

Put the supplier follow-up beside the totals

Show current approved value, invoiced spend, and uninvoiced commitment first. Then split the remaining commitment into unreceived and received-not-invoiced value. Place the supplier comparison next to an order list with due dates and an owner for each exception.

At the stated cutoff, PO-401 and PO-404 have overdue unreceived balances of $6,000 and $10,000. Their total is $16,000, while PO-402's $10,000 unreceived balance is not yet due. PO-403's past due date creates no outstanding receipt exception because its remaining receipt balance is zero.

Use the Excel dashboard guide if the review stays in a spreadsheet. The Power BI operations dashboard is the neighboring view for broader operating performance; keep this page centered on purchase commitments and spend.

Where it goes wrong

• Combining order and invoice values as spend. They describe successive stages of the same purchase, so addition double counts the commitment.
• Repeating order totals across invoice rows. An order with several invoices must not contribute its approved value repeatedly.
• Ignoring cancellations. Original order value overstates the live commitment after an approved reduction.
• Equating invoicing with payment. Cash timing requires payment records and cannot be inferred from this export.
• Mixing valuation bases. Taxes, freight, price differences, and prebilling can break the simple receipt-to-invoice bridge and need explicit treatment.

Reconcile your purchasing file in Covirage

Bring a sample of your own order, receipt, and invoice export with order identifiers and supplier names. Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the balances with every figure traced to its rows. Create a free Covirage account; creating the account takes about a minute, then you set up your business and bring your file.

See Covirage for procurement teams for the supporting purchasing context.