Problem 15 - Accounting

Question

Prometheus Co. records all cash receipts on the basis of its cash register tapes. Prometheus Co. discovered during April 2006 that one of its sales clerks had stolen an undetermined amount of cash receipts when she took the daily deposits to the bank. The following data have been gathered for April: \(\begin{array}{lr}\text { Cash in bank according to the general ledger } & \$ 12,573.22 \\ \text { Cash according to the April } 30,2006 \text { bank statement } & 13,271.14 \\ \text { Outstanding checks as of April } 30,2006 & 1,750.20 \\ \text { Bank service charge for April } & 45.10 \\ \text { Note receivable, including interest collected by bank in April } & 5,200.00\end{array}\) No deposits were in transit on April 30, which fell on a Sunday. a. Determine the amount of cash receipts stolen by the sales clerk. b. What accounting controls would have prevented or detected this theft?

Step-by-Step Solution

Answer

The stolen amount is $4,147.72. Implement stricter controls, such as independent cash verifications, to prevent future thefts.

Step 1: Understanding the Problem

We need to determine the amount of cash receipts that were stolen by reconciling the cash balance as per the company's general ledger with the bank statement adjusted for known differences like bank charges, outstanding checks, and deposits made by the bank on behalf of the company.

Step 2: Start with Bank Statement Balance

The balance as per the bank statement is $13,271.14. This amount needs to be adjusted for any outstanding checks and deposits the bank has recorded on behalf of the company but that are not yet reflected in the ledger.

Step 3: Adjust for Outstanding Checks

Subtract the outstanding checks of $1,750.20 from the bank statement balance:\[13,271.14 - 1,750.20 = 11,520.94\]

Step 4: Adjust for Bank Service Charge

Subtract the bank service charge of $45.10 from the ledger's cash balance. This adjustment would not typically affect the reconciliation of the cash balance, as we are trying to find the theft amount from deposits, not expenses.

Step 5: Adjust for Note Receivable Collected by Bank

Add the note receivable collected by the bank of $5,200.00 to the adjusted balance:\[11,520.94 + 5,200.00 = 16,720.94\]

Step 6: Reconcile with Company's Ledger Balance

The adjusted bank balance should match the company's ledger if there were no theft. Compare this calculated balance with the ledger balance recorded by the company: Company's ledger: $12,573.22 Adjusted bank balance: $16,720.94

Step 7: Calculate the Stolen Amount

Subtract the ledger balance from the adjusted bank balance to find the amount stolen:\[16,720.94 - 12,573.22 = 4,147.72\]

Step 8: Conclusion on Stolen Amount

Thus, the amount of cash receipts stolen by the sales clerk is $4,147.72.

Step 9: Accounting Controls

Implementing better controls such as independent verification of cash deposits, regularly rotating employees who handle cash, and reviewing daily cash reconciliations would help prevent or detect such thefts.

Key Concepts

Cash Reconciliation

Cash reconciliation is an essential process in accounting that ensures the cash records of a business match the bank statements. Each month, accountants check the money recorded in the company's books against what the bank says exists and what they have on file. This step is crucial because it helps to identify discrepancies like missing cash or errors in accounting entries.
Cash reconciliation involves several key tasks:

• Comparing the bank statements with the company's internal cash records.
• Adjusting for checks that have not yet been processed by the bank, known as outstanding checks.
• Recognizing and recording any bank fees or other transactions the bank performed on behalf of the business that weren't recorded in the company's books.
• Adding in any notes collected by the bank, like checks or direct deposits, which the company hasn’t yet noted in their ledgers.

The main goal is to make sure that both the bank and business records converge to a correct and consistent amount. When properly done, cash reconciliation can reveal discrepancies in cash flow, errors made during entry, or even indicate fraud.

Cash Theft Prevention

Preventing cash theft is an essential aspect of maintaining financial integrity within a company. Implementing strong controls and being vigilant can deter theft and highlight any potential weaknesses in the cash handling process.
Here are some methods to help prevent cash theft:

• Segregation of duties: Ensuring no single employee handles all aspects of a cash transaction. This includes recording, depositing, and reconciling cash.
• Mandatory daily cash reconciliations: Comparisons between expected and actual cash should be performed daily, making it harder for discrepancies to go unnoticed.
• Regular audits and reviews: Unannounced checks of cash drawers and thorough reviews of the cash handling process can help catch theft early.
• Secure cash storage: Keeping cash in a secure place, such as a safe, reduces opportunities for theft.
• Using surveillance: Cameras not only deter theft but can be essential for investigating when theft is suspected.

Fostering a culture of accountability and transparency contributes greatly to reducing the chances of cash theft. Each individual in the organization should understand the importance of such controls and adhere strictly to established guidelines.

Bank Reconciliation

Bank reconciliation is the practice of ensuring that the recorded amounts of money in a company's records align with what the bank has recorded. It's a necessary practice to catch errors, unauthorized transactions, or instances of fraud. Companies typically perform bank reconciliation on a monthly basis.
During bank reconciliation, the following steps are generally taken:

• Identify checks written by the company that the bank has yet to process. These are known as outstanding checks and need to be subtracted from the bank’s opening balance.
• Add bank-recorded items such as direct deposits, interest, and notes collected on behalf of the company, which may not yet have been entered into the company's records.
• Subtract any bank charges or overdrafts that are present on the bank statement but not yet in the books.
• Correct errors on either the bank’s side or the company's records once discrepancies are identified.

This process is important not just for its record-keeping accuracy but also for identifying any missing or incorrectly entered data that might affect a company’s financial health.

Accounting Controls

Accounting controls are systematic measures put in place by a company to safeguard assets, ensure accuracy and reliability of accounting data, and promote operational efficiency and adherence to managerial policies. These controls are vital for preventing fraud and minimizing errors.
Effective accounting controls might include:

• Access Controls: Restricting access to financial systems and records to authorized personnel only.
• Regular Review: Periodic checks and reports on financial transactions to catch any anomalies early.
• Independent Verifications: Having outside parties or auditors check financial statements and data entry accuracy.
• Automated Controls: Using software to flag unusual activities or transactions outside a set norm.
• Rotation of Staff Duties: Rotating the duties of employees who handle cash regularly to reduce the temptation or opportunity to commit fraud.

Good accounting controls integrate these measures into the everyday practices of a business. They are not just about catching wrongdoings but laying a foundation for trust in the financial system used by a company.