Report Type - GRNI Accruals Reconciliation

  • Updated

The GRNI (Goods Received Not Invoiced) Accruals Reconciliation report is a specialized version of the standard GRNI report. It has been optimized specifically for finance teams to simplify the process of reconciliating accruals at the end of a fiscal period.

 

Purpose of the Report

Unlike the broad GRNI report, this version focuses on the specific quantities and values that represent a current financial liability. It is the primary tool for:

  • Reconciling the General Ledger: Matching the "unbilled" balance in your ERP to the physical receipts logged in Unimarket.
  • Accuracy in Accruals: Ensuring that only the specific quantity of goods received (but not yet billed) is recognized as a liability.
  • Audit Documentation: Providing a clean, concise list of outstanding received items for external auditors.
  • Sample report: Unimarket GRNI Accruals Reconciliation Example

 

Report Logic

  • Date Range: The report looks at orders where receiving activity occurred within your specified dates.
  • Filter Criteria: It only includes line items where a receipt exists but a matching invoice has not yet been processed.
  • Optimization: This report removes extraneous product data to focus solely on the financial identifiers needed for reconciliation.

 

Best Practices for Reconciliation

  • Target the Delta: Use the Received Not Invoiced Total to calculate your journal entries for the month-end close. This column represents the exact dollar amount of the liability your institution has incurred.
  • Clean Up Old Receipts: If you see items on this report from several months ago, it often indicates a user accidentally "Received" an item they didn't get. Or a supplier sent a "paper" invoice that was never entered into the system.
  • ERP Cross-Referencing: Use the Supplier Vendor ID to quickly look up the vendor in your ERP. To see if an invoice is currently sitting in a "Pending" or "Draft" state, in your Accounts Payable module.

Note: This report is the most "finance-friendly" view of your unbilled liabilities because it calculates the remaining value for you, reducing the need for manual spreadsheet formulas.

 

Report Columns and Definitions

Column Name Description
Order Number The Purchase Order identifier.
Order Date The original issuance date of the PO.
Supplier Name The name of the vendor.
Supplier Vendor ID The unique identifier for the vendor within your ERP system.
Order Line Number The specific line item being tracked.
Order Line Description A brief description of the goods or services.
Order Line Quantity The total quantity ordered on this line.
Received Not Invoiced Qty The specific quantity that has been received but is still awaiting an invoice.
Received Not Invoiced Total The calculated financial value (Qty x Unit Price) that needs to be accrued.