Reconcile the received-not-invoiced account to the receipts still open

An old goods-received-not-invoiced balance is not necessarily a collection of missing supplier invoices. Some invoices may be saved but unposted, some receipt reversals may be incomplete, and some amounts may come from direct journals that never entered purchasing. Reconcile the account to those underlying events before asking someone to clear its oldest lines.

Begin with the accounting process actually in use. Record which receipt event creates the accrual, which invoice event clears it, where price differences go, and how returns affect the sequence. Separate inventory receipts, service receipts and manual period-end estimates when they use different workflows. A single account can contain all three while an unmatched-receipts report includes only one.

The required output is a receipt-level explanation of the closing ledger balance. It should show what remains genuinely uninvoiced, what is waiting for an internal posting, and what needs correction. This is different from canceling an undelivered purchase-order remainder: goods already received can leave an obligation even after purchasing closes the order.

Save the receipt detail, invoice matching status and ledger activity with their extraction times. State the entity, currency, account, cutoff date and transaction filters. A live report run after the close may incorporate an invoice matched yesterday, while the saved trial balance still represents last month. Those two views cannot be compared without a timing bridge.

Check the application's definition of an unmatched receipt. Microsoft documents that, in Dynamics GP, a receipt can leave the received-not-invoiced report when its invoice is matched and saved, before the invoice posts. Direct ledger entries are another documented source of differences. These are product-specific examples of why the report's selection rule matters; verify the equivalent behavior in your own system and version.

Inspect one known receipt through its full sequence. Locate the physical receipt, accrual posting, supplier invoice, match and clearing entry. Confirm whether the report shows original receipt value, remaining uninvoiced value or something else. Testing a known item makes the report's fields more useful than relying on their labels alone.

Start with the prior reconciled balance. Add receipt accruals created in the period, subtract posted invoice clearings and supported receipt reversals, then show other approved movements separately. Retain the receipt identifier and ledger reference for each component. A total that ties only because unrelated debit and credit differences cancel is still unresolved.

Consider a hypothetical account with a $12,000 opening credit balance. New receipt accruals add $8,000. Posted invoice matches clear $15,000, and a documented return reverses another $1,000. With no other movements, the closing credit balance is $4,000. This example uses positive amounts to describe remaining accrued liabilities rather than the ledger's debit-and-credit display convention.

Suppose the operational report shows $3,000 because a further $1,000 invoice has been matched and saved but not posted. The $1,000 timing item explains the difference; it does not justify an extra clearing journal. If the invoice is later posted correctly, the normal workflow should reduce the ledger balance to $3,000. Record the actual posting reference when that happens.

For a partially billed receipt, compare accepted quantity, invoiced quantity, receipt valuation and invoice price. A receipt for 100 units with only 60 billed should retain an explanation for the other 40. Do not conclude that the whole receipt is settled merely because one invoice references its purchase order.

Price differences require the posting rules, not just subtraction of invoice totals. If receipt accruals used an estimated price, the invoice may clear the original receipt valuation and send the price difference elsewhere. Comparing the invoice's gross amount directly with the accrued receipt can therefore create an apparent residual that does not belong in this account.

Keep freight, tax and currency effects visible when they follow different posting paths. Use the company's approved currency basis for the reconciliation and identify any remeasurement entries separately. The person checking receipt completion should not have to reverse-engineer a tax or exchange difference hidden inside an unexplained quantity balance.

A warehouse return, a supplier credit and a receipt reversal describe related events, but they need not occur together. Determine whether the original goods were invoiced before the return. A return of uninvoiced goods can follow a different accounting route from a return that creates a credit against an existing supplier payable.

Read the return reference against the original receipt and any replacement delivery. If the supplier sends replacement goods, decide with operations whether the system should show a return and new receipt or another supported correction. Finance should see the resulting records, not erase the original accrual simply because the physical item is no longer on the shelf.

Check whether an invoice has cleared a different receipt with similar quantities. Matching the wrong line can leave one old accrual open and make a newer receipt appear settled. Correct the documented relationship through the supported process. A journal that makes the account total agree will not repair the purchasing history or prevent the same invoice from being matched again.

Age is useful for assigning attention, but it does not decide whether a supplier obligation has ended. For each old line, record the receipt evidence, supplier position, subsequent invoice search and the buyer's explanation. A missing bill, disputed delivery and duplicate receipt need different outcomes even when all are twelve months old.

Separate operational corrections from accounting judgments. Receiving can confirm that a duplicate entry was made; the accountant approves the financial correction and reporting period. A supplier's silence does not by itself establish a right to release a liability. Questions about enforceability, settlement or other legal consequences belong with the appropriate adviser.

Give each unresolved item a specific next action. Asking the buyer to obtain the supplier's final invoice is different from asking the system administrator to find an unposted batch. Keep the amount and the account effect attached to that action so the next close can see whether the evidence changed or the item merely became older.

After approved corrections, rerun the relevant detail and ledger activity. Check both the account total and the receipt-level exceptions. A successful result might leave a legitimate balance for goods awaiting invoices; it does not require the account to become zero. Preserve the reason for every amount that remains.

For a direct journal, record why the normal purchasing workflow could not produce the required correction and how the open item was handled. Otherwise, the ledger can be fixed while the receipt stays open and later clears a second time. Confirm any linked reversal, cancellation or supported matching adjustment with the process owner.

Carry the closing explanation into the next period as the opening schedule. Keep subsequent invoices and credits linked to the original receipt instead of rebuilding the history from scratch. The useful control is continuity: each remaining accrual has an identifiable receipt, a known status and a documented route to resolution.