Complete the pop-up box to match the following, then click “OK”: **Please note On” could say or Values” both are okay – “Sort “Values” “Cell – This will allow you to quickly spot check transactions by amount for some or all of the following: Round numbers or recurring numbers Unfamiliar employee names associated with transactions Appropriateness of the transaction For any inconsistencies or questions arising from the spot check, request or review supporting documentation. For a very high level review of a few large-dollar transactions throughout the month: Click on the drop-down arrow next to (Column H) and “Amount” Filters” Select “Number Select 10” “Top This will allow you to review the largest dollar expenditures quickly for some or all of the following: Correct Account Code description Existence and accuracy of source documents Appropriateness of transaction 1. Go to the tab at the top and click on “Data” “Sort” Complete the pop-up box to match the following, then click “OK”: This will allow you to quickly spot check transactions by vendor for some or all of the following: Recurring payments to the same vendor throughout the month Unfamiliar vendors Non-UF Market vendors such as Publix, Amazon, Lowe’s, Walmart etc. Appropriateness of the transaction For any inconsistencies or questions arising from the spot check, request or review supporting documentation. Click on the drop-down arrow next to Detail” (Column D) and “Transaction
Complete the pop-up box to match the following, then click “OK”: **Please note – “Sort On” could say “Values” or “Cell Values” – both are okay This will allow you to quickly spot check transactions by amount for some or all of the following: Round numbers or recurring numbers Unfamiliar employee names associated with transactions Appropriateness of the transaction For any inconsistencies or questions arising from the spot check, request or review supporting documentation. For a very high level review of a few large-dollar transactions throughout the month: Click on the drop-down arrow next to “Amount” (Column H) and Select “Number Filters” Select “Top 10” This will allow you to review the largest dollar expenditures quickly for some or all of the following: Correct Account Code description Existence and accuracy of source documents Appropriateness of transaction 1. Go to the “Data” tab at the top and click on “Sort” Complete the pop-up box to match the following, then click “OK”: This will allow you to quickly spot check transactions by vendor for some or all of the following: Recurring payments to the same vendor throughout the month Unfamiliar vendors Non-UF Market vendors such as Publix, Amazon, Lowe’s, Walmart etc. Appropriateness of the transaction For any inconsistencies or questions arising from the spot check, request or review supporting documentation. Click on the drop-down arrow next to “Transaction Detail” (Column D) and
1_Quick_Guide_Spot_Checking_TransactionDetail.docx