Proof of Cash Baht Company

Proof of cash
You obtained the following information on the current account of Baht Company during your
examination of its financial statements for the year ended December 31, 2015.
The bank statement on November 30, 2015 showed a balance of P76, 500. Among the bank
credits in November was customer’s note for P25,000 collected for the account of the company
which the company recognized in December among its receipts. Included in the bank debits were
cost of check books amounting to P300 and a P10,000 check which was charged by the bank in
error against Baht Co. Account. Also in November you ascertained that there were deposits in
transit amounting to P20,000 and outstanding checks totaling P42,500.
The bank statement for the month of December showed total credits of P104,000 and total
charges of P51,000. The company’s book for December showed total receipts of P183,900
disbursements of P101,800 and a balance of P121,400. Bank debits memos for December were:
No. 143 for service charges, P400 and No. 145 on a customer’s returned check marked “DAIF”
for P6,000.
On December 31,2015 the company placed with the bank a customer’s promissory note with a
faced value of P30,000 for collection. The company treated this note as part of its receipts
although the bank was able to collect on the note only in January, 2016.
A check for P990 was recorded in the company cash payments books in December as P9,900.
REQUIRED:
1. Prepare a 4-column bank reconciliation for the month of December

a. Bank to book method;
b. Book to bank method; and
c. Adjusted balance method
2. Adjusting entries as of December 31, 2015.
SOLUTION:
Baht Company
Proof of Cash - Bank to Book Method
For the month of December, 2012
December
Receipt
Nov. 30 s Disb. Dec. 31
Unadjusted bank balances 76,5 104,000 51,000 129,500
00
Add (deduct) adjustments:
Customers' note collected by bank
(25,0
November 00) 25,000
Bank service charges
30
November 0 300
December (400) 400
10,0
Erroneous bank debit-November 00 (10,000) -
Undeposited collections
20,0
November 00 (20,000)
December 54,900 54,900
Outstanding checks
(42,5
November 00) (42,500)
December 90,490 (90,490)
NSF checks
December (6,000) 6,000
Book errors in December
Uncollected customer's note treated as receipts 30,000 30,000
Error in recording a check (SB P990, AR
P9,900) 8,910 (8,910)
39,3
Unadjusted book balances 00 183,900 101,800 121,400
Computation of deposits in transit, December 31:
Deposit in transit, Nov. 30 20,000

Add collections in December:
December book receipts 183,900
Less receipts not representing collections in December:
Customers' note collected by bank, Nov.
30 25,000
Note with the bank treated as receipts 30,000 55,000 128,900
Total 148,900
Less deposits credited by the bank in December:
December bank receipts 104,000
Less receipts not representing
deposits:
Erroneous bank debit, Nov.; corrected
Dec. 10,000 94,000
54,900
Outstanding checks, December 31:
Outstanding checks, Nov. 30 42,500

Add checks issued in December:
December book disbursements 101,800
Less disbursements not representing checks for
December:
Book error (SB P990, AR
P9,900) 8,910
Bank service charge, Nov.; recorded Dec. 300 9,210 92,590
Total 135,090
Less checks paid by the bank in
December:
December bank disbursements 51,000
Less disbursements not representing checks:
NSF checks, Dec. 6,000
Bank service charge, Dec. 400 6,400 44,600
90,490
Baht Company
Proof of Cash - Book to Bank Method
December
Nov. 30 Receipts Disb. Dec. 31
Unadjusted book balances 39,300 183,900 101,800 121,400

(25,000
November 25,000 )
November (300) (300)
December 400 (400)

(10,000
Erroneous bank debit-November ) 10,000 -
(20,000
November ) 20,000
(54,900 (54,900
December ) )
Outstanding checks
November 42,500 42,500

(90,490
December ) 90,490
NSF checks
(6,000
December 6,000 )

(30,000 (30,000
Uncollected customer's note treated as receipts ) )
Error in recording a check (SB P990, AR (8,910
P9,900) ) 8,910
Unadjusted bank balances 76,500 104,000 51,000 129,500
Baht Company
Proof of Cash - Adjusted Balance Method
December
Nov. 30 Receipts Disb. Dec. 31

76,50 104,00 51,00 129,50
Unadjusted bank balances 0 0 0 0
10,00 (10,00
Erroneous bank debit-November 0 0) -
20,00 (20,00
November 0 0)
December 54,900 54,900
Outstanding checks
(42,50 (42,50
November 0) 0)
(90,49
December 90,490 0)
64,00 128,90 98,99 93,91
Adjusted bank balances 0 0 0 0
183,90 101,80 121,40

Unadjusted book balances 39,300 0 0 0
25,00 (25,00
November 0 0)
(300 (300
November ) )
(400 AJE
December 400 ) 1
NSF checks
6,00 (6,00 AJE
December 0 0) 2
Uncollected customer's note treated as (30,00 (30,00 AJE
receipts 0) 0) 3
Error in recording a check (SB P990, AR (8,91 8,91 AJE
P9,900) 0) 0 4
64,00 128,90 98,99 93,91
Adjusted book balances 0 0 0 0
- - - -
Adjusting journal entries:
1) Bank service charge 400

Cash in bank 400
2) Accounts receivable 6,000

Cash in bank 6,000
3) Notes receivable 30,000

Cash in bank 30,000
4) Accounts payable 8,910

Cash in bank 8,910

Proof of Cash Baht Company

Uploaded by

Copyright:

Available Formats

Proof of Cash Baht Company

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Proof of Cash Baht Company

Uploaded by

Copyright:

Available Formats

Proof of cash

1. Prepare a 4-column bank reconciliation for the month of December

Computation of deposits in transit, December 31:

Deposit in transit, Nov. 30 20,000

Outstanding checks, December 31:

Outstanding checks, Nov. 30 42,500

Add (deduct) adjustments:

Customers' note collected by bank

Bank service charges

November (300) (300)

December 400 (400)

November 42,500 42,500

Book errors in December

Nov. 30 Receipts Disb. Dec. 31

183,90 101,80 121,40

1) Bank service charge 400

2) Accounts receivable 6,000

3) Notes receivable 30,000

4) Accounts payable 8,910

You might also like