AutoCount Accounting · Stock Guide

How to Do Stock Take in AutoCount: Step-by-Step

Prepare the Inventory Physical Worksheet, count actual stock, record quantities and review adjustments in AutoCount—using the original instructional screenshots.

Follow the stock take steps
Warehouse inventory stock take in a Malaysian business setting
Practical inventory control

What is AutoCount Stock Take?

Stock take is a physical inventory count used to compare the quantities actually on hand with the quantities recorded in AutoCount. The differences should be reviewed and, once approved, reflected through the correct stock adjustment workflow.

1. PreparePrint an Inventory Physical Worksheet with the correct date and settings.
2. CountPhysically count and verify each item's stock quantity.
3. ReconcileRecord the count in Stock Take, check variances and post authorised adjustments.
Date and cut-off: The original example uses the previous day's date for the worksheet and adjustment. Retain that date only where it matches the stock count's agreed cut-off. Check transactions posted after the cut-off, locations, the stock period and accounting requirements before posting.

Step 1 — Print the Inventory Physical Worksheet

For the original workflow, include items with zero recorded quantity so that they can still be checked during the physical count.

STEP 1.1

Open the worksheet

Go to Stock → Inventory Physical Worksheet.

AutoCount Stock menu showing Inventory Physical Worksheet
Stock menu showing Inventory Physical Worksheet · Open image to enlarge
STEP 1.2

Select the count date

Choose the worksheet date that matches the agreed stock take cut-off. The original walkthrough selects the previous day, then opens More Option.

AutoCount Inventory Physical Worksheet date and More Options
Inventory Physical Worksheet date and More Options · Open image to enlarge
STEP 1.3

Include zero-balance items

Tick Include Zero Balance and select OK.

AutoCount Include Zero Balance selection
Include Zero Balance selection · Open image to enlarge
STEP 1.4

Run Inquiry and print

Select Inquiry to refresh the worksheet, then print it for the counting team.

AutoCount Inventory Physical Worksheet Inquiry and Print
Inventory Physical Worksheet Inquiry and Print · Open image to enlarge

Step 2 — Conduct the physical count

Count the stock at the designated location, record each item's actual quantity and verify uncertain results. Avoid changing the system quantity simply to make figures match.

  • Count each stock item physically and record the correct unit of measure.
  • Write the counted quantity on the corresponding Inventory Physical Worksheet row.
  • Separate damaged, returned or otherwise restricted stock according to your actual business process.
  • Recount major variances and confirm any stock movement during the counting period.
AutoCount Printed physical stock counting worksheet
Printed physical stock counting worksheet · Open image to enlarge

Step 3 — Update the on-hand quantities in AutoCount

STEP 3.1

Open Stock Take

Go to Stock → Stock Take.

AutoCount Stock menu showing Stock Take
Stock menu showing Stock Take · Open image to enlarge
STEP 3.2

Create a new record

Click New.

AutoCount New Stock Take record
New Stock Take record · Open image to enlarge
STEP 3.3

Enter count details

Fill in the relevant Stock Take information and counted quantities shown on the worksheet.

AutoCount Enter stock take details
Enter stock take details · Open image to enlarge
STEP 3.4

Merge, recalculate and post

The original walkthrough checks the relevant date, clicks Merge, then Recalculate On Hand Qty and finally Post to Adjustment. Review item quantities, variances, stock movement and permissions before posting the adjustment.

AutoCount Merge Recalculate On Hand Qty and Post to Adjustment
Merge Recalculate On Hand Qty and Post to Adjustment · Open image to enlarge
Important: Do not post a stock adjustment solely because there is a difference. Confirm the source of the variance, the correct date and warehouse/location, and the approved quantities. Screen labels and options may differ by installed version.

Common Stock Take mistakes and how to avoid them

MistakePossible impactRecommended check
Poor stock take planningDisorganised counts and delaysChoose the cut-off, define count areas, assign counters and explain the process
Inaccurate physical countingPhysical and system quantities do not agreeCount carefully and independently recount material differences
No reconciliation or verificationUnexplained variances remain unresolvedCompare physical quantities against system figures and investigate movements
Poorly recorded count sheetsMissing or unclear quantities make entry unreliableUse consistent worksheets and document item codes, UOM and locations
Wrong item numberAdjustment may affect a different itemVerify the item code and description before confirming
Wrong entered quantityIncorrect stock valuation and on-hand balancesCross-check quantities and use a second-person review for exceptions

Use the Stock Card Report to investigate differences

The Stock Card Report shows inventory movement by item, helping you review stock-in, stock-out, brought-forward quantities and transaction history relevant to a variance.

STEP 1

Open Stock Card Report

Go to Stock → Stock Card Report.

AutoCount Stock Card Report menu
Stock Card Report menu · Open image to enlarge
STEP 2

Run the inquiry

Click Inquiry to refresh the transaction results, then Preview.

AutoCount Stock Card Report Inquiry and Preview
Stock Card Report Inquiry and Preview · Open image to enlarge

Review the detailed transactions, quantities and relevant costs. The original report example also shows adjusted quantity information.

AutoCount Stock Card Report with adjusted quantity
Stock Card Report with adjusted quantity · Open image to enlarge

Use the report alongside the count worksheets and adjustments. If the discrepancy remains unexplained, check transaction timing, unit of measure, and the correct stock location before making further changes.

Need help with stock take in AutoCount?

SL Software Solutions can help review your inventory counting workflow and AutoCount setup.

Contact Us