By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    data science anayst
    Growing Demand for Data Science & Data Analyst Roles
    6 Min Read
    predictive analytics in dropshipping
    Predictive Analytics Helps New Dropshipping Businesses Thrive
    12 Min Read
    data-driven approach in healthcare
    The Importance of Data-Driven Approaches to Improving Healthcare in Rural Areas
    6 Min Read
    analytics for tax compliance
    Analytics Changes the Calculus of Business Tax Compliance
    8 Min Read
    big data analytics in gaming
    The Role of Big Data Analytics in Gaming
    10 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Using Procurement Analytics to Simplify Your Supplier Reconciliation
Share
Notification Show More
Latest News
ai in automotive industry
AI Is Changing the Automotive Industry Forever
Artificial Intelligence
SMEs Use AI-Driven Financial Software for Greater Efficiency
Artificial Intelligence
data security in big data age
6 Reasons to Boost Data Security Plan in the Age of Big Data
Big Data
data science anayst
Growing Demand for Data Science & Data Analyst Roles
Data Science
ai software development
Key Strategies to Develop AI Software Cost-Effectively
Artificial Intelligence
Aa
SmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Quality > Using Procurement Analytics to Simplify Your Supplier Reconciliation
AnalyticsBusiness IntelligenceData ManagementData QualityData VisualizationData WarehousingDecision ManagementKnowledge ManagementPredictive AnalyticsRisk ManagementSoftware

Using Procurement Analytics to Simplify Your Supplier Reconciliation

Keith Peterson
Last updated: 2023/03/27 at 5:36 PM
Keith Peterson
4 Min Read
SHARE

Ask finance managers to name a necessary evil of their responsibilities and many will cite reconciling goods received against invoices not received (“GR-NI”). The GR-NI issue is time-consuming to manage but not exactly mission critical to finding new business. 

Because of that it often gets demoted to the lowest of priorities.  Not dealing with GR-NI, however, creates financial liabilities and can introduce significant risk to your business operations. 

The primary GR-NI concern is that a supplier delivers goods to the business – but the invoices for those goods never arrive in the Accounts Payable department.  The AP team must pull lists of goods received and compare that to invoices in the AP database to find these gaps.  These provisions may add up over time.  And, without an automated way to monitor and resolve discrepancies, the piles of paper just keep adding up.  These piles have risk – liabilities are incorrectly stated, provisions in the GR-NI account tie-up capital, supplier relationships may suffer, and credits may be missed. 

However, with a simple software-based supplier reconciliation process in place, an organization can automate this cumbersome process to save hundreds to thousands of man hours every year. And with the same system, it can improve its audit processes and even automate the process of supplier communication to resolve issues as they arise. 

More Read

ai in automotive industry

AI Is Changing the Automotive Industry Forever

SMEs Use AI-Driven Financial Software for Greater Efficiency
6 Reasons to Boost Data Security Plan in the Age of Big Data
Growing Demand for Data Science & Data Analyst Roles
Key Strategies to Develop AI Software Cost-Effectively

For example, one of our clients, a vegetable processor, works with over 2,000 suppliers and receives nearly 300,000 invoices every year. Using a manual approach to invoice reconciliation, they tied up four AP staff members for a week every month to reconcile dozens of statements from across 2,000 vendor accounts.  Inadequate audit controls, misstated liabilities, and frustration of dealing with vendors chasing invoice status all took their toll. 

Implementing a new GR-NI process needs some focus and targets to be successful. For example, our client focused on critical preferred supplier relationships with high volume to start.  This limited the initial number of suppliers to the 200 most critical ones. 

A simple overview of their process:

  • Creation of a database to integrate financial and orders data;
  • Routine upload of AP ledger(s) to the system;
  • Cross-reference orders with invoices received;
  • Build chart visuals to highlight discrepancies by amount and supplier type;
  • Output supplier lists prioritized for review and contact; and
  • Track results in system to improve overall supplier processes. 

Key elements of solution are:

  • A method to get statements into the system regardless of format and source;
  • Cross-link matching of companies and multi-level parent-child relationships resolved;
  • Automatic generation of statements in PDF and spreadsheet formats; and
  • Electronic report distribution to suppliers. 

To maximize value, look for the operational areas in your company that can benefit from better processes. Tedious tasks like resolving goods received-not invoiced issues may not fall on your radar.  But automating and improving these processes can deliver serious positive impact.  Halo’s platform is an ideal solution for supplier reconciliation processes. 

Keith Peterson July 20, 2015
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

ai in automotive industry
AI Is Changing the Automotive Industry Forever
Artificial Intelligence
SMEs Use AI-Driven Financial Software for Greater Efficiency
Artificial Intelligence
data security in big data age
6 Reasons to Boost Data Security Plan in the Age of Big Data
Big Data
data science anayst
Growing Demand for Data Science & Data Analyst Roles
Data Science

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

ai in automotive industry
Artificial Intelligence

AI Is Changing the Automotive Industry Forever

5 Min Read
Artificial Intelligence

SMEs Use AI-Driven Financial Software for Greater Efficiency

10 Min Read
data security in big data age
Big Data

6 Reasons to Boost Data Security Plan in the Age of Big Data

7 Min Read
data science anayst
Data Science

Growing Demand for Data Science & Data Analyst Roles

6 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive
data-driven web design
5 Great Tips for Using Data Analytics for Website UX
Big Data

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?