• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Download Purchase Return Book With Tax Excel Template

Download Purchase Return Book With Tax Excel Template

Recently, many countries have implemented various taxes like GST and VAT. Taking into consideration all these things and other applicable expenses we have created an advanced Purchase Return Book With Tax.

Earlier, we have issued a Simple Purchase return Book Template which only contains simple transaction details.

What is a Purchase Return Book?

Purchase Return Book is a subsidiary book of accounts that records the goods returned to our suppliers that are against the purchase order, poor quality, inaccurate quantity or untimely delivery. Purchase Return Book is also called Return Outward Book.

Such discrepancies happen often in every business and are a routine part of the business. Such transactions are posted in the Purchase Return Book in the respective account of the supplier as and when the return of goods takes place.

Every entry in the Purchase Return Book is made on the basis of debit notes issued by the buyer to the suppliers.

Thus, the supplier’s account is debited in our books of account. Accounts Payable amount of the supplier decreases whenever a purchase return is initiated.

Purchase Return Book With Tax Excel Template

We have created a simple and ready-to-use Purchase Return Book With Tax with predefined formulas. You can easily record your purchase transaction in this template.

Click here to download Purchase Return Book With Tax.

Click here to Download All Accounting Excel Templates for ₹299.

You can download other accounting templates like Accounts Payable With Aging, Accounts Receivable With Aging, Petty Cash Book, and Expense Report.

Let us discuss how to efficiently use this template.

How to use Purchase Return Book Template With Tax?

Purchase Return Book Template With Tax is really a simple and easy template. This template consists of 2 sections:

  1. Header Section
  2. Data Input Section.

1. Header Section

The header section consists of your company name and logo and the heading “Purchase Return Book”. In addition to that, enter the month and year for which you are maintaining the Purchase Return Book.

Purchase Return Book With Tax

2. Data Input Section

Data Input Section consists of the following columns:

Date: Date of Goods Returned

Debit Note No.: Debit Note Number

Invoice No.: Invoice Number against which the debit note is issued.

Supplier Name: Select the supplier name from the dropdown list.

Purchase Return Book With Tax

The names of the suppliers can be updated in the Supplier Sheet.

Purchase Return Book With Tax

Product Details: Insert the product name or article number etc for the product in this column.

If there are multiple products then in one debit note enter only the names of products. Otherwise, you can add it in multiple rows with the same debit note number and invoice details. The same applies when there are multiple tax rates for different products.

Purchase Return Book With Tax

Quantity: Quantity of the product returned.

Rate: Rate of the product.

Tax %: Applicable Tax percentage on the product.

Tax Paid: This column contains a predefined formula. Thus, entering the percentage in the previous column is enough. The formula applied here is:

[(Quantity X Rate) X Tax %]

If you just want to enter the tax amount leave the Tax % column blank and overwrite the formula.

Other Expenses: Whenever a purchase takes place there are many additional expenses incurred on it. Some businesses claim back such expenses from their suppliers in lieu of the wrong supply.

Total Amount: Final line total including the product price, tax, and other expenses. The formula applied here is:

[(Quantity X Rate) + Tax Paid + Other Expenses] 

In the end, the Final Total of Purchase Return in that month is displayed in the last row. Sum Function is used to calculate the Purchase Return Total Amount for the respective month.

Report Printing

When there are many such purchase return transactions, there are 2 ways to manage the records and print reports for a particular supplier.

The first way is that you can make one sheet per supplier. The second way to do this is that you can use the table function. The Excel Template has been created using the table.

You can print reports pertaining to any column heading. Just click on the button beside the column heading. It will display a dropdown list. Select the desired date, supplier name, tax %, etc and click “OK”.  The sheet will display the desired results. See images below:

Input:

Purchase Return Book With Tax

Output:

Purchase Return Book With Tax

The Purchase Return Total will display the sheet total only. To know the total of a particular supplier, either select the cells with the amount and it will display the amount in the below bar or you can enter sum formula for the respective cells in another cell.

Purchase Return Book With Tax can be a useful tool to maintain your purchase return records. Regular maintenance of the Purchase Return Book helps to avoid discrepancies of creditor’s accounts.

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries please share in the comment section below. I will be more than happy to assist you.

« Download Purchase Order Excel Template
Download Marketing Budget Excel Template »

Filed Under: Accounting Templates

You are Here: Home / Excel Templates / Accounting Templates / Download Purchase Return Book With Tax Excel Template

About Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Accounting Templates

  • Accounts Payable Excel Template
  • Accounts Receivable Excel Template
  • Cash Book Excel Template
  • Invoice Excel Templates
  • Expense Report Excel Template
  • Petty Cash Book Excel Template
  • Inventory Management Excel Template
  • Billing Statement Excel Template
  • Purchase Return Book Excel Template
  • Accounts Payable With Aging Excel Template
  • Accounts Receivable With Aging Excel Template
  • Budget With Charts Excel Template
  • Checkbook Register Excel Template
  • Purchase Order Excel Template
  • Purchase Return Book With Tax Excel Template
  • Marketing Budget Excel Template
  • Asset Inventory Tracker Excel Template
  • Depreciation Calculator Excel Template

ExcelDataPro

Free Excel Pro Templates

  • Glossary
    • Accounting Glossary
    • HR & Payroll Glossary
    • Tax Glossary
  • Templates
    • Accounting
      • Financial Analysis
      • Financial Statement
    • Educational
    • Taxation
      • Federal Income Tax
      • GST
      • UAE VAT
      • UK VAT
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Sales-Marketing
    • Personal Finance
    • Other
      • Health & Fitness
  • Functions
  • FAQ’s
  • Blog
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2023. Content Licensed Under Creative Commons with Attribution Required

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT