Damaged Goods Log: Free Template for Retail and Warehouses

By Nicole Hullihen, former SaaS Chief Operating Officer and Microsoft MVP · Updated October 25, 2026

A pallet dropped by a forklift, a case of jars crushed in a delivery, a returned blender with a cracked base. Damaged goods are a cost every retail store and warehouse deals with. When damage isn't recorded, inventory counts drift, vendor credits are missed and the same problems keep happening.

This guide includes a free damaged goods log template and explains what to record, how to handle damage found at receiving, in storage and from returns, how to file vendor claims, when to mark down or write off items and how to use the log to reduce damage.

Note: This is general information, not accounting or tax advice. Ask your accountant how to record damaged and written-off inventory.

Why Keep a Damaged Goods Log?

• Accurate inventory: damaged items are removed from sellable stock.
• Vendor credits: records support claims for items that arrived damaged.
• Lower costs: patterns show where damage starts.
• Accountability: each entry shows who found and handled it.
• Better decisions: data on damaged products, vendors and areas.
• Cleaner books: your accountant has records for write-offs.

Free Damaged Goods Log Template

RTV means return to vendor. Use one row per item or SKU, not one row per incident, so totals by product are easy to see.

Damage Categories

Use the same categories every time so you can compare months.

Damage Found at Receiving

1. Inspect deliveries before the driver leaves, if possible.
2. Note damage on the delivery receipt before signing.
3. Take photos of the damaged items, packaging and labels.
4. Record the items in the damaged goods log and the receiving log.
5. Set damaged items aside in a marked area.
6. Contact the vendor or carrier the same day to start a claim.

See the receiving log for the full receiving process. Many vendors and carriers have short deadlines for damage claims, so act quickly and check each vendor's terms.

Damage Found in Storage or on the Floor

1. Remove the item from the shelf or sales floor.
2. Record it in the log with the cause, if known.
3. Move it to the damaged goods area.
4. Decide what to do with it: repair, mark down, return or discard.
5. Fix the cause if it's a shelving, storage or handling problem.

Customer Returns

Returned items need a decision: can they go back on the shelf, be sold as open box, be returned to the vendor or be discarded? Inspect each return, record any that can't be resold as new and follow your return policy. Track defective returns by product, since repeated defects may justify a vendor claim or removing the product.

Setting Up a Damaged Goods Area

• A clearly marked shelf, cage or bin away from sellable stock.
• Labels or tags on each item with the date and log entry.
• Separate sections for RTV, markdown, repair and disposal.
• Regular clearing, such as weekly, so items don't pile up.
• Limited access to prevent damaged items from being sold or taken.

Return to Vendor (RTV)

Many vendors give credit for items that arrive damaged or are defective, and some give credit for damage within certain limits. To get credit:

1. Check the vendor's return and damage policy.
2. Request a return authorization number.
3. Pack items as the vendor requires.
4. Record the RTV number, items and date in the log.
5. Track the credit until it appears on your account.

Keep damage and return terms in your vendor list so staff know each vendor's process.

Markdowns, Repairs and Disposal

Never sell damaged items that could be unsafe, such as damaged electrical products, food in damaged packaging or recalled items. Follow any rules that apply to your products.

Updating Inventory Records

Every damaged item should be adjusted out of sellable inventory, or moved to a separate damaged location in your system. If you skip this step, your counts will show stock you can't sell. See the inventory count sheet. Ask your accountant how to record write-offs and markdowns in your books.

Reviewing the Log Each Month

Ways to Reduce Damage

• Train staff on safe handling and stocking.
• Fix shelving: heavy and fragile items on lower shelves.
• Don't over-stack cases or pallets.
• Improve packaging requirements with vendors.
• Inspect at receiving before signing.
• Control temperature and moisture in storage.
• Keep aisles clear to prevent bumps and drops.

Example: A Home Goods Store

A home goods store threw away damaged items without recording them, and its inventory counts were always off. The manager started a damaged goods log and a marked RTV shelf. After two months, the log showed that one vendor's glassware arrived broken far more often than others, and that most in-store damage happened on one overloaded endcap. The vendor agreed to better packaging and issued credits, and rearranging the endcap cut in-store breakage noticeably.

Common Damaged Goods Mistakes

