Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am having trouble preforming a cash audit described below. If you would please view the pictures below and provide a solution I will be

I am having trouble preforming a cash audit described below. If you would please view the pictures below and provide a solution I will be sure to leave positive feedback! Thank you!
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
We received the bank confirmation and bank cutoff statement this morning from Apollos primary bank. I left both documents in your mailbox at the office. I would prefer that you audit cash rather than Timothy (let him stick to vouching documents to keep him out of trouble). A couple of points:
1. Dont forget to trace from the cutoff bank statement to the outstanding check list to make sure that the listing is complete and accurate.
2. There was an adjustment made at the end of the year to other income that looks odd. If I remember correctly, there was a transaction in investments for the same amount. You may want to take a closer look.
3. The last check written in December was check number 3621. They use duplicate checks so I was able to look at the carbons when I was out at Apollo on Saturday.
Talk to you soon.
DW
STANDARD FORM TO CONFIRM ACCOUNT
BALANCE INFORMATION WITH FINANCIAL INSTITUTIONS
Apollo Shoes, Inc
CUSTOMER NAME
FINANCIAL INSTITUTION'S NAME AND ADDRESS
Twenty First National Bank
Post Office Box 1
Shoetown, ME 00002
We have provided to our accountants the following information as of the close of business on 12/31/2017, regarding our deposit and loan balances. Please confirm the accuracy of the information, noting any exceptions to the information provided. If the balances have been left blank, please complete this form by furnishing the balance in the appropriate space below.* Although we do not request nor expect you to conduct a comprehensive, detailed search of your records, if during the process of completing this confirmation additional information about other deposit and loan accounts we may have with you comes to your attention, please include such information below. Please use the enclosed envelope to return the form directly to our accountants.
1. At the close of business on the date listed above, our records indicated the following deposit balance(s):
ACCOUNT NAME
ACCOUNT NO.
INTEREST RATE
BALANCE*
General Cash Account
Payroll Account
Savings Account
604-17-526-5
604-29-016-3
604-03-739-8
n/a
n/a
3.2%
3,309,192.03
0
3,645,599.15
2. We were directly liable to the financial institution for loans at the close of business on the date listed above as follows:
ACCOUNT NO./
DESCRIPTION
BALANCE*
DATE DUE
INTEREST
RATE
DATE THROUGH WHICH INTEREST IS PAID
DESCRIPTION OF COLLATERAL
Note#106316
Line of Credit,
Acct#7500438
12,000,000
44,403,000
1/1/2018
20158(revolving)
8.15%
9.16%
11/30/2017
11/30/2017
Inventory
Inventory
E.P Unum 1/9/2018
(Customer's Authorized Signature(Date)
The information presented above by the customer is in agreement with our records. Although we have not conducted a comprehensive, detailed search of our records, no other deposit or loan accounts have come to our attention except as noted below.
I.M. Rich 1/13/2018
(Financial Institution Authorized Signature)(Date)
EXCEPTIONS AND OR COMMENTS
No exceptions noted.
Please return this form directly to our accountants:
Andersen, Olds, and Watershed, LLP
32nd Financial Avenue
Shoetown, ME 00002
* Ordinarily, balances are intentionally left blank if they are not available at the time this form is prepared.
Approved 1990 by American Bankers Association, American Institute of Certified Public Accounts, and Bank Administration Institute. Additional forms available from: AICPA - Order Department, P.O. Box 1003 NY, NY 10108-1003
Apollo Shoes, Inc.
100 Shoe Plaza
Shoetown, ME 00001
*** Your Checking Account 1-1-2018 THRU 1-15-2018 ***
Your Previous Balance
3,309,192.03
Additions
3 Deposits
29,597,022.90
2 Transfers from other accounts
11,500,000.00
Deductions
55 Checks
12,031,004.11
3 Transfers to other accounts
29,365,369.20
Your Current Balance
3,009,841.62
CYC
MC
FREQ
1
1
M0000
Deposits and Other Additions
Date
Amount
Date
Amount
1/3/18
440,782.45
1/13/18
23,146,954.54
1/5/18
6,009,285.91
Checks and Other Withdrawals
Check
Date
Amount
Check
Date
Amount
3586
1/3/18
8,533.12
3590
1/7/18
10,587.77
3587
1/3/18
4,741.30
3603
1/7/18
14,766.54
3582
1/3/18
330,375.80
3604
1/7/18
15,816.16
3591
1/4/18
7,566.07
3606
1/7/18
2,794.07
3598
1/4/18
16,472.00
3583
1/10/18
9,606.37
3597
1/5/18
15,746.44
3584
1/10/18
823.27
3599
1/5/18
12,610.96
3588
1/10/18
14,122.85
3602
1/5/18
6,394.61
3592
1/10/18
5,684.08
3615
1/5/18
12,904.00
3594
1/10/18
12,741.49
3612
1/5/18
4,194.79
3595
1/10/18
988.55
3593
1/6/18
18,421.90
3601
1/10/18
5,717.19
3610
1/6/18
5,929.87
3605
1/10/18
4,807.21
3617
1/6/18
1,073.73
3607
1/10/18
2,667,006.32
3619
1/6/18
7,841.27
3608
1/10/18
9,515.15
3585
1/6/18
7,960.15
3609
1/10/18
1,501.40
3589
1/6/18
6,707.05
3613
1/10/18
17,205.98
467,473.06
2,793,684.40
Account
604-17-526-5
Page 2 of 2
Checks and Other Withdrawals
CheckDateAmountCheckDateAmount
36211/10/201811,137.1936271/13/20186,891.16
35961/12/201810,014.9436281/13/20186,025.43
36001/12/2018200,000.0036291/13/2018927.09
36111/12/20181,266.8536331/13/20186,924.96
36161/12/20189,338.0236351/13/20185,174.00
36141/12/201814,366.4636361/13/2018585.28
36181/12/201813,377.1436241/14/20186,868.12
36201/12/20182,566.3036301/14/20188,419.69
36221/13/20186,683.9336311/14/20188,434,889.09
36231/13/20182,937.1336321/14/20181,117.19
36251/13/2018124.8136341/14/20184,994.99
36261/13/201815,216.88
Transfers to Other Accounts
DateAmountAccount
1/7/20186,300,000.00604-03-739-8
1/13/201822,500,000.00604-03-739-8
1/14/2018565,369.20604-29-016-3
Transfers from Other Accounts
DateAmountAccount
1/10/20183,500,000.00604-03-739-8
1/14/20188,000,000.00604-03-739-8
Date: 10 JAN 2018 13:02:47 +0000
From: "Karina Ramirez"
Subject: PBC Schedules
Weve completed the schedules that we agreed to prepare in our audit planning meeting. Ive left them on your worktable in the conference room.
According to your instructions, weve marked them PBC for Prepared by Client. Ive attached copies to this e-mail as well as posted them to your firms intranet site as you directed. Let us know if you have any questions.
Ive also left some other documents that you requested last Friday, specifically copies of two bank deposit slips from early January that you requested for your accounts receivable work.
Karina
Karina Ramirez
Director, Internal Audit
Apollo Shoes, Inc.
B-1
Apollo Shoes, Inc.
Cash Lead Schedule
Prepared by
For Year Ended 12/31/2017
Reviewed by
PBC
(Audited)
Unaudited
Balance
Balance
Acct #
Account Title
12/31/16
12/31/17
10100
Cash on Hand
$1,987.28
$2,275.23
10200
Regular Checking
$198,116.52
$557,125.92
10300
Payroll Checking
$0.00
$0.00
10400
Savings
$3,044,958.13
$3,645,599.15
$3,245,061.93
$4,205,000.30
Apollo Shoes
Bank Reconciliation
12/31/17
General Account
Unadjusted book balance
226,750.12
Bank Adjustments
0
Amount to Balance
330,375.80
* Adjustment to balance posted to Cash and Controller's Clearing Account
Adjusted book balance
557,125.92
Balance per bank statement
3,309,192.03
Add Deposits in transit
440,782.45
Deduct O/S Checks
-3,192,848.56
Adjustment to Balance
Adjusted bank balance
557,125.92
Payroll Account
Unadjusted book balance
0
Bank adjustments
0
Adjusted book balance
0
Balance per bank statement
0
Add Deposits in transit
598,341.59
Deduct O/S Checks
-598,341.59
Adjusted bank balance
0
Apollo Shoes, Inc
Outstanding Checks
31-Dec-17
PBC
Check #
Date
Amount
Check #
Date
Amount
3583
12/31/17
9,606.37
3606
12/31/17
2,794.07
3584
12/31/17
823.27
3607
12/31/17
2,667,006.32
3585
12/31/17
7,960.15
3608
12/31/17
9,515.15
3586
12/31/17
8,533.12
3609
12/31/17
1,501.40
3587
12/31/17
4,741.30
3610
12/31/17
5,929.87
3588
12/31/17
14,122.85
3611
12/31/17
1,266.85
3589
12/31/17
6,707.05
3612
12/31/17
4,194.79
3590
12/31/17
10,587.77
3613
12/31/17
17,205.98
3591
12/31/17
7,566.07
3614
12/31/17
14,366.46
3592
12/31/17
5,684.08
3615
12/31/17
12,904.00
3593
12/31/17
18,421.90
3616
12/31/17
9,338.02
3594
12/31/17
12,741.49
3617
12/31/17
1,073.73
3595
12/31/17
988.55
3618
12/31/17
13,377.14
3596
12/31/17
10,014.94
3619
12/31/17
7,841.27
3597
12/31/17
15,746.44
3620
12/31/17
2,566.30
3598
12/31/17
16,472.00
3621
12/31/17
11,137.19
3599
12/31/17
12,610.96
3600
12/31/17
200,000.00
TOTAL
$3,192,848.56
3601
12/31/17
5,717.19
3602
12/31/17
6,394.61
3603
12/31/17
14,766.54
3604
12/31/17
15,816.16
3605
12/31/17
4,807.21
Apollo Shoes, Inc
Bank Deposit Slip
Twenty First National Bank, Account #604-17-526-5
5-Jan-18
Customer Name
Check Number
Check Amount
Pay More Shoes
16625
$526,004.85
Nuke Me
16949
$35,028.59
Shoe Shack
17309
$730,588.25
Trenchfoot
18544
$85,534.25
Imelda's Closet
11618
$96,452.11
Eight East
18369
$45,258.22
Feet Lamour
15299
$385,241.02
Neutralizer
18608
$3,053,144.23
Bad Boy Shoes
12818
$400,253.31
Wild Hair Shoes
12085
$252,769.26
Big Bob's Shoe Store
14819
$399,011.82
Total Deposit
$6,009,285.91
Apollo Shoes, Inc
Bank Deposit Slip
Twenty First National Bank, Account #604-17-526-5
13-Jan-18
Customer Name
Check Number
Check Amount
Run For Your Life Shoes
13289
$2,165,500.55
Hip Hop Shoes
14675
$695,542.21
International Soccer Federation
10531
$1,222,359.56
Walk About
13695
$932,653.33
Doug's Shoes
17097
$2,648.75
Custom Shoes
14659
$5,996.13
Blue Bird Shoes
11500
$11,844.63
Pump It Up Shoes
11186
$3,375.54
Hop Scotch Shoes
15820
$895,606.23
Sassy Shoes
19785
$5,765,081.85
Evil Spirit Shoes
15759
$86,450.60
Action Foot Shoes
10716
$793,544.22
Paul Bunion Footware
19851
$10,458,847.58
Shack's Shoe Shine
523
$3,000.00
Lock-Up Shoe Store
16514
$104,503.36
Total Deposit
$23,146,954.54
Date: 19 JAN 2018 15:37:42 +0000 From: "Darlene Wardlaw" Subject: Audit of Cash We received the bank confirmation and bank cutoff statement this morning from Apollo's primary bank. I left both documents in your mailbox at the office. I would prefer that you audit cash rather than Timothy (let him stick to vouching documents to keep him out of trouble). A couple of points: 1. Don't forget to trace from the cutoff bank statement to the outstanding check list to make sure that the listing is complete and accurate. 2. There was an adjustment made at the end of the year to other income that looks odd. If I remember correctly, there was a transaction in investments for the same amount. You may want to take a closer look. 3. The last check written in December was check number 3621. They use duplicate checks so I was able to look at the carbons when I was out at Apollo on Saturday. Talk to you soon. DW STANDARD FORM TO CONFIRM ACCOUNT BALANCE INFORMATION WITH FINANCIAL INSTITUTIONS Apollo Shoes, Inc CUSTOMER NAME FINANCIAL INSTITUTION'S NAME AND ADDRESS so 2/3/2012 Twenty Fire National Bank Post Office Box Show, ME 1. At the close of business on the date listed above, our records indicated the following deposit balance(s): ACCOUNT NAME ACCOUNT NO INTEREST RATE BALANCE 3.309,192.03 3.645.599.15 2. We were directly liable to the financial institution for loans at the close of business on the date listed above as follows: DATE THROUGH ACCOUNT NO DESCRIPTION BALANCE DATE DUE INTEREST WHICH INTEREST DESCRIPTION OF RATE ESPAID COLLATERAL 12,000,0001/2018 1.19% 11/30/2017 Inventory 44.403,000 2015 revolving.16% 11/30/2017 E.P Unum 1/9/2018 (Customer's Authorized Signature (Date) The information presented above by the customer is in agreement with our records. Although we have not conducted a comprehensive, detailed search of our records, no other deposit or loan accounts have come to our attention except as noted below. I.M. Rich 1/13/2018 (Financial Institution Authorized Signature) (Date) EXCEPTION AND OR CORRENT No exceptions noted. deren, d. and Matershed, LLC and Financial Avenge Foton E 0002 Ordinarily balances are intentionally left blank if they are not available at the proporc. 2015 revolving..16% 11/30/2017 Inventory E.P Unum 1/9/2018 (Customer's Authorized Signature (Date) The information presented above by the customer is in agreement with our records. Although we have not conducted a comprehensive, detailed search of our records, no other deposit or loan accounts have come to our attention except as noted below. I.M. Rich 1/13/2018 (Financial Institution Authorized Signature) (Date) PERCEPTIONS AND CR CORRENTE No exceptions noted. Financial Avenue Ordinarily, balances are intentionally left blank if they are not available at the time this form is prepared. Approved 1990 by American Bankers Association, American Institute of Certified Public Accounts, and Bank Administration Institute. Additional forms available from: AICPA - Order Department, P.O. Box 1003 NY, NY 10108- 1003 Account 604-17-525-5 Page 1 of 2 Apolo Shoes, Inc 100 Show Sheetown, ME 00001 *-* Your Checking Account 1-1-2018 THRU 1-15-2018 Your Previous Balance Additions 3.09.192.00 3 Deposite 2 Transfers from other accounts 11.500.000,00 55 Checks 12.0310411 3 Transfers to other accounts 20.5.0.20 3.009.841.62 Deduction Your Cument Balance CYC MC 1 FREO MOOOO Deposits and Other Add Account 604-17-526-5 Page 1 of 2 Apollo Shoes, Inc 100 Shoe Plaza Shoelown, ME 00001 ...Your Checking Account 1-1-2018 THRU 1-15-2018 Your Previous Balance Additions 3,309,192.03 3 Deposits 29.597,022.90 2 Transfers from other accounts 11,500,000.00 55 Checks 12,031.004.11 3 Transfers to other accounts 29,366,369.20 3.009 841.62 Deductions Your Current Balance CYC FREQ M0000 Deposits and Other Additions Date Amount Date Amount 1/3/18 440.782.45 1/5/18 6,009.285.91 1/13/18 22,146.954.54 Checks and Other Withdrawals Check Date 3586 1/3/18 3587 1/3/18 3582 1/3/18 3591 1/4/18 3598 1/4/18 3597 1/5/18 3599 1/5/18 3602 1/5/18 3615 1/5/18 3612 1/5/18 3593 1/6/18 3610 1/8/18 3617 1/6/18 36191/6/18 35851/6/18 3589 1/6/18 Amount Check Dete Amount 8.533.12 3590 17/18 10.587.77 4,741.30 3503 17/18 14.766.56 330.375.80 3804 17/18 15.816.16 7.566.07 3506 17/18 2.794.07 16.472.00 3583 1/10/18 9.605 37 15.746.44 35841/10/18 823 27 12.610.96 3588 1/10/18 14.122.85 6,394 61 35921/10/18 5,684.08 12,904.00 35941/10/18 12.741.49 4.194.79 35951/10/18 988.55 18.421.90 3601 1/10/18 5.717.19 5.929.87 38051/10/18 4.807 21 1.073.73 38071/10/18 2.667.00532 7.841.27 38081/10/18 9.515.15 7,960.15 309 110/18 1.501.40 6.707.05 36131/10/18 17.205.98 467.473.06 2,793,684.40 Acc ount Filter 17-526-5 Page 2 of 2 Checks and Other Withdrawals Check Date Amount Check Date Amount 36211/10/2018 11,137.19 3627 1/13/2018 6,891 .16 3596 1/12/2018 10,014.94 3628 1/13/2018 6,025 .43 3600 1/12/2018 200,000.00 36291/13/2018 927. 09 3611 1/12/2018 1,266,85 3633 1/13/2018 6,924 96 3616 1/12/2018 9.338.02 3635 1/13/2018 5.174. 00 3614 1/12/2018 14,366.46 3636 1/13/2018 5852 8 3618 1/12/2018 13,377.14 3624 1/14/2018 6.868 .12 3620 1/12/2018 2,566.30 3630 1/14/2018 8.419. 69 3622 1/13/2018 6,683.93 3631 1/14/2018 8.434, 889.09 3623 1/13/2018 2.937.13 3632 1/14/2018 1.117 19 3625 1/13/2018 124.81 3634 1/14/2018 4,994.99 3626 1/13/2018 15,216.88 Transfers to Other Accounts Date Amount Account 1/7/2018 6,300,000.00 604-03-739-8 1/13/2018 22,500,000.00 604-03-739-8 1/14/2018 565,369.20 604-29-016-3 Transfers from Other Accounts Date Amount Account 1/10/2018 3,500,000.00 604-03-739-8 1/14/2018 8,000,000.00 604-03-739-8 1/14/2018 565,369.20 604-29-016-3 Transfers from Other Accounts Date Amount Account 1/10/2018 3,500,000.00 604-03-739-8 1/14/2018 8,000,000.00 604-03-739-8 Date: 10 JAN 2018 13:02:47 +0000 From: "Karina Ramirez" Subject: PBC Schedules We've completed the schedules that we agreed to prepare in our audit planning meeting. I've left them on your worktable in the conference room. According to your instructions, we've marked them PBC for "Prepared by Client." I've attached copies to this e-mail as well as posted them to your firm's intranet site as you directed. Let us know if you have any questions. I've also left some other documents that you requested last Friday, specifically copies of two bank deposit slips from early January that you requested for your accounts receivable work. Karina Karina Ramirez Director, Internal Audit Apollo Shoes, Inc. Apollo Shoes, Inc. Cash Lead Schedule For Year Ended 12/31/2017 Prepared by ved by PBC (Audi Balance 12/31/16 Unaudited Balance 1201/17 Acct Account Title 10100 Cash on Hand Director, Internal Audit Apollo Shoes, Inc. Apollo Shoes, Inc. Cash Lead Schedule For Year Ended 12/31/2017 PSC Audited nude Balance Acete Account Title 1299 12017 10100 Cash on Hand $1.98728 52.27523 10200 Regular Checking $18.916.52 5587.32582 10300 Payroll Checking 10400 Savings 2013 $3.50.15 $3.225.01.89 $200.00022 Apollo Shoes Bank Reconciliation 12/31/17 General Account Unadjusted book balance Bank Adjustment 226.750.12 Amount to Balance Adjustment to balance posted to 330.375. Cash and Controller's Clearing Account 557,125.92 Adjusted book balance Balance per bank statement 3.109.192.03 Add Deposits in transit 40,7824 Deduct / Checks Adjustment to Balance Adjusted bank balance 557,125.92 Payroll Account Unadjusted book balance Bank adjustments Adjusted book balance Balance per bank statement Add Deposits in transit Deduct o/8 Checks 598,341.59 -598,341.59 Adjusted bank balance Apollo Shoes, Inc Outstanding Checks 31-Dec-17 PBC Check! Dale Amount Check! Dute 3583 12/31/17 9.606.378061231/17 2.7. 3584123117 823 27 30123177 2.667,006,32 35851231/17 7.900.15 08121/17 3586 1231/17 8.533.1258091201/17 1.50140 3567 121/17 11.30 10120117 35881291/17 14.122.5 3611120117 35801231/17 6.70705 12 2011 3500 12/31/17 10.581.77 301312/31/17 17.205.58 35011231/177.50 3814 12/31/17 14.366.46 3582 12/31/17 5.664.00 38152017 12.04.00 3583 1231/17 18.421.50 3516129117 35961231/17 12.74149 2017 2017 1973.73 3586 121/17 98.5 18 2017 3.3774 3506 12/31/17 10:0549 1921 712 3507 123/17 15.766.44 2012/17 3568 123/17 16.472.00321129117 3500 1231/17 12.690.96 3800 123/17200,000.00 TOTAL 53.132.84858 30011231/17 5.717.19 302 12/31/17 6,3461 38001231/17 14.76654 36041281/17 15.816.16 3061231117430721 Bank Deposit Slip Twenty Fire Nail Bank Account - 19.6365 Customer Pay More Shoes Nuke Me S536.000 Trachfoot Imelders Closet 1856 5333433 18.252.11 Feet Bad Boy Shoes WIM Hair Shoes Big Bob's Shoe Store Total Deposit Baskes Slip Twenty Fire Naal Bank Account 0-19-5365 Customer Name Run For Your Life Shoes Hip Hop Shoes International Ser Foderation Walk About Dog's Shoes Blue Bird Shoes Pump It Up Shoes Hop Scotch Shoes 1150063 1076 35432 Evil Spirit Shoes Action Foot Shoes Poul Bunin For Shack's Shoe Shine Lack-Up Shoe Total Dent 53.197.545.56 3500 12/31/17 200,000.00 TOTAL 3601 12/31/17 5.717.19 3602 12/31/17 6,394.61 3603 12/31/17 14,766.54 3604 12/31/17 15.816.16 3605 12/31/17 4,807.21 Apollo Shoes, Inc Bank Deposit Slip Twenty First National Bank, Account 1604-17-526-5 5-Jan-18 Customer Name Check Number Check Amount Pay More Shoes 16625 S526,00485 Nuke Me 16949 $35,028 59 Shoe Shack 17309 $730.588.25 Trenchfoot 18544 585534 25 Imelda's Closet 11618 S96.45211 Eight East 18369 $45.258 22 Feet Lamour 15199 $385.241.02 Neutralizer 18608 3,053,144.23 Bad Boy Shoes 12818 S400_25331 Wild Hair Shoes 12085 5252,76926 Big Bob's Shoe Store 14819 $399.011.82 Total Deposit $6,009.285.91 Apollo Shoes, Inc Bank Deposit Slip Twenty First National Bank, Account #60-17-526-5 13-Jan-18 Customer Name Run For Your Life Shoes Hip Hop Shoes International Soccer Federation Walk About Doug's Shoes Custom Shoes Blue Bird Shoes Pump It Up Shoes Hop Scotch Shoes Sassy Shoes Evil Spirit Shoes Action Foot Shoes Paul Bunion Footware Shack's Shoe Shine Lock-Up Shoe Store Total Deposit Check Number Check Amount 13289 $2,165,500.55 14675 $695 342.21 10531 S1.222.359 36 13695 5932,653.33 17097 $2,648.75 14659 $5.996.13 11500 SI1.84163 11186 53.375 54 15820 5895.606 23 19785 55,765,081.85 15759 $86,450.60 10716 $793.544.22 19851 S10.458.84758 523 $3.000,00 16514 $104 503 36 $23.146.954.54 Apollo_Shoes_Case_7e-2.doc - Compatibility Mode - Saved to this PC- Search ert Design Layout References Mailings Review View Help Times New Rom - 28 A A Aa 21 AaBbc AaBt AaBbce Char Char Char BIU XX A A Font Paragraph Date: 19 JAN 2018 15:37:42 +0000 From: "Darlene Wardlay" Subject: PBC Schedules We've completed the schedules that we agreed to prepare in our audit planning meeting. Lys left them on your worktable in the conference room. According to your instructions, we've marked them PBC for "Prepared by Client." Thys at copies to this e-mail as well as posted them to your firn's intranet site as you directed. Let us know if you have any questions. I've also left some other documents that you requested last Friday, specifically copies of two bank deposit slips from early January that you requested for your accounts receivable work. Karina Karina Ramirez Director, Internal Audit Apollo Shoes, Inc. Copyright 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without Design Layout References Mailings Review View Help nes New Rom - 28 Aa A 211 AaBbc AaBt AaBbcc) IV X. A A Char Char Char Font Paragraph B-1 Apollo Shoes, Inc. Cash Lead Schedule For Year Ended 12/31/2017 Prepared by Reviewed by PBC (Audited) Balance 12/31/16 $1,987.28 Unaudited Balance 12/31/17 $2,275 23 Acct Account Title 10100 Cash on Hand 10200 Regular Checking $198,116.52 $557,125.92 10300 Payrol Checking $0.00 $0.00 10400 Savings $3,044,958.13 $3,645,599.15 $3,245,061.93 $4,205,000 30 Char Char Re Char Char Char 1 Caption 1 Normal Title Subtitle Se Styles 5 Edit Apollo Shoes Bank Reconciliation 12/31/17 General Account Unadjusted book balance Bank Adjustments Amount to Balance Adjusted book balance 226, 750.12 0 330, 375.80 "Adjustment to 557,125.92 bland posted to Controller's Clusing Account Balance per bank statement Add Deposits in transit Deduct 0/3 Checks Adjustment to Balance Adjusted bank balance 3,309,192.03 440,782.45 -3, 192,848.56 557,125.92 Payroll Account Unadjusted book balance Bank adjustments 0 0 O Adjusted book balance Balance per bank statement Add Deposits in transit Deduct 0/3 Checks 0 598,341.59 -598, 341.59 O Adjusted bank balance DE Focus Dashboard - Googl... Chap 6 analysis OL- Petroware (Gatewa... ADDL Aalbo Char Char ab X X LA Char Font Paragraph Apollo Shoes, Inc Outstanding Checks 31-Dec-17 PBC Check 3583 3584 3585 3586 3587 3588 3589 3590 3591 3592 3593 3594 3595 3596 3597 3598 3599 Date 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 Amount 9,606.37 823.27 7,960.15 8,533.12 4,741.30 14.122.85 6,707.05 10,587.77 7,566.07 5,684.08 18,421.90 12,741.49 988.55 10,014.94 15,746.44 16,472.00 12,610.96 200,000.00 5,717 19 6,394.61 14,766.54 15,816.16 4,807 21 Check 3606 3607 3608 3609 3610 3611 3612 3613 3614 3615 3616 3617 3618 3619 3620 3621 Date 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 12/31/17 Amount 2,794.07 2,667,006,32 9,515.15 1.501.40 5,929.87 1,266.85 4,194.79 17,205.98 14,366.46 12,904.00 9,338.02 1,073.73 13,377.14 7,841.27 2,566.30 11.137 19 3600 TOTAL $3.192.848.56 3601 3602 3603 3604 3605 Char Char Char Char Char 1 Caption 11 Normal Title Subtitle Styles Apollo Shoes, Inc Bank Deposit Slip Twenty First National Bank, Account #604-17-526-5 5-Jan-18 Customer Name Pay More Shoes Nuke Me Shoe Shack Trenchfoot Imelda's Closet Eight East Feet Lamour Neutralizer Bad Boy Shoes Wild Hair Shoes Big Bob's Shoe Store Total Deposit Check Number 16625 16949 17309 18544 11618 18369 15299 18608 12818 12085 14819 Check Amount $526,004.85 $35,028.59 $730,588.25 $85,534.25 $96,452.11 $45,258.22 $385,241.02 $3,053,144.23 $400,253.31 $252,769.26 $399.01182 $5.009.285.91 Apollo Shoes, Inc Bank Deposit Slip Twenty First National Bank, Account #604-17-526-5 13-Jan-18 Customer Name Run For Your Life Shoes Hip Hop Shoes International Soccer Federation Walk About Doug's Shoes Custom Shoes Blue Bird Shoes Pump It Up Shoes Hop Scotch Shoes Sassy Shoes Evil Spirit Shoes Action Foot Shoes Paul Bunion Footware Shack's Shoe Shine Lock-Up Shoe Store Total Deposit Check Number 13289 14675 10531 13695 17097 14659 11500 11186 15820 19785 15759 10716 19851 523 16514 Check Amount $2,165,500.55 $695,542.21 $1,222,359.56 $932,653.33 $2,648.75 $5,996.13 $11,844,63 $3,375.54 $895,606.23 $5,765,081.85 $86,450.60 $793,544.22 $10,458,847.58 $3,000.00 $104.503.36 $23. 146.954.54 D Focus Date: 19 JAN 2018 15:37:42 +0000 From: "Darlene Wardlaw" Subject: Audit of Cash We received the bank confirmation and bank cutoff statement this morning from Apollo's primary bank. I left both documents in your mailbox at the office. I would prefer that you audit cash rather than Timothy (let him stick to vouching documents to keep him out of trouble). A couple of points 1. Don't forget to trace from the cutoff bank statement to the outstanding check list to make sure that the listing is complete and accurate. 2. There was an adjustment made at the end of the year to other income that looks odd. IfI remember correctly, there was a transaction in investments for the same amount. You may want to take a closer look. 3. The last check written in December was check number 3621. They use duplicate checks so I was able to look at the carbons when I was out at Apollo on Saturday. Talk to you soon. DW Date: 19 JAN 2018 15:37:42 +0000 From: "Darlene Wardlaw" Subject: Audit of Cash We received the bank confirmation and bank cutoff statement this morning from Apollo's primary bank. I left both documents in your mailbox at the office. I would prefer that you audit cash rather than Timothy (let him stick to vouching documents to keep him out of trouble). A couple of points: 1. Don't forget to trace from the cutoff bank statement to the outstanding check list to make sure that the listing is complete and accurate. 2. There was an adjustment made at the end of the year to other income that looks odd. If I remember correctly, there was a transaction in investments for the same amount. You may want to take a closer look. 3. The last check written in December was check number 3621. They use duplicate checks so I was able to look at the carbons when I was out at Apollo on Saturday. Talk to you soon. DW STANDARD FORM TO CONFIRM ACCOUNT BALANCE INFORMATION WITH FINANCIAL INSTITUTIONS Apollo Shoes, Inc CUSTOMER NAME FINANCIAL INSTITUTION'S NAME AND ADDRESS so 2/3/2012 Twenty Fire National Bank Post Office Box Show, ME 1. At the close of business on the date listed above, our records indicated the following deposit balance(s): ACCOUNT NAME ACCOUNT NO INTEREST RATE BALANCE 3.309,192.03 3.645.599.15 2. We were directly liable to the financial institution for loans at the close of business on the date listed above as follows: DATE THROUGH ACCOUNT NO DESCRIPTION BALANCE DATE DUE INTEREST WHICH INTEREST DESCRIPTION OF RATE ESPAID COLLATERAL 12,000,0001/2018 1.19% 11/30/2017 Inventory 44.403,000 2015 revolving.16% 11/30/2017 E.P Unum 1/9/2018 (Customer's Authorized Signature (Date) The information presented above by the customer is in agreement with our records. Although we have not conducted a comprehensive, detailed search of our records, no other deposit or loan accounts have come to our attention except as noted below. I.M. Rich 1/13/2018 (Financial Institution Authorized Signature) (Date) EXCEPTION AND OR CORRENT No exceptions noted. deren, d. and Matershed, LLC and Financial Avenge Foton E 0002 Ordinarily balances are intentionally left blank if they are not available at the proporc. 2015 revolving..16% 11/30/2017 Inventory E.P Unum 1/9/2018 (Customer's Authorized Signature (Date) The information presented above by the customer is in agreement with our records. Although we have not conducted a comprehensive, detailed search of our records, no other deposit or loan accounts have come to our attention except as noted below. I.M. Rich 1/13/2018 (Financial Institution Authorized Signature) (Date) PERCEPTIONS AND CR CORRENTE No exceptions noted. Financial Avenue Ordinarily, balances are intentionally left blank if they are not available at the time this form is prepared. Approved 1990 by American Bankers Association, American Institute of Certified Public Accounts, and Bank Administration Institute. Additional forms available from: AICPA - Order Department, P.O. Box 1003 NY, NY 10108- 1003 Account 604-17-525-5 Page 1 of 2 Apolo Shoes, Inc 100 Show Sheetown, ME 00001 *-* Your Checking Account 1-1-2018 THRU 1-15-2018 Your Previous Balance Additions 3.09.192.00 3 Deposite 2 Transfers from other accounts 11.500.000,00 55 Checks 12.0310411 3 Transfers to other accounts 20.5.0.20 3.009.841.62 Deduction Your Cument Balance CYC MC 1 FREO MOOOO Deposits and Other Add Account 604-17-526-5 Page 1 of 2 Apollo Shoes, Inc 100 Shoe Plaza Shoelown, ME 00001 ...Your Checking Account 1-1-2018 THRU 1-15-2018 Your Previous Balance Additions 3,309,192.03 3 Deposits 29.597,022.90 2 Transfers from other accounts 11,500,000.00 55 Checks 12,031.004.11 3 Transfers to other accounts 29,366,369.20 3.009 841.62 Deductions Your Current Balance CYC FREQ M0000 Deposits and Other Additions Date Amount Date Amount 1/3/18 440.782.45 1/5/18 6,009.285.91 1/13/18 22,146.954.54 Checks and Other Withdrawals Check Date 3586 1/3/18 3587 1/3/18 3582 1/3/18 3591 1/4/18 3598 1/4/18 3597 1/5/18 3599 1/5/18 3602 1/5/18 3615 1/5/18 3612 1/5/18 3593 1/6/18 3610 1/8/18 3617 1/6/18 36191/6/18 35851/6/18 3589 1/6/18 Amount Check Dete Amount 8.533.12 3590 17/18 10.587.77 4,741.30 3503 17/18 14.766.56 330.375.80 3804 17/18 15.816.16 7.566.07 3506 17/18 2.794.07 16.472.00 3583 1/10/18 9.605 37 15.746.44 35841/10/18 823 27 12.610.96 3588 1/10/18 14.122.85 6,394 61 35921/10/18 5,684.08 12,904.00 35941/10/18 12.741.49 4.194.79 35951/10/18 988.55 18.421.90 3601 1/10/18 5.717.19 5.929.87 38051/10/18 4.807 21 1.073.73 38071/10/18 2.667.00532 7.841.27 38081/10/18 9.515.15 7,960.15 309 110/18 1.501.40 6.707.05 36131/10/18 17.205.98 467.473.06 2,793,684.40 Acc ount Filter 17-526-5 Page 2 of 2 Checks and Other Withdrawals Check Date Amount Check Date Amount 36211/10/2018 11,137.19 3627 1/13/2018 6,891 .16 3596 1/12/2018 10,014.94 3628 1/13/2018 6,025 .43 3600 1/12/2018 200,000.00 36291/13/2018 927. 09 3611 1/12/2018 1,266,85 3633 1/13/2018 6,924 96 3616 1/12/2018 9.338.02 3635 1/13/2018 5.174. 00 3614 1/12/2018 14,366.46 3636 1/13/2018 5852 8 3618 1/12/2018 13,377.14 3624 1/14/2018 6.868 .12 3620 1/12/2018 2,566.30 3630 1/14/2018 8.419. 69 3622 1/13/2018 6,683.93 3631 1/14/2018 8.434, 889.09 3623 1/13/2018 2.937.13 3632 1/14/2018 1.117 19 3625 1/13/2018 124.81 3634 1/14/2018 4,994.99 3626 1/13/2018 15,216.88 Transfers to Other Accounts Date Amount Account 1/7/2018 6,300,000.00 604-03-739-8 1/13/2018 22,500,000.00 604-03-739-8 1/14/2018 565,369.20 604-29-016-3 Transfers from Other Accounts Date Amount Account 1/10/2018 3,500,000.00 604-03-739-8 1/14/2018 8,000,000.00 604-03-739-8 1/14/2018 565,369.20 604-29-016-3 Transfers from Other Accounts Date Amount Account 1/10/2018 3,500,000.00 604-03-739-8 1/14/2018 8,000,000.00 604-03-739-8 Date: 10 JAN 2018 13:02:47 +0000 From: "Karina Ramirez" Subject: PBC Schedules We've completed the schedules that we agreed to prepare in our audit planning meeting. I've left them on your worktable in the conference room. According to your instructions, we've marked them PBC for "Prepared by Client." I've attached copies to this e-mail as well as posted them to your firm's intranet site as you directed. Let us know if you have any questions. I've also left some other documents that you requested last Friday, specifically copies of two bank deposit slips from early January that you requested for your accounts receivable work. Karina Karina Ramirez Director, Internal Audit Apollo Shoes, Inc. Apollo Shoes, Inc. Cash Lead Schedule For Year Ended 12/31/2017 Prepared by ved by PBC (Audi Balance 12/31/16 Unaudited Balance 1201/17 Acct Account Title 10100 Cash on Hand Director, Internal Audit Apollo Shoes, Inc. Apollo Shoes, Inc. Cash Lead Schedule For Year Ended 12/31/2017 PSC Audited nude Balance Acete Account Title 1299 12017 10100 Cash on Hand $1.98728 52.27523 10200 Regular Checking $18.916.52 5587.32582 10300 Payroll Checking 10400 Savings 2013 $3.50.15 $3.225.01.89 $200.00022 Apollo Shoes Bank Reconciliation 12/31/17 General Account Unadjusted book balance Bank Adjustment 226.750.12 Amount to Balance Adjustment to balance posted to 330.375. Cash and Controller's Clearing Account 557,125.92 Adjusted book balance Balance per bank statement 3.109.192.03 Add Deposits in transit 40,7824 Deduct / Checks Adjustment to Balance Adjusted bank balance 557,125.92 Payroll Account Unadjusted book balance Bank adjustments Adjusted book balance Balance per bank statement Add Deposits in transit Deduct o/8 Checks 598,341.59 -598,341.59 Adjusted bank balance Apollo Shoes, Inc Outstanding Checks 31-Dec-17 PBC Check! Dale Amount Check! Dute 3583 12/31/17 9.606.378061231/17 2.7. 3584123117 823 27 30123177 2.667,006,32 35851231/17 7.900.15 08121/17 3586 1231/17 8.533.1258091201/17 1.50140 3567 121/17 11.30 10120117 35881291/17 14.122.5 3611120117 35801231/17 6.70705 12 2011 3500 12/31/17 10.581.77 301312/31/17 17.205.58 35011231/177.50 3814 12/31/17 14.366.46 3582 12/31/17 5.664.00 38152017 12.04.00 3583 1231/17 18.421.50 3516129117 35961231/17 12.74149 2017 2017 1973.73 3586 121/17 98.5 18 2017 3.3774 3506 12/31/17 10:0549 1921 712 3507 123/17 15.766.44 2012/17 3568 123/17 16.472.00321129117 3500 1231/17 12.690.96 3800 123/17200,000.00 TOTAL 53.132.84858 30011231/17 5.717.19 302 12/31/17 6,3461 38001231/17 14.76654 36041281/17 15.816.16 3061231117430721 Bank Deposit Slip Twenty Fire Nail Bank Account - 19.6365 Customer Pay More Shoes Nuke Me S536.000 Trachfoot Imelders Closet 1856 5333433 18.252.11 Feet Bad Boy Shoes WIM Hair Shoes Big Bob's Shoe Store Total Deposit Baskes Slip Twenty Fire Naal Bank Account 0-19-5365 Customer Name Run For Your Life Shoes Hip Hop Shoes International Ser Foderation Walk About Dog's Shoes Blue Bird Shoes Pump It Up Shoes Hop Scotch Shoes 1150063 1076 35432 Evil Spirit Shoes Action Foot Shoes Poul Bunin For Shack's Shoe Shine Lack-Up Shoe Total Dent 53.197.545.56 3500 12/31/17 200,000.00 TOTAL 3601 12/31/17 5.717.19 3602 12/31/17 6,394.61 3603 12/31/17 14,766.54 3604 12/31/17 15.816.16 3605 12/31/17 4,807.21 Apollo Shoes, Inc Bank Deposit Slip Twenty First National Bank, Account 1604-17-526-5 5-Jan-18 Customer Name Check Number Check Amount Pay More Shoes 16625 S526,00485 Nuke Me 16949 $35,028 59 Shoe Shack 17309 $730.588.25 Trenchfoot 18544 585534 25 Imelda's Closet 11618 S96.45211 Eight East 18369 $45.258 22 Feet Lamour 15199 $385.241.02 Neutralizer 18608 3,053,144.23 Bad Boy Shoes 12818 S400_25331 Wild Hair Shoes 12085 5252,76926 Big Bob's Shoe Store 14819 $399.011.82 Total Deposit $6,009.285.91 Apollo Shoes, Inc Bank Deposit Slip Twenty First National Bank, Account #60-17-526-5 13-Jan-18 Customer Name Run For Your Life Shoes Hip Hop Shoes International Soccer Federation Walk About Doug's Shoes Custom Shoes Blue Bird Shoes Pump It Up Shoes Hop Scotch Shoes Sassy Shoes Evil Spirit Shoes Action Foot Shoes Paul Bunion Footware Shack's Shoe Shine Lock-Up Shoe Store Total Deposit Check Number Check Amount 13289 $2,165,500.55 14675 $695 342.21 10531 S1.222.359 36 13695 5932,653.33 17097 $2,648.75 14659 $5.996.13 11500 SI1.84163 11186 53.375 54 15820 5895.606 23 19785 55,765,081.85 15759 $86,450.60 10716 $793.544.22 19851 S10.458.84758 523 $3.000,00 16514 $104 503 36 $23.146.954.54 Apollo_Shoes_Case_7e-2.doc - Compatibility Mode - Saved to this PC- Search ert Design Layout References Mailings Review View Help Times New Rom - 28 A A Aa 21 AaBbc AaBt AaBbce Char Char Char BIU XX A A Font Paragraph Date: 19 JAN 2018 15:37:42 +0000 From: "Darlene Wardlay"

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting Text Problems And Cases

Authors: M Y Khan, P K Jain

6th Edition

125902668X, 978-1259026683

More Books

Students also viewed these Accounting questions