Jira & Confluence 
Bitrix24 01
Fill it in the browser
Type into the inventory list right on this page — no sign-up. Save it to a free Layers account to keep it.
- Works today Pages, spreadsheets and documents in the browser
Philippines · Due 30 January 2027
Inventory list template for BIR — fill it in, print it, submit by 30 January 2027
Calendar-year taxpayers submit the inventory list to BIR within 30 days after year end — by 30 January 2027. The list is open below; the Excel version builds it from your stock list with deliveries and sales.
| STOCK LIST — quantities from opening count + movements | ||||||||||||
| Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them. | ||||||||||||
| Business | Kapitbahay Hardware (sample) | Count date | 2026-01-01 | |||||||||
| Item code | Description | Category | Unit | Opening qty | Qty in | Qty out | On hand | Unit cost (₱) | Total cost (₱) | Reorder level | Reorder? | Location |
| HW-0001 | Portland cement, 40 kg bag | Merchandise | bag | 120 | 200 | 95 | 225 | 255.00 | 57,375.00 | 50 | Bodega A | |
| HW-0002 | Deformed bar 10 mm × 6 m | Merchandise | pc | 300 | - | 140 | 160 | 182.00 | 29,120.00 | 50 | Bodega A | |
| HW-0003 | Deformed bar 12 mm × 6 m | Merchandise | pc | 220 | 120 | - | 340 | 268.00 | 91,120.00 | 50 | Bodega A | |
| HW-0004 | Plywood 1/4" marine 4×8 | Merchandise | sheet | 60 | 40 | - | 100 | 495.00 | 49,500.00 | 50 | Bodega A | |
| HW-0005 | Common nails 3" (kg) | Merchandise | kg | 180 | - | 150 | 30 | 82.00 | 2,460.00 | 50 | Reorder | Bodega A |
| HW-0006 | Latex paint, white, 4 L | Merchandise | gal | 48 | - | 21 | 27 | 720.00 | 19,440.00 | 50 | Reorder | Bodega A |
| HW-0007 | PVC pipe 1/2" × 3 m | Merchandise | pc | 150 | - | - | 150 | 95.00 | 14,250.00 | 50 | Bodega A | |
| SUP-001 | Plastic bags, large (pack) | Supplies | pack | 40 | - | 12 | 28 | 65.00 | 1,820.00 | 50 | Reorder | Bodega A |
| - | - | - | - | |||||||||
| - | - | - | - | |||||||||
| TOTAL | 265,085.00 | |||||||||||
| 3 items to reorder · 0 with negative stock | ||||||||||||
| © Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers. | ||||||||||||
| MOVEMENTS — deliveries in, sales and use out (one line each) | |||||
| Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them. | |||||
| Date | Item code | Description (automatic) | Qty in | Qty out | Reference (DR, OR, SI No.) |
| 2026-01-08 | HW-0001 | Portland cement, 40 kg bag | 200 | DR 4410 | |
| 2026-01-09 | HW-0001 | Portland cement, 40 kg bag | 95 | SI 0012-0031 | |
| 2026-02-03 | HW-0002 | Deformed bar 10 mm × 6 m | 140 | SI 0012-0102 | |
| 2026-02-14 | HW-0004 | Plywood 1/4" marine 4×8 | 40 | DR 4482 | |
| 2026-03-02 | HW-0006 | Latex paint, white, 4 L | 21 | SI 0012-0188 | |
| 2026-03-20 | HW-0005 | Common nails 3" (kg) | 150 | SI 0012-0240 | |
| 2026-04-05 | HW-0003 | Deformed bar 12 mm × 6 m | 120 | DR 4530 | |
| 2026-04-06 | SUP-001 | Plastic bags, large (pack) | 12 | store use | |
| © Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers. |
| INVENTORY LIST | ||||||
| Year-end inventory list — draft from your stock list. Use the exact BIR format for your industry (RMC 57-2015, Annex A for merchandising / manufacturing). | ||||||
| Taxpayer name | Kapitbahay Hardware (sample) | |||||
| TIN | 000-000-000-00000 | |||||
| Registered address | Brgy. San Isidro, Example City | |||||
| RDO code | 000 | |||||
| Inventory as of | 2026-12-31 | |||||
| Due to BIR (30 days after year end) | 2027-01-30 | |||||
| Item code | Item description | Category | Unit | Quantity | Unit cost (₱) | Total cost (₱) |
| HW-0001 | Portland cement, 40 kg bag | Merchandise | bag | 225 | 255.00 | 57,375.00 |
| HW-0002 | Deformed bar 10 mm × 6 m | Merchandise | pc | 160 | 182.00 | 29,120.00 |
| HW-0003 | Deformed bar 12 mm × 6 m | Merchandise | pc | 340 | 268.00 | 91,120.00 |
| HW-0004 | Plywood 1/4" marine 4×8 | Merchandise | sheet | 100 | 495.00 | 49,500.00 |
| HW-0005 | Common nails 3" (kg) | Merchandise | kg | 30 | 82.00 | 2,460.00 |
| HW-0006 | Latex paint, white, 4 L | Merchandise | gal | 27 | 720.00 | 19,440.00 |
| HW-0007 | PVC pipe 1/2" × 3 m | Merchandise | pc | 150 | 95.00 | 14,250.00 |
| SUP-001 | Plastic bags, large (pack) | Supplies | pack | 28 | 65.00 | 1,820.00 |
| TOTAL INVENTORY | 265,085.00 | |||||
| Merchandise | 263,265.00 | |||||
| Raw materials | - | |||||
| Goods in process | - | |||||
| Finished goods | - | |||||
| Supplies | 1,820.00 | |||||
| Submit with a notarized certification of the taxpayer's authorized representative (Annex D of RMC 57-2015), soft copy as your RDO requires. Totals must agree with the financial statements. | ||||||
| © Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers. | ||||||
Start typing right in the document — no sign-up. It stays in this browser; save it to your free Layers account to keep it, open it on your phone and share it.
- 1Fill in. Type into the inventory list template right here on the page — no sign-up, nothing to install.
- 2Print or download. Print it in one click, or download the Excel file to keep and edit.
- 3Send. Print it with the notarized certification (Annex D) and submit it to your RDO in the medium it requires.
- 4Deadline. Within 30 days after year end: 30 January 2027 for calendar-year 2026.
What is inside
The Excel file, sheet by sheet
Stock list
Item code, description, category, unit, opening count, quantity in and out, on hand, unit cost, total cost.
Movements
Deliveries (DR) in, sales (SI / OR) out — on-hand quantity updates itself.
Reorder
Reorder level per item; "Reorder" and negative-stock flags.
BIR inventory list
Taxpayer, TIN, RDO, inventory as of 31 December, items and totals by category; deadline computed.
Yellow cells are for you to type, blue cells are calculated. Ordinary formulas, no macros — opens in Excel, Google Sheets and LibreOffice. Licence CC BY 4.0 · © Layers (layers.md).
How to use it
Five steps
1
Count
Do a physical count at year end and type the quantities.
2
Cost
Unit cost by your costing method (e.g. weighted average); total cost follows.
3
Check
Total inventory must agree with your financial statements.
4
Use the BIR format
Copy the list into the exact format for your industry (RMC 57-2015: Annex A for merchandising / manufacturing).
5
Submit by 30 January
With the notarized certification (Annex D), in the medium your RDO requires.
What people do next
Books of accounts
Inventory feeds the cost of sales in your year-end books.
Keep the stock list going
Record deliveries and sales during 2027 so next year's count is easier.
What Layers does with it
Honest status: Works today is live now; Coming is not yet.
02
The real Excel file
Formulas, checks and print layout in .xlsx — opens in Excel, Google Sheets and LibreOffice.
- Works today Download as .xlsx
03
Share and work together
One folder for the team: everyone sees the latest version; comments instead of e-mail threads.
- Works today Drive with shared folders, chat, calls
04
Edit the Excel file in Layers
Open the .xlsx in the Layers spreadsheet editor with formulas, without Microsoft Office.
- Works today For signed-in users
- Coming Right on this page, without an account
Questions
Who must submit an inventory list to BIR?
Taxpayers that keep inventory — manufacturers, wholesalers, distributors, retailers, real estate and construction companies — and taxpayers with tangible-asset-rich balance sheets (RMC 57-2015).
When is the BIR inventory list due?
Within 30 days after the close of the taxable year: 30 January 2027 for calendar-year 2026. Check your RDO for any advisory.
What format does BIR require?
The format in the annexes of RMC 57-2015 for your industry (Annex A for merchandising and manufacturing; separate formats for real estate and construction), with a notarized certification. Submissions in a different format may be treated as not received.
Can I keep my stock in this template all year?
Yes: record deliveries and sales on the Movements sheet; on-hand quantity and reorder flags update themselves.
Do I have to sign up?
No. The inventory list is open on this page; sign in free only to save it.
More free Excel templates
Keep it, share it, open it on your phone
The template and the editor are free. Layers is free for teams of up to 20 people.
Templates are starting points. Check figures and rules with your accountant, engineer or the agency concerned. Layers is an independent product.