Fourth Analytics: Inventory Dashboards (Purchase Reconciliation & Invoice Reconciliation)

Purchase Reconciliation Tab

The Purchasing Reconciliation tab reconciles the number and value of orders raised against those actually received, helping identify purchase orders that are missing, outstanding, or awaiting a goods received note (GRN).

This tab includes:

• Filters for organisational hierarchy, location, stock location, cost centre, category groupings, product, supplier, date, PO number and document ID
• An Orders not Received by Month chart showing the number and value of orders raised that have not yet been received
• A Reconciliation - Ordered vs Received panel that walks through Orders Raised, orders raised outside the period, and missing POs, reconciling this against Orders Received, orders received outside the period, orders Not Received, and missing GRNs
• A Supplier Order Reconciliation detail report (available on request, as it is too large to display by default)
• An Orders Not Invoiced by Month chart and a Reconciliation - Received vs Invoiced panel, following the same reconciliation logic through to invoicing
• A Supplier Receiving Reconciliation detail table showing received and invoiced values by PO reference and the number of days since receipt
• A No PO Reference panel and matching No PO Reference Number detail table, listing raised, received and invoiced orders that have no PO reference, with PO, GRN and invoice values by document

Invoice Reconciliation Tab

The Invoice Reconciliation tab is used to reconcile variances between the value of goods received and the value invoiced and credited, and includes a built-in reference guide to how each column in the underlying report is calculated.

This tab includes:

• Filters for organisational hierarchy, location, stock location, cost centre, category groupings, product, supplier, date, PO number and document ID
• An explanation panel noting that users can drill through from an individual PO reference number or Document ID to look up the full order transaction “thread”, and that the GRN/INV date used is the GRN date for most rows or the invoice date for rows reporting invoices without a GRN
• A description of each data column in the detail report: Received in Period, Invoiced of Received in Period, Received outside Period of Invoiced in Period, Other Invoiced in Period, Invoices with Incorrect References, Credit Note, and GRN minus INV+CN (the variance between received value and invoiced plus credited value)

• A detailed reconciliation report (available on request, as it is too large to display by default)