How do you reconcile a supplier statement?

Gather the supplier's statement and your internal records for the same period. Compare each line item, checking invoice numbers, amounts, dates and references. Flag any discrepancies such as missing invoices, payment timing differences or amount variances. Investigate and resolve each discrepancy before approving the statement.

What are common discrepancies in supplier statements?

Common discrepancies include invoices recorded by the supplier but not yet received by your team, payments made but not yet credited by the supplier, timing differences at month-end, duplicate invoices, pricing or quantity variances, and currency conversion differences for international suppliers.

How does automation help supplier statement reconciliation?

Automation extracts data from both the supplier SOA and your internal records, normalizes the fields and runs two-way matching automatically. Matched records are cleared and discrepancies are flagged with reasons for your team to review. KIP.ai processes 3,600 supplier documents a month for one optical retail client in Malaysia.

What file formats does KIP.ai accept for SOA reconciliation?

KIP.ai accepts supplier statements of account in PDF and CSV formats, and ERP goods received entry files in CSV format. Finance teams upload both file types through the admin portal. KIP.ai extracts and normalizes key fields from both sources.

Supplier Statement Reconciliation: How to Match SOA to Your Records

Supplier statement reconciliation is the process of comparing a vendor’s statement of account (SOA) to your internal records to ensure both sides agree on what has been invoiced, received and paid. The supplier sends a statement listing all transactions for a period; your finance team matches it against purchase orders, goods received notes and payment records. Discrepancies are investigated before payment runs or month-end close.

KIP.ai by Axrail automates this matching for finance teams who still reconcile supplier statements by hand. One leading optical retail chain in Malaysia uses KIP.ai to reconcile 3,600 supplier documents a month. Axrail, an Applied AI expert and AWS Premier Tier Partner, built KIP.ai to extract data from both sources, run two-way matching and flag every discrepancy for review. This guide covers what supplier statement reconciliation is, how it works and how to automate it.

What is supplier statement reconciliation?

Supplier statement reconciliation is a control process that verifies your records match what your supplier believes you owe. The supplier’s statement of account shows all invoices sent, credits issued and payments received over a period. Your internal records show the same transactions from your perspective: goods received, invoices processed and payments made. Reconciliation finds the gaps between these two views.

According to a 2024 APQC benchmark, finance teams spend an average of 23% of their time on reconciliation activities. The Institute of Finance & Management (IOFM) found that manual statement reconciliation takes an average of 42 minutes per supplier per month for organizations with 50 or more vendors.

Why does supplier statement reconciliation matter?

Without reconciliation, discrepancies accumulate. You might pay for invoices you never received, miss early payment discounts, fail to claim credits owed to you, or carry incorrect balances into your financial statements. For organizations with hundreds of suppliers, these errors compound into material misstatements.

A 2023 Levvel Research survey found that 34% of organizations discovered payment errors during statement reconciliation that would otherwise have gone unnoticed. The Aberdeen Group reported that best-in-class organizations reconcile supplier statements within 3 days of receipt, compared to 12 days for laggards.

Statement reconciliation also strengthens vendor relationships. When you catch discrepancies early and resolve them quickly, suppliers trust your payment process. This can translate into better terms, faster dispute resolution and priority during supply constraints.

What does a supplier statement of account contain?

A supplier statement of account typically includes:

Opening balance: The amount owed at the start of the period.
Invoices: Each invoice issued during the period, with date, number and amount.
Credits: Any credit notes issued for returns, rebates or corrections.
Payments received: Payments the supplier has applied to your account.
Closing balance: The amount owed at the end of the period.

Your internal records should contain the same information from your perspective: invoices received, credits claimed, payments made and the resulting balance in your accounts payable ledger.

The manual reconciliation process

In the manual process, a finance team member receives the supplier statement by email or post. They export the relevant transactions from the ERP into a spreadsheet. They compare each line item, checking invoice numbers, amounts and dates. Discrepancies are noted, investigated and resolved. The reconciled statement is approved and filed.

This process has several pain points:

Time-consuming: Large suppliers may have hundreds of line items per statement.
Error-prone: Comparing figures by eye invites typos and overlooked differences.
Inconsistent: Different team members may reconcile using different methods.
Delayed: Statements pile up during busy periods, pushing reconciliation past month-end.

Common discrepancies in supplier statements

Discrepancies fall into several categories. Understanding them helps you investigate efficiently and prevent recurring issues.

Discrepancy type	What it means	Common cause
Invoice not on your records	Supplier shows an invoice you have not received	Invoice lost in transit, misdirected or not yet processed
Invoice not on supplier records	You have an invoice the supplier does not show	Duplicate entry, invoice from a different entity, or supplier error
Payment timing difference	You made a payment the supplier has not credited	Payment in transit, applied to wrong account, or posted to a different period
Amount variance	Invoice amount differs between records	Price changes, currency conversion, tax calculation differences
Credit not applied	You are owed a credit the supplier has not issued	Return not processed, rebate not calculated, dispute not resolved

