BranchWarehouse.docVIP

Contributed June 25, 2002 by Douglas Warner DOUGLAS.WARNER@ Branch Name and Number________________________________________________ Review Date ____________  AUTHOR Internal Audit Department Page  PAGE 10  DATE 2017/4/24 BRANCH WAREHOUSE (DISTRIBUTION)Audit Objectives and Procedures  Workpaper Ref. Perform ByPLANNINGAudit Objective: To obtain a general understanding of the Branch operations in order to plan the audit.Procedures: Obtain the following information for the Branch to be audited:Run branch P L reports – Income Statement by month (“Charles” report). Perform detail analysis on statement paying attention to controllable vs. non-controllable costs. Look for spikes. Run the most recent Accounts Receivable Summary Aging Report for the Branch. Using Prelude path - Main Menu Financial A/R User Routine Reports A/R Aging Reports Reports Aged Accounts Rec. (input warehouse number and enter changing D to S). Use ACL reports for detailed analysis of any customers with large outstanding balances.Obtain from credit depart a copy of most recent A/R Ranking Report.Review Flash Reports for key performance indicators.Branch personnel listing – Obtain from corporate payroll department. Include hire dates and date of current position for each employee associated with branch. Do not include salary.Open Sales Order Report – Using Prelude path - Main Menu Distribution Order Processing Reports Daily Order Detail Open Sales Order (input branch number, ending date (give 30 day cushion), and sort by W/B). Run again using 3-day window. Use screen view to get total and post on 30-day report.ACL analysis reports – reports generated through ACL by downloading Inventory, A/R, and deleted orders from Prelude. See download sheets for additional instructions in this area. Run warranty claim tag reports – Using Prelude path – Main Dist. Inventory Reports