2020 Chapter 3 Audit of Cash Student Guide
2020 Chapter 3 Audit of Cash Student Guide
2020 Chapter 3 Audit of Cash Student Guide
APPLIED AUDITING
OVERVIEW OF DISCUSSION
During the topic discussion for Audit of Cash and its Equivalents, you are required to develop and learn a
(an):
(1) Understanding the nature of cash as a financial instrument;
(2) Understanding the criteria for recognizing “cash equivalents”;
(3) Presentation of Cash & Equivalents in the Financial Statements;
(4) Identify the Internal Controls (ICs) for safeguarding cash;
(5) Test of Controls (TOCs) for cash;
(6) Substantive audit procedures for the audit of cash balances, cash collections, and cash payments;
(7) Preparation of Bank Reconciliation Statements and Proof of Cash;
(8) Petty Cash Funds (PCF) and audit of cash shortages.
DEFINITION OF CASH
Cash includes money and other negotiable instruments that is payable in money and acceptable by the
bank for deposit and immediate credit. It includes cash on hand, demand deposits, and other items that
are unrestricted for use in the current operations.
d. Revolving fund
e. Interest fund
f. Petty cash fund
g. Dividend fund
h. Travel fund
i. Tax fund
Unrestricted Foreign Either cash on hand or deposited in banks (converted into their peso
Currencies values using the spot rate or closing rate at the BS date)
Treasury warrants A warrant for the payment of money into or from public treasury
(treated as cash)
c. Treasury bills (these are actually government-issued checks but different from the commercial
checks)
If the problem is silent, then it is cash & cash equivalent
If purchased three months before maturity, then cash equivalent
If purchased within one year before maturity, then short-term investment
VALUATION AND PRESENTATION OF CASH AND CASH EQUIVALENTS IN THE BALANCE SHEET
a. It is generally valued at face amount
b. Cash in foreign currencies are valued in Philippine Peso using the current exchange rate/ spot
rate/ closing rate as of the balance sheet date.
c. Cash in bank from financial institutions having financial difficulty or in bankruptcy should be
shown as its estimated realizable value or recoverable value. (presented as a receivable)
d. Presentation: shown as the first item among the current assets, as one line item but the detail of
which should be disclosed in the notes to financial statements.
Audit notes:
(a) Urban bank was closed two years ago. The company expects to recover only P0.60 for every peso
deposited.
(b) This amount includes unreplenished vouchers totaling P7,000 as of December 31, 2020.
(c) This is a two-year treasury note acquired on December 31, 2020.
(d) This is a 180-day treasury bill acquired on July 31, 2020.
Required:
How much should BRISBANE Company report as cash and cash equivalent on its 12/31/20 balance sheet?
(1) Prepare a bank reconciliation statement to arrive at the adjusted cash balance at December 31,
2020.
(2) Adjusting journal entries as of December 31, 2020.
PRO TIP: The Adjusted Cash Balance is also known as “True Cash Balance” or “Correct Cash Balance” in other financial
accounting terminologies while the Unadjusted Cash Balance is also known as “Cash Balance Per Record” or “Cash Balance Per
Books”.
7648 12,000
7654 8,800
CHECK REGISTER
December 31, 2018
BANCO DE ORO
Period: November 30, 2018 – December 31, 2018
DATE DESCRIPTION CHECK DEBIT CREDIT BALANCE
NO.
Balance forwarded 371,500
Dec 1 Cash deposit 20,600 392,100
Dec 1 Check issued 7648 12,000 380,100
Dec 4 Check issued 7662 19,000 361,100
Dec 4 Check issued 7661 3,225 357,875
Dec 5 Check deposit 62,000 419,875
Dec 6 Check issued 7663 2,400 417,475
Dec 8 Check deposit 23,000 440,475
Dec 10 Check issued 7664 1,875 438,600
Dec 15 Encashment 7666 73,000 365,600
Dec 22 Encashment 7670 7,000 358,600
Dec 28 Encashment 7671 84,000 274,600
Dec 29 Debit Memo – BSC 1,000 273,600
Dec 29 Credit Memo – IE 1,550 275,150
Required:
(1) What is the cash balance per record as of December 31, 2018?
(2) Compute the amount of outstanding checks as of December 31, 2018.
(3) What is the correct cash balance as of December 31, 2018?
Number Amount
1972 P 1,040
1973 720
1974 816
1975 692
Required:
(1) What is the amount of the shortage?
(2) How did the cashier attempt to conceal the shortage?
Required: For each of the following items, indicate in which the reconciling items would appear:
(a) Deposit in transit of P5,000 at December 31
(b) November bank charges of P75
(c) P18,000 checks written in November have not cleared the bank by November 30
(d) Proceeds of bank loan of P80,000 was credited by the bank to the company’s account in December
and recorded by the Company in January of the following year
(e) Check drawn in December in payment of accounts payable amounting to P15,000 was recorded
by the bookkeeper as P1,500
(f) Checks outstanding at December 31 amounted to P16,700
(g) Customer’s NSF check of P17,000 was returned by the bank in December and recorded by the
company in January
(h) The bank in error, credited the company’s account for P4,500 in December for deposit of another
company
(i) Erroneous bank credit of P14,000 in November was corrected by the bank in December
(j) Erroneous bank credit of P17,000 in December was corrected by the bank in December
Tapes for bank and company cash data offer the following totals:
Required:
(1) Prepare a reconciliation of receipts, disbursements, and bank balances for December
(2) Give whatever entries may be required on the company’s books
Outstanding checks:
Nov 30 8,007
Dec 31 ?
Deposit in transit:
Nov 30 ?
Dec 31 13,356
Customer’s note collected by bank:
Nov 30 1,500
Dec 31 4,277
NSF checks:
Nov 30 526
Dec 31 700
Bank service charges:
Nov 30 60
Dec 31 65
Erroneous bank debits:
Nov 30 600
Dec 31 900
Erroneous bank credits:
Nov 30 1,000
Dec 31 3,000
Balances:
Book December 31, 2019 166,236
Bank November 30, 2019 130,640
December transactions:
Receipts:
Book 151,230
Bank 149,451
Disbursements:
Book 111,513
Bank 110,098
Required:
(1) Outstanding checks as of December 31
(2) Deposits in transit as of November 30
(3) Adjusted cash balance as of November 30
(4) Adjusted cash balance as of December 31
charges 40
Adj. book balance P 32,100
Upon inquiry about the client’s June 30 bank reconciliation you were informed that it has been lost and
that the client is too busy at this time to prepare another. Your supervisor tells you to get the June bank
statement and paid checks and to prepare the June 30 reconciliation so that you may complete the June
proof of cash. The June bank statement is reproduced below:
June 29 50 E 50 EC
June 30 10 SC
EC – Error corrected NSF – Customer’s check returned by the bank for due to
insufficiency of funds
E – Error
SC – Service charges
Cash received for the period June 21 through June 30 of P3,500 was deposited in the bank on July 1. The
paid checks accompanying this bank statement (all clearing in June) were:
The check register revealed that the last check issued in June was No.159 for P250 and that Check No. 156
was for P130.
Required:
(1) Unadjusted book disbursements in June 30, 2019
(2) Unadjusted book receipts in June 30, 2019
(3) Unadjusted book balance as of June 30, 2019
Currency P 972
Unreplenished vouchers:
Supplies 388
Transportation 240
Repairs 170
Stamps 400
Check drawn by Beaulieu payable to Bicester [Bister], cash custodian 1,100
The petty cash fund general ledger account has an imprest balance of P4,000.
Required:
(1) Compute the amount of cash shortage, if any
(2) Adjusting journal entries on June 30, 2019
Accountability:
Petty cash fund 1,000
Required: Compute for the amount of cash overage (shortage) on the space provided below.
Bills
2 fifties, 8 twenties, 12 tens, 5 fives, 15 twos
Coins
P1.00 8 loose
(3) The following employees’ pay envelopes have been opened and the money removed. Each
envelop was marked “unclaimed”
Anthony Koon P33.25
Leo Lim 24.75
REQUIRED: Prepare a cash count sheet and compute for the amount of cash shortage on the space
provided below. (see Petty Cash Fund count sheet next page)
COMPANY:
NAME OF FUND:
CASH COUNT DATE:
DENOMINATION QUANTITY AMOUNT TOTAL
BILLS
Checks
Vouchers
IOUs
REQUIRED: Prepare a cash count sheet and compute for the amount of cash shortage or overage.
COMPANY:
NAME OF FUND:
CASH COUNT DATE:
DENOMINATION QUANTITY AMOUNT TOTAL
BILLS
COINS
FRACTIONAL DENOMINATIONS
PROBLEM 1
The internal control procedures for cash transactions in the PROCTER & GAMBLE Co. were not adequate.
Alvin, the cashier-bookkeeper handles cash receipts, made small disbursements from cash receipts,
maintained accounting records, and prepared the monthly reconciliation of the bank account. At
November 30, the bank statement showed a balance of P17,500. The outstanding checks were as follows:
The cash balance as shown on the PROCTER & GAMBLE Co. records was P20,258.31, and this included the
cash on hand. The bank statement for November showed a credit of P200 arising from the collection of a
note left with the bank. The company’s book did not include an entry to record the collection.
The cashier prepared the following reconciliation in an attempt to conceal his theft.
PROBLEM 2
Your examination of the financial statements of MERALCO Inc. for the year ended December 31, 2019.
You obtained the following information on the checking account of the company:
PROBLEM 3
You have been engaged to examine the financial statements of McVean Pacific, Inc. The company is a
distributor of automotive parts across the Asia Pacific.
You were given a copy of the unadjusted trial balance for its year ended December 31, 2019. As a senior
in charge of the audit, you were provided the following summarized information:
A. A surprise count of cash and other items conducted by your junior audit associate on January 04,
2020 disclosed the following compositions:
B. Bills and coins P 2,255
C. Check payable to PCF custodian representing his salary 2,000
IOU notes of several employees, all dated December 2019 5,600
A sheet of paper bearing the signatures of several employees, together with
their contributions (total P500) for a gift to a departing employee.
Attached to the paper currency of… 500
E. The company maintains account with North South Bank and you were given a copy of the bank
reconciliation statement which showed the following…
F. A trial balance prepared by the client as of December 31, 2019 showed a petty cash balance of
P25,000 and a cash in bank balance of P3,470,600.
PROBLEM 4
You have been asked by the proprietor of Bebelgum Company to verify the accountability of the cashier-
bookkeeper, who was allowed to take a vacation leave a few days ago.
a. The bank reconciliation statements prepared by the cashier-bookkeeper are presented below:
b. The cash in bank account in the general ledger shows the following debits and credits during
December of 2019:
c. The following summarized transactions were taken from the bank statement for the month of
December 2019:
d. Cash on hand per count in the early morning of Jan. 02, 2020 amounted to P6,300.
e. Before leaving his company for a one-week vacation, the proprietor had left several signed checks
that the cashier-bookkeeper had cashed for his personal use.
PROBLEM 5
The following information pertains to the cash in bank account of Mango Company for the month of April
2019:
a. Balances per bank statement March 31, P21,460 and April 30, P23,040.
b. Balances of cash in bank account in Company’s books: March 31, P16,645 and April 30, P22,680
c. Total receipts per books were P222,090 of which P1,210 was paid in cash to a creditor on April 16
d. Total charges in the bank statement during April were P218,870
e. Undeposited receipts as of March 31 amounted to P9,060
f. Outstanding checks as of April 30 were P1,930 of which a check for P500 was certified by the bank
g. NSF checks returned, recorded as reductions of cash receipts were:
1. Returned by bank in April recorded also in April, P1,040
2. Retuned by the bank in March recorded by the company in April, P100
3. Returned by the bank in April recorded in May, P860
h. Collections by the bank not recorded by the Company were P12,150 in March and P11,640 in April
i. Bank service charges not entered in the Company’s books were: March 31, P750 and P420 in April
j. A check for P950 of Manga Company was charged by the bank in error to Mango Company’s
account in April
k. A check drawn in April for P840 was erroneously entered in the books as P480
The bank statement for the month of July 2019 showed the following:
All reconciling items on June 30, 2019 cleared through the bank in July. The outstanding checks totaled
P600,000 and the deposits in transit amounted to P1,000,000 on July 31, 2019.
11/30/2019 12/31/2019
Balance, bank statement P 344,420 P 275,020
Balance, company records 271,260 226,010
Deposits in transit 35,000 ?
Outstanding checks 88,240 ?
12/1-31/2019 01/1-12/2020
Receipts, cash records P 963,230 P 292,500
Credits, bank statement 941,010 321,490
Disbursements, cash records 1,008,480 177,570
Charges, bank statement 1,010,410 230,180
b) A note of P20,000, sent to the bank for collection on November 15, 2019, was collected and
credited to the account on November 28, 2019, net of collection fee of P80. The note was
recorded in the cash receipts on December 21, 2019, at which date the collection fee was
entered as a disbursement.
c) The client records the returned checks in red in the cash receipts journal.
The checks listed in the table were returned by the bank:
d) Two payroll checks for employee’s vacations totaling P5,500 were drawn on January 3, 2020,
and cleared by the bank on January 8, 2020. These checks were not entered in the client’s
records because semi-monthly payroll summaries are entered only on the 15th and the last day
of each month.
REQUIRED:
1. Compute for the following:
i Deposits in transit as of December 31, 2019
ii Outstanding checks as of December 31, 2019
iii Deposits in transit as of January 12, 2020
iv Outstanding checks as of January 12, 2020
2. Prepare a Proof of Cash (POC) for the month of December 2019 and for the period January 1 to
12, 2020 using the adjusted balance method.
Bills Coins
P100 10 pieces P1.00 410 pieces
50 80 pieces 0.50 324 pieces
20 70 pieces 0.25 64 pieces
10 54 pieces
Checks
DATE PAYEE DRAWER AMOUNT
Dec. 30 Cash Ms. Jessie P 2,400
Dec. 30 Rupee Company Robert 28,000
Dec. 31 Rupee Company Jay Ar, sales manager 3,360
Dec. 31 Rupee Company Francis 35,600
Dec. 31 Rupee Company Ryan 16,600
Dec. 31 German Corp. Rupee Company 54,000
Expense Vouchers
DATE PAYEE DESCRIPTION AMOUNT
Dec. 23 Jay Ar, sales manager Cash advance for trip P 14,000
to Baguio City
Dec. 27 Central Post Office Postage Stamps 3,240
Dec. 29 Messengers Transportation 300
Dec. 29 PC Express Computer repairs 1,600
Additional information:
(a) The custodian is not authorized to cash checks.
(b) The last official receipt included in the deposit on December 30 is No. 351 and the last official
receipt issued for the current year is No. 355. The following official receipts are all dated
December 31, 2019.
O.R. Number Amount Form of payment
352 P27,200 Cash
353 35,600 Check
354 7,200 Cash
REQUIRED:
(1) Determine the shortage or overage, if any
(2) Adjusting entries as of December 31, 2019