Before sellers can access a countsheet, you need to create the show in the Backstage employee portal. Backstage is the central hub for all operations — it manages accounts, shows, team documents, and links to every tool including the countsheet.
| Field | Where it appears |
|---|---|
| Show Title | Displayed at the top of the countsheet and on all exports |
| Venue Name | Shown in countsheet Show tab (read-only) and on order exports |
| City / State | Shown in countsheet Show tab (read-only) |
| Cycle / Dates | Shown in countsheet Show tab (read-only) |
| Shipping Address | Printed on all order CSVs and PDFs exported from the countsheet |
| Status | Active = countsheet accessible; Locked = view-only for sellers |
Once the show is created, click Open Countsheet → on the show card in Events. This opens the countsheet pre-loaded with that show's data. Bookmark the URL or share it with your sellers — every time it's opened, it loads the same show.
The merch. countsheet has two modes: a seller-facing count mode and a PIN-protected Manager Mode for configuration and reporting. Sellers never see Manager Mode screens. Both require a Backstage login — users who aren't signed in are automatically redirected to the portal sign-in page.
Once inside, nine tabs are shown at the top of the screen:
| Tab | Purpose |
|---|---|
| Show | Venue info, show dates, weekly goal, discount tiers, PIN |
| Booths | Add/remove/reorder selling locations with color coding |
| Products | Product catalog — name, variant, SKU, price, active state |
| Schedule | Performance schedule — dates, times, active/locked states |
| Backstock | Inventory levels, par minimums, on-hand calculations |
| Shipments | Receive inbound stock via CSV, apply to backstock |
| Order | Generate reorder quantities, export CSV or PDF |
| Summary | Weekly CSV/PDF exports; import Booth Report JSONs for running summary; Sales Forecast and Sales Goal progress bars |
| Tools | Import/export config JSON, clear data, factory reset |
The Show tab displays the show's identity and shipping information — pulled automatically from Backstage — alongside the financial settings you configure directly in the countsheet.
These fields are populated from the portal and displayed for reference. To change them, edit the show in Backstage → Retail → Events.
| Field | Description |
|---|---|
| Show Name | Production title — appears at top of countsheet and on all exports |
| Venue | Theatre name — printed on order CSVs and PDFs |
| City / State | Venue location |
| ZIP | Venue postal code |
| Street Address / Address 2 | Shipping address lines — printed on every order form |
| Attn / Phone | Venue contact info |
| Ship City / Ship State / Country | Override shipping destination if different from venue |
| Cycle | Reporting cycle label (e.g. "Week 12") |
| Start Date / End Date | Cycle date range |
These fields are not managed in the portal — configure them directly here in Manager Mode.
| Field | Description |
|---|---|
| Weekly Goal ($) | Revenue target for the cycle; drives the Sales Goal progress bar in the Summary tab |
| Apparel Discount % | Markdown % applied to apparel for order quantity calculations |
| Goods Discount % | Markdown % applied to goods/novelties |
| Media Discount % | Markdown % applied to media items |
| PIN | 4-digit Manager Mode PIN (change from default 1234) |
Booths (also called "locations") represent the physical selling stations in the venue — for example, the Main Lobby table, a Mezzanine kiosk, or a Box Office window. Each seller logs in by selecting their location, so accurate setup here is essential.
Each booth is assigned a color automatically as it is added, cycling through: Gold, Blue, Green, Purple. These colors appear as color-coded chips throughout the seller interface and in reports to help distinguish booths at a glance.
The location color chips appear in seller login, count sheets, the Summary tab's running summary table, and exported PDFs — making it easy to track revenue by location at a glance.
The Products tab is where you define everything sellers can sell. Every item that appears on a count sheet must be configured here first.
Tap + Add Product and fill in the following fields:
| Field | Description |
|---|---|
| Name | Product name (e.g. "Logo Tee", "Magnet", "Cast Recording") |
| Variant | Size, color, or format that distinguishes items with the same name (e.g. "S", "XL", "Black", "CD") |
| SKU | Warehouse SKU code — used in shipment matching and order exports |
| Category | Apparel, Goods, or Media — determines which discount tier applies |
| Retail Price | Standard ticket-holder price |
| House Price | Discounted price for house seats / comp guests |
Each product has an Active toggle. Active products appear on count sheets for sellers. Inactive products are hidden from sellers but retained in the system — useful for items that are temporarily out of stock or discontinued mid-run without losing historical data.
Products that share the same Name but have different Variants are automatically grouped together on the count sheet. For example, "Logo Tee / S", "Logo Tee / M", and "Logo Tee / L" will appear as a single group on the seller's screen, making counting faster and more organized.
The Schedule tab defines the list of performances sellers can select when logging in. Each show is identified by a show number and is used as the organizing unit for all count data and reports.
Tap + Add Show to create a new performance entry:
| Field | Description |
|---|---|
| Show Number | Sequential identifier (e.g. 1, 2, 3…) within the cycle |
| Date | Calendar date of the performance |
| Day of Week | Automatically derived but editable (e.g. "Wednesday") |
| Time | Curtain time (e.g. "2:00 PM", "8:00 PM") |
| State | Meaning |
|---|---|
| Active | Visible to sellers in the show selection list. Sellers can open counts and enter data. |
| Locked | Visible to sellers but read-only. Prevents any edits. Use after reconciliation is complete. |
| Inactive | Hidden from sellers entirely. Use for shows that were cancelled or not yet scheduled. |
| # | Date | Day | Time | Status |
|---|---|---|---|---|
| 1 | 4/22/26 | Wed | 2:00 PM | Active |
| 2 | 4/22/26 | Wed | 8:00 PM | Active |
| 3 | 4/23/26 | Thu | 8:00 PM | Locked |
| 4 | 4/24/26 | Fri | 8:00 PM | Active |
Shows appear in the order they are listed here. Set all shows for the full week at the beginning of each cycle so sellers can always select the correct performance.
Below each show's date/time row in the Schedule tab there is a Location Goals section. Once locations have been configured in the Booths tab, each active location appears here with a dollar input field. Enter a revenue goal for each location for that specific show.
A Show Forecast total — the sum of all location goals for that show — is displayed below the inputs in the brand color #ffc907. This per-show forecast feeds into the Sales Forecast progress bar on the Summary tab (see Section 9).
The Backstock tab is your live inventory ledger. It shows what is physically on hand at the venue and helps you identify which products need reordering before they run out.
| Column | Description |
|---|---|
| Product / Variant | Product name and variant label |
| Backstock | Quantity you entered as the starting inventory for this cycle |
| On-Hand | Calculated: Backstock minus units added (opened) for all shows so far |
| Par | Minimum stock level at this venue — set by you per product |
| Stock Bar | Visual bar showing On-Hand vs. Par. Green = above par, Amber = near par, Red = below par |
| Remaining BS | What will be left after all scheduled show adds are accounted for |
Tap any row to edit the Backstock quantity (typically when you first receive a shipment and apply it) or the Par level. The stock bar updates instantly.
The Remaining BS column projects inventory after all shows have been opened. A red value means you will likely run out before the next shipment arrives — add those items to your order.
The Shipments tab is used when physical merchandise arrives at the venue. It lets you reconcile what was packed at the warehouse against what you actually received, and then apply the confirmed quantities directly to Backstock.
merch. supports up to three concurrent shipment slots — useful when orders are split across multiple pallets or arrive on different days.
Any row where Received ≠ Packed is highlighted in red to draw your attention. This is a variance — you received more or fewer units than expected.
Tap ⬇ Variance Report to export a CSV containing only the rows with discrepancies. Send this to your warehouse contact to resolve short or over-shipments.
When you are satisfied with your received quantities, tap ✓ Apply to Backstock. The received quantities are added to Backstock for each matching product. The shipment row then shows a green checkmark to indicate it has been applied.
The Order tab calculates how much to reorder based on your current inventory, sales velocity, and the discount tiers configured in the Show tab. Use it at the end of each cycle to prepare your warehouse order.
For each active product, merch. considers:
The suggested quantity aims to bring you to par plus enough stock for the next cycle's projected sales.
The Order Qty column is fully editable. Override any suggested quantity manually. You can also add free-text Order Notes per row (e.g. "Hold — awaiting new design") for the warehouse team.
| Product | Variant | Rem. BS | Suggested | Order Qty |
|---|---|---|---|---|
| Logo Tee | S | 12 | 6 | 6 |
| Logo Tee | M | 4 | 12 | 12 |
| Logo Tee | L | 0 | 18 | 18 |
| Magnet | — | 31 | 0 | 0 |
| Program Book | — | 8 | 24 | 24 |
| Export | Description |
|---|---|
| ⬇ Order CSV | Fixed-format CSV for direct warehouse upload. Columns and formatting match the warehouse's import template exactly — do not modify before uploading. |
| 🖨 Order PDF | Human-readable order for the fulfillment person. Includes a checkbox column for picking verification, an adjustment box per line, and a signature / date block at the bottom. |
The Summary tab (previously called "Reports") is the hub for all financial exports and progress tracking. It has two subsections: Device Exports (data from this iPad's own count records) and the Weekly Running Summary (aggregated across all booths by importing Booth Report JSONs from sellers).
At the top of the Summary tab — above the Weekly Running Summary table — two progress bars appear whenever their respective values have been set. Both bars track actual imported JSON revenue in real time as Booth Report JSONs are imported during the week.
| Progress Bar | Target Value | Actual Value Tracked |
|---|---|---|
| Sales Forecast | Sum of all per-show, per-location goals entered in the Schedule tab (see Section 5 — Location Goals). Appears once at least one location goal has been set. | Grand revenue (grandRev) from all imported Booth Report JSONs for the current cycle. |
| Sales Goal | The weekly goal dollar amount set in the Show tab (Weekly Goal field). Appears once that field is non-zero. | Same imported JSON revenue total — tracks how the week's actual sales compare to the overall cycle target. |
These exports draw from count data entered directly on this device.
| Export | What It Contains |
|---|---|
| ⬇ Week CSV | Detailed spreadsheet. Body rows: only shows that have count data. Footer section: full weekly summary with every scheduled show (populated or not) and grand totals. |
| 🖨 Week PDF | Same logic as the CSV: populated shows appear in the main body; all shows appear in the summary table. Print-friendly, formatted for management review. |
This section aggregates data from all selling locations. Sellers export a Booth Report JSON at the end of their shift and send it to you (via AirDrop, email, or any file transfer method).
| Show | ● Main Lobby | ● Mezz | Total | |
|---|---|---|---|---|
| #1 Wed 2PM | $2,840 | $1,120 | $3,960 | |
| #2 Wed 8PM | $3,210 | $1,450 | $4,660 | |
| #3 Thu 8PM | $2,590 | — | $2,590 | |
| Week Total | $8,640 | $2,570 | $11,210 |
Each show row has a 🖨 PDF button that generates a single-show Summary PDF. This is the primary document you send to production management after each performance.
The Summary PDF structure is:
The 🖨 Summary PDF button in the header exports all imported shows at once as a combined document.
The ⬇ CSV button exports a merged CSV of all imported Booth Report JSONs — useful for importing into your own tracking spreadsheet or sending to your regional manager.
The Tools tab provides configuration backup/restore utilities and destructive data management functions. Access carefully.
| Function | Description |
|---|---|
| ⬇ Export Config JSON | Exports all settings — Show info, Booths, Products, Schedule, Backstock par levels, and per-show location goals — as a single JSON file. Use this to back up your configuration or share it with another manager's device. Because location goals are included, all forecasting data transfers automatically. |
| ⬆ Import Config JSON | Restores a previously exported config, including per-show location goals. Useful for onboarding a second manager device or recovering from accidental changes. Count data is not affected by an import. |
| Action | What Is Erased |
|---|---|
| Clear All Count Data | Deletes all show count data (open counts, close counts, cash rec entries, imported Booth Report JSONs). Configuration — Show, Booths, Products, Schedule, Backstock — is preserved. |
| Factory Reset | Deletes everything: count data AND all configuration. The app returns to its initial state as if freshly installed. Use only at the end of a run when decommissioning the device. |
This section walks through the complete lifecycle of a show night from initial configuration to final manager reporting. Use this as a reference checklist when starting at a new venue or training a new manager.