answer a questions

soosa
wew.xlsx

A-1 PBC 2019 Trial Balance

Apollo Shoes, Inc PBC
Preclosing Trial Balance (Audited) A-1
31-Dec-19
Account ID Account Description Debit Credit
10100 Cash on Hand $1,987.28
10200 Regular Checking Account $198,116.52
10300 Payroll Checking Account $0.00
10400 Savings Account $3,044,958.13
11000 Accounts Receivable $16,410,902.71
11500 Allowance for Doubtful Accounts $1,262,819.88
12000 Inventory - Spotlight $18,825,205.24
12300 Reserve for Inventory Obsolescence $3,012,000.00
14100 Prepaid Insurance $743,314.38
14200 Prepaid Rent $200,000.00
14300 Office Supplies $7,406.82
14400 Notes Receivable-Current
14700 Other Current Assets
15000 Land $117,000.00
15100 Buildings and Land Improvements $623,905.92
15200 Machinery, Equipment, Office Furniture $433,217.10
17000 Accum. Depreciation $164,000.00
19000 Investments $572,691.08
19900 Other Noncurrent Assets $53,840.59
20000 Accounts Payable $4,633,118.09
23100 Sales Tax Payable $0.00
23200 Wages Payable $29,470.32
23300 FICA Employee Withholding $1,318.69
23350 Medicare Withholding $583.99
23400 Federal Payroll Taxes Payable $6,033.01
23500 FUTA Tax Payable
23600 State Payroll Taxes Payable $2,815.47
23700 SUTA Tax Payable
23800 FICA Employer Withholding $1,318.69
23900 Medicare Employer Withholding $583.99
24100 Line of Credit $10,000,000.00
24200 Current Portion Long-Term Debt
24700 Other Current Liabilities
27000 Notes Payable-Noncurrent
39003 Common Stock $8,105,000.00
39004 Paid-in Capital $7,423,000.00
39005 Retained Earnings $2,219,120.65
40000 Sales $246,172,918.44
41000 Sales Returns $4,497,583.20
42000 Warranty Expense $1,100,281.48
45000 Income from Investments $0.00
46000 Interest Income $204,302.81
50010 Cost of Goods Sold $141,569,221.61
57500 Freight $4,302,951.46
60000 Advertising Expense $897,140.01
61000 Auto Expenses $208,974.39
62000 Research and Development $31,212,334.17
64000 Depreciation Expense $133,000.00
64500 Warehouse Salaries $4,633,383.82
65000 Property Tax Expense $80,495.32
66000 Legal and Professional Expense $3,605,133.96
67000 Bad Debt Expense $1,622,425.99
68000 Insurance Expense $853,942.65
70000 Maintenance Expense $61,136.04
70100 Utilities $135,642.99
70110 Phone $76,373.78
70120 Postal $128,033.21
71000 Miscellaneous Office Expense $17,023.27
72000 Payroll Tax Exp $1,550,989.06
73000 Pension/Profit-Sharing Plan Ex $3,000,000.00
74000 Rent or Lease Expense $2,603,485.87
77500 Administrative Wages Expense $16,875,305.98
78000 Interest Expense $875,000.00
78500 Income Tax Expense - Federal $2,365,000.00
78510 Income Tax Expense - State $429,000.00
80000 Loss on Legal Settlement $19,172,000.00
$283,238,404.03 $283,238,404.03

A-2 PBC 2020 Trial Balance

