Year-End Inventory Count Does Not Match the Books in the Philippines: Find the Cause, Adjust Properly, Report Honestly to the BIR

Do not touch the figures yet: freeze the count, recount, and separate book errors from missing goods

The first step is to preserve the count exactly as taken, then run a second independent count on the categories with the largest differences. Until the discrepancy is confirmed real, not a single figure in the books changes. A good share of apparent shortages disappear on recount: the first team miscounted, mixed up units, or missed a batch stored somewhere nobody thought to look.

In practice:

1. Archive the original count sheets. Handwritten tally sheets, scanner exports, photographs, all filed as taken, with the date and the names of the counters. Do not correct the originals; record the recount on a new sheet.
2. Recount the large differences. Use a different team, ideally including someone not involved in day-to-day warehouse management. Recount only categories above the threshold you set, not everything.
3. Check the cut-off. Were receipts, shipments and returns in the days around the count date double-counted or missed? This is the most common source of a book error: goods shipped but not yet deducted in the system, or goods invoiced but not yet arrived.
4. Check units and conversions. Cartons, pieces, kilograms, metres: do the books and the count use the same unit? Imported goods are especially prone to this.
5. Check locations. Stock held at a supplier, in transit, at a branch, out for repair or on trial with a customer is easily left out.

After the recount, differences fall into two groups. Book errors: the goods exist but were recorded wrongly, and the fix is a correction of records. Missing goods: the stock is genuinely gone, the search for where continues, and any adjustment involves recognising a loss that needs evidence. Mixing the two groups is where most later trouble begins, so list them separately at this stage.

If the company keeps manual or loose-leaf books, first confirm that the books themselves are properly registered; otherwise there is nothing valid to adjust. See registering books of accounts in the Philippines.

Four directions to investigate: document lag, shrinkage and returns, system and human error, theft or misappropriation

Missing goods almost always trace to one of four causes. Investigate from the most likely and least harmful to the rarest and most serious, striking out the differences each cause explains before moving to the next.

Direction one: document lag. Goods were shipped or scrapped but the delivery note or disposal form never reached the books. Check outbound records, logistics documents and customer acknowledgements around the count date and confirm the system captured every release. These differences are explained once the documents are completed and are not losses.

Direction two: normal shrinkage and returns. Expired food and beverage, broken fragile items, samples given out, customer returns not yet received back into stock. These need records: disposal forms, breakage photos, sample issue slips, return notes. Shrinkage with no record is very hard to have recognised for tax, which is why documentation has to happen daily, not at year-end.

Direction three: system and human error. Entry mistakes, duplicate entries, confused item codes, conversion errors. Test by sampling: pick the categories with the largest differences and trace them transaction by transaction from receipt to release. System errors are explained by correcting entries, but keep the before and after records and the reason for each correction.

Direction four: theft or misappropriation. Only differences that the first three cannot explain belong here. Signals include differences concentrated in high-value or easily resold items, recurring in the same bay or the same shift, implausible manual adjustments in release records, and CCTV anomalies. The method changes at this point: stop discussing it in group chats, question nobody yet, and preserve evidence first (movement records, access logs, CCTV footage, handover sheets), then let management decide on an internal investigation and a police report. The procedure for employees is in handling employee embezzlement and theft.

An honest observation: most companies reach direction two and discover that the real problem is not theft but poor daily record-keeping. That finding is less dramatic than direction four, but it decides whether next year's gap is bigger.

Write the outcome of all four directions into a difference memorandum: for each category, the quantity difference, which direction it falls under, and the supporting documents. This memorandum is the core document for the adjustments and for any future audit.

Principles for adjusting: a document behind every entry, different treatment by type, a trail anyone can follow

Three rules for adjustments: every entry has a supporting document; differences of different types get different accounting treatment rather than one blanket write-off; and both the pre- and post-adjustment records are kept so anyone can trace them later. The specific entries and tax treatment are the accountant's work. What follows is the framework an owner or manager needs in order to talk to the accountant and judge whether the approach is sound.

• Book errors: correct the records. Post the missing releases, reverse duplicate receipts, fix conversions. The basis is the completed documents and a correction note. No loss is involved, but you must be able to explain why the original entry was wrong.
• Normal shrinkage: recognise as shrinkage. The basis is disposal forms, breakage records and sample slips. Whether and how this can be treated for tax depends on having compliant records and on the tax authority's current requirements for that kind of loss; some industries and goods require notifying the authority or having its representative witness the disposal. Follow the current rules and your accountant's advice.
• Theft or misappropriation: recognise as a loss. The basis is the police report, the internal investigation report and any insurance documents. The tax loss claim has its own procedure and deadlines, the same as for warehouse theft, set out in the tax filing for an inventory loss and what it requires.
• Unexplained differences: list them honestly as differences under investigation; do not force them into a category. The accountant will decide treatment by materiality, but never hide them inside another category or roll them into next year to make the figures look clean.

Common bad practices, none of which to touch: changing the opening balance directly, booking a loss as a sale followed by a return, using undocumented purchases to put goods back on the books, and deferring the difference to next year. Each is easy to detect in an audit, and each turns an accounting issue into a question of honesty. Why undocumented purchases cannot be used to fill the gap is explained in cash purchases with no receipts.

Once the adjustments are complete, the stock balance in the books, the inventory list and the financial statements must agree. If the three do not agree, the adjustment is not finished, and none of the three should be filed yet. If a return already filed needs correction, the process is in amending a return filed with the BIR.

Reconciling the BIR inventory list with the books: report actual figures, attach the explanation, never force a match

