Skip to main content

Supplier Returns

Credit purchases and return stock to your suppliers with Supplier Returns.

Heather Worthington avatar
Written by Heather Worthington
Updated yesterday

Use Supplier Returns to credit and return the stock you've purchased and ensure your Stock on Hand (SOH) value and quantity are up to date and accurate in real-time. Within each Supplier Return, you can also choose whether any additional costs incurred from the original Purchase Order (PO) should be refunded or written off.

Tutorial Video: How to manage Supplier Returns

Supplier Return Reasons

Within each line of a Supplier Return, you can select a "reason" as to why the product has been either credited or returned to your supplier. By defining a reason per return line, you're able to keep an eye on your supplier's performance, and use the data to guide your future purchasing decisions.

To create Supplier Return Reasons specific to your business, head to the main menu and select Settings > System > Supplier Return Reasons.

Supplier Return role permissions

A user must have the permission "Supplier Return" enabled to create and complete a Supplier Return.


Create a Supplier Return

You can create more than one Supplier Return per PO, provided there is still stock or value needing to be returned for it. Once a PO is in a Complete status, a Supplier Return can be created for it in one of the following ways:

  • From the original PO's page, by clicking on the Return button in the top right corner of the PO.

  • From the View Purchases page, by clicking on Return in the PO's individual action cog icon's menu.

  • From the main menu, under Purchases > Supplier Returns > Add Supplier Return. Search and select the order number of the PO being returned in the Purchase Order Number field.

If a Supplier Return has already been created for a PO, a pop-up window stating "Supplier returns already exist for this purchase" will be shown, allowing you to review the Supplier Returns that already exist and ensure you're not creating unnecessary duplicates. But you also have the option to click on the Create New button, in the same window, to proceed with creating another Supplier Return.

Upon creation, a Supplier Return will be given an auto-generated order number, a Parked status, and all order lines and costs that were included on the original PO upon completion will be populated in it. You can then manage the products, quantities, costs, and prices in the Supplier Return as necessary, to ensure you credit or return only the appropriate stock when completing it.

Manage a Supplier Return

Whilst a Supplier Return is in Parked status, you can update the products, quantities, prices, and costs included on it to ensure you only return the appropriate inventory and value from your stock to your supplier. The details included on a Supplier Return will determine how the remaining stock's on hand and quantities and values are updated, so you must ensure they are accurate prior to completing.

Alternatively, if the Supplier Return is no longer needed, you have the opportunity to delete it by clicking on the Delete button in the bottom right corner of a Parked Supplier Return. Once a Supplier Return is deleted, it cannot be edited or restored.

Supplier Return header fields

In the header fields on the Supplier Return, you will see the return's original Purchase Order Number, the PO's supplier, and the PO's original Order Date, all of which cannot be edited in the return. However, you can update the following header details, as necessary, in the Supplier Return:

  • Supplier Reference

  • Warehouse

  • Return Date

  • Template

  • Supplier EORI

๐Ÿ“ŒNote: If returning the stock to the supplier, the stock must be in the warehouse it was originally receipted into.

Supplier Return header fields explained

  • Supplier Reference: The original PO's supplier reference will automatically populate, but you can update it per your Supplier Return's requirements.

  • Warehouse: Use the dropdown menu to ensure the warehouse the PO was originally receipted into is selected.

  • Return Date: Set a date for when the stock is due to be returned to your supplier.

  • Template: Use the dropdown menu to select which Doc Designer template will be used when emailing tr printing the Supplier Return.

  • Supplier EORI: The EORI number provided in the supplier's record will populate automatically, but you can update the field per your Supplier Return's requirements.

Supplier Return Order Lines

Below the Supplier Return's header fields, you'll find all the order lines initially included on the PO populated for return. Update the return prices, quantities, and reasons for the products being returned, or use the bin icon to delete any order lines not due to be credited or returned to the supplier.

The following fields are available to edit per order line in a Supplier Return to align with the credit and stock returns due for your supplier:

  • Base Unit Quantity

  • Return Quantity

  • Return Price

  • Return Cost

  • Reason

  • Return

๐Ÿ“ŒNote: You cannot return more than what was receipted on the original PO.

