• Upload Master Files
  
• Open Audit Details
  
• Export Audit to Excel
  
• Print Audit Reports
  
• Apply Master Files to Bill

Upload Master Files 

1. Click on the Project Auditor Menu to Expand to Sub-menus - Click On Upload Master Files (see image below)
   

Master Files Defined

• Master Files should be created to align to clients agreement. Then saved in a clients MASTER Folder - No one can Replace or Overwrite this file 
  

• Master Files can be distributed to users but you should never accept a file as a MASTER file.  These files can be sent out ONLY
  

• Master Price Data - This is the Client's Master Price Data File - This is the file that was created to align to clients agreement (Required to Run Audit)
  

• Master Project Settings - This is the Client's Master Project Settings File - This is the file that was created to align to clients agreement (Required to Run Audit)
  

• Master Admin File - This is an optional file when it comes to the Project Auditor - (NOT Required to Run Audit).
  

We recommend you click on 

1. "Open Audit Details"  to review Summary and Details
   

2. "Upload Master Files" to begin Audit Process

1. Open Bill File - Immediately Save the Bill with a New File Name before you run an audit. This protects the original Bill file if there is a problem or mistake made in audit process.
   

2. Remove Sales Tax from Bill - Since the Master Project Settings File will not have Sales Tax Values - Since this is normally applied on a per project basis.
   

3. With the Bill file (New Name Saved) then Open Audit Details
   

4. Upload Master Files in Order
   

5. Click on - Open/Import Master Database File Dialog Step 1 (see image below)
   

6. Click On BROWSE - Go to the folder that contains the MASTER Price Data File 
   

7. Double Click On Master File - This will bring you back to dialog then Click ENTER

1. Click on - Open/Import Master Project Settings File (see image below)
   

2. Go to the folder that contains the MASTER Project Settings File 
   

3. Double Click On Master File - This will load the file and immediate Audit will take place

1. Click on - Open/Import Master Project Settings File (see image below)
   

2. Go to the folder that contains the MASTER Admin Settings File 
   

3. Double Click On Master File - This will load the file and immediate Audit will take place

Notice the Difference Column - Project Auditor Flagged Differences from Billed Totals to Audit Totals

Based on Audit Results the Following was Flagged

• Original Invoice Total - $106,123.78
  

• Audit Results Total - $102,325.58
  

• Difference (+/-) Total - $3,798.20 (Over Billed)
  

• Now you MUST Confirm each Category that is showing the Differences (see image below)

• Click on the Project Auditor Menu to Expand to Sub-menus - Click On Open Audit Details (see image below)
  
• Audit Details include Summary and All Billing Categories Details (see images below)
  

• Invoice Total - Represents the Values on the Bill
  

• Audit Results - Represents the Values AFTER you run the Project Auditor
  

• Difference (+/-) - Represents the Values for each billing category AFTER you run the Project Auditor
  

Below are copies of each AUDIT PAGE as they appear in the program - How To Read Each Audit Page 

• On each page you will see side by side comparisons for the Actual Billed Total to the MASTER Total
  

• Any Header that contains the word (Master) represents the values from the MASTER FILES all other Header represents Billed Item/Totals 

Click on the Project Auditor Menu to Expand to Sub-menus - Click On Export Audit to Excel® (see image below)

• To Export Audit to Excel® - Follow these instructions
  

• Click on Sub-menu - Export Audit to Excel® to Open Dialog (see image below)
  

• Click BROWSE from Dialog - Navigate to the folder in which you will save this Excel® file
  

• You will be required to name the file and then click SAVE on file explorer.  
  

• You will be directed back to this dialog 
  

• To have the program open Excel® when the Export is complete check the box "Check to Open Excel® after Saving"
  

• Excel® will automatically open when Export is complete (you will need to make adjustments to Excel® columns manually) 
  

• This will Export a FULL Version of the bill and other items
  

• IMPORTANT NOTE: There is NO Adjuster or Consultant Copy for COST this is an internal report ONLY

Please note - You must use 11x17 or greater paper due to the width of report.  

Click on the Project Auditor Menu to Expand to Sub-menus - Click On Apply Master Files to Bill (see image below)

Important Notice for this Function: You should only use this if there are not Change Orders or Other Authorizations that support the changes. If you have these or some authorizations that allow some, but not all the changes, then we recommend either you run the Apply Master Files to Bill and then go back into bill and modify the items with the authorized changes, or you do NOT run the Apply Master Files to Bill and make the changes manually using the MODIFY function. 

Apply Master Files To Bill

The Apply Master Files to Bill is a Unique Function that is Powerful and Fully Automated to correct the bill to equal the Audit Results

Here are the AUDIT RESULTS after Upload Master Files and Before the APPLY MASTER FILES TO BILL is applied