You are responsible for your workpapers – you prepare professional workpapers that a CPA
Auditor would prepare
DUE: THURSDAY April 21* – hard copy turned in at the beginning of class
If you use Excel – here’s one way:
New Column – Formula
“Concatenate” with Vendor#, Invoice#, & Amount (Title new column
whatever you want)
Sort file using new column either high to low or low to high
New Column – Title “Duplicate”
– say that is column “G”
In new column:
O
Formulas – Logical – OR
O
Logical1 = G3=G4
O
Logical2 = G3=G2
O
Copy and paste all the way down to bottom of data
O
If data is exact, cell will show “TRUE”
O
If data is different, cell will show “FALSE”
0
TRUE = Duplicate
O
Filter – then the Duplicate Column – click “True”
All the TRUEs will be listed in new excel worksheet
Remember – you may get 2 or 3 or 4 or more of the same invoice. One invoice is correct, the rest are
duplicates.
Identify total duplicate payments and subtract from original balance
List correct balance
Determine if William’s Hospital’s payments are fairly stated!
