< FormatWorks >

Item Wise PO Tracker Template

Item wise Purchase Order Tracking Sheet in Excel by FormatWorks. Download Now and start keeping track on the purchase orders released in your business.




Easily manage all the purchase orders (PO) released in your organization or in your client’s business with the help of this “Item wise PO Tracker” Excel Template. Customize this template as per your need and requirement.
Features of Item Wise PO Tracker

PO Stands for Purchase Orders. These are the documents created by buyer of goods or service, confirming the purchase or requesting the seller to make the supply. Now, in business, it will be very important to keep track of all the procurement made. Thus, the importance of this tracker differs with the size and nature of the business.

For management of procurement and creation of purchase orders, entity may implement ERP solutions like SAP, Dymanic365 etc. However, sometimes entities choose to create manual purchase orders as well. In such case, list of purchase orders (PO) created in a period of time, along with tax and other component paid towards each procurement is good to have information. In ERP like SAP, Purchase order list can be extracted using T-Codes like ME2N or ME2L or tables like EKKO and EKPO.

This template will help you keep track of all the items procured, respective purchase orders and other information like:

  • Invoice type, supplier information, supplier invoice number
  • VAT rate applicable
  • Address and other basic information of supplier
  • Item description, price, net value, VAT amount/ Tax amount
  • PO Number, PO Item
  • Cost object
  • Service entry sheet number etc.

Thus, the intention and use of this template is to keep track of all the Purchase orders issued to any particular Vendor/ Supplier. For example, a supplier may issue single invoice for multiple purchase orders issued and materials supplied.

Three way match concept

Now, this tracker template will help in three way match of;

  • Procurement order released
  • Items accepted along with quantity and value
  • Invoice received and payment to be made.

Three way match is a very important concept in business. In simple words, it is the process of comparing the purchase order, invoice, and goods receipt to make sure they match, prior to approving the invoice. Since, this excel template is fully customizable, you can add more fields and columns to make your own version.

Download Instructions

Follow the download instructions below, if you need any assistance. You can download this template for free and start customizing or using it. All the templates, resources, formats and designs are free of cost. However, By downloading this template, you also accept our terms of use policy and privacy policy.

Once you download this template, by default, the file/ folder extension will be compressed (zip). You will require decompressing software to get all the template files. You can use 7ZIP, WINRAR etc. Also, ensure that you have the appropriate software installed on your system for the file type you are downloading (e.g., Microsoft Office for DOCX and XLSX files, a PDF reader for PDF files). Now, Right-click on the template file you’ve downloaded and Select “Open With” from the context menu.

You can choose the relevant software/application to open the file. For DOCX files, use a word processing application (e.g., Microsoft Word). For XLSX files, use a spreadsheet application (e.g., Microsoft Excel). For PDF files, use a PDF reader (e.g., Adobe Acrobat). Alternatively, you can double-click on the template file, and it will open in the default application associated with that file type on your system.

If you encounter any issues, ensure your software is up-to-date or consider using an alternative application that supports the file type.

Picture of FormatWorks
FormatWorks Inc. offers free designs, templates, formats and layouts for various personal and business use cases. Our aim is to deliver resources free of cost. You can get templates for presentation, spreadsheet, CV/ Resume, agreements and more.

Related Templates