Box Office in a Box
Reports
Box Office in a Box produces the types of reports you need to survive and thrive.
Box Office in a Box Reports
The Reporting Module allows you to:
- Customize and execute user-definable reports with the assistance of the Report Wizards
- Create an unlimited User-Definable Report Definitions (queries)
- Choose from over 25 Standard Report Formats including mailing labels, call sheets and export files
- Generate a variety of standard Quick Reports from all major reporting areas in the software
Report Wizards
With the Build a Report Wizard you can create your own Report Definitions based on any combination of criterion including Membership, Attendance, Ticket Sales, Transactions, Payments or Subscription data. Using the Run a Report Wizard you can select the Report Definition plus specify the Report Format to quickly get exactly the information you need in the format you desire.
User-Definable Report Definitions (Queries)
User-Definable Query portion of a Report Definition Query is asking for Donors from the current or previous fiscal year who also purchased subscriptions to the selected season (S3)
Standard Report Formats
Using User-Definable Report Definitions you can select from a variety of output formats to get the printed information you need.
| Format | Type | Output |
|---|---|---|
| Mailing Labels | ||
| Avery Format 4162 | 1 Across Labels | Dot Matrix |
| Avery Format 4162 in Postal Format | 1 Across Labels | Dot Matrix |
| Avery Format 4143 | 2 Across Labels | Dot Matrix |
| Avery Format 5161 | 2 Across Labels | Laser |
| Avery Format 4144 | 3 Across Labels | Dot Matrix |
| Avery Format 5160 | 3 Across Labels | Laser |
| Avery Format 5160 in Postal Format | 3 Across Labels | Laser |
| Index Cards | ||
| Avery Format 4166 | 1 Across by 2 Down | Dot Matrix |
| Avery Format 5388 | 1 Across by 3 Down | Laser |
| Avery Format 4166 with Yearly Donor Stats | 1 Across by 2 Down | Dot Matrix |
| Rotary Cards | ||
| Avery Format 4168 | 1 Across by 3 Down | Dot Matrix |
| Avery Format 4169 | 1 Across by 2 Down | Dot Matrix |
| Avery Format 5386 | 1 Across by 3 Down | Laser |
| Avery Format 5385 | 2 Across by 4 Down | Laser |
| File Folder Labels | ||
| Avery Format 4266 | 1 Across by 12 Down | Dot Matrix |
| Avery Format 5266 | 2 Across by 15 Down | Laser |
| Line Reports | ||
| Subscriber Membership Fields | Landscape (approx. 15 records per page) | Either |
| Lifetime Pledges and Donations | Landscape (approx. 15 records per page) | Either |
| Pledge Status | Landscape (approx. 15 records per page) | Either |
| Calendar Year Donor Membership Fields | Landscape (approx. 15 records per page) | Either |
| Fiscal Year Donor Membership Fields | Landscape (approx. 15 records per page) | Either |
| Forms | ||
| Contact Sheet | Portrait (approx. 8 records per page) | Either |
| Telemarketing Form | Portrait (approx. 4 records per page) | Either |
| Export Files | ||
| Address Block | ASCII or Excel Spreadsheet | File |
| Address Block + 5 yrs. Tkt, Sub, Donor Flags | ASCII or Excel Spreadsheet **DELUXE ONLY | File |
| Contact & Ticket Sales Info | ASCII or Excel Spreadsheet **DELUXE ONLY | File |
| Full Address Book | ASCII or Excel Spreadsheet | File |
Quick Reports
Box Office in a Box provides Quick Reports for each major area of the software. These reports can be run by simply providing one or two pieces of information and then clicking a button. Listed below are all the reporting areas and reports contained in the software.
| Report | Type | Availability |
|---|---|---|
| Attendance Reports | ||
| Season Summary | Report | Standard |
| Event Summary | Report | Standard |
| Event Detail | Report | Standard |
| Event Labels-1 Across (Standard or Postal Format) | Dot Matrix Label | Standard |
| Event Labels-3 Across (Standard or Postal Format) | Laser Label | Standard |
| Event Export | Excel Spreadsheet | Deluxe |
| Performance Analysis | Report | Standard |
| Performance Detail | Report | Standard |
| Performance Labels-1 Across (Standard or Postal Format) | Dot Matrix Label | Standard |
| Performance Labels-3 Across (Standard or Postal Format) | Laser Label | Standard |
| Performance Export | Excel Spreadsheet | Deluxe |
| Box Sales Reports | ||
| Sorted By Transaction Date (Details or Totals Only) | Report restricted by user set date range | Standard |
| Sorted By Patron (Details or Totals Only) | Report restricted by user set date range | Standard |
| Sorted By Price Code (Details or Totals Only) | Report restricted by user set date range | Standard |
| Sorted By Performance (Details or Totals Only) | Report restricted by user set date range | Standard |
| Sorted By Ticket Marketing Question 1 (Details or Totals Only) | Report restricted by user set date range | Standard |
| Sorted By Ticket Marketing Question 2 (Details or Totals Only) | Report restricted by user set date range | Standard |
| Sorted By Ticket Marketing Question 3 (Details or Totals Only) | Report restricted by user set date range | Standard |
| Sorted By Ticket Marketing Question 4 (Details or Totals Only) | Report restricted by user set date range | Standard |
| Sorted By Ticket Marketing Question 5 (Details or Totals Only) | Report restricted by user set date range | Standard |
| Export of Subscription/Pass Sales | Excel Spreadsheet restricted by user set date range | Deluxe |
| Export of Non-Subscription/Pass Sales | Excel Spreadsheet restricted by user set date range | Deluxe |
| Export of Other Sales | Excel Spreadsheet restricted by user set date range | Deluxe |
| Export of All Sales | Excel Spreadsheet restricted by user set date range | Deluxe |
| Export of Payments | Excel Spreadsheet restricted by user set date range | Deluxe |
| Cash Drawer Reports | ||
| Balance Report | Report | Standard |
| Sales (All, Ticket or Non-Ticket) | Report | Standard |
| Payments (All, Cash, Check, Credit Card or Refunds) | Report | Standard |
| Cash Drawer Deposit | Report | Standard |
| Cash Drawer Withdrawal | Report | Standard |
| Audit Trail | Report | Standard |
| Season Reports | ||
| Listing by Date | Report | Standard |
| Listing by Event | Report | Standard |
| Listing by Event Type, then Event | Report | Standard |
| Listing by Venue, then Date | Report | Standard |
| Season Listing Export | Excel Spreadsheet | Deluxe |
| Setup Reports | ||
| ADAM Users | Report | Standard |
| Box Users | Report | Standard |
| User Defined Membership Fields | Report | Standard |
| User Defined Custom Fields | Report | Standard |
| Available Report Formats | Report | Standard |
| User-Defined Report Definitions (Queries) | Report | Standard |
| Available Membership Field Icons | Report | Standard |
| Available Price Code Icons | Report | Standard |
| Available Donor Profile Icons | Report | Standard |
| Show Form Reports | ||
| People in Attendance | Report | Standard |
| Subscribers in Attendance | Report | Standard |
| Groups in Attendance | Report | Standard |
| Comps in Attendance | Report | Standard |
| Seat Listing | Report | Standard |
| Attendance Overview | Report | Standard |
| Amount Due Report | Report | Standard |
| Cash Drawer Balance Form | Report | Standard |
| Subscription Reports | ||
| Defined Subscriptions & Passes | Report | Standard |
| Subscription & Pass Sales Count | Report | Standard |
| Unassigned Subscription Seats | Report | Standard |
| Unassigned Pass Seats | Report | Standard |
| Subscription Renewal Export | Excel Spreadsheet | Deluxe |
| System Reports | ||
| User Log | Report | Standard |
| Database Maintenance Log | Report | Standard |
| Box Office in a Box Change Log | Report | Standard |
| Master Book Change Log | Report | Standard |
| System Maintenance Log | Report | Standard |
| Error Log | Report | Standard |
| Venue Reports | ||
| Defined Venues List | Report | Standard |
| Venue Definition (Layout) | Report | Standard |
| Venue Definition (Text) | Report | Standard |
Astor Street Software
Milwaukee, WI 53202
Voice: 414.276-6100
Fax: 414.278-6078