According to a 2024 PayStream Advisors report, timing differences account for 41% of statement discrepancies, while missing invoices account for 28% and amount variances account for 19%.

How to reconcile a supplier statement manually

Follow these steps for consistent manual reconciliation:

Gather the documents: Obtain the supplier statement and export your internal records for the same period and supplier.
Sort by date or invoice number: Align both lists to make comparison easier.
Match line by line: For each item on the supplier statement, find the corresponding entry in your records. Mark matched items.
Flag discrepancies: Note any items that do not match or appear on only one side.
Investigate: For each discrepancy, determine the cause. Contact the supplier or internal teams as needed.
Resolve: Make correcting entries, request credits, or document the reason the discrepancy is acceptable.
Approve: Once the statement is reconciled, approve and file it with supporting notes.

How to automate supplier statement reconciliation

Automation removes the manual comparison and surfaces only the discrepancies. The steps become:

Upload documents: The supplier SOA and your internal records (such as goods received entries) are uploaded to the system.
Extract data: The system reads both documents and extracts key fields: invoice number, date, amount, supplier name and references.
Normalize data: Fields are standardized for comparison, handling date formats, currency symbols and naming variations.
Two-way matching: The system compares each item in the SOA against your internal records and vice versa.
Generate reports: A Matched Records Report shows reconciled items. An Exception Report shows discrepancies with reasons.
Review and approve: Your team reviews exceptions and approves the reconciliation.
Push to ERP: Approved results are sent to your accounting system.

How KIP.ai handles supplier statement reconciliation

KIP.ai automates the matching between supplier statements of account and your internal records. Finance teams upload supplier SOA files (PDF or CSV) and ERP goods received entries (CSV) through the admin portal. KIP.ai extracts and normalizes the key fields from both sources: invoice number, invoice date, amount, supplier name and supplementary fields including branch code, transaction code and currency.

KIP.ai runs two-way matching between the supplier SOA data and the ERP goods received entries. Results are split into a Matched Records Report and an Exception Report that describes each discrepancy. Every exception is flagged for the team to review and decide.

A leading optical retail chain in Malaysia uses KIP.ai to reconcile 3,600 supplier documents a month. Before KIP.ai, the finance team reconciled statements against goods received entries by hand, creating accuracy risks and heavy workloads. Now, data extraction, normalization and two-way matching are handled automatically. You can read the full story in how a leading optical retail chain reconciled 3,600 supplier documents a month with KIP.ai.

Results you can expect

Based on the optical retail case study and typical implementations:

Faster reconciliation: Matching runs automatically across high document volumes, replacing the manual step that consumes the most time.
Reduced manual workload: Your team focuses on reviewing exceptions rather than entering and comparing data.
Fewer discrepancies reaching the ERP: Issues are identified and reviewed before results are pushed to your accounting system, so only verified data flows downstream.
Consistent process: Every statement is reconciled the same way, reducing errors from inconsistent methods.

According to a 2023 Deloitte survey, organizations using automated reconciliation report 67% faster month-end close compared to those reconciling manually.

Governance and control

Reconciliation is a financial control, so people stay in charge of it. Every exception is flagged for your team to review and decide. Approved reconciliation results are pushed directly back into your ERP system. Nothing is posted automatically without human sign-off.

This human-in-the-loop approach ensures that unusual items receive attention. If a supplier has issued a credit you were not expecting, your team sees it and can investigate. If a payment timing difference will resolve itself next period, your team can document that decision.

Getting started with SOA reconciliation automation

You do not need to change your entire AP process to start automating statement reconciliation. Follow these steps:

Identify high-volume suppliers: Start with suppliers who send the most line items per statement. These give the biggest time savings.
Standardize your exports: Ensure your ERP can export goods received entries in a consistent CSV format.
Pilot with one supplier: Test the matching process with a single supplier before rolling out broadly.
Measure the baseline: Track how long manual reconciliation takes so you can measure improvement.
Expand gradually: Add more suppliers as you prove value and refine the matching rules.

Frequently asked questions

How often should I reconcile supplier statements?

Best practice is to reconcile monthly, aligned with your month-end close. For high-volume or high-value suppliers, some organizations reconcile weekly.

What if the supplier does not send a formal statement?

Contact the supplier and request regular statements. Most accounting systems can generate them automatically. Without a statement, you are reconciling your records against your own expectations, which is less effective.

Can KIP.ai handle statements in different languages?

KIP.ai supports statements in multiple formats. Contact the Axrail team to confirm support for specific languages or formats.

How does KIP.ai handle partial matches?

KIP.ai flags partial matches as exceptions with a reason, such as an amount variance or a date mismatch, so your team can investigate and decide.

See it in action

The live demo on gokip.ai shows how KIP.ai matches documents and flags discrepancies. The demo has built-in sample documents, and no files or account are needed. When you are ready to try KIP.ai on your own documents, start a free trial or book a demo.

Try the reconciliation demo