Workbook layout to import opening on-hand quantities by location — bars, warehouses, merch stores, and mobile points — aligned to your catalog SKUs.
“Opening stock is the baseline everything else measures against — import it once, correctly, by location.”
A short preview of the fields and sections included in the full template pack.
The Opening Stock Import Template is an XLSX workbook for your first on-hand import — bars, warehouses, merch stands, kitchens, and vendor handoff points. Use it after your catalog exists and before POS trading, so counts, replenishment, and variance reporting start from a defensible baseline.
• Stock controllers importing opening balances before doors open • Bar and retail managers loading location-specific on-hand • Festival ops teams handing off vendor or mobile point stock • Finance reviewers validating total opening stock value
Complete Locations, Categories, and Suppliers tabs. Enter rows on Opening Stock Import with batch ID, location code, SKU, opening quantity, and unit cost — opening stock value calculates automatically. Review Validation Checks until readiness shows READY, then complete Import Sign-Off before posting to EventSuite Inventory or your WMS.
Run the Inventory Setup Checklist first, define SKUs in the Stock Item Catalog Template, then import opening quantities here. After trading begins, use the Stock Count Template for cycle and event counts — opening stock is the anchor those variances reference.
EventSuite Inventory connects catalog, locations, receiving, opening balances, POS depletion, counts, and reporting on one record. Download the template to align your import batch offline, then explore inventory software or book a demo to model locations and opening stock in the platform.
Connect checklist rows to the product modules teams use for live delivery.
Track stock, replenishment, and POS-linked inventory controls.
Explore module →Menus, devices, settlement batches, and on-site revenue controls.
Explore module →Connect ticketing, POS, and settlement workflows.
Explore module →Vendor listings, procurement packages, and fulfilment workflows.
Explore module →Understand sales, attendance, and operational outcomes from one analytics layer.
Explore module →More practical resources from the EventSuite library.
Cashless payments and POS are not just payment tools. For festivals and venues they reduce queues, improve reconciliation, support vendors, unlock offers and vouchers, lift revenue per attendee, and sharpen post-event reporting — when ticketing, commerce, and finance share one commercial spine.
View resource →Use this event budget template to plan income, costs, deposits, supplier spend, staffing, ticketing revenue, vendor revenue, POS income, sponsorship, contingency, and post-event reconciliation — so commercial, ops, and finance share one workbook before doors open.
View resource →A printable checklist to stand up sellable product inventory: locations, suppliers, catalog items, opening stock, POS mapping, and first count — before event-day trading begins.
View resource →After catalog and locations are defined and before on-site selling — typically after setup checklist sign-off and POS product mapping, immediately before or at load-in.
That is valid — each row is SKU plus location. Validation Checks flag duplicate SKU/location pairs on the same row keys, not the same SKU in different bars.
Opening import sets the starting on-hand baseline. Stock counts compare expected vs counted after you are trading. Use both — import first, count later.
Teams use this template to align data before import. EventSuite Inventory supports catalog, locations, movements, and opening balances in-product — book a demo to map your import path.
Connect resource owners to ticketing, vendors, payments, and reporting modules so operational work stays tied to live delivery.
