Stock Movements
The Stock Movements page shows a complete history of all inventory changes. Track what came in, what went out, and why—providing an audit trail for your inventory.
Overview cards
At the top of the page, summary cards show movement activity:
Movements Today
- Count: All stock adjustments made today
- Purpose: Daily activity snapshot
- Resets: Each day at midnight
Stock Increased
- Count: Entries where quantity was added
- Examples: Purchases, returns, adjustments
- Purpose: Track inbound stock
Stock Decreased
- Count: Entries where quantity was removed
- Examples: Sales, damage, shrinkage
- Purpose: Track outbound stock
Movement list
The main table shows all stock changes:
Columns
| Column | Shows |
|---|---|
| Date | When movement occurred |
| Item | Product name and code |
| Type | Increase or Decrease |
| Quantity | Amount changed |
| Reason | Why adjustment made |
| Reference | Related document (PO, invoice, etc.) |
| User | Who made the adjustment |
Row details
Click any row to see:
- Full item details
- Before and after quantities
- Notes or comments
- Linked transactions
Filters
Type filter
Filter by movement direction:
- All Types: Both increases and decreases
- Increase: Stock added only
- Decrease: Stock removed only
Reason filter
Filter by adjustment reason:
- All Reasons: Everything
- Stock Received: Purchases, inbound goods
- Damaged: Broken, spoiled, unsellable
- Shrinkage: Loss, theft, unexplained
- Adjustment: Correction, audit, count
- Sale: Customer order fulfillment
- Return: Customer returns
- Other: Custom reasons
Understanding movement types
Stock increases
Stock Received:
- New purchase order arrived
- Supplier delivery
- Most common increase reason
Return:
- Customer returned goods
- Items back in inventory
- Usually quality check needed
Adjustment (positive):
- Found missing stock
- Count correction
- Initial setup
Stock decreases
Sale:
- Goods sold to customer
- Auto-deducted on invoice
- Linked to invoice number
Damaged:
- Broken in handling
- Expired (perishables)
- Quality issues
- Remove from sellable stock
Shrinkage:
- Theft
- Unexplained loss
- Data entry errors (discovery)
- Requires investigation
Adjustment (negative):
- Count correction
- Data cleanup
- System reconciliation
Manual adjustments
When to adjust manually
Do adjust:
- Stocktake discrepancies
- Damaged goods
- Shrinkage discovery
- Returns processing
- Initial stock setup
Don’t adjust (system handles):
- Normal sales (invoices auto-deduct)
- Purchase receipts (bills auto-add)
Making adjustments
From Tracked Items:
- Find item
- Click Adjust Stock
- Enter quantity (+ or -)
- Select reason
- Add notes if needed
- Save
Movement automatically appears in Stock Movements.
Movement details
Date and time
- Exact timestamp of adjustment
- Shows local time zone
- Sortable by date
Item information
- Full product name
- Item code/SKU
- Link to item details
Quantity change
- Amount added or removed
- Running balance not shown (check item)
- Can be decimal for partial units
Reason code
Standardized categories:
- Ensures consistent reporting
- Affects accounting treatment
- Required for all manual adjustments
Reference
Links to source documents:
- Invoice number (for sales)
- Bill number (for purchases)
- Adjustment ID
- Manual entry notes
User tracking
- Who made the adjustment
- Timestamp
- Audit trail accountability
Reporting and analysis
Movement reports
Generate reports by:
- Date range
- Item(s)
- Reason
- User
Uses:
- Cost analysis
- Shrinkage investigation
- Purchase verification
- Sales reconciliation
Trends to watch
High shrinkage:
- Security issues
- Process problems
- Need investigation
Frequent adjustments:
- Count procedures need improvement
- System vs physical mismatch
- Training opportunity
Seasonal patterns:
- Understand demand cycles
- Optimize reorder points
- Plan for peaks
AU-specific considerations
GST implications
- No GST on internal movements
- GST already claimed on purchase
- GST charged on sale already handled
- Adjustments don’t affect GST
Accounting treatment
Different reasons have different accounting:
- Stock Received: Debit inventory, credit liability
- Damaged: Debit expense, credit inventory
- Shrinkage: Debit expense, credit inventory
- Sale: Already handled by invoice
Audit requirements
Maintain records for:
- ATO compliance (5+ years)
- BAS reconciliation
- Year-end stock valuation
- Insurance claims
COGS calculation
Cost of Goods Sold derived from:
- Opening stock
- Purchases (Stock Received)
- Closing stock
- Adjustments (damage/shrinkage)
Best practices
Record promptly
- Adjust same day as discovery
- Don’t batch adjustments
- Keep movement records current
Be specific
Reason codes:
- Use most specific reason available
- Add notes for context
- Reference source documents
Regular review
Weekly:
- Check for unusual movements
- Verify large adjustments
- Confirm reasons appropriate
Monthly:
- Movement summary by reason
- Shrinkage analysis
- Trend identification
Quarterly:
- Full reconciliation
- Process improvements
- Audit preparation
Security
- Limit adjustment permissions
- Require approval for large adjustments
- Review user access regularly
- Investigate unusual patterns
Common workflows
Processing a return
- Customer returns item
- Inspect for resaleability
- If good: Go to Tracked Items
- Find item
- Click Adjust Stock
- Enter positive quantity
- Select reason “Return”
- Add customer/order reference
- Save
- Stock increased, movement logged
Recording damaged goods
- Discover damaged stock
- Go to Tracked Items
- Find damaged item
- Click Adjust Stock
- Enter negative quantity (amount damaged)
- Select reason “Damaged”
- Add details in notes
- Save
- Stock decreased, movement logged
- Consider insurance claim if significant
Stocktake adjustment
- Complete physical count
- Compare to system (Tracked Items)
- Note discrepancies
- For each variance:
- Go to item
- Click Adjust Stock
- Enter correction (+ or -)
- Select “Adjustment”
- Note “Stocktake correction”
- Save
- All movements appear in history
- Investigate large variances
Investigating shrinkage
- Review Stock Movements
- Filter by “Shrinkage” reason
- Identify patterns:
- Which items?
- Which location?
- Which time periods?
- Which staff?
- Implement controls:
- Security cameras
- Access restrictions
- Count procedures
- Staff training
Troubleshooting
Movement missing
- Check date filter
- Verify user permissions
- Check archived items
- Review filter settings
Wrong quantity recorded
- Cannot edit past movements
- Make new adjustment to correct
- Use “Adjustment” reason
- Note correction reference
Can’t find specific movement
- Use search (item name/code)
- Adjust date range
- Clear all filters
- Check linked reference numbers
Duplicate movements
- Review before saving adjustments
- Check if system already recorded
- Delete duplicate if not needed
- Document correction
Integration with other modules
Bills & Purchases
- Purchase orders → Stock Received
- Bills link to movements
- Three-way match (PO, Bill, Stock)
Quotes & Invoices
- Invoices auto-deduct stock
- Movements show as “Sale”
- Link to invoice reference
Reports
- Inventory valuation
- COGS analysis
- Shrinkage reporting
- Movement summaries
Related pages
- Tracked Items - Manage current stock levels
- Items - Product catalog management
- Inventory Settings - Configure movement tracking
- Reports - Inventory analysis and valuation