Scribd
Upload
49 views9 pages

Quiz 1 - Audit of Cash Solution

This document contains 5 problems involving bank reconciliation. Problem 1 provides adjusting entries to reconcile beginning balances between a company's books and its bank statement. Problem 2 reconciles balances as of January 31. Problem 3 reconciles cash balances and identifies a $24,000 cash shortage as of October 31. Problem 4 provides adjusting entries to reconcile cash balances between the company's books and its bank as of December 31. Problem 5 lists various cash and cash equivalent accounts as of December 31.

Uploaded by

millescaasi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
49 views9 pages

Quiz 1 - Audit of Cash Solution

This document contains 5 problems involving bank reconciliation. Problem 1 provides adjusting entries to reconcile beginning balances between a company's books and its bank statement. Problem 2 reconciles balances as of January 31. Problem 3 reconciles cash balances and identifies a $24,000 cash shortage as of October 31. Problem 4 provides adjusting entries to reconcile cash balances between the company's books and its bank as of December 31. Problem 5 lists various cash and cash equivalent accounts as of December 31.

Uploaded by

millescaasi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 9

SET A

Problem 1.
31-Aug Receipts Disbursements
BANK TO ADJUSTED
Unadjusted Balance 4,407,000 10,503,000 8,715,500
Deposit in Transit
31-Aug 250,000 (250,000)
30-Sep 1,340,000
Outstanding Checks
31-Aug (550,000) (550,000)
30-Sep 1,160,000
Erroneous bank credit (40,000)
Erroneous debit memo - loan amortization - - (90,000)
ADJUSTED BALANCE 4,107,000 11,553,000 9,235,500

31-Aug Receipts Disbursements


BOOK TO ADJUSTED
Unadjusted Balance 4,076,600 11,202,000 9,239,600
Bank Service Charge
31-Aug (3,600) (3,600)
30-Sep 4,900
Notes collected by bank - August 34,000 (34,000)
Proceeds from disounting 376,000
Book Errors
Understatement of book receipts 9,000
Overstatement of book disbursements - - (5,400)
ADJUSTED BALANCE 4,107,000 11,553,000 9,235,500

Problem 2.
31-Jan Receipts Disbursements
BOOK TO ADJUSTED
Unadjusted Balance 637,860 306,220 367,840
Bank Credit Memo, 02/28 2,060
Erroneous Disbursement, 02/28 (980)
Stop Payment Order (780) (780)
Bank Service Charge, 01/31 (60) - (60)
ADJUSTED BALANCE 637,800 307,500 366,020

31-Jan Receipts Disbursements


BANK TO ADJUSTED
Unadjusted Balance 685,180 308,120 355,900
Deposit in Transit
31-Jan 15,260 (15,260)
28-Feb 16,140
Outstanding Checks
31-Jan (64,140) (64,140)
28-Feb 74,080
Erroneous charge - January 1,500 (1,500)
Erroneous charge - February - - 180
ADJUSTED BALANCE 637,800 307,500 366,020

Problem 3.
Cash balance per books, October 1 463,855
Cash receipts for October, per books 985,900
Cash disbused for October, per books (1,338,836)
Unadjusted cash balance per books, Oct. 31 110,919
Bank service charge for October (368)
Adjusted cash balance per books, October 31 110,551

Cash balance per bank statement, Oct. 31 61,366


Deposit in transit, Oct. 31 36,000
Outstanding checks, Oct. 31 (10,815)
Adjusted cash balance per bank, Oct. 31 86,551

Adjusted cash balance per books, Oct. 31 110,551


Adjustdd cash balance per bank, Oct. 31 86,551
CASH SHORTAGE 24,000

Problem 4.
Unadjusted cash balance per books, Nov. 30 15,580
Unadjusted book receipts - December
Collection from customers - December 33,000
Bank collection of customers' notes - November 1,600 34,600
Unadjusted book disbursements - December
Checks drawn - December 19,600
Bank service charge - November 20 (19,620)
Unadjusted Cash Balance per books, Dec. 31 30,560

30-Nov Receipts Disbursements


BOOK TO ADJUSTED
Unadjusted Balance 15,580 34,600 19,620
Bank Service Charge
30-Nov (20) (20)
31-Dec 30
Bank Credit Memo
30-Nov 1,600 (1,600)
31-Dec 1,400
Check No. 2259 (6,000-600) (5,400)
Check No. 2767 1,000
ADJUSTED BALANCE 12,760 34,400 19,630
30-Nov Receipts Disbursements
BANK TO ADJUSTED
Unadjusted Balance 18,160 33,800 24,760
Deposit in Transit
30-Nov 1,000 (1,000)
31-Dec 1,600
Outstanding Checks
30-Nov (6,400) (6,400)
31-Dec 1,540
Erroneous charge (300)
Bank Service Charge erroneously charge to other client - - 30
ADJUSTED BALANCE 12,760 34,400 19,630

Problem 5
Current account at ALII Bank 56,000.00
Treasury bills (3 mos) 25,000.00
Payroll account 259,000.00
Traveler's check 75,000.00
Money order 24,000.00
Undelivered company check 33,000.00
Petty cash fund 2,500.00
Cash and Cash Equivalent, 12/31 474,500.00
SET B