Apollo Shoes, Inc PBC
Preclosing Trial Balance A-2
31-Dec-20
Account ID Account Description Debit Amt Credit Amt
10100 Cash on Hand $2,275.23
10200 Regular Checking Account $557,125.92
10300 Payroll Checking Account
10400 Savings Account $3,645,599.15
11000 Accounts Receivable $51,515,259.98
11400 Other Receivables $1,250,000.00
11500 Allowance for Doubtful Accounts $1,239,009.75
12000 Inventory $67,724,527.50
12300 Reserve for Inventory Obsolescence $846,000.00
14100 Prepaid Insurance $3,424,213.78
14200 Prepaid Rent
14300 Office Supplies $8,540.00
14400 Notes Receivable-Current
14700 Other Current Assets
15000 Land $117,000.00
15100 Buildings and Land Improvements $674,313.92
15200 Machinery, Equipment, Office Furniture $2,929,097.13
17000 Accum. Depreciation $610,000.00
19000 Investments $1,998,780.39
19900 Other Noncurrent Assets $53,840.59
20000 Accounts Payable $1,922,095.91
23100 Sales Tax Payable
23200 Wages Payable
23300 FICA Employee Withholding $8,439.65
23350 Medicare Withholding $11,414.99
23400 Federal Payroll Taxes Payable $118,086.12
23500 FUTA Tax Payable
23600 State Payroll Taxes Payable $55,106.86
23700 SUTA Tax Payable
23800 FICA Employer Withholding $8,439.65
23900 Medicare Employer Withholding $11,414.99
24100 Line of Credit $44,403,000.00
24200 Current Portion Long-Term Debt
24700 Other Current Liabilities
27000 Notes Payable-Noncurrent $12,000,000.00
39003 Common Stock $8,105,000.00
39004 Paid-in Capital $7,423,000.00
39005 Retained Earnings $6,590,483.64
40000 Sales - Spotlight $242,713,452.88
41000 Sales Returns $11,100,220.89
42000 Warranty Expense $1,158,128.47
45000 Income from Investments $1,426,089.31
46000 Interest Income $131,881.46
47000 Miscellaneous Income $2,166,000.00
50010 Cost of Goods Sold $130,196,645.26
57500 Freight $4,240,263.09
60000 Advertising Expense $1,036,854.01
61000 Auto Expenses $210,502.80
62000 Research and Development $528,870.44
64000 Depreciation Expense $446,000.00
64500 Warehouse Salaries $4,720,715.56
65000 Property Tax Expense $99,332.45
66000 Legal and Professional Expense $4,913,224.45
67000 Bad Debt Expense
68000 Insurance Expense $36,106.92
70000 Maintenance Expense $35,502.87
70100 Utilities $137,332.18
70110 Phone $52,599.02
70120 Postal $77,803.61
71000 Miscellaneous Office Expense $24,891.82
72000 Payroll Tax Exp $1,577,811.85
73000 Pension/Profit-Sharing Plan Ex $3,630,375.80
78600 Controllers' Clearning Account $330,375.80
74000 Rent or Lease Expense $1,206,574.00
77500 Administrative Wages Expense $16,197,225.43
78000 Interest Expense $2,591,736.50
78500 Income Tax Expense - Federal $8,900,000.00
78510 Income Tax Expense - State $3,100,000.00
$330,119,291.01 $330,119,291.01

(Example) Revenue Narative

Apollo Shoes, Inc C-3
Revenue narrative and controls Documentation Prepared by: PBC, TC
31-Dec-20 Reviewed by:

Apollo Accounting and Control Systems: Revenue and Collection Cycle As evident in the company organization chart (A-3), Apollo has several departments and offices concerned with management, accounting, and control. The company also has an abbreviated accounting and control manual (C-2), although the manual has not been kept up to date. Officers and employees have described accounting and control procedures informally under the heading of several transaction cycles. Descriptions of the company's current revenue cycle activities appear below.   Credit Approval and Sales Processing Customer orders are received primarily via the company website, but also accepted in the mail, over the telephone, and over the counter by salesclerks in the marketing department. Online orders are assigned an order number (RC #1) when completed by the customer or sales associate. The sales order documents used in the office are not prenumbered but are assigned an electronic number as soon as they are entered into the system. The clerks prepare online sales orders for telephone and counter customers, printing and then signing each one and asking the counter customers to sign in person. All sales orders contain the customer name, a customer number (usually the phone number/assigned immediately for new customers), customer address, identification of products, and the quantity ordered (RC #2). Hard copies of sales order forms with signatures are kept in the salesclerks’ working area through which many people pass during the day. All sales orders are entered into the computer system daily by the salesclerks (RC #3).   The salesclerks prepare an estimate of the dollar amount of the order and write it on the form. For online orders this is done automatically. The sales orders are then sent to the credit manager, who is also in the marketing department. The credit manager manually checks new customers’ credit file information using a computer-based inquiry system. If credit is approved, the credit manager approves the sales order. Online orders for established customers are automatically checked based on thresholds set and managed by the credit manager (RC #4).   If credit is not approved, the customer is asked to pay in advance, and the sales order is held until notification of payment is received from the cashier (RC #5). The sales order is stamped or marked “paid” and sent to the billing department (RC #6). Likewise, when customers pay cash over the counter, the money is taken by the cashier, and the sales order is marked “paid” within the sales order system and sent to the billing department. For bookkeeping convenience, these “cash” sales are treated the same as credit sales, with the invoice amount being charged to an account receivable set up for the customer, and the customer’s payment being applied immediately to the same account.   After credit has been approved, or a payment received, the sales orders are sent to the billing department in the controller’s office. The billing clerks produce a sales invoice assigned an invoice number by the system. They double check the customer and product information from the customer order, the date, and the product unit prices from an approved price list (RC #7). Sales taxes, delivery charges, and the invoice total are computed and put on the invoice.    The sales invoice, the customer order, and the sales order are sent to the accounts receivable accounting department, which is also in the controller’s office. These e-documents are held in invoice numerical order in a “pending shipment” file, awaiting matching with the shipping forms (RC #8).   Shipment and Delivery Upon receipt of a sales order which serves as the authorization to move goods to the shipping area (RC #9), the inventory storekeeper supervises removal of shoe products from shelves and bins. Warehouse employees utilize tablets and cloud based inventory tracking software to fulfill orders. The tablet displays sales order, and product location (RFID scanning technology) for all customer orders. As products are picked they are scanned and entered into software which flows through to the shipping receipt which flows to the sales invoice, adjusts inventory levels, and produces shipping information (weights, destination etc.). Before the package is shipped all documentation is reviewed by an inventory manager (RC #10). If partial orders are shipped due to lack of in stock inventory the sales order with the remaining items is placed in an electronic que (master pending file) to fulfill the order when inventory becomes available. Shipping information, once complete is sent to the billing and accounts receivable department.    

