| Table of Contents | ||||||||
|---|---|---|---|---|---|---|---|---|
|
Overview
The Inventory Count Wizard enables Users to perform a Book to Physical Reconciliation within the Office Product, and post the associated Inventory Adjustments related to the process. The tool has Count Sheets to assist with Physical counting, and online reconciliations to help finalize Inventory Adjustments. Managers at Clubs will want to perform physical counts of their inventory, and book the related adjustments (overages/shortages) to ensure financial statements are properly stated, and to determine that financial controls and processes are effective. |
Video
This video walks Users through the Inventory Count Wizard.
...
| Total Video (Length) | 7:31 | |||
|---|---|---|---|---|
| Prepare for Inventory | 0:00 | Adjust Counts | 4:21 | |
| Print Count Sheets | 2:26 | Finalize Counts | 5:13 | |
| Enter Counts | 2:43 | Generate Inventory Adjustment Batch | 6:10 | |
| Save Counts & Review Variances | 3:48 | Reporting - Inventory On-Hand | 6:55 |
Content
|
|---|
Accessing the Tool
Within the Clubessential Office Product:
Choose Items
Inventory Count Wizard
Screen Overview
1. Process Count for Area - For Multi-Inventory Clubs, designates specific area to Inventory. Use lookup button to assist with area selection.
...
18. Final Review of Counts – This screen gives you an overview of everything that’s been done to that point, and allows you to complete the inventory count process.
Prepare for Inventory
Post Prior Batches
Prior to beginning the Inventory Count, ensure all open batches impacting current On-Hand Inventory are posted. The following Warning message will appear, and will serve as a reminder to handle these items.
Click, “OK” to proceed.
Select Area (For Clubs Using Multi-Inventory System)
For Clubs utilizing the Multi-Inventory System (Multiple Areas with Inventory), select area to be inventoried. Start typing or Utilize Look-Up Button for assistance.You need to be sure that accounting has posted all sales up to current day before you.
Select Categories
Select Categories for inclusion into Physical Inventory. Select with Mouse (for Range), or Control Select (hold CTRL and click with Mouse), for singular selections.
Lock Selected
Once Categories are selected, click the Lock Selected button. This will provide a snapshot in time of system (book) quantities.
...
Once Locked, the “LockedOn” quantity column will populate with the Lock Date. This may take a few minutes to appear.
Print Count Sheets
To assist with the Physical Count Process, select, “Print Count Sheets.” Note that Printing options exist to Show All Locked Categories or a Selection, Show/Hide Locked Count on Count Sheet, and/or Paginate based on Category. The “Exclude Items with Zero Variance” will apply only after initial counts have been entered.
...
Once printed, physically count the Inventory (either by hand, or with a Scanning device).
Enter Counts
When physical counting is finished, click “Enter Count Sheets” to enter counts. Counts may be entered manually, or with the assistance of a *.csv file generated from a Scanning Device.
Enter Manual Counts
To enter manual counts, type the physically counted quantities in the “Counted Quantity” column.
(Or) Enter Counts via *.CSV File
Export data from scanning device to a .csv file. Then, import data into system by clicking, “Import Counts from Scanning Device (*.csv).”
...
“Counted Quantity” column will populate with data from CSV file.
Save Counts
Once finished, click “Save Counts.”
Review Variance Report
After clicking “Save Counts,” message will appear and will prompt user to review a variance report (Count Sheet Summary).
...
Click “Yes,” to launch Variance Report and view Differences between System Quantities (Book), and Physically Counted Quantities (Physical).
Adjust Counts
After revisiting the Variance report, differences may be investigated. Additional inventory may be found and/or counts verified again may yield a different result. To change quantities previously counted, click, “Enter Counts Sheets” again.
Note that a “Previous Count” column now exists. New counts may be entered in the “Counted Quantity Column.
...
Adjusting/entering counts may occur as many times as necessary.
Finalize Counts
Once counts are reviewed and are deemed final, click the “Final Review of Counts” button.
...
Print, or Save the finalized Count Summary.
Generate Inventory Adjustment Batch
To finalize the Physical Inventory process, click the “Create Inventory Adjustment Batch,” to have system auto-generate the Inventory Adjustment that will be posted in conjunction with the variances identified within the Physical Inventory process.
...
System will generate batch and will appear for review. Click “Post Batch” to post to G/L.
Reporting - Inventory On Hand
To generate an On-Hand Inventory Report, navigate to Interactive Reports.
...
Expand Inventory Option, and choose “Inventory On Hand”.
Designate appropriate Area, and “View Report.”
FAQs
Q. Can I still ring in sales while doing my inventory process?
...
A. Once Unlock Selected has been clicked, the inventory process has been undone, and must be started again.
Downloadable Guide