Kailing Technology

How to create a supplier reconciliation detail sheet? Handling six types of discrepancies by category

2026-11-22Kailing Technology · Business-Finance-Tax Solution Team
How to create a supplier reconciliation detail sheet? Handling six types of discrepancies by category

How to create a supplier reconciliation detail sheet? Handling six types of discrepancies by category

The goal of the supplier reconciliation detail sheet is to explain the relationship between each transaction and the supplier's settlement statement, and to record the reasons for discrepancies and handling evidence. Do not directly alter source data just to make the totals equal, and do not promise that the six types of discrepancies can definitely be "reconciled in one pass." First verify orders, receipts, returns, invoices, and payments, then handle discrepancies according to business facts.

1. At minimum, which fields the detail sheet should retain

It is recommended to use the purchase order line or receipt batch as the reconciliation unit, recording supplier, contract or order number, material, specification, unit of measure, ordered quantity, received quantity, unit price, tax-inclusive and tax-exclusive amounts, receipt date, invoice number and status, payment or prepayment amount, discrepancy type, responsible person, handling deadline, and closure evidence link. For partial deliveries, consolidated invoicing, and partial payments, retain one-to-many relationships; do not force them into a single row. The reconciliation basis and cutoff point should be confirmed with the supplier first.

2. Start from document relationships; do not treat unmatched items as amount errors

Link orders, delivery or logistics notes, acceptance and warehousing, returns, supplier settlement statements, invoices, and payment records item by item. When numbers are inconsistent, batches are not written back, or invoices have not arrived, first mark them as "pending match," then check the original documents and business status. Compare physical quantity, unit price, tax amount, and settlement amount separately, and record at which stage the discrepancy occurred. Original vouchers should be reviewed according to regulations; fields recognized by OCR are only candidate data and must not be directly regarded as reviewed or automatically booked.

Six types of supplier reconciliation discrepancies: quantity, price, invoice-payment, cross-period, duplicate, unit

3. How to verify the six common types of discrepancies

For quantity discrepancies, check short shipments, over-receipts, rejections, returns, and partial deliveries; for price discrepancies, check contract price adjustments, discounts, and settlement basis; for invoice-payment discrepancies, check partial invoicing, red-letter invoices, prepayments, and warranty deposits; for cross-period discrepancies, check the timing of receipt, invoicing, and booking; for duplicate discrepancies, check whether the same transaction or the same invoice was imported repeatedly; for unit discrepancies, check conversions among procurement, warehousing, and settlement units. The six types are only practical categories, not exhaustive or statutory classifications. Each discrepancy should state the responsible person, handling action, and verifiable closure materials.

4. After closing discrepancies, verify payments and archiving

For confirmed discrepancies, decide on supplementary documents, settlement adjustments, returns, or accounting corrections according to contracts, acceptance results, and accounting policies; where supplier confirmation is needed, retain correspondence records. Payment approval should verify the confirmed settlement amount and payment terms, and unresolved matters should be tracked separately. Original vouchers, reconciliation sheets, handling records, and electronic attachments should be organized and retained according to the entity's archiving system; scanned copies or automatic linking alone do not equal compliance with all conditions for electronic accounting archives.

5. What software can help with, and what still requires review

Kailing Technology's AI OCR, input VAT invoice management, and electronic accounting archives related products can serve as candidate tools for document extraction, duplicate checking, linking, and audit trails. The data sources that can actually be connected, invoice verification, system integration, and degree of automation must be confirmed according to product version, authorization, region, interfaces, and project acceptance. Accounting personnel still need to review original vouchers, determine the causes of discrepancies, and approve accounting treatment.

First create a detail sheet that can trace back to original documents, then arrange handling by the six discrepancy types. The standard for completing reconciliation is that both parties confirm the basis, discrepancy handling has evidence, and balances can be explained, not that all cells turn green.

Verification Basis

Ministry of Finance's Norms for Basic Accounting Work;Ministry of Finance "Measures for the Management of Accounting Archives";Ministry of Finance accounting treatment for material warehousing and accounts payable。