Supplier Return Order Line fields explained

  • Base Unit Quantity: The number of base units to be returned or credited, auto-calculated from the unit of measure and Return Quantity provided.

  • Return Quantity: The number of units to be returned or credited, based on the unit of measure selected.

  • Return Price: The per-unit price to be credited to the supplier.

  • Reason: Use the dropdown menu to select a Supplier Return Reason for why the product is being credited or returned.

  • Return: Use the checkbox to identify whether the stock is due to be physically returned to the supplier. If Return is ticked, the number of units advised in Return Quantity will be removed from SOH to be returned to the supplier. If Return is not ticked, SOH will remain unchanged.

Important: At least the Return Quantity or Return Price greater than zero must be provided per order line on a Supplier Return.

Bulk actions for Supplier Return order lines

Hover over the action cog icon in the Supplier Return's order line header to see the options available for bulk-updating the lines of the return. Choose "Select All" from the action cog's menu, and all checkboxes on the Supplier Return's current page will be ticked. Choose "Select None" and all checkboxes will be unticked. These options can then help you to delete or update the "Return" checkbox on each order line in bulk.

Use the "Check Return All Lines" or "Uncheck Return All Lines" actions in the column header's action cog menu to determine whether the order lines selected via the column's checkbox should remove stock from your SOH to return to the Supplier.

Select the "Delete Selected Lines" option in the column header's action cog menu to remove all lines selected in the column's checkboxes from the Supplier Return.

โ€‹โ€‹

Supplier Return Cost Lines

If the Supplier Return's original PO included additional costs, those costs will be automatically included on the Supplier Return in the Cost Lines section, below the order lines. The costs included in a Supplier Return will be used, along with the product's Return Price and Quantity, to calculate how much the returning product's stock value will be reduced by.

You can adjust the returning cost value via the Cost field, but for each cost, you will need to determine whether the returning cost is to be refunded or written-off using the selector options at the end of the cost's line:

  • Refund: Select Refund if a credit is due from the Supplier for the cost.

  • Write-off: Select Write-off if a credit is not due from the Supplier, but the cost is being absorbed as an expense.

By default, the Cost in a Supplier Return is distributed amongst the Supplier Return's order lines to calculate a "Return Cost" per line. If you reduce the Cost Line's cost, each order line's Return Cost will automatically update to align with the updated distributing value. You can also update each order line's Return Cost manually, but you must ensure the sum-total of Return Costs matches the total cost on the Supplier Return, in the cost supplier's currency. Click on the circular arrow shown in the Cost Line's Cost header to revert the adjusted Return Costs to their original distribution.

Complete a Supplier Return

When the details included on a Supplier Return, including the products, quantities, prices, and costs, are correct and your inventory needs to be updated to account for it, click on Complete the Supplier Return.

Once completed, the quantities ticked to be returned will be removed from your selected warehouse's SOH and the returning product's stock value will be updated to account for the credited prices and costs.

Print and email Supplier Returns

Supplier Returns can be printed or emailed using the button functions available at the bottom of each Supplier Return, or via the action cog in the View Supplier Returns page. When printed or emailed, the Doc Designer template chosen in the Supplier Return's Template field will be used to generate the PDF version of the Supplier Return.

You can automate default message and subject line used when a Supplier Return is emailed by heading to your Settings > Company and in the Email Templates tab, updating the Supplier Return email template. You'll have the opportunity to add further detail to each Supplier Return's email, but the email template will be used to provide an initial format to the message.

Click on the View Email Log button in the Supplier Return to review any emails sent to the supplier from the Supplier Return. It is not possible to review the email's content, but you're able to review the recipients, senders and dates of each email.


Residual values

A "residual value" is the difference between a product's current value and its initial purchase landed costs. When a product is receipted into your inventory, the product's Average Landed Cost (ALC) is recalculated, using the receipted purchase price and distributed costs, to determine the product's current total stock value.

A residual value error can occur and will stop a Supplier Return from being completed if:

  • The returning value of a product is greater than the current on-hand value, regardless of the current stock on hand quantity.

  • The returning value is less than the current on-hand value, and the Supplier Return is also expected to reduce the product's stock on hand to zero.

To resolve a residual value error, you must update the product's current total stock value to match the value of the stock being returned, which can be done using either a stock revaluation or a value-only Stock Adjustment.

If a residual value error occurs because the "Return" checkbox was not selected during the Supplier Return, consider completing a manual stock adjustment as follows:

  • Manually adjust the stock value associated with the unchecked return.

  • Specify the stock adjustment at the original purchase order (PO) value. This approach ensures consistency by reconciling the inventory to properly reflect the stock removal from the Supplier Return.

