User Manual
×
Menu

Audit Processing

Audit Processing imports in an audit file and processes the inventory adjustments into the system. In order to use Audit Processing you must have an Audit file on the computer. Audit files can come from hand held Audit devices, from 3rd party Audit companies and you can create your own Audit files.  Audits do not make any informational changes to Items in the Pricebook like Department or Description changes.
 
How Audits work in My Pricebook: When you process an audit, the systems takes the audit quantity, creates a total audit retail value by multiplying price x audit quantity and calculates the total audit cost from purchase history. The system compares those three audit values to those same values currently in the Pricebook, also called the book values. My Pricebook then calculates the difference between the audit values and the book values and those differences are put in the inventory Over/Short value for the day the audit is processed. My Pricebook then takes Audit values and makes them the book values as of the end of business on the day the audit is processed.
 
Very important note: Audit values are updated as of the end of the day that they are processed into. This means that on the day the audit is processed, that days' ending book value for the items in the audit will be set to to the audit value.
 
Best Practices: If possible, the actual counting of items should be done late at night or early in the morning.  If audit was done at night the audit should be processed on same day of count. If the Audit was done early in the morning, the audit should be processed on previous day's work. This will keep book values as accurate as possible.
 
These are 6 steps to getting and Audit into the system:
 
Audit Processing
1

Create or locate Audit file

1. Create or locate Audit file
The first thing you need to do is make sure you have your audit file on your computer.  If you are using a handheld device or getting an audit file from a third party audit company you need to make sure those files have been saved on your computer and you know what folder they are in. If you are creating your own audit file please follow the instructions here.
2

Import the Audit file

2. Import the Audit file 
In this step you will find the Audit file on the computer and bring the data in to My Pricebook. Click the 'Import Audit File' button above and then click here for instructions.
3

Process the Audit file

3. Process the Audit file
Next you will process the Audit file which will put the data in the correct format and match the Items in the Audit to the Items in the Pricebook. Click the 'Process Audit' button and then click here for instructions.
4

Edit the Items

4. Edit the Items 
Edit the quantities for the Items that came in on the Audit. You can check Audit totals using the Adjust Reports button to view a Summary Report for the Audit. Click the 'Edit Items' button and then click here for instructions.
5

Make Department Adjustments

5. Make Department Adjustments
Make any Adjustments to the Department totals as needed. Click here for instructions.
6

Complete the Audit

6. Complete the Audit
After editing your Items and making any Department Adjustments,you need to completed the Audit. Click the 'Complete Audit' button and then click here for instructions.