Stocktake Count Sheet

What Is a Stocktake Count Sheet?

A Stocktake Count Sheet is a physical or digital record used to list and count the inventory a business holds at a specific point in time. It serves as the primary source of truth for verifying what is actually on the floor or in the warehouse compared to what your accounting software says you should have.

For Australian businesses, this document is more than just a list of items. It is a critical legal record. The Australian Taxation Office (ATO) requires businesses to account for trading stock if the value of that stock changes by more than $5,000, or if the difference between the estimated value and actual value is greater than 5%. The Stocktake Count Sheet is the evidence you rely on to substantiate these figures for your tax return and financial statements.

Whether you run a cafe in Brisbane, a plumbing business in Perth, or a retail store in Melbourne, the count sheet is the tool that bridges the gap between your physical assets and your financial records.

When to Use This Document

While many businesses associate stocktakes with the end of the financial year (June 30), there are several other times when using this document is necessary or beneficial.

End of Financial Year (EOFY)

Under the Income Tax Assessment Act 1997, you must value your trading stock at the end of each income year if the criteria mentioned above are met. For most businesses with significant inventory, a full physical stocktake on June 30 is standard practice to ensure accurate income tax calculations.

Before Lodging Business Activity Statements (BAS)

If your business uses the accrual method for accounting, you may need to adjust your GST credits based on stock changes. Regular counts help ensure you aren't paying tax on stock that has been lost, stolen, or written off.

Before an Insurance Claim

If your business suffers a theft, fire, or flood, your insurer will require proof of ownership and value. As noted by Business.gov.au, a recent stocktake count sheet serves as vital evidence to verify your claim. Without it, settling a claim can be difficult and result in lower payouts.

During Internal Audits or Fraud Prevention

Regular spot checks using a count sheet help identify "shrinkage" (stock loss due to theft or error). The Corporations Act 2001 requires directors of companies to keep financial records that accurately record and explain transactions. Regular stocktaking helps fulfil this obligation by revealing discrepancies early.

Key Sections and Required Elements

To create a document that satisfies ATO requirements and stands up to scrutiny, your Stocktake Count Sheet needs specific components. A simple list on a notepad is often insufficient for audit purposes.

1. Control and Audit Header

The top of the sheet must establish the context of the count.

• Business Name: Identifies the legal entity.
• Stocktake Location: Essential if you have multiple warehouses or job sites.
• Date and Time: Crucial for locking down the value as of a specific moment, especially for EOFY compliance.
• Stocktake Reference ID: A unique code to track this specific batch of records.

2. Item Identification

This section prevents ambiguity during the count.

• SKU or Part Number: The unique code for the item.
• Description: A clear name for the product.
• Unit of Measure (UOM): This is vital. You must specify if you are counting items individually, in pairs, by the kilogram, or by the carton. Confusion here is a common cause of accounting errors.
• Location/Aisle: Helps the counter find the item and helps with subsequent re-stocking.

3. Count and Verification

To meet standards of accuracy and internal control, you should allow for a two-step process.

• Count 1 (Initial): The number written down by the first counter.
• Count 2 (Verification): The number written down by a second person to verify the first count.
• Discrepancy Notes: A space to explain why the counts differ or why the number is different from the system record.
• Final Adjusted Count: The agreed-upon number to be entered into your accounting system.

4. Valuation and Condition

According to ATO rulings, you must value stock correctly.

• Unit Cost: The price you paid for the item.
• Total Value: Calculated by multiplying the Final Count by the Unit Cost.
• Condition Code: Columns to mark if stock is Good, Damaged, or Obsolete. You generally cannot claim a tax deduction for obsolete stock until it is actually written off or disposed of.

5. Employee Declaration (Fair Work Compliance)

If employees are working outside their regular hours to perform the stocktake, this section serves as a timesheet record.

• Employee Name: Who performed the count.
• Time Started and Finished: Essential for calculating overtime or penalty rates under the Fair Work Act 2009.
• Signature: A declaration that the count is accurate to the best of their knowledge.

How to Write a Stocktake Count Sheet (Step by Step)

Creating a usable stocktake system requires planning. Follow these steps to ensure your count sheet is effective and compliant.

Step 1: Choose Your Format

Decide between a physical sheet or a digital solution. While many Australian businesses use digital inventory management systems like Xero or MYOB, a physical "tally sheet" is often still used as the backup source document. If you are creating a manual sheet, use a spreadsheet program like Excel or Google Sheets, or download a professional Stocktake Count Sheet template to ensure you include all mandatory fields.

Step 2: Prepare the "Master" List

Do not start with a blank page if you can avoid it. Print a list of items you expect to have. This is known as a "blind count" if you hide the expected quantities, or a "tracked count" if you show them. For better fraud prevention, use the blind count method where the counters do not see the system quantity.

Step 3: Define the Valuation Method

Before you begin counting, determine the valuation method you will use. Under Taxation Ruling TR 98/19, you can generally choose between Cost, Market Selling Value, or Replacement Value. However, you must apply this method consistently. Write this method at the top of your sheet so there is no confusion later.