(Example) Revenue Controls Test

Walkthrough Testing - Revenue C-5
Apollo Shoes, Inc Prepared by: PBC, TC Effective
Revenue controls Documentation Reviewed by: Deficient
31-Dec-20 N/A
Voucher#32263 Voucher#34229 Voucher#36112 Voucher#38488 Voucher#40009 Voucher#41775 Voucher#41899 Voucher#40814 Voucher#41617 Voucher#41317 Don't Know
RC-1 All orders are assigned an order number Effective Effective Effective Effective Effective
RC-2 Sales orders require customer name, phone number, address, product name and quantity in order to generate. Effective Effective Effective Effective Effective
RC-3 All sales order made offline reviewed and entered daily. N/A N/A N/A N/A Effective
RC-4 The credit manager reviews all new credit requests. And sets electronic thresholds. Effective Effective Effective Effective N/A
RC-5 When credit is not approved, orders are not filled unless payment is made. N/A N/A N/A N/A Effective
RC-6 Once payment is made all orders are stamped paid. Effective Effective Effective Deficient Effective
RC-7 Invoices are reviewed for correct products, prices, and customer info. Effective Effective Effective Effective Effective
RC-8 Pending shipping documents are matched with sales orders and invoices. Effective Effective Effective Effective Effective
RC-9 A sales order is required to pick/pack and ship goods Effective Effective Effective Effective Effective
RC-10 Before packages are shipped they are reviewed by an inventory manager. Effective Effective Effective Effective Effective
A

A - Voucher #38488 was not stamped paid per RC-6. However it appears that the payment was made (pmt ID -Wg%yo2). Therefore it appears that this incident was a minor oversight. No further testing necessary.

C-1 Purchase Narative

Apollo Shoes, Inc C-6
Purchasing narrative and controls Documentation Prepared by: PBC, TC
31-Dec-20 Reviewed by:

Asset or Supply Purchase Requisition For each required purchase the department manager of the requesting department will review and approve an employee's written request. Then he/she will submit a request via the intranet system to purchasing. Once reviewed by the purchasing team it is approved by the purchasing manager. Once approved the request is assigned to a purchaser who then places the order with a vendor from an approved vendor list. Receipt of Goods Once an approved purchase has been received it is opened and all contents are compared to the original purchase order and documented by an individual in the warehouse. Once the receipt of goods is complete it is sent to purchasing for matching to relevant documents and forwarding to either accounts payable or to be filed as complete. The goods are forwarded on to the requesting department. Cash Disbursements All disbursements shall be made by check, signed by the treasurer, including reimbursements of the petty cash funds. Checks shall be made payable to a named payee and not to “cash.” Blank check stock shall be kept under lock and key in the accounts payable accounting department. Under no circumstances may blank checks be signed by the treasurer. Voided checks shall be transmitted to the treasurer for inspection and later filed in numerical order with paid checks. Cash disbursement journal entries shall be dated with the date of the check. The related monthly general ledger summary entries shall carry the date of the month summarized.

