How a leading optical retail chain reconciled 3,600 supplier documents a month with KIP.ai

- 3,600supplier documents a month
At a glance
- Customer
- A leading optical retail chain
- Industry
- Optical Retail
- System
- Goldsoft ERP
- Use case
- Accounts payable (AP)
- KIP.ai workflows used
- Supplier SOA and ERP file upload through the admin portal, AI data extraction and normalization, Two-way matching, Matched Records Report and Exception Report generation, Approved results pushed to the Goldsoft ERP
KIP.ai, Your AI Native Finance Department, automates supplier statement reconciliation for a leading optical retail chain in Malaysia. Finance teams upload supplier statements of account and ERP goods received entries through the admin portal. KIP.ai extracts and normalizes the data, runs two-way matching between the two sources and generates matched and exception reports. Approved results are pushed back into the Goldsoft ERP. KIP.ai is built by Axrail, an AWS Premier Partner and a team of Applied AI experts.
A leading optical retail chain in Malaysia operates a wide network of outlets across the country. That scale brings a steady flow of supplier statements of account each month, each requiring reconciliation against goods received entries submitted by outlet staff.
Reconciling supplier statements of account against ERP entries by hand created accuracy risks and heavy posting workloads.
The finance team reconciled supplier statements of account against goods received entries submitted by outlet staff by hand each month. At 3,600 documents a month, manually verifying data accuracy and resolving discrepancies such as missing invoice numbers, mismatched amounts and date inconsistencies created heavy posting workloads and accuracy risks across the supply chain.
KIP.ai extracts data from supplier SOAs and ERP files, runs two-way matching and flags every discrepancy for the team.
Finance teams upload supplier statements of account (PDF and CSV) and ERP goods received entries (CSV) via the KIP.ai 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.
Once the team approves the reconciliation results, KIP.ai pushes the finalized data back into the Goldsoft ERP system.
Faster reconciliation, reduced manual workload and fewer discrepancies reaching the ERP system.
- Faster reconciliation: Reconciliation runs automatically across a monthly volume of 3,600 documents, replacing the manual step that consumed the most time.
- Reduced manual workload: Data extraction, normalization and two-way matching are handled by KIP.ai, so the finance team focuses on reviewing exceptions rather than entering data.
- Fewer discrepancies reaching the ERP: Discrepancies are identified and reviewed before results are pushed to the Goldsoft ERP, so only verified data flows downstream.
Key takeaways
- Two sources matched automaticallyKIP.ai extracts and normalizes data from supplier SOA files (PDF and CSV) and ERP goods received entries (CSV), then runs two-way matching between the two sources.
- Every discrepancy is flaggedResults are categorized into a Matched Records Report and an Exception Report. Every exception is flagged for the team to review and decide.
- Verified data goes back to the ERPApproved reconciliation results are pushed directly back into the Goldsoft ERP system.
Frequently asked questions
What is supplier SOA reconciliation automation?
Supplier SOA reconciliation automation uses AI to extract transaction data from supplier statements of account and match it against ERP goods received entries automatically. Instead of manually comparing the two sources line by line, the system identifies matches and flags discrepancies for review. This is the process KIP.ai runs for a leading optical retail chain in Malaysia, processing 3,600 documents a month.
How does two-way matching work in accounts payable reconciliation?
Two-way matching compares two sources: the supplier's statement of account and the buyer's internal ERP records. KIP.ai extracts and normalizes key fields from both documents, then checks them against each other. Matched records flow through; mismatches such as missing invoice numbers, wrong amounts or inconsistent dates are flagged in an Exception Report for the finance team to review and resolve.
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.
How does KIP.ai push reconciliation results back to the ERP?
Once the finance team approves the reconciliation output, KIP.ai pushes the finalized data directly back into the Goldsoft ERP system. Only verified, approved records are written back.