Step 4: Conduct the Count

Assign teams to specific aisles or zones. One person should call out the item and count, while the other records it on the Stocktake Count Sheet. Ensure they are using the correct Unit of Measure. For example, if you buy cement in bags but sell it by the pallet, count it in bags but note the pallet size for valuation.

Step 5: Verify and Reconcile

Once the counting is finished, a different person should review the sheet. They check for obvious errors (like writing "10" instead of "100"). Then, enter the data into your accounting software. You must reconcile the physical count against the opening stock plus purchases, minus sales. This identifies any shrinkage.

Step 6: Sign and Store

The supervisor and the counters must sign and date the document. Under Australian Standard AS/NZS ISO 9001:2016, documented information must be legible and retained. Keep these sheets for at least five years, as the ATO can request them as part of an audit.

Common Mistakes to Avoid

Counting Stock You Do Not Own

A common error is including stock held on consignment for another business. This inflates your assets and your tax liability. Conversely, failing to count stock you own but which is stored off-site (like at a trade show or a customer's site for installation) will understate your assets.

Ignoring the "Lower of Cost or Market" Rule

The ATO requires you to value trading stock at the "lower of cost or market selling value." Some business owners value stock at what they hope to sell it for, rather than its current reality. If your stock is obsolete or damaged, you must write it down to its recoverable value. Keeping old stock on your books at full price is not legally sound.

Mixing Units of Measure

If one employee counts cartons and another counts individual items, your final valuation will be wrong. Ensure the Stocktake Count Sheet clearly states the Unit of Measure for every single line item.

Neglecting Work Health and Safety (WHS)

Stocktaking often involves climbing ladders, lifting heavy boxes, or working in confined spaces. Under the Work Health and Safety Act 2011 (Cth) and the Occupational Health and Safety Act 2004 (VIC), you have a duty of care to your employees. Do not rush the process in a way that encourages unsafe behaviour. If the stocktake involves hazardous manual handling, ensure your staff follow the relevant Safe Work Method Statement (SWMS).

Failing to Pay Penalty Rates

Stocktakes often happen on weekends or after hours. The Fair Work Act 2009 mandates that employees must be paid the appropriate penalty rates for these hours. Using the time log section of your count sheet helps you calculate the correct wages and ensures you are compliant with the Modern Awards.

Legal Considerations (AU)

Income Tax Assessment Act 1997 (Cth) & ATO Rulings

The primary driver for stocktaking in Australia is tax compliance. You can only claim a tax deduction for the cost of goods sold when you can prove the stock existed and was sold or written off. If the ATO audits your business, they will look for your Stocktake Count Sheets to verify the numbers in your tax return. If you cannot produce these records, the ATO may adjust your assessment, leading to higher taxes and penalties.

Corporations Act 2001 (Cth)

If you operate a company (Pty Ltd), the Corporations Act requires you to keep financial records that correctly record and explain the company's transactions and financial position. Directors can be penalized for failing to keep adequate records. A signed and verified Stocktake Count Sheet is a key piece of the puzzle that proves your balance sheet is accurate.

Fair Work Act 2009 (Cth)

While this Act does not regulate the document itself, it regulates the work performed to create it. If your stocktake involves employees working overtime, you must keep accurate records of those hours. The count sheet can act as a time record. Fair Work Inspectors may view these records to ensure you have paid minimum wage and penalty rates correctly.

Work Health and Safety Legislation

Stocktaking is a high-risk activity for injuries. In Western Australia, the Work Health and Safety Act 2020 (WA) aligns with national standards. You must ensure, so far as is reasonably practicable, that the stocktake process does not endanger the health and safety of workers. This includes providing safe access to high shelves and not allowing excessive time pressures that lead to rushing.

Frequently Asked Questions (preview)

Do I need to count every single item? For small businesses, yes. If your turnover is under $10 million, the ATO allows you to use the "Simplified Tax System" for trading stock, which allows estimates if the value difference is less than $5,000. However, a full count is the best way to ensure accuracy. If you are a larger business, you may be able to use statistical sampling, but this requires strict ATO approval.

Can I do a stocktake on a date other than June 30? Yes. You can perform a stocktake at any time, as long as you adjust the figures to account for stock movements between the count date and June 30. This is known as a "roll-forward" or "roll-back" calculation.

What if I find stock is missing? Missing stock is recorded as a loss. It is counted as an expense in your Cost of Goods Sold, which reduces your taxable income. However, if the loss is due to theft and is significant, you may need to report it to the police and provide a report to the ATO or your insurer.

Is a digital count from a barcode scanner sufficient? Yes, provided the system keeps an audit trail. You must be able to produce a report that shows who counted the items, when they counted them, and the final quantities. A simple total number in a software program is not enough; you need the underlying count data.

How long do I need to keep the sheets? The ATO requires businesses to keep records for five years. This includes your Stocktake Count Sheets, purchase invoices for the stock, and any adjustment notes explaining changes in value.