Inventory & Purchasing
··
Workbook overviewVerified Product Library facts
Create one traceable path from count preparation to reconciliation.
A 100-item catalogue feeds a dedicated count sheet. Formulas distinguish blank from genuine zero counts, calculate unit, percentage, and value variances, classify results, and surface items beyond the review threshold for reconciliation.
What it helps you do
✓Prepare up to 100 catalogue items for one count cycle.
✓Distinguish uncounted items from genuine zero counts.
✓Calculate quantity, percentage, and value variances.
✓Review completion, shortages, overages, and material flags.
Inventory & Purchasing
Small Business Stock Count Tracker
Plan a physical count, compare counted quantities with book records, and reconcile stock variances.
✓ Verified Product Library facts
Available file languages
EN · v1.0.0AR · v1.0.0ES · v1.0.0
LSTBooks Launch Collection
FREEFree during our launch offer
Download workbook · EN✓ No registration or payment required.
Early public previewProduct purchasing is not open yet. This page is available so you can review the verified scope, compatibility, and language coverage.
100items
100count rows
7worksheets
1,961formulas
3languages
7 / 7
Inside the workbook
Inside the workbookPurpose
01START-HEREWorkflow, capacity, colors, and limits.
02SETUPCount details, thresholds, categories, and lists.
03ITEMSCatalogue with book quantity and unit cost.
04COUNT-SHEETPhysical count entries and notes.
05COUNT-VARIANCESQuantity, percentage, value, and review classification.
06RECONCILIATIONCount completion and exception review.
07DASHBOARDManagement KPIs and variance charts.
Compatibility
Compatibility
✓Microsoft ExcelExcel 2021 · Desktop
Microsoft Excel 2021 desktop · Macro-free XLSX · Standard formulas, tables, validation, conditional formatting, and charts · No external links or connections.
Scope
One physical-count cycle—not continuous inventory control.
It does not track stock movements, multiple locations, lots, serial numbers, barcodes, live feeds, approvals, or accounting entries. Book quantities and unit costs must come from the business's records and adjustments remain subject to normal controls.
Language editions
Version and updates
ENv1.0.0Verified editionARv1.0.0Verified localized edition with RTL sheet viewsESv1.0.0Verified localized edition
An entitlement remembers the Product and purchased license. Patch and minor updates are included; major upgrades remain separately priced under the approved policy.
Reviews
No reviews yet.
Reviews will open only to verified buyers after launch.
LSTBooks library
Related tools
Continue with other verified LSTBooks workbooks.
Sales & Customers
Small Business Sales Pipeline Tracker
Manage up to 100 opportunities with stages, owners, weighted pipeline value, eight KPIs, and two charts.
HR & Payroll
Small Business Attendance & Timesheet Manager
Keep attendance, hours, and team records structured in an eight-sheet Excel workbook.Based on the verified v1.0.0 English, Arabic, and Spanish editorial masters, workbook packages, and matching Product Library media.