C-2 Purchase Controls Test

Test of Control - Purchase
Apollo Shoes, Inc
Purchase controls Documentation
31-Dec-20
Control Activity Test of Control
PC-1
PC-2
PC-3
PC-4
PC-5

F-1 Liabilities Lead Sheet

Apollo Shoes, Inc. F-1
Liabilities Lead Schedule Prepared by
For Year Ended 12/31/2020 Reviewed by
(Audited) Unaudited
Balance Balance Adjustments Audited
Acct # Account Title 12/31/19 12/31/20 AJE# Dr Cr 12/31/20 WP
20000 Accounts Payable $4,633,118.09 $1,922,095.91 $1,922,095.91
24100 Line of Credit $10,000,000.00 $44,403,000.00 $44,403,000.00
24200 Current Portion Long-Term Debt $0.00 $0.00 $0.00
24700 Other Current Liabilities $0.00 $0.00 $0.00
27000 Notes Payable-Noncurrent $0.00 $12,000,000.00 $12,000,000.00
$14,633,118.09 $58,325,095.91 $58,325,095.91

Tickmark Legend F - Footed without exception M - Amount is considered immaterial (<$126,373), no further work necessary. TB - Agrees to Trial Balance without exception PY - Agrees to prior year audited financial statements without exception

F-2 Debt Confirmations

F-2.1
F-2.2

The following documents were received from Confirmation.com, a bank confirmation clearinghouse. Received on 01/22, additionally received confirmations for cash, documented in the audit for cash.

F-3 AP Aged Schedule

Apollo Shoes, Inc. F-3
AP Aging Schedule PBC
For Year Ended 12/31/2020
Current Past Due
Vendor Outstanding Amt <30 Days 30-60 Days 60-90 Days >90 Days
Anglonesian Institute for Reprograming & Rehabilitation - 0 - 0 - 0 - 0 - 0
B. Franklin's LP&E - 0 - 0 - 0 - 0 - 0
Fleur de Lis Catering 6,868.12 6,868.12 - 0 - 0 - 0
Just Boxes - 0 - 0 - 0 - 0 - 0
Lawyers "R" Us, LLC 1,902,224.45 687,269.26 634,074.82 580,880.37 - 0
Office Hacks Supplies 1,117.19 1,117.19 - 0 - 0 - 0
Sign Up! 4,994.99 - 0 4,994.99 - 0 - 0
Smart Chip - 0 - 0 - 0 - 0 - 0
Squint Telephone and Cellular 6,891.16 6,891.16 - 0 - 0 - 0
Synergizer Battery Company - 0 - 0 - 0 - 0 - 0
Tiger Jaguar Dealership - 0 - 0 - 0 - 0 - 0
Zrocks - 0 - 0 - 0 - 0 - 0
$1,922,095.91 702,145.73 639,069.81 580,880.37 - 0

Tickmark Legend F - Footed without exception M - Amount is considered immaterial (<$126,373), no further work necessary. TB - Agrees to Trial Balance without exception. Per the Legal confirmation at J-1 incurred legal fees as of 12/31 included 3,600,000 which had been incurred but not yet billed to Apollo.

F-4 Cash Disbursements Journal

