How Walmart Allowances Can Go Wrong

2020-07-08
7 min read

Learn about:

  • Walmart allowances and why they’re used
  • How incorrect allowances can cause deductions
  • How to correct allowance errors
  • How to dispute allowance deductions

Walmart allowances are used to help Walmart to recover some of the cost of doing business. Most of the allowances can be given Off Invoice (OI). Allowances, for the most part, are found in agreements between suppliers and Walmart.

Allowance deductions depend on what allowances the Walmart buyer and the supplier agree on when setting up the vendor agreement and the terms. When you are negotiating the types of allowances that you are going to give, make sure that the vendor agreement is filled out to match what you have discussed. 

The most common error when filling out the vendor agreement is to put that you are going to give Walmart an allowance but then not check how you expect to give that allowance.  By doing that, you are agreeing to give that allowance Off Invoice. 

The most common OI allowances are “New Warehouse” allowances, “Defective Merchandise” allowances, and “New Location” allowances. Most of the other allowances are better if you agree to give them on a quarterly or yearly bases.

Walmart Allowance Deductions

When allowances are not given correctly off the invoices you will see deductions for Walmart allowances. The deduction codes for allowances are in the 50s and generally involve allowances that are on your Online Supplier Agreement (OSA). These codes are:

  • Code 50: Advertising Allowance is generated when there is an advertising allowance (negotiated to defray advertising costs on Walmart’s behalf) listed in your OSA but is missing from the invoice.
  • Code 51: Promotional Allowance is generated when there is a promotional allowance (for certain products during a specified period of time) listed in your OSA but is missing from the invoice.
  • Code 52: Volume Allowance is generated when there is a volume allowance (when Walmart buys a large amount of merchandise) listed in your OSA but is missing from the invoice.
  • Code 53: Truckload Allowance is generated when there is a freight allowance (negotiated to offset transportation costs) listed in your OSA but is missing from the invoice.
  • Code 54: Warehouse Allowance is generated when there is a warehouse allowance (negotiated for warehouse orders to eliminate the work and expense of shipping direct to stores) listed in your OSA but is missing from the invoice.
  • Code 55: New Location Allowance is generated when there is a new location allowance (for new warehouses, orders placed prior to the grand opening of new stores, and some purchase orders sent to distribution centers with new stores) listed in your OSA but is missing from the invoice.
  • Code 56: Early Buy Allowance is generated when there is an early buy allowance (negotiated in return for giving the supplier budgeting advantages) listed in your OSA but is missing from the invoice.
  • Code 57: Quantity Discount is generated when there is a quantity allowance (for purchase orders for a particular quantity ordered) listed in your OSA but is missing from the invoice.
  • Code 58: DSDC Allowance is generated when there is a DSDC (direct-to-store, shipped through DC) allowance (used to cover a margin of error within advanced shipment notice [ASN] packs listed on Type 73 POs) listed in your OSA but is missing from the invoice.
  • Code 59: Defective Merchandise Allowance is generated when there is a defective merchandise allowance (to offset against the merchandise costs of returns) listed in your OSA but is missing from the invoice.

Visibility right where you need it

Common Allowance Errors

The most common reason for getting allowance deductions is not giving the allowances in the correct spot when invoicing Walmart.  Your invoice should mirror the raw EDI data from Walmart. Some suppliers do not select to pull the raw data from Walmart’s EDI transmission, so allowances are given in the wrong area of the invoice.  

An example would be if in the raw EDI data it shows that you are to give the allowance off the bottom of the invoice, but when you transmit the invoice, you are giving the allowance off each line of the invoice.  Walmart will keep the allowance that you gave to them in the incorrect locations but then take a deduction for the allowance off the entire invoice.  

Another common error occurs when you are supposed to be giving a defective allowance but you transmit the invoice as another allowance type such as a promotional allowance. Again, with this Walmart will take a deduction for the valid deduction code but keep the invalid allowance that was given off invoice. 

Walmart’s line-level matching system cannot match an allowance that is given off in the wrong area of the invoice which is why you will see an allowance deduction. This is why it is very important that when your EDI team is receiving the raw data from Walmart, they retrieve all of the segments and transmit all of the required segments.

Correcting Allowance Errors

The first step you will need to do to correct this error is to have your EDI team pull the Walmart raw EDI data and see where the allowances are supposed to be on the invoices.  If they are not showing allowances in the raw data, then they are not pulling that segment from the raw data and will need to change the segments that they are capturing.  This is a common mistake that a lot of suppliers make.  Remember you are supposed to be mirroring the invoice to the raw EDI data.  

If the segment that you are putting the allowance in when transmitting the invoices is not the same segment, then you are transmitting the invoice incorrectly.  To correct this mistake, change the allowance to the correct segment and remove it from the incorrect segment. 

Get insights into your deductions

Getting Repaid for Walmart Allowance Deductions 

You will need to create a spreadsheet showing all of the invoices that the invalid Walmart deductions were taken on.  On this list, you will need the invoice number, PO number, allowance code, deduction amount, check date, and check number.  Also, provide a few invoice examples showing that you gave the allowance off the invoices. 

The more information that you provide to Walmart upfront when disputing invalid deductions, the better chance of getting it resolved the first time around. If you are seeing deductions for Walmart allowances, then you would need to dispute these in the Walmart disputes portal explaining the error.  

Sometimes the accounting team will research this error and pay the invalid deductions back without needing additional information. However, the most common response to an invalid allowance deduction is that you will have to go through your buyer to approve payback. At that point, the buyer should work with the accounting team to get the invalid deductions repaid. 

One-Click Disputes

SupplyPike offers an easy software solution for disputing invalid deductions. Our Deductions Navigator software will automatically download the necessary documents, such as POs and invoices, showing the valid allowances so you can get your money back. 

One-Click Deduction Disputes

One-Click Deduction Disputes

Get started today for free!

Related Resources

Written by The SupplyPike Team

About The SupplyPike Team

SupplyPike builds software to help retail suppliers fight deductions, meet compliance standards, and dig down to root cause issues in their supply chain.

Read More
The SupplyPike Team

About

SupplyPike

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