The inventory list shows the actual figures after the count and the adjustments, not the book figures and not the figures you wish you had. The list, the books and the financial statements must reconcile, with differences explained in writing rather than hidden in numbers. Format, filing method and deadline follow the tax authority's current rules and the accountant files it; here are the points an owner should watch.

One: consistent basis. Category groupings, units of measure and costing method (first-in first-out, weighted average and so on) must be the same in the list and in the books. Many companies' problem is not wrong numbers but a list prepared on one basis and books kept on another, which is exhausting to explain in an audit.

Two: a written explanation of differences. Turn the difference memorandum from the previous section into a version fit for submission or for the file: categories, quantities, amounts, cause classification and supporting documents. Even if the current rules do not require it to accompany the list, file it together with the list, because it is the only thing you will be able to produce when asked later.

Three: do not force a match. The most common shortcut is to enter book figures instead of actual figures on the grounds that nobody will come and count. The risk is that if an audit or a warehouse incident ever requires reconciliation, your list will contradict every other piece of evidence. Inconsistency between the list and the books is a standard audit focus; see the BIR tax audit process.

Four: year-end statement consistency. The total on the list must equal the stock balance on the year-end financial statements, and the movement in stock feeds the cost and profit figures. The accountant should run a three-way check before filing. The owner's only question is whether the list, the books and the statements show the same number.

Five: keep the complete set. Original count sheets, recount sheets, the difference memorandum, adjustment support, the final list and the filing acknowledgement, archived by year. The authority may request these within the statutory retention period, which follows current rules.

If bookkeeping is outsourced, ask the provider about every item in this section rather than assuming it was done. Companies bearing the consequences of an agent's missed or wrong filings are not rare; see when your bookkeeping agent botched the filings. The annual filing schedule is in the Philippine annual tax filing calendar.

When the difference points to theft or misappropriation: linking the police report, employee action and the tax loss claim

Once book errors, shrinkage and system errors are ruled out and theft or misappropriation is the remaining explanation, the order is: preserve evidence, decide on a police report, deal with the people involved, and only then make the tax loss claim. Do not reorder these, and above all do not act against a person before the evidence is secured.

Step one: preserve evidence. Movement records, access and CCTV logs, handover sheets, key and system permission assignments, and shift schedules for the relevant staff. CCTV retention is short, so request preservation immediately. Originals stay with management, never with anyone who might be involved.

Step two: decide on a police report. A report does three things: it creates a formal record, it supports any insurance claim, and it supports the tax loss claim. Even if nobody is ever caught, the report itself is a required document. File with the police covering the premises, bringing the difference memorandum, the evidence list and the count records, and ask for a copy or a reference number.

Step three: deal with the people involved. If evidence points to a specific employee, follow due process: written notice, an opportunity to explain, a hearing, then a decision. Dismissing without process can lose a labour case even where the facts are true. The procedure is in handling employee embezzlement and falsified records. If the evidence does not point to anyone, do not act on suspicion; tighten controls instead.

Step four: the tax loss claim. Whether an inventory loss can be recognised for tax, what documents are needed and the filing window follow the tax authority's current rules. Typical requirements include the police report, the internal investigation or count report, the loss list with its valuation basis and any insurance documents. Amounts recovered from insurance generally cannot be claimed again. The accountant handles this step; your job is to have kept everything from the first three.

One distinction to keep clear: stock missing after a break-in during the long holiday starts with the police report rather than the four-direction investigation; see an incident at the office during the year-end shutdown. The two paths converge at the adjustment and tax claim stage.

For employee liability and recovery, consult a licensed attorney; for tax treatment, a licensed accountant.

Making next year's count a confirmation rather than a discovery, and what Yixing can do

Companies with large year-end differences rarely have a year-end problem. They have a year-round problem: movements without documents, shrinkage without records, no separation of duties, and no interim counts. Fix those four and the year-end count becomes a confirmation, not a discovery.

From next year:

1. A document for every movement, the same day. A receiving report for goods in, a delivery note and acknowledgement for goods out, a disposal form for scrap, an issue slip for samples, a return note for returns. Electronic is fine, but it must exist and it must be same-day.
2. Cycle counts monthly or quarterly. Not a full count each time; rotate categories, counting high-value items more often. Differences caught small are far easier to trace.
3. Separation of duties. Whoever keeps the records does not handle goods, whoever handles goods does not keep records, and whoever approves a release does not execute it. A small company cannot separate fully, but the owner or finance lead should at least spot-check regularly.
4. A written count procedure. One page: who participates, which forms, how to treat goods in transit and on consignment, the difference threshold, how recounts work. Execute year-end from that page.
5. Agree the basis with the accountant early. Confirm list format, costing method and shrinkage treatment well before year-end, not days before filing.
6. Be ready for a surprise visit. Tax officers sometimes arrive around year-end with a mission order to check invoices and registration, and stock records can come up; see a BIR surprise visit with a mission order.

In fairness: these controls add daily workload, especially for a small trading company. Set that against the cost of a large year-end gap: a week of investigation, a loss that may not be recognised for tax, an audit you cannot explain, and not knowing where your goods went. Daily documentation is far cheaper.

What Yixing can do: Yixing is a private consultancy registered with the Philippine SEC providing tax and compliance retainer services to foreign-owned companies. We can help structure your count and difference memorandum, coordinate with a licensed accountant on adjustments and the inventory list filing, and, where theft or misappropriation is involved, help assemble the documents for the police report and the tax loss claim. Yixing does not replace the licensed accountant's signing responsibility and cannot influence the tax authority's determination. → Tax compliance and filing support

Once more: the inventory list format and deadline follow the tax authority's current rules; consult a licensed accountant on tax treatment and a licensed attorney on liability. This article is not tax or legal advice.