# Administrative Reports FAQ

1. Window Sticker
2. Sale Sticker
3. Mailing Labels
4. Registration Card
5. Dealer License Expiration
6. Gate Activity
7. Auction Insurance Agency Report
8. Bank Master and Fee Master Reports
9. Lot Turn List

# Window Sticker

**<span style="font-family: Arial;"><span style="color: #808000;"><span style="font-size: large;"><span style="color: #000000;">WIN</span> <span style="color: #000000;">Sticker</span></span> </span></span>**

**<span style="font-family: Arial;"><span style="font-family: Arial; font-size: small;"><span style="font-size: large;">Win (window) Sticker</span></span></span>**

<span style="font-size: medium;">This report is designed to provide larger and more readable information for a vehicle than the Sales Sticker. You may run this report from the [**Sale Profile**](https://cam3-wiki.auctionstreaming.com/books/cams-3-wiki-faq/page/sale-profile) or the [**Vehicle Block**](https://cam3-wiki.auctionstreaming.com/books/cams-3-wiki-faq/page/vehicle-block) application.</span>

<span style="font-size: medium;">Select </span>

- <span style="font-size: medium;">The Sale Profile application &gt; Reports &gt; Administrative Reports &gt; Win Sticker</span>

<span style="font-size: medium;">[![win-saleP.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/win-salep.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/win-salep.jpg)</span>

- <span style="font-size: medium;">The Vehicle Block application &gt; Reports &gt; Administrative Reports &gt; Win Sticker</span>

<span style="font-size: medium;">[![Win-vB.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/win-vb.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/win-vb.jpg)</span>

<span style="font-size: medium;">**Note**: **You must select the 'Sale Description' (click the '+' sign next to the Sale Date') to run the report and select a vehicle.**</span>

<span style="font-size: medium;">**<video controls="controls" height="400" width="800"><source src="https://cam3-wiki.auctionstreaming.com/attachments/27"></source></video>**</span>

# Sale Sticker

<span style="font-size: medium;">The Sales Sticker is used to identify a vehicle's Run Number, Year, Mileage, Make, Model and Color. It is affixed to the front windshield and has a bar code for use when the vehicle departs. The report can be configured to automatically print after the following orders are done:</span>

- [**Office Check In**](https://cam3-wiki.auctionstreaming.com/books/cams-3-wiki-faq/page/check-in-order)
- [**Sale Check In**](https://cam3-wiki.auctionstreaming.com/books/cams-3-wiki-faq/page/check-in-order)
- [**Roll Over**](https://cam3-wiki.auctionstreaming.com/books/cams-3-wiki-faq/page/roll-over-order)
- [**Re-Run**](https://cam3-wiki.auctionstreaming.com/books/cams-3-wiki-faq/page/re-run-order)

<span style="font-size: medium;">You may re-print the Sales Sticker from the Dealer Profile or Vehicle Block application. You may also use **Print Settings** to define the printer output according to your user ID.</span>

<span style="font-size: medium;">Click the "Printer icon" to enable the print setting to save the report as PDF and click the "Eye icon" to change and enable the printing for the report to open in preview mode. Click the "Gear icon" to reset to default"</span>

<span style="font-size: medium;">**[![printsetting.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/printsetting.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/printsetting.jpg)**</span>

<span style="font-size: medium;">**here**</span>

<span style="font-size: medium;">Select</span>

<span style="font-size: medium;">The [**Vehicle Block**](https://cam3-wiki.auctionstreaming.com/books/cams-3-wiki-faq/page/vehicle-block) application&gt; Reports &gt; Administrative Reports &gt; Sales Sticker</span>

<span style="font-size: medium;">[![Sale-VB.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/sale-vb.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/sale-vb.jpg)</span>

<span style="font-size: medium;">The **[Dealer Profile](https://cam3-wiki.auctionstreaming.com/books/cams-3-wiki-faq/page/dealer-profile)** application&gt; Reports &gt; Administrative Reports &gt; Sales Sticker</span>

<span style="font-size: medium;">[![Sale-DP1.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/sale-dp1.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/sale-dp1.jpg)</span>

<span style="font-size: medium;">\*\*\***The Dealer Profile application&gt; Reports &gt; Printing Setting &gt; Sales Sticker** </span>

<span style="font-size: medium;">**Note**: **You must select a vehicle in the grid of the Vehicle Block application**</span>

<span style="font-size: medium;">**<video controls="controls" height="400" width="800"><source src="https://cam3-wiki.auctionstreaming.com/attachments/26"></source></video>**</span>

# Mailing Labels

<span style="font-size: medium;">Mailing labels may be printed from the Dealer Profile. These labels are designed to print on Avery (or a similar maker) of the 5160 labels, Envelopes and.</span>

<span style="font-size: medium;">Select</span>

<span style="font-size: medium;">The **[Dealer Profile](https://cam3-wiki.auctionstreaming.com/books/cams-3-wiki-faq/page/dealer-profile)** &gt; Reports &gt; Administrative Reports &gt; Envelope </span>

<span style="font-size: medium;">Print the Dealers Address on envelopes</span>

<span style="font-size: medium;">[![envelope.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/envelope.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/envelope.jpg)</span>

<span style="font-size: medium;">The **[Dealer Profile](https://cam3-wiki.auctionstreaming.com/books/cams-3-wiki-faq/page/dealer-profile)** &gt; Reports &gt; Administrative Reports &gt; Mailing Labels 5160</span>

<span style="font-size: medium;">Print Dealers Business Street on Avery 5160 Labels</span>

<span style="font-size: medium;">[![Avery5160.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/avery5160.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/avery5160.jpg)</span>

<span style="font-size: medium;">The **[Dealer Profile](https://cam3-wiki.auctionstreaming.com/books/cams-3-wiki-faq/page/dealer-profile)** &gt; Reports &gt; Administrative Reports &gt; Electronic Mailing</span>

<span style="font-size: medium;">Create a text file with the dealer's Address and you can include the Email Address as well.</span>

<span style="font-size: medium;">[![Electron.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/electron.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/electron.jpg)</span>

<span style="font-size: medium;"><video controls="controls" height="400" width="800"><source src="https://cam3-wiki.auctionstreaming.com/attachments/24"></source></video></span>

# Registration Card

<span style="font-size: medium;">The Registration ID card is printed on a 4 x 3 bid badge label which is affixed to a plastic card. The label has a bar code used by a Representative to register themselves as a bidder using a scanner.</span>

<span style="font-size: medium;">Select</span>

<span style="font-size: medium;">The **[Dealer Profile](https://cam3-wiki.auctionstreaming.com/books/cams-3-wiki-faq/page/dealer-profile)** application &gt; Select the Rep&gt; Reports &gt; Administrative Reports &gt; Registration Card &gt; </span>

<span style="font-size: medium;">You can also choose the media to type the card that will be printed on</span>

- <span style="font-size: medium;">Paper Media </span>

<span style="font-size: medium;">[![paper1.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/paper1.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/paper1.jpg)</span>

**<span style="font-size: medium;">Sample print of Paper Media</span>**

<span style="font-size: medium;">[![paper2.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/paper2.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/paper2.jpg)</span>

- <span style="font-size: medium;">Plastic Media</span>

<span style="font-size: medium;">[![Plastic.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/plastic.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/plastic.jpg)</span>

<span style="font-size: medium;">**Sample print of Plastic Media**</span>

<span style="font-size: medium;">**[![plastic2.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/plastic2.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/plastic2.jpg)**</span>

<span style="font-size: medium;">**<video controls="controls" height="400" width="800"><source src="https://cam3-wiki.auctionstreaming.com/attachments/25"></source></video>**</span>

# Dealer License Expiration 

The Dealer License number along with the State and expiration date is stored in the system. The Dealer License Expiration report is designed to list Dealer Accounts whose license has expired or is incomplete.

Select

The **[Dealer Profile](https://cam3-wiki.auctionstreaming.com/books/cams-3-wiki-faq/page/dealer-profile)** application &gt; Reports &gt; Administrative Reports &gt; Dealer License Exp

[![DealerLicense1.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/dealerlicense1.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/dealerlicense1.jpg)

Select the Dealer Type and if you wish to include 'Active' Dealer accounts only.

[![DealerLicense2.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/dealerlicense2.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/dealerlicense2.jpg)

<video controls="controls" height="400" width="800"><source src="https://cam3-wiki.auctionstreaming.com/attachments/37"></source></video>

# Gate Activity

This report provides details on Redemption, Departure, and Test Drive times for vehicles leaving and/or returning to the lot. It provides elapsed time for Test Drives and quickly identifies if vehicles left but did not return.

Select the **[Dealer Profile](https://cam3-wiki.auctionstreaming.com/books/cams-3-wiki-faq/page/dealer-profile)** application &gt; Reports &gt; Administrative Reports &gt; Gate Activity

[![gate1.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/gate1.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/gate1.jpg)

After selecting the report you will be prompted for the **'Begin'** and **'End'** dates for the order.

[![gate2.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/gate2.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/gate2.jpg)

<video controls="controls" height="400" width="800"><source src="https://cam3-wiki.auctionstreaming.com/attachments/38"></source></video>

# Auction Insurance Agency Report

The Auction Insurance Agency report is used to provide sales information to **AIA** (**Auction Insurance Agency**)

Select The **[Sale Profile ](https://cam3-wiki.auctionstreaming.com/books/cams-3-wiki-faq/page/sale-profile)**application &gt; Reports &gt; Administrative Reports &gt; Auction Inc Agency

Ensure to select the Sale Date you want to run the report for

[![AIA.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/aia.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/aia.jpg)

In the event, you buy or sell vehicles to the Public you should include these dealers in this report by selecting the checkboxes.

[![AIA2.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/aia2.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/aia2.jpg)

<video controls="controls" height="400" width="800"><source src="https://cam3-wiki.auctionstreaming.com/attachments/46"></source></video>

# Bank Master and Fee Master Reports

**<span style="text-decoration: underline;">Bank Master Report</span>**

The Bank Master lists all banks as they relate to each Dealer.

Select

The **[Dealer Profile](https://cam3-wiki.auctionstreaming.com/books/cams-3-wiki-faq/page/dealer-profile)** application &gt; Reports &gt; Administrative Reports &gt; Master Listings &gt; Bank Master

[![BankMaster1.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/bankmaster1.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/bankmaster1.jpg)

This will launch the Bank Master Report form. You may sort according to Bank, Branch, or Dealer. You may also select all Dealers or just one.

[![BankMaster2.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/bankmaster2.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/bankmaster2.jpg)

Click **'OK'** to create the report and print

[![BMexample.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/bmexample.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/bmexample.jpg)

<span style="text-decoration: underline;">**Fee Master Report**</span>

The Fee Master report is used to provide details on what rates the Auction has set up to charge its customers for Sales, Registration, Transportation, and settlement Fees.

Select

The **[Dealer Profile](https://cam3-wiki.auctionstreaming.com/books/cams-3-wiki-faq/page/dealer-profile)** application &gt; Reports &gt; Administrative Reports &gt; Master Listings &gt; Fee Master

[![FeeM1.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/feem1.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/feem1.jpg)

This will launch the Bank Master Report form. You may run the report for 'All Dealers' or only one.

[![feeM2.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/feem2.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/feem2.jpg)

Select the Fee Type:

- **Sales Fees (buyer and seller)**
- **Registration Fees (sold and unsold)**
- **Transportation**
- **Settlement**
- You may sort the report by Dealer name, Representative name, or by Customer ID.
- Click **'OK'** to create the report and print

[![FeeMexample.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/scaled-1680-/feemexample.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-08/feemexample.jpg)

<video controls="controls" height="400" width="800"><source src="https://cam3-wiki.auctionstreaming.com/attachments/64"></source></video>

# Lot Turn List

The Lot Turn report is used to identify the remaining vehicles from the previous week when setting the sale.

To this Report Select the**[ Vehicle Block](https://cam3-wiki.auctionstreaming.com/books/cams-3-wiki-faq/page/vehicle-block)** application &gt; Reports &gt; Administrative Reports &gt; Lot Turn list

[![lotturn1.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-09/scaled-1680-/lotturn1.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-09/lotturn1.jpg)

You will be asked if you want to exclude In Active and Off-Site vehicles here we choose yes because we don't want the departed vehicles in our report. The report will then be generated for printing.

[![lotturn2.jpg](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-09/scaled-1680-/lotturn2.jpg)](https://cam3-wiki.auctionstreaming.com/uploads/images/gallery/2022-09/lotturn2.jpg)

<video controls="controls" height="400" width="800"><source src="https://cam3-wiki.auctionstreaming.com/attachments/85"></source></video>