If by “BIR” you mean the Philippine Bureau of Internal Revenue, an annual inventory list is a year-end schedule of the goods and materials a business has on hand. The template below is a practical starting point, not a form represented as an official BIR-issued file; check current BIR instructions for the applicable format, deadline, and submission method.
What an Annual Inventory List Is
An annual inventory list records the stock a business holds at a stated date, usually the end of its accounting or taxable year. Depending on the business, it may cover merchandise held for sale, raw materials, work in process, finished goods, and supplies that are part of inventory records. The list helps explain how the business arrived at its closing inventory figure and gives staff a structured record to compare with stock on shelves, in storage, or held elsewhere.
For a BIR-related purpose, the important distinction is between a useful working template and an official or currently required filing format. A spreadsheet with sensible columns can help organize records, but that alone does not establish that it satisfies a particular reporting requirement. BIR rules and administrative instructions can change, and requirements may depend on the taxpayer and the nature of its business. Verify the rules that apply to your circumstances before submitting anything.
An inventory list is also not necessarily the same thing as a stock card or a full transaction ledger. A stock card tracks movements in and out over time; a year-end list is a snapshot of quantities and values on a specific date. The two records should be consistent, but they serve different purposes.
Annual Inventory List Template
Blank template — enter one item per row. Add rows as needed and keep the supporting count sheets or records with the completed schedule.
| Business and reporting details | |
|---|---|
| Registered business name | |
| Taxpayer identification number | |
| Business address | |
| Taxable or accounting year | |
| Inventory date | |
| Prepared by and date | |
| Item code | Description | Category | Unit | Quantity on hand | Unit cost | Total cost | Location or notes |
|---|---|---|---|---|---|---|---|
Sample (fictional) — the figures below only illustrate how a row might be completed; they are not a prescribed BIR valuation rule.
| Item code | Description | Category | Unit | Quantity on hand | Unit cost | Total cost | Location or notes |
|---|---|---|---|---|---|---|---|
| DEMO-01 | Blue ceramic mug | Merchandise | piece | 12 | ₱100 | ₱1,200 | Fictional sample stockroom |
What to Put in Each Column
Give every item a description that someone other than the person who counted it can recognize. An internal item code helps distinguish similar products, while the category makes it easier to group merchandise, materials, or work in process. State the unit clearly: pieces, boxes, kilograms, meters, or another unit used consistently in the business. If a box contains a fixed number of pieces, record the unit and conversion clearly rather than mixing boxes and pieces without explanation.
Quantity on hand should reflect the inventory date, not a later date when the spreadsheet happens to be completed. Unit cost and total cost make the schedule more useful for reconciliation, but the method used to determine cost should follow the business’s accounting records and applicable requirements. The simple multiplication shown in the sample works only when it matches the actual unit-cost basis being used.
Use the notes or location column for details that help explain the count: for example, stock in a named storage area, goods set aside as damaged, or items held by another party. Notes are not a substitute for supporting documents. If an item’s status affects whether or how it belongs in the schedule, keep a record of the facts and confirm the treatment rather than silently excluding it.
How to Prepare the List
A reliable list starts with a defined cutoff date and a count process. Plan the count so that movements of goods during the count are controlled or documented; otherwise, a sale, delivery, or transfer may be recorded on the wrong side of the cutoff. For a small operation, a careful physical count may be manageable. A larger business may need count teams, assigned locations, and a way to mark areas already counted.
- Set the inventory date and identify the locations and categories to be covered.
- Prepare count sheets with item descriptions and units, but avoid relying only on a prefilled quantity if that could bias the physical count.
- Count and record goods, including stock in separate storage areas or with another party when relevant to the business’s records.
- Investigate differences between the physical count and stock records; document adjustments and their reasons.
- Enter the final quantities and values in the schedule, then compare its totals with the inventory balance in the accounting records.
- Have an appropriate person review the completed list, save the supporting records, and check current BIR instructions if the schedule is for submission.
For example, a small shop might count 24 units of a product in the sales area and 6 in a back room. The list should show the total on hand as 30 if both locations are within scope, while the location notes or count sheets preserve the detail. If the accounting record says 32, the difference needs investigation; changing the list to 32 just to match the ledger would not document what was actually counted.
Quantities, Cost, and Reconciliation
A list can be arithmetically tidy and still be unreliable if its quantities or cost basis are unclear. Keep units consistent, check extensions, and make sure the total agrees with the supporting calculation. When several purchases of the same item have different costs, do not assume that the latest invoice price is automatically the correct unit cost for the entire quantity. The business’s established accounting method and relevant rules govern how inventory is valued.
Reconciliation means comparing the completed schedule with other records, such as count sheets, stock cards, purchase and sales records, and the inventory balance in the books. It does not mean forcing every record to agree without explanation. Differences can arise from timing, data-entry mistakes, breakage, returns, unrecorded transfers, or counting errors. Record the cause when it is known and retain evidence for any adjustment.
Damaged, obsolete, or slow-moving goods deserve attention because their physical presence and their recorded value are separate questions. Identify them rather than quietly removing them from the count. Whether a value adjustment is appropriate is a matter for the business’s accounting treatment and applicable requirements; ask a qualified tax professional for help with a situation that requires a tax or accounting determination.
Which Items and Locations to Consider
The right scope depends on what the business sells or makes and how it keeps its records. A retailer may mainly list goods held for resale. A manufacturer may have raw materials, partly completed products, and finished goods. A service business may have few or no goods for sale, but it could still hold materials or supplies that its inventory records treat as inventory. Do not copy another business’s categories without checking whether they fit your operations.
Think beyond the main storeroom. Relevant stock may be on a sales floor, in a branch, in a vehicle, at a temporary site, or held by a third party. Conversely, items physically present may belong to someone else or may be held under arrangements that need separate review. Record enough information to explain the item’s location and status, then confirm how it should be treated for the particular purpose of the list.
For a business with many small items, a useful schedule can group items only when the grouping remains clear and traceable to detailed records. A single line labelled “assorted goods” is usually less helpful than item-level detail, especially if quantities and unit costs vary. Keep the detailed records available even if a required summary uses broader categories.
Format, Submission, and Recordkeeping
The template is designed for internal organization and can be adapted to a spreadsheet or printed count sheet. It is not a guarantee of BIR acceptance. Before filing, check the current BIR guidance for the taxpayer’s filing situation, including whether a list is required, what information or file format is specified, the applicable deadline, and the authorized submission channel. Do not rely on an old checklist or a remembered deadline when current instructions can be checked.
Keep a dated copy of the submitted schedule and the records that support it, such as count sheets, reconciliations, and explanations of adjustments. Use a clear file name that identifies the business and inventory date, and preserve a version that cannot be casually overwritten. If the business later corrects a schedule, retain the revised version and a note describing what changed and why, following its recordkeeping procedures.
When a template is converted to a required electronic format, verify that headings, units, dates, and totals remain readable. Do not add confidential information that is not required, and use only the official channel specified by current instructions. For a filing decision specific to your business, ask a qualified tax professional.
Common Errors to Avoid
- Using the wrong date: Label the inventory date and keep the count tied to that cutoff, even if data entry happens later.
- Mixing units: Do not total cartons and individual pieces as if they were the same unit; state conversions and use them consistently.
- Leaving out locations: Include covered stock in branches, storage rooms, or other relevant locations, not just the easiest area to count.
- Copying book quantities without a count: Use records to investigate differences, not as a substitute for a physical count when one is needed.
- Using vague descriptions: A clear description or item code makes later checking possible and reduces confusion between similar goods.
- Assuming the sample is an official form: The example demonstrates layout only. Confirm current BIR requirements before treating any template as a filing document.
Another common misconception is that a year-end inventory list and an annual financial statement are interchangeable. They are related records, but a list of items and quantities is not, by itself, a complete set of financial statements or proof that all filing obligations have been met.
Frequently Asked Questions
Is this an official BIR inventory list form?
No. It is a generic working template intended to organize inventory details. Check current BIR instructions to find out whether a prescribed form, file structure, or additional schedule applies to your filing.
What date should the annual inventory list show?
Use the inventory date relevant to the business’s year-end records and the applicable filing instructions. Do not assume every taxpayer uses the same year-end or cutoff; confirm the correct date for your situation.
Do I include raw materials and work in process?
Those categories may be relevant to a manufacturer or another business that tracks them as inventory. Include the categories that fit the business’s operations and records, and verify any specific reporting scope required for the filing.
Can I submit this template as a spreadsheet?
Possibly, but the template alone does not establish an accepted submission format. Check the current instructions for the file type, required fields, and submission channel before sending it.
What if my physical count does not match my books?
Investigate the difference, check cutoff timing and count records, and document any correction and its reason. Do not change a quantity merely to make two records agree; seek qualified help if the difference raises an accounting or tax question.