← DNA ERP Certified

Lesson 50 of 159·4 min

Supplier reconciliation and closing the procurement cycle

A supplier statement and the company's records may show different balances. The difference can arise from timing, missing invoices, unapplied credits, incorrect allocations, or an actual disputed charge.

Supplier reconciliation is the process of understanding those differences. Its purpose is to establish an explainable position, not simply make two totals equal through an arbitrary adjustment.

Start with the meaning of the balance

A supplier statement describes the supplier's view at a particular date. The ERP describes the company's recorded invoices, credits, payments, and allocations. Differences in the cutoff date or treatment of an in-transit payment can produce a legitimate temporary difference.

DNA's supplier transaction relationships and allocation workbench support investigation of the recorded position. The workbench has its own permission and uses matching principles that distinguish the original records from the allocations between them.

A practical reconciliation

A supplier statement shows USD 8,000 due. The company shows USD 6,500. Investigation identifies a USD 1,000 credit accepted by the supplier but not yet included on the statement, and a USD 500 payment the supplier has not yet matched.

Those explanations account for the USD 1,500 difference. They do not require another USD 1,500 payment or an invented credit. The evidence should identify the original documents and the timing or allocation issue.

If the supplier does not accept the claimed credit, the difference remains a dispute rather than a completed reconciliation. A plausible explanation is not enough without support.

Matching errors and cash errors

A payment allocated to the wrong invoice can leave one invoice open and another incorrectly settled while the supplier's total account remains unchanged. Correcting the allocation addresses the detailed match; it does not represent another bank movement.

A duplicate actual payment has a different effect. It may create an overpayment or amount to recover. The business needs to distinguish these causes before choosing a correction.

Procurement completion

Financial settlement does not necessarily mean the entire order is fulfilled. Goods may remain undelivered, or a service acceptance issue may remain unresolved. Conversely, a fully received order may still have unbilled charges or outstanding invoices.

Closing the procurement cycle therefore requires an understanding of the remaining commitment, receipts, billing, credits, and settlement. Each responsibility should be complete or have an explicit unresolved position.

Learning from recurring differences

Repeated missing credits may indicate a weak communication process. Repeated quantity disputes may indicate receiving problems. Repeated duplicate invoices may indicate poor reference checking or fragmented supplier records.

Reconciliation becomes more valuable when it improves the cause of the difference. DNA provides the transaction evidence; the business uses that evidence to strengthen purchasing and supplier relationships.

Check your understanding

Not marked. Answer every question to finish the lesson.

Question 1 · Choose one answerConsider this statement about supplier reconciliation and closing the procurement cycle: Supplier reconciliation explains differences through actual documents and timing. Is the statement correct?

Question 2 · Choose one answerCheck your understanding of supplier reconciliation and closing the procurement cycle: Which statement is accurate?

Question 3 · Choose every answer that appliesCheck your understanding of supplier reconciliation and closing the procurement cycle: Select all correct statements. Exactly two answers are correct.