• Throwing items away without recording them.
• Signing for damaged deliveries without noting it.
• Missing vendor claim deadlines.
• Damaged items left on shelves or mixed with good stock.
• Not adjusting inventory.
• Never reviewing the log for causes.

Damaged Goods Checklist

Monthly Damage Summary

Compare the monthly total with your sales to see damage as a percentage of revenue. Watching that number over time shows whether your fixes are working.

Damage in Warehouses

• Train forklift and pallet jack operators on safe handling.
• Wrap pallets properly and check stretch wrap before moving.
• Keep rack beams and uprights in good condition and report damage.
• Don't store heavy items on top of fragile ones.
• Use dock bumpers and plates in good condition.
• Mark high-damage areas and review layout.

Record equipment issues that cause damage in your equipment maintenance log.

Damage From Shipping to Customers

If you ship products to customers, damage can happen after the item leaves your building. Track shipping damage separately: carrier, packaging used, product and outcome. If one product or carrier causes most of the claims, improve packaging or change carriers. Ask customers to send photos of damage before you issue a refund or replacement.

Training Staff on Damaged Goods

1. Show where the damaged goods log and area are.
2. Explain how to tag and record items.
3. Explain why damaged items must never go back on the shelf.
4. Review safe handling for fragile and heavy products.
5. Explain how to handle customer-damaged items politely.

Write the steps as a short procedure. See SOPs for small business.

When Customers Break Something

Accidents happen on sales floors. Most stores don't charge customers for accidental breakage, but they do record it. Make sure the area is safe, help the customer, clean up and log the item with "customer damage" as the cause. If breakage happens often in one spot, look at the display.

Damaged Goods and Loss Prevention

Damaged goods records can also reveal theft or fraud, such as items repeatedly marked damaged and discarded by the same person, or damaged items disappearing from the damaged area. Limit who can approve disposals, require a second person for high-value items and compare damage records with inventory counts.

Spreadsheet Tips

• Use drop-downs for cause and action.
• Calculate total cost with a formula: quantity × unit cost.
• Use a pivot table to total cost by cause, product and vendor.
• Highlight open vendor claims until credits arrive.
• Keep one tab per month and a summary tab for the year.

Damaged Goods Quick Tips

• Log it right away.
• Separate it from sellable stock.
• Note damage before signing for deliveries.
• Track vendor credits.
• Fix the cause, not just the item.

Sample Completed Entries

This sample uses made-up items. Even four entries show two different problems: a vendor's packaging and a roof leak.

Damaged Goods Policy Template

Common Questions About Damaged Goods

• Should employees pay for items they damage? Be careful; federal and state rules limit deductions from pay. See is it legal to dock an employee's pay.
• Can I donate damaged items? Usable, safe items can often be donated. Never donate unsafe or recalled items.
• How long should I keep damaged items for a vendor claim? Until the vendor or carrier confirms what they need, and check their terms.

Who Owns the Damaged Goods Process?

Assign one person, such as the store manager, receiving lead or warehouse supervisor, to own the damaged goods area and log. They decide what happens to each item, file vendor claims, track credits and clear the area weekly. A clear owner keeps damaged items from piling up and makes sure credits are actually collected.

Getting Started This Week

1. Print the log and post it in receiving and the stockroom.
2. Mark off a damaged goods shelf or bin.
3. Train staff on tagging and recording.
4. Review each vendor's damage and return terms.
5. Clear the area at the end of the week and record actions.

After the first month, review the totals with your team and pick one cause to fix.

Damaged Goods and Your Margins

Every damaged item is a sale you can't make and a cost you've already paid. For low-margin products, a few broken units can wipe out the profit on a whole case. Tracking damage as a percentage of sales by category shows which products are worth the risk and which need better packaging, different storage or a higher price to cover expected losses. See markup vs. margin.

Damaged Goods Log Quick Reference

Post a short reference card next to the damaged goods area so every employee knows what to do: remove the item from sale, tag it with the date and reason, record it in the log, place it in the right section and tell a manager if it's high-value or arrived damaged. A visible reminder keeps the process consistent across every shift.

Over time, a consistent log turns damage from a frustrating surprise into a cost you can measure, manage and reduce.

Start with one location or department, refine the process, then roll it out everywhere.

Track Inventory and Vendors With Updoot

Updoot's purchasing keeps vendors and orders organized, asset tracking tracks what you own and SOP management keeps your damage handling steps consistent.

Frequently Asked Questions