Reports: Inventory & Service

Inventory Item Listing Report

The Inventory Item Listing Report includes the details of your in-stock parts inventory. There are report options that can be tailored to report low, medium and high details of your inventory. You can also change the sort options to sort the report results alphabetically, numerically or by the sort order specified in your item-level maintenance. Additionally, you can change the report to include ‘specific’ or ‘all’ vendors and include ‘all negative on-hand quantities’ that currently exist in your system.

The QuickTouch system will sell negative amounts if the parts are actually available. This could occur if a parts order has been delivered but the Purchase Order has not been posted. When the order is posted, the inventory restocking will add the received amount to the negative quantity onhand and end up with the correct on-hand levels.

Your inventory is one of the largest monetary investments in your store and one that you have control over. The value, performance and accuracy of your inventory are highly important to the profitability of your business.

What’s in it?

Open

Open

Inventory Value Report

The Inventory Value Report provides total current inventory value for accounting and management purposes. It lists the current on-hand amounts and multiplies it by the last cost for each inventory item number in your system. The last page of the report will summarize the results by inventory group, vendor and the total replacement cost on hand. If you need the value for a previous date, see the Inventory Value Snapshot report. Report options are customizable and the items can be sorted alphabetically or numerically, grouped by vendor or item group, and you can include ‘all’ or ‘single’ for groups and vendors.

After taking a physical inventory stock check and making the necessary adjustments to the on-hand system totals (see Inventory Adjustment), this report tells you exactly what your total current inventory value is. Run this report on the last day of the month or accounting period to update the accounting system. It is the report to use to manage overall dollar levels tied up in inventory stock.

What’s in it?

Inventory Worksheet

The Inventory Worksheet is a detailed list of item (stock) numbers that are included in the store’s inventory. It is formatted to provide a worksheet to perform physical inventory and document the counts and discrepancies of inventory that should be on-hand. This worksheet is generally used monthly or quarterly to verify that the quantities on-hand match the system’s quantities. Report options are customizable and include sorting alphabetically or numerically, grouping by vendor or item group, and you can show ‘all’ or ‘specific’ item groups and vendors.

Checking physical inventory takes time and discipline. The Inventory Worksheet is designed to make verifying your current inventory levels go much more smoothly. Discrepancies in the on-hand counts can be adjusted (with audit reporting) using the Inventory Adjustment function in Inventory Maintenance.

What’s in it?

Stock Reorder Report

The Stock Reorder Report lists all of the items that need to be reordered, based on the ordering method for each item (Minimum Level with Standard Order or Automatic). This report is normally printed for each vendor and is used to place an order.

If ordering has been properly configured on your QuickTouch system, using the reorder report can save you countless time in manually checking items before placing a stock order. The system automatically checks every stock item to see if it has fallen below the necessary stock level and, if so, it is added to the reorder report. Stock items where the on-hand levels are still above the minimum levels will be skipped until the next reorder report is run.

What’s in it?

Vendor Listing Report

The Vendor Listing Report is a simple report providing a complete listing of all of your vendors and their contact information that is stored on the NexGen website.

This report is useful for quickly identifying vendor names, phone or fax numbers and business contacts. It is a handy reference and can be used like a printable rolodex for all of your vendors.

What’s in it?

Stock Sales Report

The Stock Sales Report lists all stock items sold on a certain date or within a date range. The details of this report list the item group, the quantity sold, cost and selling prices, markup and profit percentages, and the minimum stock levels. The report gives the option to sort by the Slowest or Fastest selling parts, in addition to the default sorting method by Item Group.

The stock sales report can be used to validate your minimum stock levels by comparing it to the actual usage. It also highlights those stock sales that generate the most profit. Non-stock item sales are shown at the end of the report with a stock number and description. This is a great way to decide if a frequently used item that is being purchased from an outside vendor should become a stock item. Stock item purchases from a primary vendor are typically less expensive than spur-of-the-moment outside purchases. By using the Slowest Selling sort option for a large date range, you can quickly see which products are not selling and you can make adjustments in your preset ordering levels.

What’s in it?

Service Listing Report

The Service Listing Report provides a complete listing of all of the services that have been entered into your QuickTouch system through Service Maintenance.

The Service Listing Report can be useful in helping you review your services. It can also be used to help you develop your service menu.

What’s in it?

Non-Service Labor Detail

Non-Service Labor Detail is a simple report listing all labor-only transactions which were performed outside of a preset service for a single date, date range or all dates. These labor services were sold through use of the ‘Labor’ button on the customer invoicing screen.

This report can help you identify services being performed that you may want to consider incorporating into your service menu. It can also help you analyze the pricing of these services and ensure that an adequate amount is being charged for the services performed.

What’s in it?

Non-Service Parts Detail

Non-Service Parts Detail is a simple report which lists all parts transactions that were performed outside of a preset service (parts on-the-fly) for a single date, date range, or all dates. These parts were sold through use of the ‘Parts’ button on the customer invoicing screen.

This report can help you track which parts are being frequently sold outside of preset services. This is especially useful for tracking items such as drain plugs and gaskets that are routinely replaced but would not be added through a service. Note: air filter, cabin air filter, and similar parts should be set up to be sold through a service rather than as a non-service part sale (‘Parts’ button). An air filter service is an ‘installed air filter’ and the service detail sections of many of the NexGen analysis reports will include these types of services as well.

What’s in it?

Inventory Adjustment Report

The Inventory Adjustment Report provides information about the quantities of inventory items that have been adjusted manually. The report can be run for a single date, all dates or a specified date range.

Keeping track of inventory restocking and adjustments is very important for maintaining accuracy in your inventory count and values. This report provides you with the ability to see that inventory is only being manually adjusted with proper justification. Adjustments should be infrequent and are typically performed as a result of a physical inventory check. This report is a permanent record of all adjustments performed.

What’s in it?

Inventory Restocking Report

The Inventory Restocking Report provides information about items that have been brought into inventory upon receipt of a purchase order. The reporting options allow you to report on a specific vendor invoice or purchase order number. It then lists all inventory restocking that was performed for the period requested. The report details each item restocked sorted by item group, the old and new quantities, and the cost of goods received.

The Inventory Restocking report should match the packing slip received from you supplier. These are necessary to reconcile subsequent billing from that supplier as part of the accounting system and accounts payable. It is also useful to verify that inventory is being entered with the correct cost and quantity, which is crucial to maintaining accurate inventory counts and valuation

What’s in it?

Certificate Activity Report

This report is designed for centers that perform state inspections and emissions and need to track the inspection stickers by certificate number. The Certificate Activity Report lists each sticker number in sequence. This report should be used along with the Certificate Omissions report which indicates discrepancies and missing stickers.

State regulations are strict regarding the issuing and tracking of inspection stickers. Officers from the Department of Transportation may ask you to produce records of your sticker usage with little or no notice. This report gives you the ability to quickly produce a record of these transactions.

What’s in it?

Certificate Omissions Report

The Certificate Omissions Report is a complementary report to the Certificate Activity report and is intended to track certificate numbers and ensure that they are being entered in a continuous numerical order. This report indicates where there are gaps in sticker continuity.

This report allows you to quickly identify when state inspection stickers are missing. Since these are state controlled, it is imperative that every sticker be accounted for. Officers from the Department of Transportation may ask you to produce records of your sticker usage with little or no notice. This report gives you the ability produce documentation quickly and easily and allows you to catch any discrepancies before they result in costly penalties.

What’s in it?