Problem 1.
30-Sep 31-Aug
BANK TO ADJUSTED
6,194,500 Unadjusted Balance 4,407,000
Deposit in Transit
31-Aug 250,000
1,340,000 30-Sep
Outstanding Checks
31-Aug (500,000)
(1,160,000) 30-Sep
(40,000) Erroneous bank credit
90,000 Erroneous debit memo - loan amortization -
6,424,500 ADJUSTED BALANCE 4,157,000

30-Sep 31-Aug
BOOK TO ADJUSTED
6,039,000 Unadjusted Balance 4,126,600
Bank Service Charge
31-Aug (3,600)
(4,900) 30-Sep
Notes collected by bank - August 34,000
376,000 Proceeds from disounting
Book Errors
9,000 Understatement of book receipts
5,400 Overstatement of book disbursements -
6,424,500 ADJUSTED BALANCE 4,157,000

Problem 2.
28-Feb 31-Jan
BOOK TO ADJUSTED
576,240 Unadjusted Balance 637,860
2,060 Bank Credit Memo, 02/28
980 Erroneous Disbursement, 02/28
Stop Payment Order
- Bank Service Charge, 01/31 (160)
579,280 ADJUSTED BALANCE 637,700

28-Feb 31-Jan
BANK TO ADJUSTED
637,400 Unadjusted Balance 685,080
Deposit in Transit
31-Jan 15,260
16,140 28-Feb
Outstanding Checks
31-Jan (64,140)
(74,080) 28-Feb
Erroneous charge - January 1,500
(180) Erroneous charge - February -
579,280 ADJUSTED BALANCE 637,700

Problem 3.
Cash balance per books, October 1 463,855
Cash receipts for October, per books 985,900
Cash disbused for October, per books (1,333,836)
Unadjusted cash balance per books, Oct. 31 115,919
Bank service charge for October (368)
Adjusted cash balance per books, October 31 115,551

Cash balance per bank statement, Oct. 31 61,366


Deposit in transit, Oct. 31 36,000
Outstanding checks, Oct. 31 (10,815)
Adjusted cash balance per bank, Oct. 31 86,551

Adjusted cash balance per books, Oct. 31 115,551


Adjustdd cash balance per bank, Oct. 31 86,551
CASH SHORTAGE 29,000

Problem 4.
Unadjusted cash balance per books, Nov. 30
Unadjusted book receipts - December
Collection from customers - December 33,000
Bank collection of customers' notes - November 1,600
Unadjusted book disbursements - December
Checks drawn - December 19,600
Bank service charge - November 20
Unadjusted Cash Balance per books, Dec. 31

31-Dec 30-Nov
BOOK TO ADJUSTED
30,560 Unadjusted Balance 15,580
Bank Service Charge
30-Nov (20)
(30) 31-Dec
Bank Credit Memo
30-Nov 1,600
1,400 31-Dec
(5,400) Check No. 2259 (6,000-600) (5,400)
1,000 Check No. 2767 1,000
27,530 ADJUSTED BALANCE 12,760
31-Dec 30-Nov
BANK TO ADJUSTED
27,200 Unadjusted Balance 18,160
Deposit in Transit
30-Nov 1,000
1,600 31-Dec
Outstanding Checks
30-Nov (6,400)
(1,540) 31-Dec
300 Erroneous charge
(30) Bank Service Charge erroneously charge to other client -
27,530 ADJUSTED BALANCE 12,760

Problem 5
Current account at ALII Bank 56,000.00
Treasury bills (3 mos) 25,000.00
Payroll account 295,000.00
Traveler's check 75,000.00
Money order 24,000.00
Undelivered company check 33,000.00
Petty cash fund 2,500.00
Cash and Cash Equivalent, 12/31 510,500.00
Receipts Disbursements 30-Sep

10,503,000 8,715,500 6,194,500

(250,000)
1,340,000 1,340,000

(500,000)
1,160,000 (1,160,000)
(40,000) (40,000)
- (90,000) 90,000
11,553,000 9,285,500 6,424,500

Receipts Disbursements 30-Sep

11,202,000 9,289,600 6,039,000

(3,600)
4,900 (4,900)
(34,000)
376,000 376,000

9,000 9,000
- (5,400) 5,400
11,553,000 9,285,500 6,424,500

Receipts Disbursements 28-Feb

306,220 367,840 576,240


2,060 2,060
(980) 980
(780) (780)
- (160) -
307,500 365,920 579,280

Receipts Disbursements 28-Feb

308,120 355,800 637,400

(15,260)
16,140 16,140

(64,140)
74,080 (74,080)
(1,500)
- 180 (180)
307,500 365,920 579,280

15,580

34,600

(19,620)
30,560

Receipts Disbursements 31-Dec

34,600 19,620 30,560

(20)
30 (30)

(1,600)
1,400 1,400
(5,400)
- - 1,000
34,400 19,630 27,530
Receipts Disbursements 31-Dec

33,800 24,760 27,200

(1,000)
1,600 1,600

(6,400)
1,540 (1,540)
(300) 300
- 30 (30)
34,400 19,630 27,530

You might also like