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 #.
eBay active listings report
Seller Hub > Reports > Active listings. Supplies Date Listed and Current Price.
eBay orders report
Seller Hub > Orders > Download report. Supplies Sold Price and Shipping Collected. Rows link to Counterpoint by Item # = Custom label.
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
Select All
Select None
Loading inventory movement…
Check one or more account codes to include.
Category
Select All
Select None
Loading inventory movement…
Check one or more categories to include.
Account Code
Choose an account code
Status
All Status
Account Code
Choose an inventory export file first
Check one or more account codes to include.
Status
Choose an inventory export file first
Check one or more statuses to include.
Qty Avail > 0 Only
Preview Fields
Select All
Select None
Choose which columns show in the preview and download.
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.
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.
Status
Active and Discontinued
Active only
Discontinued only
Qty On Hand
All items
Above 0 only
0 or below only
Vendor
Select All
Select None
Loading vendors...
Check one or more vendors. Leave all checked to export every vendor.
Category
Select All
Select None
Loading categories...
Check one or more categories. Leave all checked to export every category.
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
Sort By
Item #
Vendor
Cat #
Category
Status
Account Code
Description
Qty On Hand
Qty On Order
Last Received Date
Sort Direction
Ascending
Descending
Then Sort By
(None)
Item #
Vendor
Cat #
Category
Status
Account Code
Description
Qty On Hand
Qty On Order
Last Received Date
Then 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
Save to Dropbox
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