Example of a residual value

Let's say you have 1 unit of a product in your SOH, and it has an ALC of $105, meaning its total stock value is $105. This 1 unit is due to be returned to your supplier, but was originally purchased at $100. If a Supplier Return were to be completed, the unit would be removed from your SOH up to its original purchase value; thus, the product's remaining stock value would be calculated as $105 - $100 = $5. As this remaining $5 does not have any SOH to allocate to, it is considered a residual value that needs to be resolved before you can complete the Supplier Return.

Value-only Stock Adjustments

A value-only stock adjustment allows you to update a product's current total stock value, without adjusting its SOH quantity. The adjustment would also result in the product's ALC being recalculated to align with the new total stock value.

To complete a value-only stock adjustment:

  1. From the main menu, navigate to Inventory > Transactions > Stock Adjustment and select Add Adjustment.

  2. In the Product field, search and select the product that requires value adjustment.

  3. In the Quantity field, enter 0.

  4. In the Value field, enter the total value needing to be adjusted, based on the total SOH quantity. To decrease the product's value, enter a negative number, e.g., -5.

  5. Click on Add.

  6. Select Complete, and the product's stock value will adjust by the value entered and its ALC will be recalculated.

Example of a residual value adjustment

If you encounter a minor residual value error, such as GBP-0.02, follow these steps:

  1. Navigate to Inventory > Transactions > Stock Adjustment > Add Adjustment.

  2. Select the problematic product.

  3. Set the quantity to "0."

  4. Enter "0.02" (or the exact residual value amount causing the error).

  5. Add the adjustment and select Complete. This ensures your inventory value aligns with the original received value, allowing you to process the Supplier Return successfully.

Tips for completing a value-only Stock Adjustment

  • Select a warehouse in the Stock Adjustment's Warehouse field that currently has an SOH greater than zero.

  • Create an Adjustment Reason specifically for Stock Adjustments completed for residual value corrections to aid accurate and insightful reporting.

  • If integrated with an accounting provider, use the Account field in the Stock Adjustment to select which Cost of Goods Sold (COGS) account the adjustment should apply to.

  • When addressing discrepancies caused by unreturned stock due to unchecked returns, ensure the stock adjustment reflects the original PO value for accurate inventory reconciliation.

  • For recurring errors, consider periodically reviewing processes to ensure the "Return" checkbox is consistently selected during Supplier Returns.


Integrating Supplier Return costs with an accounting provider

How the Cost Lines included on a Supplier Return will export to your integrated accounting provider (Xero or QuickBooks) will differ, depending on whether the cost is being refunded or written off, and whether the cost supplier is the same as the stock's supplier. The table below outlines how each variation of cost lines will export, per accounting provider.

Cost Line selection

What exports from Unleashed

Xero receives

QuickBooks receives

Refund
Same Supplier for PO and Costs

A Supplier Return for the PO and Costs

A journal to remove the total value from Stock on Hand account.

A journal to remove the total value from Stock on Hand account

Refund
โ€‹
Supplier PO differs from Cost Lines' Supplier

  • A Supplier Return for the PO

  • A Supplier Return for the Costs

Two journals (one for each Supplier's return) to remove the matching value from Stock on Hand account.

Go to Xero > Export data > Supplier Return Costs

Two journals (one for each Supplier's return) to remove the matching value from Stock on Hand account.

Go to Quickbooks > Export data > Type: Supplier Return Costs

Write-off

  • A Supplier Return for the PO

  • A Supplier Return for the Costs

Multiple journals:

  • A journal to remove the price value from Stock on Hand account.

  • A write-off journal to increase the expense account.

Go to Xero > Export data > Journal > Supplier Return Journal

Multiple journals:

  • A journal to remove the price value from Stock on Hand account.

  • A write-off journal to increase the expense account.

Go to Quickbooks > Export data > Journal > Type: Supplier Return Journal


Frequently asked questions

Can a Supplier Return be created if there is no Purchase Order?

You can only create a Supplier Return if there is an original Purchase Order completed in your account, for the stock to be returned against

If you have stock on hand for a product that needs to be sent back to a Supplier, but the stock was not receipted against a Purchase Order in Unleashed, complete a Stock Adjustment to remove it from your inventory's stock on hand.

Did this answer your question?