About Kailing Technology
As a comprehensive business-finance-tax digitalization solution service provider, Kailing Technology provides business-finance-tax management digital transformation products and operational services for various government agencies, institutions, and large, medium, and small enterprises. The product line includes: solutions for sales contract management system, procurement contract management system, fully digitalized Leqi interface project, automatic output invoicing system, reverse invoicing system, invoice issuance for individuals system, employee expense control and reimbursement system, input VAT invoice management system, supply chain collaborative reconciliation system, image AI OCR recognition system, automatic financial bookkeeping system, electronic accounting archives system, etc., comprehensively driving the digitalization process across various fields.
Consultation Hotline: 18513895936 / 010-60974119 Location: Beijing
Common Questions
Which fields must be retained in a supplier reconciliation detail table to be sufficient?
It is recommended to use the purchase order line or receiving batch as the reconciliation unit, recording supplier, contract or order number, material, specification, unit of measure, ordered and actually received quantities, unit price, tax-inclusive and tax-exclusive amounts, receipt date, invoice number and status, payment or prepayment amount, discrepancy type, responsible person, handling deadline, and links to closing evidence. For partial deliveries, consolidated invoicing, and partial payments, retain the one-to-many relationships; do not compress them into a single row.
What categories of supplier reconciliation discrepancies are generally distinguished, and how should they be checked?
Six common categories: quantity discrepancies involve short shipments, over-receipts, rejections, returns, and partial deliveries; price discrepancies involve contract price adjustments, discounts, and settlement bases; invoice-payment discrepancies involve partial invoicing, red-letter invoices, prepayments, and warranty deposits; cross-period discrepancies involve the timing of receipt, invoicing, and booking; duplicate discrepancies involve whether the same transaction or invoice has been imported repeatedly; unit discrepancies involve conversions among purchasing, warehousing, and settlement units. These are only practical categories, not exhaustive or statutory classifications.
During reconciliation, if document numbers do not match and invoices have not yet arrived, can it be directly counted as an amount error?
No. First, the order, delivery or logistics note, acceptance and warehousing, returns, supplier settlement statement, invoice, and payment records should be linked item by item. Where numbers are inconsistent, batches have not been written back, or invoices have not arrived, mark them as "pending match" first, then check the originals and business status. Physical quantities, unit prices, tax amounts, and settlement amounts should be compared in separate columns, and the stage at which the discrepancy occurred should be recorded; do not treat an unmatched item as an amount error.
Can the invoice data recognized by AI OCR be directly recorded in the books?
No. The fields recognized by OCR are only candidate data and cannot be directly regarded as verified or automatically recorded in the books. Kailing Technology's AI OCR, input VAT invoice management, and electronic accounting archives products can serve as candidate tools for document extraction, duplicate checking, linking, and trace retention, but the actual data source integration, invoice verification, and degree of automation must be confirmed according to product version, authorization, region, interfaces, and project acceptance; accountants still need to review the original vouchers and approve accounting treatment.
At what point is supplier reconciliation considered complete?
The standard is that both parties confirm the reconciliation basis and cutoff time, each discrepancy has verifiable closing evidence, and the balance is explainable, rather than all table cells turning green. Confirmed discrepancies are handled by supplementary documents, settlement adjustments, returns, or accounting corrections according to the contract, acceptance results, and accounting policies; unresolved matters are tracked separately. Original vouchers, reconciliation tables, handling records, and electronic attachments are retained according to the entity's archive system; scanned copies or automatic linking do not equal compliance with all conditions for electronic accounting archives.
Related solutions
Electronic Accounting Archive Management
Electronic voucher archiving, single-set system, compliant and auditable →
Supply chain collaboration management platform
Full-chain collaboration of procurement, orders, reconciliation, and settlement →
AI OCR Invoice Recognition Platform
Intelligent recognition and structured entry of invoice documents →
Telephone consultationBook a Demo
✕
Home ›AI digital employee ›Core products ›Customer Stories ›Insights ›Book a Demo
010-60974119