After completing and discussing this case, you should be able to examine edits/adjusting journal entries to accounting system records to determine whether any transactions have been altered:
This case explores the process of vouching from a schedule (e.g., data extraction of edits/adjusting journal entries) to source documents (e.g., deposit slips and bank statements).
Inexpensive, readily available, accounting packages have edit functions that can be fraudulently used if a company does not have adequate internal controls (i.e., separation of authorization, accounting, and asset custodian duties). After printing checks to the payee listed on the check, a fraudster can use the edit function to change the name of the payee and account. Vouching from the cash disbursements journal and the canceled check and/or bank statement will document the difference. Similarly, a fraudster can use the edit function to reduce the amount of cash receipts and deposit a lower amount (i.e., steal cash).
This case teaches you how to prepare a spreadsheet detailing original and edited transactions listed on an accounting record (e.g., data extraction from the adjustments and/or cash receipts journal). You will learn how to document the edits by vouching to the amount and date of the edited transactions to the supporting documents (e.g., deposit ticket and bank statement).
On April 2, 2016 (the day following the bank's notification of overdrawn checks), Dr. Anderson reviewed the March 2016 details from her practice over breakfast and noted that deposited cash deposits did not match the cash receipts initially recorded in the Medatrix UltraScan Point of Sale (POS) system. She asked Teresa Padgett, an information technology specialist, to look up the original and edited cash receipt transactions recorded in Medatrix UltraScan for March 2016. Teresa found that Tonya Larsen, who has been the office manager since September 2015, had made a number of even‐dollar edits to the amount of cash receipts (e.g., $2,197.95 reduced to $1,697.95, a $500.00 reduction) and that the smaller edited amounts of cash were deposited days after actual receipt. Teresa Padgett told Dr. Anderson that she thought Tonya Larsen was stealing—altering deposits with different round dollar amounts (more than $1,000 a week). Time stamps on Tonya Larsen's edits show when she changed the information. Every employee has a distinct ID and password that employees are not to share. Tonya Larsen's ID is “203–Tonya.” According to Teresa Padgett, there appears to be a delay of several days between daily sales receipts and actual deposits and there appears to be a pattern of decreased deposits.
Teresa Padgett downloaded the edits to the cash receipts journal for the period September 1, 2015, through March 31, 2016, for further examination.
Alexander Z. Boone, Esq., the independent attorney hired by Southern Appalachian Insurance Company, added a review of the edits to the cash receipts journal to your examination of Anderson Internal Medicine's employee dishonesty claim.
Before proceeding, read the documents in Chapter 7, section 7‐3, “Fraudulent Edits/Adjusting Journal Entries.” As you work the case, you will have to read and reread the documents to fully understand the evidence.
As with the information analyzed and summarized from the bank statements, canceled checks, deposit slips, and so on, the results of this additional assignment will be used by the attorney. Your assignment (in general) is as follows:
The initial steps (see exercise) are to be completed individually. You may confer online on strategy, but do your own work. In particular, all students are to perform the various fraud examination steps and submit their Excel working papers (e.g., schedules) for grades.
After reading this synopsis, you should be able to:
Essential to detecting and documenting fraudulent accounting transactions is vouching/tracing between the applicable accounting ledger, journal, or activity (edit or audit trail) log and the source document.
If you want to determine whether a transaction is valid, you use a process called vouching. Vouching follows an item found in the accounting ledger, journal, or activity (edit or audit trail) log back to the source document. Tracing is the reverse process, following a source document back to the originating document (ledger, journal, or activity log). In fraud examination, you will use both vouching and tracing.
In Anderson Internal Medicine (Case 2), you traced checks listed in the cash disbursements journal to the canceled checks and bank statements and found that the payee names on several checks did not match the payee names in the cash disbursements journal. You also traced debit card transactions listed on the bank statements back to the cash disbursements journal and found that those transactions were not listed in the accounting records.
Similarly, you can trace numbers and dates on deposit tickets and bank statements to the edit log, which tracks changes to cash deposits. You could also trace to the cash receipts journal; however, that would only show the post‐edit numbers—it would miss those deposits that were allegedly stolen. Also, you can trace transactions listed on the edit log (not the cash receipts journal) to the deposit tickets and bank statements. Pay close attention to deposit dates. Good internal controls require deposits to be made daily (as in the same day received) and intact (without withholding any of the deposit). If a company receives cash and checks, both should be deposited on the dates received.
TONYA LARSEN EDITS TO DEPOSITS— JANUARY TO MARCH 2016 | V or √ = vouched edit total to deposit ticket | ||||
TRANSACTION DESCRIPTION FROM MEDATRIX ULTRASCAN | ORIG. | EDIT | V | DIFF. | MONTHLY TOTALS |
January | |||||
February | |||||
MONTHLY TOTALS | |||||
March | |||||
Totals |