The Camera Company Reports
Upload the sales export, choose a report, set dates, and download the workbook.
Sign in
Sign in to load your report permissions.
Data Source
Load Latest from Dropbox
Optional file upload
eBay export (optional)
Adds eBay Price, Start Date, and End Date by matching Item #.
Report Filters
Report
Team Member Reports
Customer Reports
Sales Reports
Inventory Management
View
Vendor
Choose a sales export file first
Brand
Choose a sales export file first
Category
Choose a sales export file first
Check one or more. Leave blank to include all categories.
Employee
Choose a sales export file first
Item # or Description
Clear
Serial # or Item #
Clear
Category
Select All
Select None
Choose a sales export file first
Choose at least one category.
Category
Choose category
Account Code
Choose an account code
Status
All Status
Category
Choose a sales export file first
Check one or more. Leave blank to include all categories.
STAT
Choose a sales export file first
LST_REC Through
LST_SOLD Through
Cost On Hand Greater Than
Cost On Hand Less Than
Last Sale Date After
Last Sale Date Before
Last Received Date Before
Qty Avail = 0 Only
Sub Category
Choose a sales export file first
Check one or more. Leave blank to include all sub categories.
Preview Fields
Select All
Select None
Choose which columns show in the preview and download.
Summary Fields
Select All
Select None
Choose which columns show in the item summary.
Detail Fields
Select All
Select None
Choose which columns show in the detail section and download.
Summary Fields
Select All
Select None
Choose which columns show in the serial summary.
Detail Fields
Select All
Select None
Choose which columns show in the detail section and download.
Preview Fields
Select All
Select None
Choose which columns show in the preview and download.
Detail Fields
Select All
Select None
Choose which columns show in the detail section and download.
Detail Fields
Select All
Select None
Choose which columns show in the preview and download.
Preview Fields
Select All
Select None
Choose which columns show in the preview and download.
Category Fields
Select All
Select None
Choose which category columns show in the preview and download. Date and totals always show.
Report Fields
Select All
Select None
Choose which columns show in the preview and download.
Manage employee list
Active employees, one per line
This list is shared, so saving it here updates it for everyone on any computer.
Save Employee List
Reset to Default
Sort Options
Sort By
Category, Sub Category, Cat #
Sub Category, Category, Cat #
Vendor, then Item #
Item #
Cat #
Description
Date Sold Ascending
Date Sold Descending
Qty Sold, High to Low
6M Sales, High to Low
Qty Avail, High to Low
Qty on Order, High to Low
Price, High to Low
Sort By
Item #
Trade-In Rep
Sales Rep
Date Sold
Days In Inventory, High to Low
Profit %, High to Low
Inventory Sort
Vendor, Category, Item #
Item #
Category, Item #
GRP_COD, Item #
Vendor, LST_Sold
LST_Sold
LST_ORD
LST_REC
Wks on Hand
Cost On Hand
12M Sales
6M Sales
3M Sales
Sort Direction
Ascending
Descending
Sort By
Item #
Category
Description
Qty On Hand
Avg Cost
Extended Average Cost
Last Received Date
Sort Direction
Ascending
Descending
Best Customer Sort
Sales Dollars
Profit Dollars
Number of Tickets
Customer Count
Top 10
Top 25
Top 50
Top 100
Top 250
All Customers
Item Count
Top 10
Top 15
Top 25
Top 50
Top 100
Top 250
All Items
Run Report
Beginning Date
Ending Date
Preview Report
Download Workbook
Print Preview
Download PDF
Ready.
Saved Views
Save current filters as a view
Save View
Views are shared, so they will show on other computers too. Saves the filters for the selected report (vendor, category, employee, field selections, etc.) — not the date range.
Report Notes
Add note for the selected report
Add Note
Clear Notes for This Report
Notes are shared, so they will show on other computers too.
Preview