Understanding Unpaid Invoice Details In Supplier One
Managing unpaid invoices is key to maintaining good cash flow and fostering strong supplier relationships. Supplier One provides a useful report for unpaid invoices that helps suppliers keep track of all unpaid and outstanding payments.
What is the 'Unpaid Invoice Details' Report in Supplier One?
The unpaid invoice report is a detailed document that shows suppliers the entirety of what is owed by Walmart for all outstanding invoices. For suppliers, this report is essential because it will monitor outstanding payments, manage cash flow, and ensure that accurate financial records are maintained.
The report includes key information such as:
-
Vendor Number (VENDOR_NBR)
-
Invoice Date (INVOICE_DATE)
-
Division
-
Store Number (STORE_NBR)
-
Invoice Number (INV_NBR)
-
Purchase order number (PO_NBR)
-
Invoice Due Date (INV_DUE_DATE): The date by which Walmart is expected to process the payment for each invoice.
-
Discount Amount (DISCOUNT_AMT)
-
Invoice Amount (INVOICE_AMT)
-
Paid Date (PAID_DATE): This column reflects a date between the date of the invoice and the date of report generation. It is not indicative of an actual date of payment since the invoices are yet to be paid. This could be some internal processing date or just a placeholder.
-
Document: Contains a numerical identifier, possibly an internal Walmart reference number. The exact purpose of this column may vary, and suppliers should consult Walmart's support for clarification.
-
Report Date (REPORT_DATE)
-
EBU_NBR
Where Do I Find Unpaid Invoice Details?
To see the details of unpaid invoices in Supplier One,
- Sign in to Retail Link and navigate to Supplier One. Once in the app, click on the left-hand menu bar and select the "Reports" option.
Source: retaillink.login.wal-mart.com/login > Supplier One
2. Scroll down to Payments and click on "Unpaid Invoice Details."
Source: retaillink.login.wal-mart.com/login > Supplier One > Reports
3. Use the appropriate filters, such as report date and supplier ID, to get the report specific to your needs, then download it. The file should download as an Excel file.
What Is the Purpose of This Document?
The Unpaid Invoice Details report is an essential tool for suppliers looking to:
-
Monitor outstanding invoices to manage cash flow effectively.
-
Identify pending invoices and proactively identify overdue payments.
-
Record all financial transactions to help in audits and financial planning.
The Importance of Tracking Unpaid Invoices
If an invoice appears on the unpaid invoices report, it likely means the invoice hasn't yet been processed for payment. This could be due to timing based on the invoice due date or an overdue payment. In these cases, reaching out to Walmart's Enterprise Business Services (EBS) team can help clarify the status and prompt further action.
Related Reading: Walmart Supplier Help: Who Should I Reach Out To?
On the other hand, if an invoice is missing from the unpaid invoices report, it may already have been processed, possibly with a deduction applied. When deductions are processed, Walmart typically records a check line for the invoice, even if the deduction covers the full amount. Reviewing claim details can help suppliers determine if a deduction has been made and whether a dispute is needed. Staying on top of these reports and claim details ensures suppliers can address discrepancies quickly, recover funds, and maintain healthy cash flow.
Related Reading: How To Dispute A Walmart Deduction
How Can SupplyPike Help?
Using the manual process described above can take up to 45 minutes per deduction:
-
to research the validity of the deduction,
-
gather necessary data and documentation, and
-
dispute the deduction in the correct portal.
When a company is dealing with deductions that equal 5% of their business, that can add up to hours a week.
SupplyPike has taken the manual process of disputing a deduction and automated it. It is saving users, on average, 95% of the time it previously took to dispute a deduction with Walmart.
SupplyPike provides all of the required dispute information on hand. It's no longer needed to go to Retail Link, pull reports from the Accounts Payable Inquiry System, and stitch that information together in a coherent dispute.
Documentation is now a breeze with SupplyPike, where claim & shipping documentation (such as Bills of Lading and Proofs of Delivery) are collected and provided alongside your deduction information. This means suppliers can save time by not digging for the correct PDF inside of the carrier's website (or worse still, their inbox).
With all of a supplier's information and documentation ready for use, SupplyPike enables companies to clear charges quickly with one-click and auto-disputing. Allowing for companies to no longer have to transpose the information from one website to another and attach documents. It all happens like magic with the click of a button.
Schedule a demo with the team today!
Related Resources
Written by Ryan Petty
About Ryan Petty
Ryan brings 7 years of supply chain and product management expertise, leading product strategies in transportation, retailer compliance, and deduction tools.
Read MoreAbout
SupplyPike helps you fight deductions, increase in-stocks, and meet OTIF goals in the built-for-you platform, powered by machine learning.
View SupplyPike's Website