Apollo Shoes, Inc. F-4
Cash Disbursements Journal (Jan 2021) PBC
For Year Ended 12/31/2020
Check Number Date of Check Payee Amount Invoice Date Notes - Per TC
3622 1/10/21 Smart Chip $6,683.93 12/26/20 Annual computer maintenance contract—2021.
3623 1/10/21 Tiger Jaguar Dealership $2,937.13 1/8/21 Automobile maintenance on 1/9/2021.
3624 1/10/21 Fleur de Lis Catering $6,868.12 12/30/20 Catered Holiday party.
3625 1/10/21 Office Hacks $124.81 1/9/21 Office supplies purchased 1/10/2021.
3626 1/10/21 B. Franklin's LP&E $15,216.88 1/5/21 "For December electricity".
3627 1/10/21 Squint Cellular $6,891.16 1/4/21 December telephone bill.
3628 1/10/21 Sam Shaw $6,025.43 NA Car washes for fleet of 5 automobiles on 1/13/2021
3629 1/10/21 Just Boxes $927.09 1/6/21 Packaging material ordered 1/7/2021
3630 1/10/21 Synergizer Battery Company $8,419.69 1/2/21 The goods were received on 1/6/2021 with bill of lading showing a 12/30/2020 shipping date and marked FOB, Shipping - Chicago.
3631 1/10/21 Anglonesia R&R Institute $8,434,889.09 12/26/20 The receiving report was dated, Wednesday, 12/31/2020. The AP clerk indicated that the office party was held the afternoon of the 31st and the receiving report was probably not forwarded until the next working day so was not included in year-end accounts payable. This was counted and included in the inventory count.
3632 1/10/21 Office Hacks $1,117.19 12/30/20 Business cards, picked up 12/30/2020
3633 1/10/21 Smart Chip $6,924.96 1/9/21 Computer purchased 1/10/2021.
3634 1/10/21 Sign Up! $4,994.99 12/30/20 New logos on vehicles on 12/31/2020.
3635 1/10/21 Zrocks $5,174.00 1/9/21 Copy machine purchased 1/10/2021.
3636 1/10/21 Smart Chip $585.28 1/9/21 Computer supplies picked up 1/10/2021.

Tickmark Legend F - Footed without exception M - Amount is considered immaterial (<$126,373), no further work necessary. TB - Agrees to Trial Balance without exception

D-4 Cut-off Bank Statement

D-4
Account
604-17-526-5
Page
1 of 2
Apollo Shoes, Inc.
100 Shoe Plaza
Shoetown, ME 00001
*** Your Checking Account 1-1-2021 THRU 1-15-2021 ***
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/21 440,782.45 1/13/21 23,146,954.54
1/5/21 6,009,285.91
Checks and Other Withdrawals
Check Date Amount Transfers to Other Accounts
3586 1/3/21 8,533.12
3587 1/3/21 4,741.30 Date Amount Account
3582 1/3/21 330,375.80 1/7/21 6,300,000.00 604-03-739-8
3591 1/4/21 7,566.07 1/13/21 22,500,000.00 604-03-739-8
3598 1/4/21 16,472.00 1/14/21 565,369.20 604-29-016-3
3597 1/5/21 15,746.44
3599 1/5/21 12,610.96 Transfers from Other Accounts
3602 1/5/21 6,394.61
3615 1/5/21 12,904.00 Date Amount Account
3612 1/5/21 4,194.79 1/10/21 3,500,000.00 604-03-739-8
3593 1/6/21 18,421.90 1/14/21 8,000,000.00 604-03-739-8
3610 1/6/21 5,929.87
3617 1/6/21 1,073.73
3619 1/6/21 7,841.27
3585 1/6/21 7,960.15
3589 1/6/21 6,707.05
3590 1/7/21 10,587.77
3603 1/7/21 14,766.54
3604 1/7/21 15,816.16
3606 1/7/21 2,794.07
3583 1/10/21 9,606.37
3584 1/10/21 823.27
3588 1/10/21 14,122.85
3592 1/10/21 5,684.08
3594 1/10/21 12,741.49
3595 1/10/21 988.55
3601 1/10/21 5,717.19
3605 1/10/21 4,807.21
3607 1/10/21 2,667,006.32
3608 1/10/21 9,515.15
3609 1/10/21 1,501.40
3613 1/10/21 17,205.98
3621 1/10/21 11,137.19
3596 1/12/21 10,014.94
3600 1/12/21 200,000.00
3611 1/12/21 1,266.85
3616 1/12/21 9,338.02
3614 1/12/21 14,366.46
3618 1/12/21 13,377.14
3620 1/12/21 2,566.30
3622 1/13/21 6,683.93
3623 1/13/21 2,937.13
3625 1/13/21 124.81
3626 1/13/21 15,216.88
3627 1/13/21 6,891.16
3628 1/13/21 6,025.43
3629 1/13/21 927.09
3633 1/13/21 6,924.96
3635 1/13/21 5,174.00
3636 1/13/21 585.28
3624 1/14/21 6,868.12
3630 1/14/21 8,419.69
3631 1/14/21 8,434,889.09
3632 1/14/21 1,117.19
3634 1/14/21 4,994.99
Total 12,031,004.11