✦Template Printable Ideas Insights

Sales Return Day Book: Step-by-Step Example

By

A sales return day book is a crucial accounting record that documents every day's sales returns in a business. Maintaining a sales return day book not only helps maintain accurate financial records but also aids in stock management and customer service improvement. This article will guide you through the purpose, format, and examples of a sales return day book.

Before diving into the details, it's essential to understand that a sales return day book is different from a sales day book, which records daily sales. While the sales day book records outgoing inventory, the sales return day book records the reversal of that process, i.e., incoming inventory due to customer returns.

The Purpose of a Sales Return Day Book

The primary function of a sales return day book is to record and track sales returns accurately. It helps businesses to:

an open notebook with lots of writing on it
an open notebook with lots of writing on it
Free Daily Sales Report Excel Template
Free Daily Sales Report Excel Template
Book Sales Order (PDF)
Book Sales Order (PDF)
  • Reconcile differences between sales and returns.
  • Identify product return trends.
  • Track returned inventory for stock adjustments.
  • Aid in inventory control and stock management.

Sales Return Day Book Format

A sales return day book typically includes the following columns:

  • Date - The date of the sales return.
  • Invoice/Receipt Number - The unique identifier of the original sales transaction.
  • Customer Name/Seller's Name - Identification of the customer or seller involved in the return transaction.
  • SKU/Product Code - The unique code assigned to each product or item.
  • Description - A brief description of the returned item.
  • Quantity - The number of units returned.
  • Unit Price - The price per unit of the returned item.
  • Total Price - The total price of the returned item(s).
  • Reason for Return - A brief note on why the item was returned (e.g., damaged, wrong item, customer dissatisfaction).

Sales Return Day Book Example Entries

Here's an example of how to fill out the sales return day book:

Purchase Return Book Template | Business Return Tracker | Supplier Return Record | Purchase Return Register
Purchase Return Book Template | Business Return Tracker | Supplier Return Record | Purchase Return Register
the sales report is shown in this file, and it shows how many items are sold
the sales report is shown in this file, and it shows how many items are sold
the daily sales report is shown in an orange frame
the daily sales report is shown in an orange frame
Date Invoice No. Customer Name SKU Description Quantity Unit Price Total Price Reason for Return
01/05/2022 INV001 John Doe 001 Black Shirt 1 20.00 20.00 Wrong Size
01/05/2022 INV002 Jane Smith 002 Blue Jeans 2 30.00 60.00 Damaged

Adjusting Inventory and Accounting Records

After recording a sale return in the day book, remember to update your inventory records by increasing the stock level and reversing the initial sales entry in your accounts.

Updating Inventory Records

To adjust inventory, cross out the initial sales line and replace it with the returned quantity, ensuring your stock levels are accurate.

Reversing Accounting Entries

Reverse the initial sales entry by debiting the sales account and crediting the cost of goods sold (COGS) account. This rectifies the income statement, ensuring profits reflect the actual sales.

Weekly Sales Summary Log | Small Business Tracker (PDF Download A4/US Letter)
Weekly Sales Summary Log | Small Business Tracker (PDF Download A4/US Letter)
Vintage Lot of 2 Adams Sales Order Book for Business, 3 Part Carbonless and carbonless sales book. Preowned good condition.
Vintage Lot of 2 Adams Sales Order Book for Business, 3 Part Carbonless and carbonless sales book. Preowned good condition.
Sample Daily Sales Report Template in Word, Pages, PDF, Google Docs - Download | Template.net
Sample Daily Sales Report Template in Word, Pages, PDF, Google Docs - Download | Template.net
the sales playbook is shown in black with red and white text on it,
the sales playbook is shown in black with red and white text on it,
an open sales report sitting on top of a table
an open sales report sitting on top of a table

Regularly maintaining a sales return day book ensures accurate financial records, helps with stock management, and provides valuable insights for improving customer service and product offerings. So, make it a habit, and watch your business thrive.

Now that you understand the importance and function of a sales return day book, why not give it a try and see the transformation in your business's inventory and financial records?