Sage Evolution Stock Take Checklist: Before, During and After the Count
A stock take in Sage Evolution is only as reliable as its preparation. Cut-off errors, unprocessed documents and unclear ownership create variances that are really process problems. This checklist covers what to do before, during and after the count.
0 of 26 items complete
9 critical items still open - these are the highest-risk gaps.
Preparation
System freeze
Counting
Variance review
Adjustment and close
Critical items protect the accuracy of the count and the audit trail. Complete them before anyone starts counting.
Stock accuracy review
Optional: we can look at your adjustment history and suggest where errors originate.
Optional. The tool and every export work without this. No spam.
How to use the checklist
Print it and give a copy to the stores manager and the financial manager. Complete the preparation and freeze groups before counting starts, and keep the variance and close groups for after. Critical items protect your audit trail, such as the backup, the opening quantity snapshot and approval of adjustments. Keep the signed list with the count sheets.
The principle behind a clean count
A reliable count compares a physical quantity against a system quantity taken at a known moment. Anything that moves stock between the snapshot and the count must be controlled or recorded, or the variance is meaningless. That is why the checklist stresses cut-off, a freeze and separating consignment or in-transit stock. Independent counts and blind sheets reduce bias and catch errors early.
Handling variances
Do not post every variance. Set a threshold by value or percentage and recount items above it. Many variances turn out to be wrong units of measure, items stored in two locations or documents posted a day late. Only post adjustments after review and approval, and reference the count so the movement history explains it later. Reconcile the valuation difference to the general ledger.
Common mistakes
Teams count with the system open and goods still moving, hand counters the system quantity, or post adjustments before recounts. Another is losing sheets, which leaves gaps nobody can explain. Number every sheet, reconcile them, and keep a record of voided ones.
Frequently Asked Questions
Do I have to stop trading during a stock take?
Not always. Some businesses freeze movements for a few hours, others use cycle counts throughout the year. If you keep trading, you must record every movement between the snapshot and the count so you can reconcile accurately.
How big a variance is acceptable?
It depends on item value and your auditors. Many companies recount variances above a threshold, for example a set Rand value or a percentage, and investigate every variance on high value items. Agree the rule before the count starts.
Is cycle counting better than an annual count?
Cycle counting spreads effort and finds errors sooner, but needs discipline and good item classification. Many companies combine it with a smaller annual count for audit comfort. Ask your auditor what they require.
Can I use this checklist for SYSPRO or Odoo?
Yes. The principles of cut-off, snapshot, independent counts and approved adjustments apply to any ERP. Only the posting screens differ.
If you want exception reports that flag unusual movements and likely cut-off errors before the count, Netray can build a read-only layer over your Sage Evolution data.
Related Tools
SYSPRO MRP Checklist
A checklist of the master data, parameters and review steps that decide whether SYSPRO MRP output can be trusted.
Costing & FinanceSYSPRO Job Costing Worksheet
Enter estimated and actual material and labour for each WIP job and see cost variance per job and in total. Exports to Excel.
Costing & FinanceAfrica Multi-Currency ERP Setup Worksheet
List the currencies your ERP must handle, key a rate and foreign balance, and see local currency value and the effect of a rate move.
Developer ToolsSYSPRO SQL Query Generator
Generate read-only SQL Server queries against common SYSPRO tables. Fill in database and filters, then copy the code.
More Supply Chain & Inventory tools
See all- Sage Evolution Stock Adjustment Request Form
- Oracle Fusion Inventory Turns and Carrying Cost Calculator
- Distribution ERP Fill Rate Calculator
- Distributor Rebate Tracking Worksheet
- Branch Transfer Planning Worksheet
- Distributor Slow-Moving Inventory Review Worksheet
- Distributor Vendor Performance Scorecard Worksheet
- Distributor GMROI Calculator
- Distributor Backorder Cost and Fill Rate Calculator